private void Open_Customer_Load(object sender, EventArgs e)
{
con.Open();
dataGridView1.Rows.Clear();
Dt = new DataTable();
com = new SqlCommand("select company_name,contact_person,phone_puplic,sales_person,custmer_group,blance from customer");
com.Connection = con;
adapt = new SqlDataAdapter(com);
adapt.Fill(Dt);
// dataGridView1.DataSource = Dt;
for (int i = 0; i < Dt.Rows.Count; i++)
{
dataGridView1.Rows.Add(Dt.Rows[i][0], Dt.Rows[i][1], Dt.Rows[i][2], Dt.Rows[i][3], Dt.Rows[i][4], Dt.Rows[i][5]);
}
con.Close();
ado_project f = new ado_project();
dt = f.combo_opencust();
dr = dt.NewRow();
dr[0] = "All";
dt.Rows.Add(dr);
comboBox1.DataSource = dt;
comboBox1.DisplayMember = dt.Columns[0].ToString();
Open_Customer op = new Open_Customer();
op.Refresh();
}
private void update_customer_Load(object sender, EventArgs e)
{
ado_project f = new ado_project();
DataTable dt = f.combo_opencust();
comboBox6.DataSource = dt;
comboBox6.DisplayMember = dt.Columns[0].ToString();
con.Open();
SqlCommand com = new SqlCommand("select company_name,contact_person,address,phone_primary,phone_puplic,e_mail,card_num,card_verification_num,card_type,expiration_month,expiration_year,cardholder_name,shipping_address,sales_person,customer_notes,custmer_group,blance from customer where customer_id='" + value + "'", con);
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
textBox1.Text = dr[0].ToString();
textBox2.Text = dr[1].ToString();
textBox3.Text = dr[2].ToString();
maskedTextBox1.Text = dr[3].ToString();
maskedTextBox2.Text = dr[4].ToString();
textBox4.Text = dr[5].ToString();
maskedTextBox3.Text = dr[6].ToString();
maskedTextBox4.Text = dr[7].ToString();
comboBox1.Text = dr[8].ToString();
comboBox2.Text = dr[9].ToString();
comboBox3.Text = dr[10].ToString();
textBox5.Text = dr[11].ToString();
textBox6.Text = dr[12].ToString();
textBox7.Text = dr[13].ToString();
textBox8.Text = dr[14].ToString();
comboBox6.Text = dr[15].ToString();
maskedTextBox5.Text = dr[16].ToString();
}
dr.Close();
con.Close();
}
private void Customer_Load(object sender, EventArgs e)
{
ado_project f = new ado_project();
DataTable dt = f.combo_opencust();
comboBox6.DataSource = dt;
comboBox6.DisplayMember = dt.Columns[0].ToString();
//if (checkBox1.Checked == true)
//{
// maskedTextBox3.Text = "";
// maskedTextBox4.Text = "";
// comboBox1.Text = "";
// comboBox2.Text = "";
// comboBox3.Text = "";
// textBox5.Text = "";
// maskedTextBox3.Enabled = false;
// maskedTextBox4.Enabled = false;
// comboBox1.Enabled = false;
// comboBox2.Enabled = false;
// comboBox3.Enabled = false;
// textBox5.Enabled = false;
//}
}