CODEWITHSUNDEEP
c#sqlsql-servervisual-studio
ShlaSh Kanna
ShlaSh Kanna

Reputation: 1

Display values in label from SQL Server query

I'm trying to load the values to label from a SQL query:

sc.Open();
string type = Vehicle_cost.SelectedText;
string query = ("select Type from Vehicle_Registor where Reg_No = '" + type + "';");

SqlCommand cmd1 = new SqlCommand(query, sc);
SqlDataReader sdr = cmd1.ExecuteReader();
label23.Text = sdr.ToString();
sc.Close();

Upvotes: 0

Views: 1637

Answers (2)

Amnesh Goel
Amnesh Goel

Reputation: 2655

Try below code..

sc.Open();

string query = @"select Type from Vehicle_Registor where Reg_No = @Reg_No";

SqlCommand cmd1 = new SqlCommand(query, sc);
cmd1.Parameters.AddWithValue("@Reg_No", Vehicle_cost.SelectedText);

SqlDataReader sdr = cmd1.ExecuteReader();
sdr.Read();

label23.Text = sdr[0].ToString();

sc.Close();

Upvotes: 1

Paviel Kraskoŭski
Paviel Kraskoŭski

Reputation: 1419

Try something like this:

SqlCommand cmd1 = new SqlCommand(query, sc);
using (SqlDataReader sdr = cmd1.ExecuteReader())
{
    while (sdr.Read())
    {
        for (int i = 0; i < sdr.FieldCount; i++)
        {
            label23.text += sdr[i].ToString();
        }
    }
}
sc.Close();

Upvotes: 0

Related Questions