Hi
lets take an eg. where dataset name is ds and datatable name is employees.
add following lines to your code.
//to find no. of employees
DataView dv = new DataView(ds.emp loyees);
dv.RowFilter = "status = 1";
int iExist = ds.employees.ro ws.count;
//to find no. of left employees
dv.RowFilter = "status = 2";
int iLeft = ds.employees.ro ws.count;...
User Profile
Collapse
-
Hi Pankaj
Assign following properties to your combobox
Assign data source
comboBox1.DataS ource = Your Data source name
comboBox1.Displ ayMember = Your Data Source Column name which you want to display.
comboBox1.Value Member = Your Data Source Column name whose value you wants to store in your combobox.
Regards,
Guru...Leave a comment:
-
Using Filter and Find method of bindingsource
Hi
How to use filter or find on more than one column in C#.Net 2005.
e.g. I have a purchase table which contains column like date of purchase, supplier name, raw material and qty of purchase. I wants to view records of purchase made from a particular supplier for a particular date. So I am filtering purchase table on two fields i.e. date of purchase and supplier name but it is not working. It is giving me an error message... -
-
How to use validations in Datagrid
Hi
How to use following events in datagrid.
Column level validation.
Record level validation.
Is there any way to display grid columns vertically instead of horizontally.
regards,
guru -
How to speed up data update and retrieve process
Hi
I have a MS Sql table 'supplier' contains more than 100000 records. When I try to open supplier entry form it takes lot of time to fill datatable (almost between 10 to 15 seconds). I am using Visual Studio 2005 (C# language).
to fill datatable supplier the code which i have used is given below.
this.supplierTa bleAdapter.Fill (this.ds.suppli er).
Even it takes time to find a particular... -
Using Validations in Datagrid in C#
Hi
How to use following events in datagrid.
Column level validation.
Record level validation.
Is there any way to display grid columns vertically instead of horizontally.
regards,
guru -
-
how to find previous value of data column in c#
Hi
Is there any way to find previous value of data column or text in c#.
Regards,
Guru -
find no. of rows in data table inside dataset using c#
Hi
Please help me in finding out no. of rows in data table inside dataset using c#
thanks
guru
No activity results to display
Show More
Leave a comment: