DaniWeb Forum Index > Software Development > C#

How to display the data returned by select statement in a TextBox

Please support our C# advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Dec 2008

Posts: 13

Reputation: nmakkena is an unknown quantity at this point

Solved Threads: 0

nmakkena

Offline

Newbie Poster

How to display the data returned by select statement in a TextBox

Jun 20th, 2009

Hi All,

Actually i want to dispaly the results of a select statement in a TextBox. Pls anyone give me an idea how to do it.

Thanks

•

Join Date: Oct 2008

Posts: 1,999

Reputation: ddanbe has much to be proud of

Solved Threads: 294

ddanbe

Offline

Posting Virtuoso

Re: How to display the data returned by select statement in a TextBox

Jun 20th, 2009

MyTextBox.Text="result of select";
will show result of select in your textbox.
Otherwise use the (DataBindings) property

Last edited by ddanbe; Jun 20th, 2009 at 1:03 pm.

Today is a gift, that's why it is called "The Present".
Make love, no war. Cave ab homine unius libri.
Danny

•

Join Date: Feb 2009

Posts: 3,346

Reputation: sknake has much to be proud of

Solved Threads: 603

sknake

Offline

.NET Enthusiast

Re: How to display the data returned by select statement in a TextBox

Jun 20th, 2009

 Help with Code Tags 
 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("Record not found!");
        DataRow row = dt.Rows[0];
 
        int invNumber = Convert.ToInt32(row["InvNumber"]);
        string invStatus = Convert.ToString(row["InvStatus"]);
        //Bind the text boxes after you have the values
        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("Record not found!");
        DataRow row = dt.Rows[0];
        
        int invNumber = Convert.ToInt32(row["InvNumber"]);
        string invStatus = Convert.ToString(row["InvStatus"]);
        //Bind the text boxes after you have the values
        System.Diagnostics.Debugger.Break();
      }
    }