Use The OleDBCommand In ASP

I need sample code for using oleDBCommand in ASP (not dotnet),

View Replies


ADVERTISEMENT

OleDbCommand Selecting Variable Data

-Dim cmd As OleDbCommand
-cmd = New OleDbCommand("select * from qmsstats where firstname='jason'",
OleDbConnection1)
-OleDbDataAdapter2.SelectCommand = cmd
-DataGrid1.Visible = True
-OleDbDataAdapter2.Fill(DsQmsStats1)
-DataGrid1.DataBind()

In the above example I need to change 'jason' to a variable. I need the variable to be pulled from a textbox. IE: txtusername.text. Please advise how I can get the value from txtusername.text in place of 'jason'.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved