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 { }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)