如何在同一查询中插入文本框和数据库列？ [英] How do I insert textboxes and database columns in the same query?

问题描述

void add()
       {
           var docnum = SR_Yr.Text + '-' + SR_No.Text;
           string constring = "Data Source=D-HOS-MIS2;Initial Catalog=Consignment_db;Persist Security Info=True;User ID=sa;Password=t.july.01";
           string query = "insert into StockRequesitionTable (SR_DocNo,SR_ItemID) values('"+docnum+"',SRT_ID)";
           SqlConnection con_db = new SqlConnection(constring);
           SqlCommand cmd = new SqlCommand(query, con_db);
           SqlDataReader reader;

           try
           {
               con_db.Open();
               reader = cmd.ExecuteReader();
               while (reader.Read())
               {

               }
           }
           catch (Exception ex)
           {
               MessageBox.Show(ex.Message);
           }
       }

有没有办法使用textboxes，datetime和or构造它组合框和数据库表？



我尝试过：



我试过运行上面描述的代码。它在值处提示输入未知表格。我意识到我可能缺少连接查询，但我不知道如何构建它。

Is there any way to construct it using textboxes,datetime and or comboboxes along with database tables?

What I have tried:

I've tried to run the code stated above. It prompted for an unknown table at values. I realized I was lacking maybe a join query but I don't know how to construct it.

推荐答案

void add()
       {
           var docnum = SR_Yr.Text + '-' + SR_No.Text;
           string constring = "Data Source=D-HOS-MIS2;Initial Catalog=Consignment_db;Persist Security Info=True;User ID=sa;Password=t.july.01";
           string query = "insert into StockRequesitionTable (SR_DocNo,SR_ItemID) values('"+docnum+"',SRT_ID)";
           SqlConnection con_db = new SqlConnection(constring);
           SqlCommand cmd = new SqlCommand(query, con_db);
           

           try
           {
               con_db.Open();
               cmd.ExecuteNonQuery();
               
           }
           catch (Exception ex)
           {
               MessageBox.Show(ex.Message);
           }
       }

您可以在此查询中传递参数。

You can pass parameter in this your query.

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