Click here to Skip to main content
16,016,562 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hello,


when i deploy in the production server 25 user is exporting excel at same time then
data is not coming in the gridview.no data found

when they export excel in single user it is exporting excel is working
fine.

my code is the gridviewbind
C#
public void BindSummaryGrid()
    {
        SqlConnection con = new SqlConnection(connString);
        SqlCommand cmd = new SqlCommand();
        SqlDataAdapter da = new SqlDataAdapter();
        DataSet ds = new DataSet();
        try
        {
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "uspGetSummary";
            cmd.Connection = con;
            con.Open();
            cmd.Parameters.AddWithValue("@QuarterMonthID", Convert.ToInt32(ddlQuarterMonth1.SelectedValue.ToString()));
            cmd.Parameters.AddWithValue("@QuarterYearID", Convert.ToInt32(ddlQuarterYear1.SelectedValue.ToString()));
            da.SelectCommand = cmd;
            da.Fill(ds);
            grdvwExportSummary.DataSource = ds.Tables[0];
            grdvwExportSummary.DataBind();
        }
        catch (Exception ex)
        {

        }
        finally
        {
            if (con.State == ConnectionState.Open)
            {
                con.Close();
            }
        }

    }
Posted
Updated 25-Aug-15 23:17pm
v2
Comments
j snooze 26-Aug-15 17:15pm    
So the gridview is empty or the excel file is empty?
sadhana4 27-Aug-15 0:18am    
gridview is empty

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900