I want to bind the checkbox for Headertext in gridview dynamically in c Here I bind the Gridview From excel public void Importstring FilePath string extension string IsHDR string constr 3434 switch extension case 34xls34 constr ConfigurationManagerConnectionStrings34Excel03ConString34 ConnectionString break case 34xlsx34 constr

Hi rhino000Please refer the below codeHTMLltaspGridView ID34GridView134 runat34server34 OnPageIndexChanging34PageIndexChanging34 AllowPaging34true34 OnRowDataBound34GridView1RowDataBound34gtltaspGridViewgtCprivate void ImportToGridstring FilePath string Extension string isHDR string conStr 3434 switch Extension case 34xls34 Excel 9703 conStr ConfigurationManagerConnectionStrings34Excel03ConString34ConnectionString break case 34xlsx34 Excel 07 conStr ConfigurationManagerConnectionStrings34Excel07ConString34ConnectionString break conStr StringFormatconStr FilePath isHDR OleDbConnection connExcel new OleDbConnectionconStr OleDbCommand cmdExcel new OleDbCommand OleDbDataAdapter oda new OleDbDataAdapter DataTable dt new DataTable cmdExcelConnection co

How to dynamically bind checkbox in Header text of GridView using C# in ASP.Net

rhino000

SOLVED CLOSED ACTIVE ANSWERED
User: rhino000
Posted: on Jan 31, 2017 03:25 AM
Forum: Data Controls
Answer: 1
Views: 8890

I want to bind the checkbox for Headertext in gridview dynamically in c#.

Here I bind the Gridview From excel .

 public void Import(string FilePath, string extension, string IsHDR)
    {
        string constr = "";
        switch (extension)
        {
            case ".xls": 
                constr = ConfigurationManager.ConnectionStrings["Excel03ConString"]
                         .ConnectionString;
                break;
            case ".xlsx": 
                constr = ConfigurationManager.ConnectionStrings["Excel07ConString"]
                          .ConnectionString;
                break;
        }
        constr = string.Format(constr, FilePath, IsHDR);
        OleDbConnection connexcel = new OleDbConnection(constr);
        OleDbCommand cmdexcel = new OleDbCommand();
        OleDbDataAdapter oda = new OleDbDataAdapter();
        DataTable dt = new DataTable();
        cmdexcel.Connection = connexcel;
        connexcel.Open();
        DataTable dtexcelsh;
        dtexcelsh = connexcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
        string sheetname = dtexcelsh.Rows[0]["TABLE_NAME"].ToString();
        connexcel.Close();
        connexcel.Open();
        cmdexcel.CommandText = "select * from [" + sheetname + "]";
        oda.SelectCommand = cmdexcel;
        oda.Fill(dt);
        connexcel.Close();

        grdBindExcel.Caption = Path.GetFileName(FilePath);
        grdBindExcel.DataSource = dt;
        grdBindExcel.DataBind();

  

         int count = dt.Columns.Count;
         lblaaa.Text =count.ToString();

    }
    protected void grdBindExcel_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        string FolderPath = ConfigurationManager.AppSettings["FolderPath"];
        string FileName = grdBindExcel.Caption;
        string Extension = Path.GetExtension(FileName);
        string FilePath = Server.MapPath(FolderPath + FileName);

        Import(FilePath, Extension , rbHDR.SelectedItem.Text);
        grdBindExcel.PageIndex = e.NewPageIndex;
        grdBindExcel.DataBind(); 
    }

 <asp:GridView ID="grdBindExcel" runat="server" 
            onpageindexchanging="grdBindExcel_PageIndexChanging" onrowcreated="grdBindExcel_RowCreated" 
           >
           
    </asp:GridView>

I will Directly Bind the gridview From Excel.

Indresh

0 1

Reply
User: Indresh
Replied: on Jan 31, 2017 04:21 AM
Report

Hi rhino000,

Please refer the below code.

HTML

<asp:GridView ID="GridView1" runat="server" OnPageIndexChanging="PageIndexChanging"
    AllowPaging="true" OnRowDataBound="GridView1_RowDataBound">
</asp:GridView>

private void Import_To_Grid(string FilePath, string Extension, string isHDR)
{
    string conStr = "";
    switch (Extension)
    {
        case ".xls": //Excel 97-03
            conStr = ConfigurationManager.ConnectionStrings["Excel03ConString"].ConnectionString;
            break;
        case ".xlsx": //Excel 07
            conStr = ConfigurationManager.ConnectionStrings["Excel07ConString"].ConnectionString;
            break;
    }
    conStr = String.Format(conStr, FilePath, isHDR);
    OleDbConnection connExcel = new OleDbConnection(conStr);
    OleDbCommand cmdExcel = new OleDbCommand();
    OleDbDataAdapter oda = new OleDbDataAdapter();
    DataTable dt = new DataTable();
    cmdExcel.Connection = connExcel;

    //Get the name of First Sheet
    connExcel.Open();
    DataTable dtExcelSchema;
    dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
    string SheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
    connExcel.Close();

    //Read Data from First Sheet
    connExcel.Open();
    cmdExcel.CommandText = "SELECT * From [" + SheetName + "]";
    oda.SelectCommand = cmdExcel;
    oda.Fill(dt);
    connExcel.Close();

    //Bind Data to GridView
    GridView1.Caption = Path.GetFileName(FilePath);
    TemplateField tfield = new TemplateField();
    GridView1.Columns.Add(tfield);
    GridView1.DataSource = dt;
    GridView1.DataBind();
}

protected void PageIndexChanging(object sender, GridViewPageEventArgs e)
{
    string FolderPath = ConfigurationManager.AppSettings["FolderPath"];
    string FileName = GridView1.Caption;
    string Extension = Path.GetExtension(FileName);
    string FilePath = Server.MapPath(FolderPath + FileName);
    Import_To_Grid(FilePath, Extension, rbHDR.SelectedItem.Text);
    GridView1.PageIndex = e.NewPageIndex;
    GridView1.DataBind();
}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.Header)
    {
        CheckBox chkHeader = new CheckBox();
        e.Row.Cells[0].Controls.Add(chkHeader);
    }

    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        CheckBox cbColumn = new CheckBox();
        e.Row.Cells[0].Controls.Add(cbColumn);
    }
}

rhino000

0 2

Reply
User: rhino000
Replied: on Jan 31, 2017 05:04 AM
Report

@Indresh

Thanks

But i want to put chechbox only to the headertext

Indresh

0 3

Reply
User: Indresh
Replied: on Jan 31, 2017 05:16 AM
Modified: on Jan 31, 2017 05:18 AM
Report

Hi rhino000,

Please create screenshot in your gridveiw mark the checkbox position and share with me.

rhino000

0 4

Reply
ANSWER
User: rhino000
Replied: on Jan 31, 2017 06:52 AM
Modified: on Jan 31, 2017 06:52 AM
Report

protected void grdBindExcel_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
for (int i = 0; i < e.Row.Cells.Count; i++)
{
CheckBox checkBox = new CheckBox();

string val = e.Row.Cells[i].Text;

checkBox.Text = val.ToString();
checkBox.ID = Convert.ToInt32(i).ToString();
e.Row.Cells[i].Controls.Add(checkBox);
}
}}

How to dynamically bind checkbox in Header text of GridView using C# in ASP.Net

Company

Explore

Follow us

Contact Us