E sada ,u jednom textboxu ucitam iz baze imena, i onda pri pritusku na dugme, zelio mi da se u datagrid upise prezime koje odgovara tom imenu.
...
private void Form1_Load(object sender, EventArgs e)
{
...
dt = ds.Tables.Add("Racun");
dt.Columns.Add("ime", typeof(string));
dt.Columns.Add("prezime", typeof(string));
dataGridView1.DataSource = dt;
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection sqlConn;
string connstring = @"server=.\sqlexpress;Integrated Security=SSPI; initial catalog=proba";
sqlConn = new SqlConnection(connstring);
sqlConn.Open();
SqlCommand komanda1 = new SqlCommand();
komanda1.Connection = sqlConn;
komanda1.CommandText="SELECT prezime FROM tabela WHERE ime="+comboBox1.text;
SqlDataReader rider;
rider = komanda1.ExecuteReader();
DataRow dw = dt.NewRow();
dw["ime"] = comboBox1.Text;
dw["prezime"] = rider;
dt.Rows.Add(dw);
dataGridView1.DataSource = dt;
}
Javlja gresku sa SqlDataReader-om.