|
hi,
I am trying to autoformat an Excel (.xls) file and then import it into Sql server 2000 table using C# in Asp.net. But when i try to autoformat the excel file i get the exception "Attempted to read or write protected memory. This is often an indication that other memory is corrupt." Someone please help me to solve this problem
Here is the code.
sing System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Data.Odbc;
using System.Text;
using Microsoft.Office.Interop.Excel;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection Cn = new SqlConnection("server=193.14.45.137; database= NitDB; User ID=re; Password= g5");
SqlCommand Cm = new SqlCommand("Select * from ExcelFile", Cn);
Cn.Open();
SqlDataReader St = Cm.ExecuteReader();
gdExcelFile.DataSource = St;
gdExcelFile.DataBind();
St.Close();
Cn.Close();
}
public static void PrintProgressBar()
{
StringBuilder sb = new StringBuilder();
sb.Append("<div id='updiv' style='Font-weight:bold;font-size:11pt;Left:320px;COLOR:black;font-family:verdana;Position:absolute;Top:140px;Text-Align:center;'>");
sb.Append(" <script> var up_div=document.getElementById('updiv');up_div.innerText='';</script>");
sb.Append("<script language=javascript>");
sb.Append("var dts=0; var dtmax=10;");
sb.Append("function ShowWait(){var output;output='Reading data from excel...PLEASE WAIT!';dts++;if(dts>=dtmax)dts=1;");
sb.Append("for(var x=0;x < dts; x++){output+='';}up_div.innerText=output;up_div.style.color='red';}");
sb.Append("function StartShowWait(){up_div.style.visibility='visible';ShowWait();window.setInterval('ShowWait()',100);}");
sb.Append("StartShowWait();</script>");
HttpContext.Current.Response.Write(sb.ToString());
HttpContext.Current.Response.Flush();
}
public static void ClearProgressBar()
{
StringBuilder sbc = new StringBuilder();
sbc.Append("<script language='javascript'>");
sbc.Append("alert('Data exported successfully');");
sbc.Append("up_div.style.visibility='hidden';");
sbc.Append("history.go(-1)");
sbc.Append("</script>");
HttpContext.Current.Response.Write(sbc);
}
protected void btnExport_Click(object sender, EventArgs e)
{
PrintProgressBar();
{
OdbcConnection connection;
SqlBulkCopy bulkCopy;
string ConnectionString = @"server=323.65.43.134;database= NitDB; User ID=yu; Password=g0";
string connstr = @"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" + fyle.Value;
using (connection = new OdbcConnection(connstr))
{
string[] temp;
string fn1;
fn1 = System.IO.Path.GetFileName(fyle.PostedFile.FileName); \\ fyle is the Html File upload control
temp = fn1.Split('.');
object missing = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Excel.Application excel = default(Microsoft.Office.Interop.Excel.Application);
Microsoft.Office.Interop.Excel.Workbook wb = default(Microsoft.Office.Interop.Excel.Workbook);
excel = new Microsoft.Office.Interop.Excel.Application();
// I get the exception at the below statement.
wb = excel.Workbooks.Open(fn1, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
excel.Visible = true;
//wb.Activate();
excel.Cells.Select();
excel.Columns.AutoFit();
excel.Rows.AutoFit();
OdbcCommand command = new OdbcCommand("Select * FROM [" + temp[0].ToString() + "$]", connection);
connection.Open();
using (OdbcDataReader dr = command.ExecuteReader())
{
using (bulkCopy = new SqlBulkCopy(ConnectionString))
{
bulkCopy.DestinationTableName = "ImportedExcel";
bulkCopy.WriteToServer(dr);
}
dr.Close();
}
}
bulkCopy.Close();
connection.Close();
}
ClearProgressBar();
}
}
Nitin Raj Bidkikar
modified on Wednesday, October 22, 2008 9:11 AM
|
|
|
|
|
Hi everybody:
In my web application,I store some information(UserName etc.) in Session.
In a admin's web page,I want to list all the active Sessions and its data.Also, I wiil be able to stop any Session.
Is there any way?
|
|
|
|
|
|
hi,
in my asp.net web application, i want to implement one attendance marking system for employees. can we use RFID in web applications. Is there any other way to do this.
thanks in advance
Mukesh.
|
|
|
|
|
can anybody guide me that i am interesting in taking more than 100 application variables with following hard coded values...
application("abc")= "value"
application("abc_code")="101"
application("def")= "value"
application("def_code")="101"
application("ghi")= "value"
application("ghi_code")="101"
will these variable effect the performance of that website or not??
if yes then what is the alternative solution.??
umerumerumer
|
|
|
|
|
Yes, reading and writing to Application object is much slower than doing in static variables .
Question is why you want 100 Application variables to be present?
Can you put this as Static string so that those are going to share by each user ?
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
modified on Wednesday, October 22, 2008 3:13 AM
|
|
|
|
|
yes you are right i want to do in the same way so that each user can shere same kind of hard coded string with value and code
is there nay alternative way do you think if i use application variables then it will slow down the website????
umerumerumer
|
|
|
|
|
Yes, as getting the static value is much faster than the getting Application Variable value Again I am not sure Application Varaibles are share by different sessions (Users) are different copy is created at runtime So in my openion as you are storing just constant string then it should be stored in static strings.
There is no meaning in storing these values in Application Object
If you have to manage some calcaulations Like number of users online then you can make use of Application variables
Application Variables are there in ASP.NET only because compatibility with classic ASP so that while migrating the ASP application to ASP.NET they should not
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|
|
ok thanks sandeep but i want to use these variables on most of the pages and shared by multiple users but static variables will they be reliable for my functionality???? please explain.
umerumerumer
|
|
|
|
|
N0, both(Application and Static variables ) are not reliable as both
are not thread-safe. You need to handle locking yourself in order to ensure the integrity of the data.
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|
|
sandeep can you please give an example this point is not clear not me..
please write with a code example.. how??
umerumerumer
|
|
|
|
|
ok thanks sandeep but my requirement is to use these variables shared by multiple users and multiple pages of website...
can static variables fullfill this requirement????
ok if i take application variables round about 100 then will they effect performance of website or not???
umerumerumer
|
|
|
|
|
mr_muskurahat wrote: ok if i take application variables round about 100 then will they effect performance of website or not???
I think it is going to hit the performance in some manner if you see user point of view he won't see much difference (won't take much time)
Can you tell me why you want ? any business rule you want to apply ?
Why don't you use database for that then ?
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|
|
Sandeep Akhare wrote: Yes, as getting the static value is much faster than the getting Application Variable value
|
|
|
|
|
Hey Navaneeth !!!
Am i wrong by saying this ? please correct me if i am wrong
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|
|
Sandeep,
There is no performance difference in accessing a static variable and application variable. ASP.NET implements application variables in static fields. If you look carefully, you will see that ASP.NET is using HttpStaticObjectsCollection for keeping the application variable value. So you can't compare the performance.
Sorry, I could have explained this in my previous post rather than putting you into a confusion.
|
|
|
|
|
Hi Navaneeth,
Sorry to say but i have read it in one of articles on web please have a look at it and let me know if you have any different view on this (Please read last paragraph of the same )
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q312607[^]
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
modified on Thursday, October 23, 2008 5:53 AM
|
|
|
|
|
thank for reply
brother you were talking about data caching through configuration file...??
can i use more than 50 variables in with hard coded data in it???
and will it be better than application variable if yes then please provide me the code i dont want to use database.
umerumerumer
|
|
|
|
|
Why do you need this? I'd put all these in a configuration file and read from there. Cache the results to avoid reading all time.
|
|
|
|
|
ya how caching is possible through configuration file?? can you provide me the code???
value + code i want to save at place where i can access it in any page and usefull for multiple users...
umerumerumer
|
|
|
|
|
and these variables can be upto 50-70.
umerumerumer
|
|
|
|
|
mr_muskurahat wrote: ya how caching is possible through configuration file?
Just read the configuration value and assign to cache. Read books online about cache and it's usage.
mr_muskurahat wrote: can you provide me the code???
You can try it. Come back with specific problems. Lazy people asks for code.
|
|
|
|
|
Hi all i am using multiview control so change active index of multiview control i wrote ...
MultiView1.ActiveViewIndex = 0;
it is in .cs file ... can i set active index using java script if yes plz tell me how can i do this?
Thanks & Regards,
Prashant B. Lavate
Software Engineer
Mobile : +919423872257
Pune(India)
|
|
|
|
|
hi folks,
I require some points/answers related to performance issues in web application.Thanks in advance for ur help.
T.Balaji
|
|
|
|
|
There are few Points that you need to always care as given
1: Keep as low size of session data as you can.
2: Keep minimal data in session.
3: Try to transfer minimal data to server from Client.
4: Keep the size of the client pages(HTML etc) very less.
5: Use javascript as much as you can
Use best pratctices for server side coding.
Cheers!!
Brij
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
