public Open_Business_Customer_Search() { InitializeComponent(); OpenWait.Hide(); OpenResult.Hide(); SetConnectionString(); }
private void Search_Click_1(object sender, EventArgs e) { SetConnectionString(); CountryName = Country.Text; CurrencyCode = Currency.Text; if (CountryName == "") { MessageBox.Show("Please Select Country"); } else if (CurrencyCode == "") { MessageBox.Show("Please Select Currency"); } else { OpenWait.Show(); OpenSearch.Enabled = false; using (SqlConnection conn = new SqlConnection(ConnectionString)) { string CunCode = GetCunCode(CountryName); SqlCommand cmd = new SqlCommand(String.Format(@"select CustomerNumber,S.SalesLocationName,CustomerTypeCode,C.CurrencyCode, CustomerStatusCode,CustomerName, * from customer C join Saleslocation S on C.Saleslocationcode = S.saleslocationcode where C.CustomerStatusCode = 'ACT' and S.SalesLocationCode = '{0}' and C.CustomerNumber like '0005%'", CunCode), conn); conn.Open(); DataTable dt = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(dt); OpenWait.Hide(); conn.Close(); OpenResult.Show(); OpenSearch.Enabled = true; OpenResult.DataSource = dt; } } }