Thank you
Hi,
I am Asha Bhatt
I have created one table (Question) , which contain 500 of row and 6 column.
column name are QusID , Question , Option1 ,Option2 , Option3 , option4 .
and in asp.net i have one button and one lable .
when i click on the button
then my query
protected void NextQuestionButton_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(scon);
con.Open();
cmd = new SqlCommand("select Question from Questions ", con);
readqus = cmd.ExecuteReader();
while (readqus.Read())
{
QuestionLabel.Text = readqus[0].ToString();
}
readqus.Close();
con.Close();
}
here i m getting total row of a column , but i want only 1st row by clicking 1st on the button
and when i will click 2nd time on the button then 2 row should be display like the till 100.
how can i do it please help me.
Thank you.