Last post Dec 05, 2009 03:44 AM by Mikesdotnetting
Dec 04, 2009 02:25 AM|FrankGarret|LINK
I'm using Visual Studio 2008.
I have created a simple .aspx pages called Default, I'vegot a database db1 with one table in it, table1 has two columns, m1, and m2.
I want to be able to retrieve single values and assign them to variables in Default.aspx.vb,
for example I want to retrieve the value of m2 where m1=10.
Can anyone help? I realize this might seem a trifle to those with even some experience,but I've judt began learning asp.net, and I'm having to do it against my will and in quite a hurry.
Dec 04, 2009 02:50 AM|Mikesdotnetting|LINK
Dec 04, 2009 11:42 AM|FrankGarret|LINK
THanks for the reply, but I'm still stuck.
a) I get a "the type or namespace 'DataView' could not be found.." message wne using DataView.
b) What does this " e.Command.Parameters("EmployeeID").Value = 2 " do?
Basically ib my page I have two textboxes, a button and an AccessDatabaseSource control, the latter is linked to the DB. What I want is that when I input the value on m1 into the first box
and click the button, I want to get the corresponding value of m2 to appear in the second box.
Dec 05, 2009 02:05 AM|FrankGarret|LINK
Heh, I sorted the first one on my own, but I'm still wondering about " e.Command.Parameters("EmployeeID").Value = 2 ".
Dec 05, 2009 03:44 AM|Mikesdotnetting|LINK
That one simply sets the parameter value. That ensures that the Employee record with the EmployeeID of 2 is returned.