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.

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();           }          }

Sachin Singh · Answer

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

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();          }         }

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;

Piyush Pansuriya · Answer

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