How to read excel file and display in grid using asp.net

hi..
Refer the below article to read and save the excel file....
http://www.dotnetcode.in/2011/01/import-excel-table-into-sql-table.html

Amritha444, if this helps please login to Mark As Answer. | Alert Moderator

Refer this link
http://www.codeproject.com/Tips/311014/READ-EXCEL-IN-ASPNET

gowthaman8870226416

Amritha444, if this helps please login to Mark As Answer. | Alert Moderator

I Have Done this For datagrid am not sure whether the same coding vl work for the gridview,just have a try.

After Selecting the needed excel file and in a button click try this code,


ExcelFile.PostedFile.SaveAs(Server.MapPath(".\\Somepath "\\") + "FileName(Fixed).xls");


string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + Server.MapPath(".\\Somepath "\\") + "FileName(Fixed).xls;" +
"Extended Properties=Excel 8.0;";
System.Data.OleDb.OleDbDataAdapter mydata1 = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);
mydata1.TableMappings.Add("Table1", "ExcelTest1");
mydata1.Fill(FileName(Fixed));
datagrid1.DataSource = FileName.Tables[0].DefaultView;
rowcount = FileName.Tables[0].Rows.Count;
datagrid1.DataBind();

Amritha444, if this helps please login to Mark As Answer. | Alert Moderator

how to read excel file in asp.net

Amritha444, if this helps please login to Mark As Answer. | Alert Moderator

Dear Sir
sir, tell me how to read excel file asp.net . i wait your reply .

[/TITLE]

Amritha444, if this helps please login to Mark As Answer. | Alert Moderator

Dear sir,

try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
for (int i = 0; i < dt1.Rows.Count - 1; i++)
{
string check = "query"; which query i right here
//fill dt2

if (dt1.Rows.Count > 0)
{ }
else
{

string insert = "insert into inventory(name,days,hdays,months,years)values('" + dt1.Rows[i]["name"].ToString() + "'," + Convert.ToInt32(dt1.Rows[i]["days"]) + "," + Convert.ToInt32(dt1.Rows[i]["hdays"]) + "," + Convert.ToInt32(dt1.Rows[i]["months"]) + "," + Convert.ToInt32(dt1.Rows[i]["years"]) + ")";
SqlCommand ad2 = new SqlCommand(insert, cn);
ad2.ExecuteNonQuery();
}
}

Amritha444, if this helps please login to Mark As Answer. | Alert Moderator

Hi
Refer the following link for read & store excel data into SQL Server Table
http://www.aspdotnet-suresh.com/2010/09/import-data-from-excel-to-sql-database.html
http://www.aspdotnet-suresh.com/2012/12/c-importupload-data-from-excel-to-sql.html
Note: You can open new thread for your request....

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Amritha444, if this helps please login to Mark As Answer. | Alert Moderator

If you still need the sample codes for read excel document within windows vb.net application, you can check out following online tutorial:
http://www.rasteredge.com/how-to/vb-net-imaging/excel-reading/

Amritha444, if this helps please login to Mark As Answer. | Alert Moderator