名字空间引入了SQLClient,代码如下:<script language="vb" runat="server"> sub page_load(sen as Object,e as Eventargs)
dim conn as SQLConnection
dim comm as SQLCommand
dim dr as SQLDataReader
dim ds as DataSet
conn = new SQLConnection("server=.;uid=sa;pwd=demo;database=northwind")
comm = new SQLCommand("select * from 供应商",conn)
conn.Open()
dr = comm.ExecuteReader()
DataGrid.DataSource = dr
DataGrid.DataBbind()
conn.close()
end sub
</script>运行后出现下面的错误:编译器错误信息: BC30469: 对非共享成员的引用要求对象引用。源错误: 行 22: conn.Open()
行 23: dr = comm.ExecuteReader()
行 24: DataGrid.DataSource = dr
行 25: DataGrid.DataBbind()
行 26: conn.close()
是什么原因呢?要怎么引?谢谢各位
dim conn as SQLConnection
dim comm as SQLCommand
dim dr as SQLDataReader
dim ds as DataSet
conn = new SQLConnection("server=.;uid=sa;pwd=demo;database=northwind")
comm = new SQLCommand("select * from 供应商",conn)
conn.Open()
dr = comm.ExecuteReader()
DataGrid.DataSource = dr
DataGrid.DataBbind()
conn.close()
end sub
</script>运行后出现下面的错误:编译器错误信息: BC30469: 对非共享成员的引用要求对象引用。源错误: 行 22: conn.Open()
行 23: dr = comm.ExecuteReader()
行 24: DataGrid.DataSource = dr
行 25: DataGrid.DataBbind()
行 26: conn.close()
是什么原因呢?要怎么引?谢谢各位
DR。FILL(DS,表)
DATAGRI。DATASOURCE=DR
DataAdapter
void BindGrid()
{ //创建DataAdapter对像
SqlConnection MyConn=new SqlConnection("server=127.0.0.1;database=test;uid=sa;pwd=111111");
MyConn.Open();
string sql="select * from XMLClientInfo";
SqlCommand myComm=new SqlCommand(sql,MyConn);
SqlDataReader dr=myComm.ExecuteReader();
dg1.DataSource=dr;
dg1.DataBind();
}