View data selected in textboxes

Question

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");

Vulpes · 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 daydate 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 kakuru · Answer

Thanks vulpes it has worked well. Kind Regards.