Using SqlCommand Object in VB.NET

Question

Can I use two command object with one open connection in one procedure at VB.NET?

Answer 1

Yes you can. As long as you don't close the connection between commands, it'll work fine.

This is a C# example, but I'm sure you can work it out:

    using (SqlConnection cn = new SqlConnection("Connection String"))
    {

        SqlCommand cmd1 = new SqlCommand("Command1", cn);
        cmd1.CommandType = CommandType.StoredProcedure;

        SqlCommand cmd2 = new SqlCommand("Command2", cn);
        cmd2.CommandType = CommandType.StoredProcedure;

        cn.Open();

        // Execute cmd1
        // Execure cmd2

    }

Answer 2

Example; kinda pseudo but you should get the concept.

dim cnn as connection 
dim cmd as command 
dim cmd2 as command 
dim str1 as string
dim str2 as string 

cnn.open

cmd.connection = cnn 
cmd.command = str1 
cmd.execute

cmd2.connection = cnn 
cmd2.command = str2
cmd2.execute

cnn.close