View data selected in textboxes

Marvin kakuru

Hi all i am trying view various rows in a database table on various textboxes. below is the code im using

SqlConnection
string
SqlCommand
cn.Open();

string
textBox3.Text = s1.ToString();

textBox4.Text = s1.ToString();
textbox3 to view day and textbox4 to view date
any help will be highly apprieciated.
thanks

s1 = cmd.ExecuteScalar().ToString();cmd = new SqlCommand(sql, cn);sql = ("select day,date from Herdregistar where UIC like '%" + textBox1.Text + "%'");cn = new SqlConnection("Data Source=KATOTO-PC;Initial Catalog =thyfarm;User ID=sa;Password=Kyozi");

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted answer
The ExecuteScalar() method can only read the first column of the first row returned by the query.

To read two columns of the first (or only) row returned, you need to use a SqlDataReader:

SqlConnection cn = new SqlConnection("Data Source=KATOTO-PC;Initial Catalog =thyfarm;User ID=sa;Password=Kyozi");
string sql = ("select day,date from Herdregistar where UIC like '%" + textBox1.Text + "%'");
SqlCommand cmd = new SqlCommand(sql, cn);
cn.Open();
SqlDataReader sdr = cmd.ExecuteReader();
sdr.Read(); // read first row
textBox3.Text = sdr[0].ToString(); // read first column
textBox4.Text = sdr[1].ToString(); // read second column
Marvin kakuru15y ago
Thanks vulpes, it has worked well.
Kind Regards.