| Author: VijayaShankar 31 Jul 2008 | Member Level: Gold | Rating:  Points: 6 |
use the following code Snippet for uploading excel through asp.net
if(myFileUpload.HasFile)
{
String name = "PendingReports" + DateTime.Now.ToString().Replace(" ", "") + ".xls";
name = name.Replace("/", "");
name = name.Replace(":", "");
name = Server.MapPath("~/" + name);
try
{
if (!myFileUpload.FileName.EndsWith(".xls"))
{
trErrorMessage.Visible = true;
txtErrorMessage.Text = "Select an Excel file to Upload";
return;
}
else
{
myFileUpload.SaveAs(name);
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + name + @";Extended Properties=""Excel 8.0;HDR=YES;""";
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");
DataTable objDataTable;
using (DbConnection connection = factory.CreateConnection())
{
connection.ConnectionString = connectionString;
try
{
using (DbCommand command = connection.CreateCommand())
{
connection.Open();
command.CommandText = "Select * from [Sheet1$]";
}
}
}
}
|
| Author: Arun Gandhi 31 Jul 2008 | Member Level: Gold | Rating: Points: 1 |
VijayaShankar where you are saving these data. Can u briefout this.
|