DataSource Controls :: Trying To Filter Out Data That Is Being Pulled From Sql Table
May 17, 2010
I have a form that has dropdown box and user can either select Store Associate or Store Manager, when they click on either, I have GetASsociate function that pulls data from sql database. What i am trying to figure out how to do, is that if they say select Store Manager I want to filter what data to pull from that sql table that has all associates in it, so I was trying use an 'expression' statement to stay if Store Manager was selected, only pull me back the store managers from that table. Then same thing for if they selected STore Assoicate, then only bring me back teh store assocites from that table. But the expression statment does not appear to be working.
asxc.vb code behind
Private
Sub GetDataAssociates()Dim provider
As DbDataProvider' Create a collection of parameters.
Dim coll
As
New DbParameterCollection()
Dim prmCompany
As
New DbParameter
provider = DbDataProviderFactory.GetProvider(DataAccessLayer.Enumerations.ProviderType.SqlClient,
"GetAssociatesByCompany")
prmCompany.ParameterName = "@Company"
prmCompany.DbType = DbType.Int32
Select
Case ddlCompany.SelectedItem.Text.ToStringCase
"Stores"
prmCompany.Value = 100
Case
"Corporate"
prmCompany.Value = 300
Case
"Executives"
prmCompany.Value = 900
Case
"Union"
prmCompany.Value = 200
Case
Else
prmCompany.Value = 0
End
Select
coll.Add(prmCompany.ParameterName, prmCompany)
Select
Case
Me.ddlOrganisationStructure.SelectedValue.Trim
Case
"StoreManagers"
Dim expression
As
String
expression =
"Pos_Group >'0900'"
dsAssociates.Merge(provider.GetData(coll).Tables(0).Select(expression)) --IS ERRORING OUT ON ME HERE AT THIS LINE
dsAssociates.Merge(provider.GetData(coll))
dtAssociates = dsAssociates.Tables(0)
Case
"StoreAssociates"
Dim expression
As
String
expression =
"pos_group < '0900'
dsAssociates.Merge(provider.GetData(coll).Tables(0).Select(expression)) -IS ERRORING OUT ON ME HERE AT THIS LINE
dtAssociates = dsAssociates.Tables(0)
End
Select
View 4 Replies
Similar Messages:
Mar 2, 2011
I am trying to track members volunteering. I have a table that has all our members information and another table I want to update what they volunteer for throughout the year. I have a ddl that they select a last name and it populates first name, last name and spouse in a formview. This all works. There are a couple of other textboxes that need to be filled out. When I try and run an update into the volunteer table I get no errors and page shows the meber was updated. However, when I go into the volunteer table, there is no data.
[Code]....
I don't understand why it is not updating into the table. Especially since I am getting no errors.
View 2 Replies
Feb 9, 2010
I try to use a DataViewManager to filter data in a dataset, but somehow it does not work. The code below produces the error "A field or property with the name '< any field>' was not found on the selected data source". However, when I replace "GridView1.DataSource = dvm" with "GridView1.DataSource = ds" it works.
[Code]....
View 5 Replies
May 7, 2015
[URL] .... I Need to search record from GridView by using the textbox but not want to configure this with SQLDataSource Manually (Front End) therefore how to filter gridview from Codebehind.
View 1 Replies
Oct 31, 2010
I need good css for Gridview just like the mac css
can we provide the filter functionality to gridview like the excel filter.
View 3 Replies
Jun 13, 2010
Basically i deal with two tables.i have a table T1 of the following format:id company_name i need to read this data and create a table T2 as followsi wrote the following code. it worked fine for retrieving data and modification but fails to insert the modified data into the 2nd table.the error is, it does not recognise the value for @token
ArrayList dynarr=new ArrayList(); // global variable
protected void Button2_Click(object sender, EventArgs e)
{
int row = 1; int i;
string strcmd = null;
string Connection = "Data Source=....";
SqlConnection conn = new SqlConnection(Connection);
string str = "select company_name from T1 where ID=@ID";
[code]...
View 2 Replies
May 15, 2010
May you tell me how can I transfer data from a table to another table, the condition of non-repetition rows
as a procedure in database MS QSL server 2005 ,Works in the first day of the month I use the first table in the prodation environment it is contain the employee data and the second to update first table only
View 4 Replies
Apr 12, 2012
I tried to filter the data table and order by the records based on ID.
Ny filter string will looks like this.
sFilter= "ORDER BY Column1"
when i tried this, i got the following error."Missing operand after 'ORDER' operator."
View 1 Replies
Oct 18, 2010
I have a table which captures the updated data. I need to generate a report on updated fields.
how to filter the updated data from the table to display in the report.
I'm new to this so i need the sql code or stored procedure to filter and show only the updated data.
Well I have time stamp as well as a column for last changed date.
i need to produce all the fields pertaining to the updated cell in a single cell of the report.
for instance i change the last name of the person - i need to produce the persons firsname , updated lastname, his address and other details in a single cell of a report.
i also need to show the records in both ascending and decending way - like most recent update of the day and first update of the day.
View 3 Replies
Jul 8, 2010
I have seen this question asked about a half a million times and I still haven't been able to get my solution working by reading there answers.
First off I am using visual web developer 2008 express. I am brand new to asp.net net so me="nub"
I watched some videos on how to setup a website soloution and I did got a free cs and all that got it working. I installed the Ms Membership for loging in and out of my website. I got all that working. I installed the database for the membership on a sql server followed the video for doing that and everything works.
I then decided to do something so simple. I thought it was so simple.
I created a dropdown list using the control and I wanted it to go out to my database on my sql server and get my account numbers and filter them by using the current membership member that is logged in. I see that I can display my current user like this
<asp:LoginName ID="LoginName1" runat="server" />
I can see my user log in and out of the website and that seems to work fine.
So here is what my current dropdown list looks like I say current because I have tried this a ton of times with different parm options but none work.
[code]....
View 2 Replies
Oct 20, 2010
I have a gridview, fed from a datasource. Now I need to filter the data based on the values from two textboxes, getting their values from ajax CalendarExtenders.
The original (and working) datasource lookkis like this, just filtering on productnumbers:
[Code]....
Now trying to filter on the dates as well:
[Code]....
Now it goes like this:
I get all records. The productfiltering from the first eaxmple does not do anything anymore (probably related to the next problem)
Entering a date in the textbox (via the calendarextender) and pressing a button to refresh (databind my gridview) throws the following exception:
System.Data.SyntaxErrorException: The expression contains an invalid string constant: '10/01/2010 00:00:00.
Its obviously a type problem, but how do I solve it? Actually i need a daterange (from two textboxes) but simplified it here)
View 3 Replies
Oct 10, 2010
I've got a gridview that I need to perform filters on. All works great until I try and add a date range..
Below is the code. Basically I have 5 dropdown lists which all filter as expected giving them the option to use each one or just the ones they need.
The problem is they want to also have the option of filtering by date i.e date range or greater than or less than or equal to etc..
As soon as I add the date parameter it stops the other filters working. I'm guessing because I have a null value in the date field (textbox) if they dont use the option??
Does anyone have a sample on how to filter by dropdown lists and dates keeping in mind they wont use all the filter options?
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
<style type="text/css">
.style2
{
width: 100%;
}
.style3
{
width: 137px;
}
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
</br>
<table>
<tr>
<td>
Person Responsible</td>
<td>
<asp:DropDownList ID="DDLPersonResponsible" runat="server"
DataSourceID="SqlDataSource2" DataTextField="AssignedTo"
DataValueField="AssignedTo" AppendDataBoundItems="True"
AutoPostBack="True" Height="22px" Width="200px">
<asp:ListItem Text="All" Value="%"></asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
Location</td>
<td>
<asp:DropDownList ID="DDlLocation" runat="server" Height="22px" Width="200px"
DataSourceID="SqlDataSource3" DataTextField="location"
DataValueField="location" AppendDataBoundItems="True"
AutoPostBack="True">
<asp:ListItem Text="All" Value="%"></asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource3" runat="server"
ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString1 %>"
SelectCommand="usp_Locations" SelectCommandType="StoredProcedure">
</asp:SqlDataSource>
</td>
</tr>
<tr>
<td>
Activity/Product/Service</td>
<td>
<asp:DropDownList ID="DDlActivity" runat="server" DataSourceID="SqlDataSource4"
DataTextField="Activity" AppendDataBoundItems="True"
AutoPostBack="True" Height="22px" Width="200px">
<asp:ListItem Text="All" Value="%"></asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource4" runat="server"
ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString1 %>"
SelectCommand="usp_Activity" SelectCommandType="StoredProcedure">
</asp:SqlDataSource>
</td>
</tr>
<tr>
<td>
Risk Ranking</td>
<td>
<asp:DropDownList ID="DDlRiskRanking" runat="server" AppendDataBoundItems="True"
AutoPostBack="True" >
<asp:ListItem Value="%">All</asp:ListItem>
<asp:ListItem>1</asp:ListItem>
<asp:ListItem>2</asp:ListItem>
<asp:ListItem>3</asp:ListItem>
<asp:ListItem>4</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
Reference</td>
<td>
<asp:DropDownList ID="DDLReference" runat="server" DataSourceID="SqlDataSource5"
DataTextField="Reference" AppendDataBoundItems="True"
AutoPostBack="True" Height="22px" Width="200px">
<asp:ListItem Text="All" Value="%"></asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource5" runat="server"
ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString1 %>"
SelectCommand="usp_SelectReference" SelectCommandType="StoredProcedure">
</asp:SqlDataSource>
</td>
</tr>
<tr>
<td>
Target Date</td>
<td style="margin-left: 40px">Greater than
<asp:TextBox ID="txtstartTargetDate" runat="server" AutoPostBack="True"></asp:TextBox> Less Than
<asp:TextBox ID="txtendTargetDate" runat="server" AutoPostBack="True"></asp:TextBox>
</td>
</tr>
</table>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString1 %>"
SelectCommand="usp_AssignOwner" SelectCommandType="StoredProcedure">
</asp:SqlDataSource>
<br />
<asp:GridView ID="GridView1" runat="server" AllowSorting="True"
AutoGenerateColumns="False" DataKeyNames="IssueId"
DataSourceID="SqlDataSource1" Width="803px" CellPadding="4"
ForeColor="#333333"
EmptyDataText="There are no matching records to display.">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:BoundField DataField="IssueId" HeaderText="IssueId" InsertVisible="False"
ReadOnly="True" SortExpression="IssueId" />
<asp:BoundField DataField="BriefDescription" HeaderText="BriefDescription"
SortExpression="BriefDescription" />
<asp:BoundField DataField="DateEntered" HeaderText="DateEntered"
SortExpression="DateEntered" />
<asp:BoundField DataField="EnteredBy" HeaderText="EnteredBy"
SortExpression="EnteredBy" />
<asp:BoundField DataField="Likelihood" HeaderText="Likelihood"
SortExpression="Likelihood" />
<asp:BoundField DataField="Consequence" HeaderText="Consequence"
SortExpression="Consequence" />
<asp:BoundField DataField="Location" HeaderText="Location"
SortExpression="Location" />
<asp:BoundField DataField="Activity" HeaderText="ActivityProductService"
SortExpression="Activity" />
<asp:BoundField DataField="Scope" HeaderText="Scope"
SortExpression="Scope" />
<asp:BoundField DataField="Aspect"
HeaderText="Aspect" SortExpression="Aspect" />
<asp:BoundField DataField="AspectRevised" HeaderText="AspectRevised"
SortExpression="AspectRevised" />
<asp:BoundField DataField="Impact" HeaderText="Impact"
SortExpression="Impact" />
<asp:BoundField DataField="Objective" HeaderText="Objective"
SortExpression="Objective" />
<asp:BoundField DataField="KeyAction" HeaderText="KeyAction"
SortExpression="KeyAction" />
<asp:BoundField DataField="TargetDate" HeaderText="TargetDate"
SortExpression="TargetDate" />
<asp:BoundField DataField="PersonResponsible" HeaderText="PersonResponsible"
SortExpression="PersonResponsible" />
<asp:BoundField DataField="PercentageCompleted"
HeaderText="PercentageCompleted" SortExpression="PercentageCompleted" />
<asp:BoundField DataField="Reference" HeaderText="Reference"
SortExpression="Reference" />
<asp:BoundField DataField="Comments" HeaderText="Comments"
SortExpression="Comments" />
<asp:BoundField DataField="Status" HeaderText="Status"
SortExpression="Status" />
<asp:BoundField DataField="AssignedTo" HeaderText="AssignedTo"
SortExpression="AssignedTo" />
<asp:BoundField DataField="RiskRanking" HeaderText="Risk Ranking" />
</Columns>
<EditRowStyle BackColor="#2461BF" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString1 %>"
SelectCommand="usp_AllIssues" SelectCommandType="StoredProcedure" FilterExpression="assignedto like '{0}' and location like '{1}' and activity like '{2}' and riskranking like '{3}' and reference like '{4}' and targetdate > '{5}'">
<FilterParameters>
<asp:ControlParameter Name="assignedto" ControlID="ddlpersonresponsible"
PropertyName="SelectedValue" />
<asp:ControlParameter Name="location" ControlID="ddllocation"
PropertyName="SelectedValue" />
<asp:ControlParameter Name="activity" ControlID="ddlactivity"
PropertyName="SelectedValue" />
<asp:ControlParameter Name="riskranking" ControlID="ddlriskranking"
PropertyName="SelectedValue" />
<asp:ControlParameter Name="Reference" ControlID="ddlreference"
PropertyName="SelectedValue" />
<asp:ControlParameter Name="startdate" ControlID="txtStartTargetDate"
PropertyName="text" />
</FilterParameters>
</asp:SqlDataSource>
</asp:Content>
View 2 Replies
May 3, 2010
I have this GridView with this member details:
Members (ID, Title, Forename, Surname)
I want to use Drop Down List to Filter Members table by MemberType, this means having to Join the following three Tables..
Members (ID, Title, Forename, Surname, Memb_ProdID*) has Foreign Key for MemberProducts Table
MemberType (ID, MembType)
MemberProducts (ID, Duration, Price, Terms, memb_TypeID*) has Foreign Key for memberType table MembType is in Italic and underlined, how do I use this to filter members details in GridView.
View 4 Replies
Feb 4, 2010
why i can't write a sql filter by chinese character like the following select name from ABC where name like ' %可%'
View 1 Replies
Feb 17, 2011
I have an SqlDataSource, which is filtered by two RadioButtonLists. The markup is as follows:
[Code]....
In my code-behind I add the filterexpression when the radiobuttonlists are changed
[Code]....
My problem is that while it works fine when changing the RadioButtonListProducts the filtering works nicely, there is a problem with the RadioButtonListStatus, that filters on the Boolean column, 'Godkendt'. It works nicely if its set to 'Alle' (No filtering on that parameter) but when set to anything else, no records are shown. I suppose the problem is in the filterexpression
[Code]....
View 1 Replies
May 11, 2010
i have a "Users today" function that i am trying to work on, i have all the tables set up, and a TimeStamp column, i would like to know how i could get all the users that appeared, but for that day only.
So i used the select statement, but then when i tried to add into query, filtering, i tried using the DateTime.Now, but it only got the users specific to that date, hour, and second.
View 3 Replies
May 16, 2010
I want to filter a datetime field for a date without the time...
I want all fields that contain the selected date regardless of the time.
What should I use as the filter expression?
View 2 Replies
Apr 7, 2010
i have a dataset which contains some data.
let dataset have some columns one among them is " Type "
let the values in column type be type1,type2.type3 and so on
now if i want to filter dataset which contains only type3
View 4 Replies
Jan 16, 2010
I am planning a project for a pharmacy to enter quality control data to generate reports and graphs with Crystal Reports. There are 20 stores, I need to password protect the entrance page, giving each store their own username and password (just one per store is fine), allowing the store to only access that store's data. Each store will have an associated ID in the MSSQL table.I am using the Membership Provider. I know I need to implement user roles for Managers and Stores levels (Managers can run reports for all stores), I wonder if I can set the default store ID for insert/edit templates after that specific store logs in.Basically, I think I need to filter SQL queries based on the store ID associated with a user ID. I have seen a .NET site that, after logging in, you type in a store id into a textbox, and it gives you access only to that stores data. Something like this would work for my situation.Can anyone explain or show me an example for the best method to accomplish this with C#?
View 2 Replies
Aug 5, 2010
how can I get data from more than one table using sqldatasource,,, am trying the following code but i get error "Invalid column name 'Category_tbl.CategoryI"
[Code]....
View 3 Replies
Aug 5, 2010
am trying to get data from more than one table but I think I have an error in the syntax plz anyone can help methis is the code
[Code]....
View 6 Replies
Mar 2, 2010
i have an List<String> lstrings which contains a list of strings. If i want to write a linq query on a list<Employees> employees to filter for employees.name in {lstrings} var lquery = (from e in employees where e.Title =="ASP.NET" && e.Name.Contains(lstrings) select e); Im trying to filter the employees using a list of strings which match with the employee.Name
View 5 Replies
Nov 7, 2010
I've got a gridview which works fine. I use dropdownlists which are filled with distinct values of the columns. So when I select an item in a drompdownlist the gridview refreshes based on the selected value. When I have a column which uses string values, I can start the filter with a default % value to use in my select paramaters. But when I have a date column, I can't use that. I use a datasource for the gridview and I prefer to leave codebehind out if this is not needed. Now I use >= in my gridview select to show all rows. but I want to use only = to make the filter work correct when I select a date in the ddl and use the selectedvalue in the gridview selectCommand
<asp:DropDownList ID="ddlUpdateDatum" DataSourceID="dsPopulateUpdateDatum"
AutoPostBack="true" DataValueField="UPDATEDATE" runat="server"
CssClass="selectinput" AppendDataBoundItems="true">
<asp:ListItem Text="All" Value="01/01/1900"></asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="dsPopulateUpdateDatum" runat="server"
ConnectionString="<%$ ConnectionStrings:GAMSYSTEMSqlServer %>"
SelectCommand="SELECT DISTINCT(UPDATEDATE) FROM [messages] ORDER BY UPDATEDATE ASC ">
</asp:SqlDataSource>
And I use this in the gridview datasource:
<asp:SqlDataSource
runat="server"
ID="dsGridview"
ConnectionString="<%$ ConnectionStrings:DBSqlServer %>"
SelectCommand = "SELECT * FROM [messages] WHERE AND UpdateDatum >= @UpdateDatePar ORDER BY UpdateDatumDESC"
>
<SelectParameters>
<asp:ControlParameter Name="UpdateDatePar" ControlID="ddlUpdateDate" PropertyName="SelectedValue" Type="string" />
</SelectParameters>
View 2 Replies
May 9, 2010
I have a small problem I want to fetch some data from sql table. Table looks like as
sno acno amnout cash
1 A-100 5000 withdrawal
2 A-101 7000 Deposit
3 A-100 8000 Deposit
4 A-101 6000 Deposit
5 A-101 1000 withdrawal
And i want to records something like this:
acno Deposit withdrawal
A-100 8000 5000
A-101 13000 1000
View 5 Replies
Jan 12, 2010
I have a big problem, some how i changed the CreateNewBoundFile, because the heading were mispell (Qrt instead of Qtr. I only changed the BOLD part.
strQuery = "SELECT [Industry Title] AS Industry_Title, [Area Name] AS Area_Name, [Year], [Ownership Title] AS Ownership_Title, [Ownership Code] AS Ownership_Code, [NAICS Code] AS NAICS_Code, [Qrt 1 Disclosure] AS Qrt_1_Disclosure, [Qtr 2 Disclosure] AS Qrt_2_Disclosure,
[Qtr 3 Disclosure] AS Qrt_3_Disclosure, [Qtr 4 Disclosure] AS Qrt_4_Disclosure, [Annual Disclosure] AS Annual_Disclosure"
vArea = Context.Items("Area")
vYear = Context.Items("Year")
vAggLevel = Context.Items("AggLevel")
vIndustry = Context.Items("Industry")
vOwnership = Context.Items("Ownership")
strQuery = strQuery & ", [Qrt 1 Establishments] AS Qrt_1_Establishments, [Qtr 2 Establishments] AS Qtr_2_Establishments, [Qtr 3 Establishments] AS Qtr_3_Establishments, [Qtr 4 Establishments] AS Qtr_4_Establishments"
strQuery = strQuery & ", [Annual Establishments] AS Annual_Establishments"
strQuery = strQuery & ", [Jan], [Feb], [Mar], [April], [May], [June], [July], [Aug], [Sept], [Oct], [Nov], [Dec]"
strQuery = strQuery & ", [Annual Avg Emp] AS Annual_Avg_Emp"
strQuery = strQuery & ", [Qrt 1 Wages] AS Qrt_1_Wages, [Qrt 1 Taxable] AS Qrt_1_Taxable, [Qrt 1 Avg wk wage] AS Qrt_1_Avg_wk_wage, [Qtr 2 Wages] AS Qtr_2_Wages, [Qtr 2 Taxable] AS Qtr_2_Taxable, [Qtr 2 Avg wk wage] AS Qtr_2_Avg_wk_wage, [Qtr 3 Wages]
AS Qtr_3_Wages, [Qtr 3 Taxable] AS Qtr_3_Taxable, [Qtr 3 Avg wk wage] AS Qtr_3_Avg_wk_wage, [Qtr 4 Wages] AS Qtr_4_Wages, [Qtr 4 Taxable] AS Qtr_4_Taxable, [Qtr 4 Avg wk wage] AS Qtr_4_Avg_wk_wage"
strQuery = strQuery & ", [Total Annual Wages] AS Total_Annual_Wages, [Taxable Annual] AS Taxable_Annual, [Avg wk wage] AS Avg_wk_wage, [Avg Annual Pay] AS Avg_Annual_Pay"
strQuery = strQuery & " FROM [vQCEWHIST]"
CreateNewBoundField("Qrt_1_Disclosure", "Qrt_1 Disclosure", False)
CreateNewBoundField("Qrt_2_Disclosure", "Qrt_2 Disclosure", False)
CreateNewBoundField("Qrt_3_Disclosure", "Qrt_3 Disclosure", False)
CreateNewBoundField("Qrt_4_Disclosure", "Qrt_4 Disclosure", False)
CreateNewBoundField("Annual_Disclosure", "Annual Disclosure", False)
Because of the mis spell Qrt, so i change it to Qtr.
CreateNewBoundField("Qrt_1_Disclosure", "Qtr_1 Disclosure", False)
CreateNewBoundField("Qrt_2_Disclosure", "Qtr_2 Disclosure", False)
CreateNewBoundField("Qrt_3_Disclosure", "Qtr_3 Disclosure", False)
CreateNewBoundField("Qrt_4_Disclosure", "Qtr_4 Disclosure", False)
CreateNewBoundField("Annual_Disclosure", "Annual Disclosure", False)
After i changed it, when going to SQL server express, looking at the original table, some how most of the data were changed to 0 and 1, some of them still stay the same, but most of it has been changed to 0 or 1.
View 3 Replies
