private void button2_Click(object sender, EventArgs e) { if (textBox1.Text.Trim().Length == 0) MessageBox.Show("Please fill this area first"); else { SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=AG_DB;Integrated Security=True"); SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM Musteri where ID = '" + textBox1.Text + "'", con); DataTable dt = new DataTable(); sda.Fill(dt); textBox1.Text = dt.Rows[0][0].ToString(); textBox2.Text = dt.Rows[0][1].ToString(); textBox3.Text = dt.Rows[0][2].ToString(); textBox4.Text = dt.Rows[0][3].ToString(); textBox5.Text = dt.Rows[0][4].ToString(); textBox6.Text = dt.Rows[0][5].ToString(); textBox7.Text = dt.Rows[0][6].ToString(); textBox8.Text = dt.Rows[0][7].ToString(); } }
if(dt.Rows.Count > 0) { textBox1.Text = dt.Rows[0][0].ToString(); ... } else
using
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)