评论会员:爱德华・卢 时间:2012/02/07
在这里,我让你使用的SqlCommand和DataReader ADO.NET一个非常简单的例子:
try
{
SqlConnection sqlconn = new SqlConnection(connString);
sqlconn.Open();
SqlCommand sqlcmd = new SqlCommand("SELECT fistname, lastname FROM Users",
sqlconn);
sqlcmd.CommandType = CommandType.Text;
SqlDataReader dr = sqlcmd.ExecuteReader();
while(dr.Read())
{
txtFirstname.Text = dr[0].ToString();
txtLastname.Text = dr[1].ToString();
}
}
catch(Exception ex)
{
}
finally
{
sqlconn.Close();
sqlcmd.Dispose();
sqlconn = null;
}
的问候,
爱德华
评论会员:乌玛・尚卡尔帕特尔 时间:2012/02/07
尝试这个例子
DataTable dt = new DataTable();
SqlConnection connection = new SqlConnection("Data Source=OMXOKLSFD0885\SQLEXPRESS;Initial Catalog=omx;Persist Security Info=True;");
connection.Open();
SqlCommand sqlCmd = new SqlCommand("SELECT * from emp WHERE UserID = @username", connection);
SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
sqlCmd.Parameters.AddWithValue("@username",user);
sqlDa.Fill(dt);
if (dt.Rows.Count > 0)
{
TextBox1.Text = dt.Rows[0]["name"].ToString();
TextBox2.Text = dt.Rows[0]["emailid"].ToString();
Label1.Text = dt.Rows[0]["dob"].ToString();
Label2.Text = dt.Rows[0]["Deptt."].ToString();
}
connection.Close();
}
评论会员:游客 时间:2012/02/07
koolprasad2003:你可以使用连接/断开架构|imgsrc={A}]