A datareader (a recordset should not be used in ASP.NET) is strictly forward only. But, even if it wasn't, the real issue here is that you need to either store the results of your query in some kind of state, between requests, or requery the database to get the previous or the next result.
Please show us a bit of your code, and we'll likely be able to devise a good method.
|||Thanks for your response,
I have 6 dropdownlists like the following,
PrivateSub fillDropDownList3()Dim sqlStringAsString = "select * from ItemName"
Dim cmdAsNew SqlCommand(sqlString, conn)cmd.CommandType = CommandType.Text
Dim drAs SqlDataReaderconn.Open()
dr = cmd.ExecuteReader
While dr.ReadMe.DropDownList3.Items.Add(dr(0))
EndWhile
dr.Close()
conn.Close()
PrivateSub DropDownList3_SelectedIndexChanged(ByVal senderAs System.Object,ByVal eAs System.EventArgs)Handles DropDownList3.SelectedIndexChanged
Dim countAsIntegerDim sqlStringAsString = " select * from ReceiptItems where ItemName=@.ItemName"Dim cmdAsNew SqlCommand(sqlString, conn)cmd.CommandType = CommandType.Text
cmd.Parameters.Add("@.ItemName",Me.DropDownList3.SelectedItem.Text)
Dim drAs SqlDataReaderconn.Open()
dr = cmd.ExecuteReader
While dr.Read()count = count + 1
Me.TextBox3.Text = dr("Name")Me.TextBox4.Text = dr("Dept")
Me.TextBox5.Text = dr("ItemName")Me.TextBox6.Text = dr("ItemDescription")
Me.TextBox7.Text = dr("ItemSN")Me.TextBox8.Text = dr("Date")
EndWhile
dr.Close()
conn.Close()
Me.TextBox2.Text = countEndSub
but in the textbox corresponding to it, it just gives the first result. What I need is to know how to move to the next record, or get back to the previous one by clicking a button...
Thanks
|||Hi diana_j86,I've reviewed your code and it seems i can somewhat figure out what you want.However, I need to clarify frist that: You query string
select * from receiptitems whereitemname=@.ItemName
would return more than one values. If i'm wrong, please ignore my suggestion and inform me.
As Norrkoping has said, sqldatareader is strictly forward only so you can NOT use it if you want to get a previous record. I suggest you use dataset(datatable) with sqldataadapter.
You code should look like this: (Sorry, i'm not familiar with vb.net , so c# instead)
page-scope variables:
DataTable tbl = new DataTable();
int count = 0; //the count of records
int current = 0; // current record showed in your text boxes
dropdownlistbox select change event handle:
SqlDataAdapter adpter =new SqlDataAdapter(); adpter.SelectCommand =new SqlCommand("select * from receiptItems where itemsname=@.ItemName"); adpter.SelectCommand.Parameters.Add("@.ItemName",dropdownlist3.SelectdItem.Text); adpter.Fill(tbl); count = tbl.Rows.Count;current=0; // ALWAYS SHOW THE FIRST ONE AFTER SLECT CHANGED textbox2.text=tbl[0][0];
.................
Next_Button_Clicked Event handler: (Previous_Button_Clicked Event likewise)
textbox2.text=rows[current+1][0];
textbox3.text=rows[current+1][1];
....
Hope my suggestion helps|||
Thanks, Bo Chen – MSFT.
