如何在文本框中显示数据库值？ [英] How to show database values on textboxes?

问题描述

这是我的存储过程：

create procedure SP_ShowUse
   (@employeeName varchar (50))
as 
begin
     select 
         PTS_Employee.Emp_Username, PTS_Approval.Approval_ApprovedBY,  
         PTS_Branches.Branch_BranchName
    from 
         PTS_Employee, PTS_Approval, PTS_Branches
    where 
         PTS_Employee.Branch_BranchID = PTS_Branches.Branch_BranchID
         AND PTS_Employee.Approval_ApprovedID = PTS_Approval.Approval_ApprovedID
         AND PTS_Employee.Emp_Username = @employeeName
end

我要显示在3个不同的文本框中选择所有的三个值

I want to display all the three values selected in 3 different textboxes

我怎么能这样做？

推荐答案

存储在数据集中的数据，并提取fromit ...

store the data in dataset and extract fromit...

      SqlConnection con = new SqlConnection(connstring);
        con.Open();
        SqlCommand mycomm=new SqlCommand ("SP_ShowUse",con);
        mycomm.CommandType=CommandType.StoredProcedure;
        mycomm.Parameters.Add("@employeeName", SqlDbType.VarChar).Value = "Anil";
        SqlDataAdapter showdata = new SqlDataAdapter(mycomm);
        DataSet ds = new DataSet();
        showdata.Fill(ds);
        txtEmployeename.Text = ds.Tables[0].Rows[0]["Emp_Username"].ToString();
        txtBranchName.Text = ds.Tables[0].Rows[0]["Branch_BranchName"].ToString();
        txtApprvdby.Text = ds.Tables[0].Rows[0]["Approval_ApprovedBY"].ToString();
        binddropdownlist();
        con.Close();

这篇关于如何在文本框中显示数据库值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！