2
Contributors
4
Replies
5
Views
11 Years
Discussion Span
Last Post by muthu
0

I am sorry but i can't understand you ..
do you mean move all the record data from one position to another .. and give me breif decription of the table design and the moving purpose in order to help you ..

0

hai,
just moving the record in the table, ie move next in vb.

understand.

0

HI
ok i understood you ..
in C#
-You can use the dataAdapter which fill the dataset..
the dataset is like the tow dimentional array ,that you can get any record from it by its indecies ..
e.g dataset1.Tables[0].Rows[0][2].ToString();
by simple for loop you can get all the data from the dataSet (note that the limit of the loop will be dataSet1.Tables[0].Rows.Count)..

-You can use the dataReader which is assigned to the return of the ExecuteReader() method of the command , then every time the dataReader make the Read() method you can move next.
////////////
dataReader1.Read(); // the first read
while(dataReader1.HasRows())
dataReader1.Read();
// get data here by dataReader1.GetString() or other Get.. methods
/////////////

I wish i could help you
bye

0

hai,

thanks for ur help. and i will check it and tell to u

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.