VB.NET

Store data in variables

Please support our VB.NET advertiser: Programming Forums - DaniWeb Sister Site

Thread Solved

•

Join Date: Sep 2009

Posts: 18

Reputation: SecurExpert is an unknown quantity at this point

Solved Threads: 1

SecurExpert SecurExpert is offline

Offline

Newbie Poster

Store data in variables

Oct 22nd, 2009

Hi Guys,

I am using sql in and am stuck. after "selecting * from table", how do i store whatever I have obtained from my database in a variable, for display?

Thanks.

•

Join Date: Feb 2009

Posts: 3,473

Reputation: sknake has much to be proud of

Solved Threads: 630

sknake

Offline

.NET Enthusiast

Oct 22nd, 2009

Post the code where you are executing the select * from table . There are a number of ways to go about this.

Scott Knake
Custom Software Development
Apex Software, Inc.

•

Join Date: Sep 2009

Posts: 18

Reputation: SecurExpert is an unknown quantity at this point

Solved Threads: 1

SecurExpert SecurExpert is offline

Offline

Newbie Poster

Oct 22nd, 2009

OK, am having something like this:

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
.............................
.............................
Dim SQLConn As New SqlConnection
        Dim SQLCmd As New SqlCommand
        SQLConn.ConnectionString = ConnStr
        SQLConn.Open()
        SQLStr = "use Institution" 'This is my database
        SQLCmd.CommandText = SQLStr
        SQLCmd.Connection = SQLConn
        SQLCmd.ExecuteNonQuery()
        SQLStr = "Select * from Stud_Details where 1"
        SQLCmd.CommandText = SQLStr
        SQLCmd.Connection = SQLConn
        SQLCmd.ExecuteNonQuery() 'The problem begins here! Is it OK?
.............................
.............................
Dim SQLConn As New SqlConnection
        Dim SQLCmd As New SqlCommand
        SQLConn.ConnectionString = ConnStr
        SQLConn.Open()
        SQLStr = "use Institution" 'This is my database
        SQLCmd.CommandText = SQLStr
        SQLCmd.Connection = SQLConn
        SQLCmd.ExecuteNonQuery()
        SQLStr = "Select * from Stud_Details where 1"
        SQLCmd.CommandText = SQLStr
        SQLCmd.Connection = SQLConn
        SQLCmd.ExecuteNonQuery() 'The problem begins here! Is it OK?

•

Join Date: Feb 2009

Posts: 3,473

Reputation: sknake has much to be proud of

Solved Threads: 630

sknake

Offline

.NET Enthusiast

Oct 22nd, 2009

No .. that isn't ok. You need to load the results in to a DataTable using a SqlDataReader created by calling SqlCommand.ExecuteReader() .

Example:

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
    private void button3333_Click(object sender, EventArgs e)
    {
      const string connStr = "Data Source=apex2006sql;Initial Catalog=Leather;Integrated Security=True;";
      const string query = "Select * From Invoice (NOLOCK)";
 
      DataTable dt;
 
      using (SqlConnection conn = new SqlConnection(connStr))
      {
        conn.Open();
        using (SqlCommand cmd = new SqlCommand(query, conn))
        {
          using (SqlDataReader dr = cmd.ExecuteReader())
          {
            dt = new DataTable();
            dt.Load(dr); //This loads a table
          }
        }
        conn.Close();
      }
 
      MessageBox.Show(string.Format("You have {0:F0} rows", dt.Rows.Count));
    }
    private void button3333_Click(object sender, EventArgs e)
    {
      const string connStr = "Data Source=apex2006sql;Initial Catalog=Leather;Integrated Security=True;";
      const string query = "Select * From Invoice (NOLOCK)";

      DataTable dt;

      using (SqlConnection conn = new SqlConnection(connStr))
      {
        conn.Open();
        using (SqlCommand cmd = new SqlCommand(query, conn))
        {
          using (SqlDataReader dr = cmd.ExecuteReader())
          {
            dt = new DataTable();
            dt.Load(dr); //This loads a table
          }
        }
        conn.Close();
      }

      MessageBox.Show(string.Format("You have {0:F0} rows", dt.Rows.Count));
    }