如何填写sqldatareader函数的文本框 [英] How can I fill the text boxes from sqldatareader function

问题描述

Hi,Everyone

I am creating a web based project and I need to write data to textbox from database.
i have made a function that return sqldatareader but how can i write this data that came from sqldatareader into text boxes. can anybody show me code for this...

我尝试了什么：

What I have tried:

public SqlDataReader GetApproveDemand(string query)
{
    SqlDataReader reader = null;
        DBConnection().Open();
        SqlCommand cmd = new SqlCommand(query, DBConnection());
        reader = cmd.ExecuteReader();
        return reader;
}

aspx.cs文件中的MY代码如下

MY code in aspx.cs file is as follow

db db = new db();
       string query = "Select Item_ID,Emp_ID,Demand_Date,Demand_Quantity From Demands WHERE Demand_ID = '" + txt_Search_Demand_ID.Text + "'";
       SqlDataReader reader = db.GetApproveDemand(query);

       while (db.GetApproveDemand(query).Read())
       {
           txt_Approve_Item_ID.Text = (reader["Item_ID"].ToString());
           txt_Approve_Employee_ID.Text = (reader["Emp_ID"].ToString());
           txt_Approve_Date.Text = (reader["Demand_Date"].ToString());
           txt_Approve_Quantity.Text = (reader["Demand_Quantity"].ToString());
       }

推荐答案

由于你没有发布DBConnection（），我假设你在里面创建了SQLConnection对象。

我创建了一个工作样本。

As you didn't post DBConnection(), I'm assuming you are creating SQLConnection object inside it.
I've created a working sample.

SqlConnection con=null;
Public SqlConnection DBConnection()
{
   string constring=<Your Connection String>;
   if (con==null)
   {
      con=new SqlConnection(constring);
   }
   return con;
}
Public SqlDataReader GetName(string Query)
{
   SqlDataReader dr=null;
   DBConnection().Open();
   SqlCommand cmd=new SqlCommand(Query,DBConnection());
   dr=cmd.ExecuteReader();
   return dr;
}
Public void DisplayName()
{
   DB db=new DB();
   string Query="select name from demo where id = 1";
   SqlDataReader dr=db.GetName(Query);
   while(dr.read())
   {
      txtName.Text=dr["name"].toString();
   }
}

希望这会对你有所帮助。

Hope this helps you.

这篇关于如何填写sqldatareader函数的文本框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！