How to display value inside sql, based on another value RSS

• • Reply
  

  colol

  Member

  117 Points

  542 Posts

  How to display value inside sql, based on another value

  Nov 08, 2012 05:35 AM|LINK

  Hello, I have this id column and a text column in one table. I want to be able to display the text value, when the id is search inside the database. I have already created the search part, but am unsure on how to get and display the text value. This is my code:

  con = new SqlConnection(connString);
          con.Open();
  
          cmd = new SqlCommand("select * from table where ID='" + Label1.Text + "'", con);
          da = new SqlDataAdapter(cmd);
  
          da.Fill(dt);
  
          if (dt.Rows.Count > 0)
          {
            //how to be able to get/call the text value and display it on the page?
  
          }

  • Edited by colol on Nov 08, 2012 05:35 AM
  • Edited by colol on Nov 08, 2012 05:35 AM
  • Edited by colol on Nov 08, 2012 05:36 AM
• • Reply
  

  tgyoga

  Contributor

  2378 Points

  393 Posts

  Re: How to display value inside sql, based on another value

  Nov 08, 2012 08:16 AM|LINK

  First of all, you say you are gonna search for a id, so..

  You should not be using a label control, change that to a textbox, so that you can key in a ID

  Do not use "Select *", always specify the columns that you want to select like.. SELECT Name, ID FROM YourTable WHERE ID = ....

  Try to have a stored proc whereever possible, so that your input value can be parameterized.

  Before checking for the count of rows, make sure your dt is not NULL...

  if (dt != null && dt.Rows.Count > 0) {...}

  Since you want to display result, first you should be having a Gridview..

  if (dt != null && dt.Rows.Count > 0) 
  {
        gridView1.DataSource = dt;
        gridView1.DataBind();
  }

  
  
  

   

   

  Regards,
  Yoga
  • Marked as answer by Amy Peng - MSFT on Nov 16, 2012 01:10 AM
• • Reply
  

  colol

  Member

  117 Points

  542 Posts

  Re: How to display value inside sql, based on another value

  Nov 08, 2012 11:17 PM|LINK

  good morning, thank you but I dont understand the part where you say about stored proc, can you give me an example?

• • Reply
  

  Amy Peng - M...

  Star

  11753 Points

  1097 Posts

  Microsoft

  Re: How to display value inside sql, based on another value

  Nov 09, 2012 01:46 AM|LINK

  colol

  good morning, thank you but I dont understand the part where you say about stored proc, can you give me an example?

  Hi colo1,

  Please try to refer to the code about store proc:

  create procedure test @id int
  As
  Begin
  select Text1 from table where id=@id
  End
  
  exec test 1     //input the value of the @id

  Hope it can help you!
  Regards,
  Amy Peng

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store
  
  
  • Marked as answer by Young Yang - MSFT on Nov 20, 2012 02:18 AM