Hi friends,

I am new to this and my issue is my stored procedure runs very fast in management studio less than 1-2 seconds. And when i try to get those results in a dataset it takes 8-10 seconds. My Application code is below

myConnection.Open();

SqlDataAdapter MyAdapter = new SqlDataAdapter(myCommand);

MyAdapter.Fill(ds);

any one can suggest any ideas?

Jino