Skip to main content

Importing data from excel 2003 file in a gridview in asp.net c#
In this article you will see how to import given sheet from excel 2003 file into dataset and then display this data into girdview.

Below is the code for import data from given sheet named Sheet1$ into dataset then bind it to gridview, change sheet name as per your excel sheet name you have to ad suffix $ in sheet name.

Importing data from Sheet1$ of excel 2003 file code -


private void btnImportExcelToGridview_Click(object sender, System.EventArgs e)
 {
        String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
        "Data Source="+Server.MapPath(@"File/Book1.xls")+
        "Extended Properties=Excel 8.0;";

        DataSet ds = new DataSet();
        //You must use the $ after the object
        //you reference in the spreadsheet
        OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);

         da.Fill(ds);
         Gridview1.DataSource = ds.Tables[0].DefaultView;
         Gridview1.DataBind();
 }




Labels:

Popular posts from this blog

Uploading large file in chunks in Asp.net Mvc c# from Javascript ajax
Often we have a requirement to upload files in Asp.net, Mvc c# application but when it comes to uploading larger file, we always think how to do it as uploading large file in one go have many challenges like UI responsiveness, If network fluctuate for a moment in between then uploading task get breaks and user have to upload it again etc.

Read More »

Regular expression for alphanumeric with space in asp.net c#
How to validate that string contains only alphanumeric value with some spacial character and with whitespace and how to validate that user can only input alphanumeric with given special character or space in a textbox (like name fields or remarks fields). In remarks fields we don't want that user can enter anything, user can only able to enter alphanumeric with white space and some spacial character like -,. etc if you allow. Some of regular expression given below for validating alphanumeric value only, alphanumeric with whitspace only and alphanumeric with whitespace and some special characters.

Read More »

How to handle click event of linkbutton inside gridview
Recently I have posted how to sort only current page of gridview , Scrollble gridview with fixed header through javascript , File upload control inside gridview during postback and now i am going to explain how to handle click event of linkbutton or any button type control inside gridview. We can handle click event of any button type control inside gridview by two way first is through event bubbling and second one is directly (in this type of event handling we need to access current girdviewrow container)

Read More »

regex - check if a string contains only alphabets c#
How to validate that input string contains only alphabets, validating that textbox contains only alphabets (letter), so here is some of the ways for doing such task. char have a property named isLetter which is for checking if character is a letter or not, or you can check by the regular expression  or you can validate your textbox through regular expression validator in asp.net. Following code demonstrating the various ways of implementation.

Read More »