Move next previous record on label in c#

Question

i want to display some record on lables and when press next button record should be show next record on label.. in web application how to do it...

Sachin Singh · Answer

It should work , although it doesn't matter how many times you click movenext you will always get the same result because i will always be 1 (0+1=1) , as http is stateless, and you are not storing the value of i anywhere for next response.

Sachin Singh · Answer

your dataset is empty (Dataset ds= new DataSet() means just initialization), you need to fill the dataset.

Sachin Singh · Answer

Fetch the next record from database on button click using below query if using Entity Framework. var nextRecord= context.Products.Skip(previousId).Take(1); Label1.Text= nextRecord.Name;

Bhavesh Vankar · Answer

now i have modified it as below... but its not working and not any response.. what is mistake ? private void recordNext() { int i = 0; i++; SqlConnection conn = new SqlConnection(conn ); SqlCommand cmd = new SqlCommand( "Select * from PARTY_DETAILS" ,conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { lblName.Text = ds.Tables[0].Rows[i][ "NAME" ].ToString(); lblAddress.Text = ds.Tables[0].Rows[i][ "ADDRESS" ].ToString(); lblDistrict.Text = ds.Tables[0].Rows[i][ "DISTRICT" ].ToString(); lblCity.Text = ds.Tables[0].Rows[i][ "CITY" ].ToString(); lblContactno.Text = ds.Tables[0].Rows[i][ "MONO" ].ToString(); } }

Bhavesh Vankar · Answer

i have used below code. but it show error " Cannot find table 0. " private void recordNext() { int i; SqlConnection conn = new SqlConnection(conn); DataSet ds = new DataSet(); if (ds.Tables[0].Rows.Count > 0) { i = 0; lblName.Text = ds.Tables[0].Rows[i][ "NAME" ].ToString(); lblAddress.Text = ds.Tables[0].Rows[i][ "ADDRESS" ].ToString(); lblDistrict.Text = ds.Tables[0].Rows[i][ "DISTRICT" ].ToString(); lblCity.Text = ds.Tables[0].Rows[i][ "CITY" ].ToString(); lblContactno.Text = ds.Tables[0].Rows[i][ "MONO" ].ToString(); } }

Piyush Pansuriya · Answer

Hello, Please provide some more details with the code, So we can help you

Move next previous record on label in c#

Answers (6)