vb.net to c#,net

来源：百度知道 编辑：UC知道 时间：2024/05/05 15:43:09
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<Script Language="VB" Runat=Server>
Sub Page_Load(Sender As Object,e As EventArgs)
'使用数据库驱动程序的名称
Dim hb_provider = "Provider=Microsoft.Jet.OLEDB.4.0"
'数据库所在的路径
Dim hb_database = "Data Source=" & Server.MapPath("phonebook.mdb")
Dim hb_conn1 As OleDb.OleDbConnection
Dim hb_command1 As OleDb.OleDbCommand
Dim hb_reader As OleDb.OleDbDataReader
Dim hb_sql,sname, str1 As String

'取得网也传递过来的数据
sname=Request("nameid")

'创建OleDbConnection对象，以便数据操作?
hb_conn1 = New OleDb.OleDbConnection(hb_provider & ";" & hb_database)
'打开数据库文件，创建连接
hb_conn1.Open()
'设定SQL查询字符串
hb_sql = "Select * From data Where name like '" & sname & "'&quo

<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<Script Language="C#" Runat=Server>
void Page_Load(object Sender,EventArgs e){
//使用数据库驱动程序的名称
string hb_provider = "Provider=Microsoft.Jet.OLEDB.4.0" ;
//数据库所在的路径
string hb_database = "Data Source=" + Server.MapPath("phonebook.mdb") ;
OleDb.OleDbConnection hb_conn1;
OleDb.OleDbCommand hb_command1;
OleDb.OleDbDataReader hb_reader;
string hb_sql,sname, str1;

//取得网也传递过来的数据
sname=Request.Form["nameid"];//如果是URL的方式就用：sname=Request.QueryString["nameid"];

//创建OleDbConnection对象，以便数据操作?
hb_conn1 = New OleDb.OleDbConnection(hb_provider + ";" + hb_database) ;
//打开数据库文件，创建连接
hb_conn1.Open() ;
//设定SQL查询字符串
hb_sql = "Select * From data Where name like '&q