Database conn. and filter in .Net
I wish to use the filter in ASP.Net, how will this code be in .Net?
Code:
set myconn2 = server.createobject("ADODB.connection")
myconn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&server.mappath("priser.mdb")
sqlPrisPur = "SELECT * FROM pris_pur"
set rs0 = myconn2.execute(sqlPrisPur)
rs0.filter = "ID='9'"
PrisPurArr(i) = rs0("pris")
rs0.close
I've found out how to bind information to a drpList, but what if it is binding to a label or a text field?
Code:
Protected Sub bindDimensioner()
Dim strCn As String = "Provider=Microsoft.jet.oledb.4.0;"
strCn += "Data Source=" & Server.MapPath("priser04.mdb") & ";"
Dim cn As OleDbConnection = New OleDbConnection(strCn)
Dim cmdText As String = "Select dimId as dimID, dimension FROM MedieDim WHERE matId=" & intMatNr & " ORDER BY dimension ASC"
Dim cmd As OleDbCommand = New OleDbCommand(cmdText, cn)
cmd.Connection.Open()
Dim1.DataSource = cmd.ExecuteReader()
Dim1.DataValueField = "dimId"
Dim1.DataTextField = "Dimension"
Dim1.DataBind()
cmd.Connection.Close()
End Sub