我的dataGridView给了我不依赖的数据

问题描述

在我的数据库中1行



在dataGridView中给我的3行不真实



这是我的代码

In My Database 1 Row

In dataGridView Give My 3 rows not Real

This My Code

 try
           {
               DataTable dt1 = new DataTable();
               //string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
               using (SqlConnection con2 = new SqlConnection("data source=Server;Database=MnStores; Integrated Security = False; User ID=; Password=; Trusted_Connection=false;"))
               {
                   string sqlstr1 =
"Select dr.ReceiptNote_id as 'Received Id', ct.Customer_name as 'Customer Name',dr.Receipt_Date as 'Received Date',dd.Product_Id as 'Product Id',dd.Product_name as 'Product Name' from Customers_TBL as ct
inner join   Receipt_NoteHeadTBL as dr on dr.Customer_id=ct.Customers_id
inner join  Receipt_NoteDetalisTBL as dd on dr.ReceiptNote_id=dd.Fk_ReceiptNote_id WHERE  ct.Customers_id = @Customers_id and dr.Receipt_Date >= @DT11 AND dr.Receipt_Date <= @DT22";

using (SqlDataAdapter dr1 = new SqlDataAdapter(sqlstr1, con2))
                   {
                       dr1.SelectCommand.Parameters.AddWithValue("@Customers_id", txtCustomersID2.Text);

                       dr1.SelectCommand.Parameters.AddWithValue("@DT11", @dateTimePicker1.Text);
                       dr1.SelectCommand.Parameters.AddWithValue("@DT22", @dateTimePicker2.Text);
                       dr1.Fill(dt1);
                       dataGridView1.DataSource = dt1;
                   }

               }
           }
           catch { }

某些发票重复且不真实

Some Invoice Duplicated And Not Real

推荐答案

这篇关于我的dataGridView给了我不依赖的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！