I get records from the table by using "Select top(5) itemCode,ItemName,Price from Item"
Now I wan't to take next 5 records. How can I create query to that one.
After that I wan't to take the previous 5 records also.
View Complete Post
I am building an association model , if my nested table records is more than 1 lac, model is failing.
Even same while applying the model also. Server's RAM size is 16GB.
Please can you suggest the maximum number of records that can be handled?
Thanks in Advance
How could I get the total number of records present in a database table through asp.net in VB? I know about setting up and opening a connection. I wanted to loop through records, so wanted to know the number of records present. How could that be done?
Also, I used statements like 'Update' and 'Insert Into' to to change the data in my data source. Like I updated a certain field like this:
ds.Tables("tblUsers").Rows(2)(3) = "xyzzzz"
and then I executed an sql statement on the same field like this:
objCmd.UpdateCommand = new OleDbCommand
objCmd.UpdateCommand.CommandText = "Update tblUsers " & _
"SET City='xyzzzz' WHERE UserID=3"
objCmd.UpdateCommand.Connection = Conn
(where objcmd is an instance of oledbdataadapter object)
What should I do to delete a record or a field in a data source through asp.net?
ID | NAME | PARENTID
1 A 0
2 B 0
3 A.1 1
4 A.2 1
5 A.1.1 3
6 B.1 2
7 B.1.1 6
8 B.1.1.1 7