How can I execute multiple database requests in ASP.NET C#?

Question

In every ASP.NET application I have written, I would make number of request to the database before outputting the information onto the web page.

For example:

var DataTable1 = GetDataTable("Select * From Customers");
var DataTable2 = GetDataTable("Select * From Products");
var DataTable3 = GetDataTable("Select * From Orders");

As far as I'm aware, the code above would make 3 separate trips to the database and would do them one after the other.

Is there anyway I can gather together my parameterized SQL statements and make only 1 trip to the database server?

A better way to describe this would be "multiple database requests in one trip", not "parallel database requests". "Parallel" means they all happen literally at the same time, which doesn't seem to be what you're seeking; there are ways to do that too, though that makes little sense for a web page. — Ian Varley
– Ian Varley, Commented Mar 5, 2009 at 14:02
Thanks for the heads up. Your right. I've changed the title :) — GateKiller
– GateKiller, Commented Mar 5, 2009 at 18:25

GateKiller · Accepted Answer · 2009-03-05 18:26:10Z

6

var SqlString = "SELECT * FROM Customers; SELECT * FROM Products; SELECT * FROM ORDERS;");
var ds = GetDataSet(SqlString);
var DataTable1 = ds.Tables(0);
var DataTable2 = ds.Tables(1);
var DataTable3 = ds.Tables(2);

edited Mar 5, 2009 at 18:26

GateKiller

76.3k75 gold badges176 silver badges204 bronze badges

answered Mar 4, 2009 at 22:50

Joey

2,97121 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

eeerahul · Accepted Answer · 2011-12-19 07:09:01Z

1

My solution:

SqlConnection con = new SqlConnection("Server=CLASS-III-WKS10\\SQLEXPRESS;Initial 
Catalog=wind;Integrated Security=True");
int[] id=new int[9];
int i = 0;
page_load()
{
    con.Open();
    SqlCommand cmd = new SqlCommand("select *from windmill", con);
    SqlDataReader rd = cmd.ExecuteReader();
    while (rd.Read())
    {
        id[i] = rd.GetInt32(9);
        i++;
        //MessageBox.Show(id.ToString());  
    }
    rd.close();
    SqlCommand cmd1 = new SqlCommand("Update windmill set State='Stopped',PmState='Not Available'where Id=0", con);
    cmd1.ExecuteNonQuery(); 
}

edited Dec 19, 2011 at 7:09

eeerahul

1,6254 gold badges27 silver badges41 bronze badges

answered Dec 19, 2011 at 6:56

Hari Prasath

111 bronze badge

Comments

Jonathan Allen · Accepted Answer · 2009-03-04 22:53:47Z

0

Use semi-colons to separate SQL statements and reader.NextResult to get each set. Your code will end up looking something like this.

    Using con As New SqlConnection
        Using cmd As New SqlCommand("Select * From Customers; Select * From Products; Select * From Orders")
            Using reader = cmd.ExecuteReader
                Dim dt1 As DataTable
                dt1.Load(reader)

                reader.NextResult()

                Dim dt2 As DataTable
                dt2.Load(reader)

                reader.NextResult()


                Dim dt3 As DataTable
                dt3.Load(reader)

            End Using
        End Using
    End Using

answered Mar 4, 2009 at 22:53

Jonathan Allen

70.6k77 gold badges276 silver badges459 bronze badges

Comments

Pooria · Accepted Answer · 2009-03-04 22:49:33Z

-1

Create a Thread class and place a method in that class which accept string query as input: then create a Thread object and start the object.

Check this out http://msdn.microsoft.com/en-us/library/aa645740(VS.71).aspx

answered Mar 4, 2009 at 22:49

Pooria

7801 gold badge8 silver badges18 bronze badges

1 Comment

GateKiller Over a year ago

That would still make 3 trips to the database except it would do them at the same time. Not really the solution I was looking for.

Collectives™ on Stack Overflow

How can I execute multiple database requests in ASP.NET C#?

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related