本人初学VB现在做一个VB澡堂系统,
我想让我access表中的数据显示在label上,调用的是登入账号信息求解
------解决思路----------------------
Dim connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.Mappth("\澡堂系统_Data.mdb")
'定义一个连接
Dim conn As New OleDbConnection(connectionString)
conn.Open() '打开连接
Dim strSQL As String = "Select * From UserInfo " '定义sql语句
Dim da As New OleDbDataAdapter(strSQL, conn) '定义一个 DATAADAPTER
Dim ds As New DataSet '定义一个DATASET
da.Fill(ds, "UserInfo") '填充DATASET
datagrid.DataSource = ds.Tables(0).DefaultView
datagrid.DataBind()
------解决思路----------------------
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=temp21.mdb";
OleDbConnection conn = new OleDbConnection(strConn);
string select = "";
DataSet ds = new DataSet();
select = "select userid,username,remainder from 表 ";
OleDbDataAdapter da = new OleDbDataAdapter(select, strConn);
da.Fill(ds);
label1.Text = ds.Tables[0].Rows[0][0].ToString();//userid
label2.Text = ds.Tables[0].Rows[0][1].ToString();//username
label3.Text = ds.Tables[0].Rows[0][2].ToString();//remainder
conn.Close();