如何使用Datagridview添加表2中存在的列A的值

本文关键字：存在 的值 何使用 Datagridview 添加 | 更新日期: 2023-09-27 18:03:54

Mabuhay！

做这件事最有效或更方便的方法是什么。

我有一个选择查询，并将其放在基于我的过滤器的数据网格视图中。它有5列。我想知道Datagridview中的列CA是否已经存在于第3列的表2上？

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=db;User ID=sa;Password=pw");
            // DateTime dt = new DateTime();
            //dt = DateTime.Now.ToString();
            SqlDataAdapter sda = new SqlDataAdapter("SELECT max(PurchaseOrder.POTitle) as Description,sum(PurchaseOrderEntry.Price *PurchaseOrderEntry.QuantityOrdered) as Amount, max(PurchaseOrder.PONumber)as PONumber, " +
                      " max(PurchaseOrderEntry.OrderNumber) as BoxCount, max(PurchaseOrderEntry.OrderNumber) as PLC,max(PurchaseOrderEntry.OrderNumber) as Branch, max(PurchaseOrderEntry.OrderNumber) as PreparedBy, max(PurchaseOrderEntry.OrderNumber) as CheckedBy " +
                      " FROM PurchaseOrder LEFT OUTER JOIN" +
                      " PurchaseOrderEntry ON PurchaseOrder.ID = PurchaseOrderEntry.PurchaseOrderID" +
                      " WHERE (PurchaseOrder.Remarks like '%" + tanggapan.Text + "%') AND (PurchaseOrder.DateCreated BETWEEN '" + dateTimePicker1.Text + "' AND '" + dateTimePicker2.Text + "' and PurchaseOrder.OtherStoreID = '" + branch.Text + "') Group By PurchaseOrder.PONumber", con);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            dataGridView1.DataSource = dt;

这显示了我的查询筛选器。如果PurchaseOrderEntry.OrderNumber已经存在于我的记录中，那么如何操作的任何提示，以便我可以管理重复哪个。

谢谢！Chris

如何使用Datagridview添加表2中存在的列A的值

我现在在我的作品中添加了这段代码，它现在正在工作。

 DataTable dt = new DataTable();
 dt.Clear();
 dt.Reset();
 con.Close();
 adaptors1.SelectCommand = con.CreateCommand();
 adaptors1.SelectCommand.CommandText = "Select TOP 1 [ponumber],[clref]  from [ISSPandayan].[dbo].[" + branch.Text + "] where [ponumber] = '" + dr.Cells["ponumber"].Value + "' ORDER BY [clref] ASC";
 adaptors1.Fill(dt); 
 // select query para malam kung existing ponumber
 if (dt.Rows.Count == 1)
 {
     adaptorss.InsertCommand.Parameters.Add("@already", SqlDbType.VarChar).Value = dt.Rows[0][1].ToString();
 }
 else
 {
     adaptorss.InsertCommand.Parameters.Add("@already", SqlDbType.VarChar).Value = " ";
 }
 //adaptorss.InsertCommand.Parameters.Add("@already", SqlDbType.VarChar).Value = "";
 //MessageBox.Show(Convert.ToString(dr.Cells["description"].Value));
 con.Close();
 con.Open();
 adaptorss.InsertCommand.ExecuteNonQuery();
 adaptorss.InsertCommand.Parameters.Clear();
相关文章：