如何从数据库中将值存储在标签中

问题描述

string connection = System.Configuration.ConfigurationManager.ConnectionStrings["itax"].ConnectionString;
        SqlConnection con = new SqlConnection(connection);
        con.Open();

        SqlCommand cmd = new SqlCommand("SELECT @UserId 'UserId',@userPassword 'userPassword' FROM Userlogin WHERE UserId = @UserId", con);
        cmd.Parameters.Add("@UserId", SqlDbType.VarChar, 50).Value = lbl_Employee_code.Text;
        cmd.Parameters.Add("@userPassword", SqlDbType.VarChar, 50).Value = lbl_employee_name.Text;
        cmd.ExecuteNonQuery();
        con.Close();

推荐答案

SqlDataReader  dr=cmd.ExecuteQuery();
if(dr.Read())
{
Label1.Text=dr["UserId"].ToString();
}

这篇关于如何从数据库中将值存储在标签中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！