private void DisplayData() { string vWhere = string.Empty; if (!string.IsNullOrEmpty(txtFilter.Text)) { vWhere = " AND Parties.PartyName Like '%" + txtFilter.Text + "%'"; } vWhere += string.Format(" And convert(datetime,Convert(varchar,CustomerIssue.IssueDate,1)) Between Convert(Datetime,(convert(varchar,convert(Datetime,'{0} 00:00:00',102),1)))and Convert(Datetime,(convert(varchar,convert(Datetime,'{1} 00:00:00',102),1)))", dt_From.Value.ToShortDateString(), dt_ToDate.Value.ToShortDateString()); if (vIsFromReturn) { vWhere += " AND SaleID NOT IN (Select SaleID From SaleReturn)"; } try { DAL.CustomerIssue objDAL = new DAL.CustomerIssue(); objDAL.connectionstring = connectionString; dt = objDAL.getSearchRecord(vWhere); Grid.AutoGenerateColumns = false; Grid.DataSource = dt; } catch (Exception exc) { MessageBox.Show(exc.Message.ToString()); } }
private void txtVendorID_TextChanged(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtVendorID.Text)) { txtVendorName.Text = string.Empty; } else { string vWhere = string.Empty; vWhere = "AND Parties.PartyID = " + txtVendorID.Text; DAL.CustomerIssue obj = new DAL.CustomerIssue(); obj.connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["MyString"].ConnectionString; //DataTable dt = obj.getParties(vWhere); DataTable dt = obj.getParties(vWhere); if (dt.Rows.Count > 0) { txtVendorID.Text = dt.Rows[0]["PartyID"].ToString(); // vForm.MyID; txtVendorName.Text = dt.Rows[0]["PartyName"].ToString(); // vForm.MyName; } } }