using System.Data.OleDb; try { string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + @"d:\db1.mdb;"; OleDbConnection conn = new OleDbConnection(connstr); string sqlstr = "select UserName,UserAddress from UserInfo where UserID = 1"; OleDbCommand cmd1 = new OleDbCommand(sqlstr, conn); conn.Open(); OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { this.lable1.Text = reader["UserName"].ToString(); this.textBox1.Text = reader["UserAddress"].ToString(); } conn.Close(); } catch(Exception ex) { throw ex; }
一定要用 dataGridView吗? 我想自己从数据库里检索到字段。。放到自己要用的控件里,,比如label。里。 有什么办法呢? ---------------------------------------- string str_user = "select * from user_ok where s_id='" + this.tb_user.Text.Trim() + "' and s_pwd='" + this.tb_pwd.Text.Trim() + "'";
SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=sa;database=Midd_DutBacTeaInfReg"); con.Open(); SqlCommand cmd = new SqlCommand(str_user, con); SqlDataReader sqlreader = cmd.ExecuteReader(); sqlreader.Read(); tmp = sqlreader[1].ToString().Trim(); //tmp就是你所要获得的值 con.Close(); 以前别人帮助我,现在我懂的,我觉得也应该帮助别人。
using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.OleDb; public partial class Default2 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { DataTable dt=new DataTable(); Label1.Text = dt.Rows[0]["字段名"].ToString(); } public DataTable getData() { string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + @"d:\db1.mdb;"; OleDbConnection conn = new OleDbConnection(connstr); string sqlstr = "select * from table1 where id ='001' "; OleDbDataAdapter da = new OleDbDataAdapter(sqlstr, conn); DataTable dt = new DataTable(); da.Fill(dt); return dt; } }
protected void Page_Load(object sender, EventArgs e) { DataTable dt=new DataTable(); Label1.Text = dt.Rows[0]["字段名"].ToString(); } public DataTable getData() { string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + @"d:\db1.mdb;"; OleDbConnection conn = new OleDbConnection(connstr); string sqlstr = "select * from table1 where id ='001' "; OleDbDataAdapter da = new OleDbDataAdapter(sqlstr, conn); DataTable dt = new DataTable(); da.Fill(dt); return dt; }就是这样的。。小弟已经试验通过 谢谢LS的leo_qh 改日结贴再LS的各位大大。。估计你们没看清楚小弟的问题。。
你可以用ADO.NET调用
我知道可以用ADO.NET调用,但具体的不清楚
using System.Data.OleDb;
try
{
string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + @"d:\db1.mdb;";
OleDbConnection conn = new OleDbConnection(connstr);
string sqlstr = "select * from table1";
OleDbDataAdapter da = new OleDbDataAdapter(sqlstr, conn);
DataSet ds = new DataSet();
da.Fill(ds,"table1");
this.dataGridView1.DataSource = ds.Tables["table1"];
}
catch(Exception ex)
{
throw ex;
}
我想自己从数据库里检索到字段。。放到自己要用的控件里,,比如label。里。有什么办法呢?
using System.Data.OleDb;
try
{
string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + @"d:\db1.mdb;";
OleDbConnection conn = new OleDbConnection(connstr);
string sqlstr = "select UserName,UserAddress from UserInfo where UserID = 1";
OleDbCommand cmd1 = new OleDbCommand(sqlstr, conn);
conn.Open();
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
this.lable1.Text = reader["UserName"].ToString();
this.textBox1.Text = reader["UserAddress"].ToString();
}
conn.Close();
}
catch(Exception ex)
{
throw ex;
}
我想自己从数据库里检索到字段。。放到自己要用的控件里,,比如label。里。 有什么办法呢?
----------------------------------------
string str_user = "select * from user_ok where s_id='" + this.tb_user.Text.Trim() + "' and s_pwd='" + this.tb_pwd.Text.Trim() + "'";
SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=sa;database=Midd_DutBacTeaInfReg");
con.Open(); SqlCommand cmd = new SqlCommand(str_user, con);
SqlDataReader sqlreader = cmd.ExecuteReader();
sqlreader.Read();
tmp = sqlreader[1].ToString().Trim(); //tmp就是你所要获得的值
con.Close();
以前别人帮助我,现在我懂的,我觉得也应该帮助别人。
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt=new DataTable();
Label1.Text = dt.Rows[0]["字段名"].ToString();
}
public DataTable getData()
{
string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + @"d:\db1.mdb;";
OleDbConnection conn = new OleDbConnection(connstr);
string sqlstr = "select * from table1 where id ='001' ";
OleDbDataAdapter da = new OleDbDataAdapter(sqlstr, conn);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
}
{
DataTable dt=new DataTable();
Label1.Text = dt.Rows[0]["字段名"].ToString();
}
public DataTable getData()
{
string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + @"d:\db1.mdb;";
OleDbConnection conn = new OleDbConnection(connstr);
string sqlstr = "select * from table1 where id ='001' ";
OleDbDataAdapter da = new OleDbDataAdapter(sqlstr, conn);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}就是这样的。。小弟已经试验通过
谢谢LS的leo_qh 改日结贴再LS的各位大大。。估计你们没看清楚小弟的问题。。