来自数据库的文本框中的数据 [英] data in textbox from database

问题描述

我想以数据库中的列表形式从数据库中获取文本框中列的所有数据。

i我正在尝试此代码............... ..

 CON.Open（）; 
 SqlCommand CMD =  new  SqlCommand（  SELECT CUST_NAME来自CUSTOMER，CUST_ID = CUST_NAME，CON）; 
 SqlDataReader DR = CMD.ExecuteReader（）; 
  while （DR.Read（））
 {
 CUST_NAME.Text = DR [  CUST_NAME]。ToString（）; 
} 
 CON.Close（）; 

[edit]已添加代码块[/ edit]

解决方案

你可以在文本框中得到逗号分隔值，如下所示..

 CON.Open（）; 
 SqlCommand CMD =  new  SqlCommand（  SELECT CUST_NAME来自CUSTOMER，CUST_ID = CUST_NAME，CON）; 
 SqlDataReader DR = CMD.ExecuteReader（）; 
  while （DR.Read（））
 {
 CUST_NAME.Text + = DR [  CUST_NAME]。ToString（）; 
} 
 CON.Close（）; 
 

除非您的客户ID是CUST_NAME，否则它将无效。

试试这个：

 CON.Open（）; 
 SqlCommand CMD =  new  SqlCommand（  SELECT CUST_NAME来自CUSTOMER，其中CUST_ID = @ ID，CON）; 
 CMD.Parameters.AddWithValue（  @ ID，myCustomerIDThatIAmLookingFor）; 
 SqlDataReader DR = CMD.ExecuteReader（）; 
  if （DR.Read（））
 {
 CUST_NAME.Text = DR [  CUST_NAME]。ToString（）; 
} 
 CON.Close（）; 

请注意，我还将更改为循环到 if - 因为每次循环可能不是你想要的时候都会覆盖框中的文字......

  //  搜索详情 
 
 SqlDataAdapter retail =  new  SqlDataAdapter（  SELECT RetailPrice FROM AddItem WHERE itemCode =' + comboBox2 .Text +  '，DB.connection（））; 
 
  //   create DataTable  
 DataTable DT3 =  new  DataTable（）; 
  //  填写DataTable  
 retail.Fill（DT3）; 
  //  搜索详细信息十进制 
  decimal  cat2 =（ decimal ）DT3.Rows [ 0 ] [ 0 ]; 
  //  填充textBox  
 textBoxretail.Text = Convert.ToString（cat2） ; 

[edit]已添加代码块[/ edit]

i want to fetch all data of a column in textbox from database in form of list like combobox.
i am trying this code .................

CON.Open();
SqlCommand CMD = new SqlCommand("SELECT CUST_NAME FROM CUSTOMER WHERE CUST_ID=CUST_NAME", CON);
SqlDataReader DR = CMD.ExecuteReader();
while (DR.Read())
{
   CUST_NAME.Text = DR["CUST_NAME"].ToString();
}
CON.Close();

[edit]Code block added[/edit]

解决方案

you can get comma separated value as below in textbox..

CON.Open();
SqlCommand CMD = new SqlCommand("SELECT CUST_NAME FROM CUSTOMER WHERE CUST_ID=CUST_NAME", CON);
SqlDataReader DR = CMD.ExecuteReader();
while (DR.Read())
{
    CUST_NAME.Text += DR["CUST_NAME"].ToString();
}
CON.Close();

Well, it won't work, unless your customer id is "CUST_NAME".
Try this:

CON.Open();
SqlCommand CMD = new SqlCommand("SELECT CUST_NAME FROM CUSTOMER WHERE CUST_ID=@ID", CON);
CMD.Parameters.AddWithValue("@ID", myCustomerIDThatIAmLookingFor);
SqlDataReader DR = CMD.ExecuteReader();
if (DR.Read())
   {
   CUST_NAME.Text = DR["CUST_NAME"].ToString();
   }
CON.Close();

Note that I also changed your while loop to an if - since you overwrite the text in the box each time a loop is probably not what you want...

//search Details

SqlDataAdapter retail = new SqlDataAdapter("SELECT retailPrice FROM AddItem WHERE itemCode='" + comboBox2.Text + "'", DB.connection());

//create DataTable
            DataTable DT3 = new DataTable();
//Fill DataTable
            retail.Fill(DT3);
//Search Details Decimal
            decimal cat2 = (decimal)DT3.Rows[0][0];
//Fill textBox
            textBoxretail.Text = Convert.ToString(cat2);

[edit]Code block added[/edit]

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