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;
}
}
}
