im getting an error when fetching data into gridview

Subin Thomas

7y1.1k.NET

i have a gridview with project names with autogenerated select button when select button is selected bellow code is executed

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
lblProjectno.Text = GridView1.SelectedRow.Cells[1].Text;
String s1 = lblProjectno.Text;
SqlConnection con = new SqlConnection(ppd_Vas);
con.Open();
SqlCommand cmd = new SqlCommand("query'", con);
cmd.Parameters.AddWithValue("@ProjectNo", s1);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView2.DataSource = ds;
GridView2.DataBind();
con.Close();
GridView5_Show();
DisplayProject();
Panelprojectdashboard1.Visible = true;
Bindchart1();
BindChart2();
}

above code generates a gridview after selecting the select button

in above code i have mentioned a function call Gridview5_show()

code of Gridview5_show() is bellow

protected void GridView5_Show()
{
string s1 = GridView1.SelectedRow.Cells[1].Text;
SqlConnection con = new SqlConnection(ppd_Vas);
con.Open();
SqlCommand cmd = new SqlCommand("query ", con);
cmd.Parameters.AddWithValue("@ProjectNo", s1);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView5.DataSource = ds;
GridView5.DataBind();
con.Close();
}

but when im selecting the select button it is showing error at line 17 da.Fill(ds);

error is : Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manoj Bhoir7y ago
Hi,

Try by configuring CommandTimeOut Property of SQLCommand.

This will wait as much time as needed for the operation to complete.
cmd.CommandTimeout = 0;
+1
Amit Kumar7y ago
Hi Subin,You can do onething. Debug your code where you will get error take the snapshot post the snapshot. After getting and error we can solve ur problem easily. If it is possible then post it.
+2
Subin Thomas7y ago
hey amit,
i tried the syntax like you said and now it is showing that it has invalid columns
but when i run the same query in database it is working fine
+1
Subin Thomas7y ago
hi anoop and mohsin,

i have executed the query in my sql server and it took 9 to 10 sec to fetch the record when i run my application it gives error after 14-15 sec
+1
Mohsin Arif7y ago
hi
i think your query which you have not shown here . is taking much time so dont wory about this run the query in SQL and check out how much it take.
if this take a long time there is execution plan option in SQL which is use for indexing,
index your query then execute it will take lowest time. if again take a time then set timeout time more in your code.
+2
Amit Kumar7y ago
Hi,
Use the below code. It will work fine you can change your datatable according to your self.
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{

  lblProjectno.Text = GridView1.SelectedRow.Cells[1].Text;

  string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

  string query = "SELECT * FROM Customers where ProjectNo ="+@ lblProjectno.Text +"";
  using (SqlConnection con = new SqlConnection(constr))
  {
        using (SqlDataAdapter sda = new SqlDataAdapter(query, con))
        {
            using (DataSet ds = new DataSet ())
            {
                sda.Fill(ds);
                GridView2.DataSource = ds;
                GridView2.DataBind();
            }
        }
    }

           GridView5_Show();
           DisplayProject();
           Panelprojectdashboard1.Visible = true;
           Bindchart1();
           BindChart2();

       }
+2
Anoop Kumar Sharma7y ago
Hi Subin,

I think your query is taking longer time which throws an error Execution Timeout Expired. I will recommend you to check the query as it might require some tuning. You can also increase connection timeout (or command timeout) if needed.

Hope this will help you.
+2
Subin Thomas7y ago
hey amit
actually i have wrote a proper select query as i am not supposed to share the select query i just wrote query here
+1
Amit Kumar7y ago
Hi,
you have write wrong one place where
Sqlcommand cmd= new SqlCommand ("query ",con);
Here in place of query you will have to write select query then it will work properly.like.

Sqlcommand cmd= new SqlCommand ("select * from tablename ",con);
+2