How do you get records number from 5 to 15 in a dataset of 100 records? Write code.
How do you get records number from 5 to 15 in a dataset of 100 records? Write code.
✍: Guest
Answer1
DataSet ds1=new DataSet();
String strCon=â€data source=IBM-6BC8A0DACEF;initial catalog=pubs;integrated security=SSPI;persist†+†security info=False;user
id=sa;workstation id=IBM-6BC8A0DACEF;packet size=4096?;
String strCom1=â€SELECT * FROM employeeâ€;
SqlDataAdapter sqlDa1=new SqlDataAdapter(strCom1,strCon);
ds1.Tables.Add(â€employeeâ€);
sqlDa1.Fill(ds1,40,50,ds1.Tables[â€employeeâ€].TableName);
DataGrid dg1.DataSource=ds1.Tables[â€employeeâ€].DefaultView;
dg1.DataBind();
Answer2
OleDbConnection1.Open()
OleDbDataAdapter1.Fill(DataSet21, 5, 15, “tabâ€)
This will fill the dataset with the records starting at 5 to 15
2014-09-11, 1677👍, 0💬
Related Topics:
SQL
How do you update 100 rows with single query with variable data populating each row ? 2014-09-19, 2752👍, 0💬
Convert Windows login to SQL login
how will you convert windows authentication mode to sql server mode? 2014-09-15, 2287👍, 0💬
How many classes can a single.NET DLL contain?
How many classes can a single.NET DLL contain? Answer1: As many Answer2: One or more 2014-09-04, 1881👍, 0💬
On order to get assembly info which namespace we should import?
On order to get assembly info which namespace we should import? System.Reflection Namespace 2014-09-08, 1692👍, 0💬