changing multiple lables with one sql query

Expand Post »

I am trying to figure out how to set multiple text boxes/labels with one sql query.

I dont need help connecting to the database or anything like that I just need to know how I can write one query to and set multiple text boxes with that one query.

here is what I have been doing, and there has got to be an easier way.

c# Syntax (Toggle Plain Text)
string selectAddress = "select cust_address from customers where customer_id = " + customerID;
string selectCity = "select customer_city from customer where customer_id = " + customerID;
 
SqlCommand cmdAddress = new SqlCommand(selectAddress, con);
SqlCommand cmdCity = new SqlCommand(selectCity, con);
 
this.lblAddress1.Text = cmdAddress.ExecuteScalar().ToString();
this.lblCity.Text = cmdCity.ExecuteScalar().ToString();
string selectAddress = "select cust_address from customers where customer_id = " + customerID;
string selectCity = "select customer_city from customer where customer_id = " + customerID;

SqlCommand cmdAddress = new SqlCommand(selectAddress, con);
SqlCommand cmdCity = new SqlCommand(selectCity, con);

this.lblAddress1.Text = cmdAddress.ExecuteScalar().ToString();
this.lblCity.Text = cmdCity.ExecuteScalar().ToString();

I would like to be able to write one query (actually just put it in a procedure) and set the text boxes/labels to the results of the query.

Thanks in advance for any help!
Cheers

Similar Threads

how to delete duplicate record in a table by using SQL query in MS SQL
SQL Query not quite pulling the data I expected... in MySQL
help in sql query in PHP
Read multiple column data from SQL query ( 1 row ) in ASP.NET
Javascript array from sql query in JSP

Yellowdog428

Reputation Points: 27

Solved Threads: 0

Light Poster

Offline

25 posts
since Mar 2008

Permalink

Jun 25th, 2009

Re: changing multiple lables with one sql query

Instead of calling ExecuteScalar you should open a DataReader and populate a DataTable.

c# Syntax (Toggle Plain Text)
    private void button1_Click(object sender, EventArgs e)
    {
      const string connStr = "Data Source=apex2006sql;Initial Catalog=Leather;Integrated Security=True;";
      const string query = "Select * From Invoice Where InvNumber = @InvNumber";
      using (DataTable dt = new DataTable())
      {
        using (SqlConnection conn = new SqlConnection(connStr))
        {
          conn.Open();
          using (SqlCommand cmd = new SqlCommand(query, conn))
          {
            cmd.Parameters.Add(new SqlParameter("@InvNumber", 1100));
            using (SqlDataReader dr = cmd.ExecuteReader())
            {
              dt.Load(dr);
            }
          }
          conn.Close();
        }
        if (dt.Rows.Count != 1)
          throw new Exception("Row not found");
 
        DataRow row = dt.Rows[0];
        string invNumber = Convert.ToString(row["InvNumber"]);
        string custName = Convert.ToString(row["CustomerName"]);
 
        System.Diagnostics.Debugger.Break();
      }
    }
    private void button1_Click(object sender, EventArgs e)
    {
      const string connStr = "Data Source=apex2006sql;Initial Catalog=Leather;Integrated Security=True;";
      const string query = "Select * From Invoice Where InvNumber = @InvNumber";
      using (DataTable dt = new DataTable())
      {
        using (SqlConnection conn = new SqlConnection(connStr))
        {
          conn.Open();
          using (SqlCommand cmd = new SqlCommand(query, conn))
          {
            cmd.Parameters.Add(new SqlParameter("@InvNumber", 1100));
            using (SqlDataReader dr = cmd.ExecuteReader())
            {
              dt.Load(dr);
            }
          }
          conn.Close();
        }
        if (dt.Rows.Count != 1)
          throw new Exception("Row not found");

        DataRow row = dt.Rows[0];
        string invNumber = Convert.ToString(row["InvNumber"]);
        string custName = Convert.ToString(row["CustomerName"]);

        System.Diagnostics.Debugger.Break();
      }
    }

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

Permalink

Jun 26th, 2009

Re: changing multiple lables with one sql query

C# Syntax (Toggle Plain Text)
DataTable tbl = new DataTable();
SqlDataAdapter adapt = new SqlDataAdapter(string.Format("select cust_address,customer_city  from customers where customer_id = {0}", customerID), con);
adapt.Fill(tbl);
if (tbl.Rows.Count > 0)
{
       lblAddress1.Text = (string)tbl.Rows[0]["cust_address"];
       lblCity.Text = (string)tbl.Rows[0]["customer_city"];
}
tbl.Dispose();
DataTable tbl = new DataTable();
SqlDataAdapter adapt = new SqlDataAdapter(string.Format("select cust_address,customer_city  from customers where customer_id = {0}", customerID), con);
adapt.Fill(tbl);
if (tbl.Rows.Count > 0)
{
       lblAddress1.Text = (string)tbl.Rows[0]["cust_address"];
       lblCity.Text = (string)tbl.Rows[0]["customer_city"];
}
tbl.Dispose();

Just one of many ways of doing this.

JerryShaw

Reputation Points: 69

Solved Threads: 75

Posting Pro in Training

Offline

465 posts
since Nov 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: date t date crystal report

Next Thread in C# Forum Timeline: datagrid in windows application

DaniWeb Message

Cancel Changes

User Name
Password