private void dataGridViewX1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyValue == 27)
{
dataGridViewX1.Visible = false;
Ptxt3.Focus();
}
if (e.KeyValue == 13)
{
dataGridViewX1.Visible = false;
Ptxt3.Focus();
}
}
private void maskedTextBox1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyValue == 27)
{
this.Close();
}
if (e.KeyValue == 13)
{
con.connection();
DataTable dt = con.show_data("select code'کد مشتری',name+N' '+family'نام و نام خانوادگی' from moshtary where code = N'" + txt1.Text + "' AND codemar = N'" + function.Code_markaz + "' ");
con.Disconnect();
if (dt.Rows.Count == 0)
{
txt2.Text = "";
txt1.Text = "";
}
else
{
txt1.Text = dt.Rows[0].ItemArray.GetValue(0).ToString();
txt2.Text = dt.Rows[0].ItemArray.GetValue(1).ToString();
}
Ptxt3.Focus();
}
if (e.KeyCode == Keys.Down)
{
dataGridViewX1.Visible = true;
dataGridViewX1.Focus();
con.connection();
if (txt1.Text == "")
{
sql = "select code'کد مشتری',name+N' '+family'نام و نام خانوادگی' from moshtary";
}
else
{
sql = "select code'کد مشتری',name+N' '+family'نام و نام خانوادگی' from moshtary where (code LIKE N'" + txt1.Text + "%') AND (codemar = N'" + function.Code_markaz + "')";
}
dataGridViewX1.DataSource = con.show_data(sql);
con.Disconnect();
}
}