|
Hi Friends,
I have data in excel and i want to transfer data from excel to datagrid,
having columns name,date of join and salary,how can i transfer excel data
to grid. pls let me know how to make the connection, can you send the code for that.
Regards,
Arpita 
|
|
|
|
|
First of all, if you want to show your Excel data in a datagridview on an aspx page, you have to upload that spreadsheet onto the server. Best way - use the FileUpload control.
I'm only going to show you one way of doing what you want to do. If you don't like it, at least you'll have some reference on how to approach it.
To "make the connection" with an excel spreadsheet, you need to add reference to Interop.Excel.dll, Interop.Microsoft.Office.Core.dll and Interop.VBIDE.dll in your project first.
Then, in your code:
using System.Data.OleDb;
private void ExcelToGrid()
{
DataTable dt = new DataTable("sheet");
OleDbConnection conn = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;data source=" + MapPath("Yourfilename.xls";extended properties=Excel 8.0");
OleDbDataAdapter SheetAdapter = new OleDbDataAdapter("select * from [$Sheet1]", conn);
SheetAdapter.Fill(dt);
DataGridView1.DataSource = dt;
DataGridView1.DataBind();
}
That should really do the trick. Obviously, you need to change $Sheet1 to whatever your sheet is called in the spreadsheet. And read up on versions of the Jet engine - i can't guarantee it's gonna work with all the living versions of Excel.
var question = (_2b || !(_2b));
modified on Monday, February 23, 2009 7:05 AM
|
|
|
|
|
I was doing it by defining the Table Name to the Range of cells required to read/write. On Writing to excel it will automaticallly insert new row to that table.
That way, it will not depend on the sheet and structure will become more similar to other database. Because from database, you are retrieveing data from table and not from sheet.
That's my personal view. 
|
|
|
|
|
Far as I'm concerned, he wanted to read data from an excel spreadsheet and put it into a datagridview.
There was nothing in the email indicating he also wanted to WRITE in the excel document. Nothing about any databases either.
The JET engine treats a spreadsheet like a table, far as I'm concerned.
Plus I'm sorry, i did not quite understand the part where you say:
"On Writing to excel it will automaticallly insert new row to that table."
What table? The DataTable?
var question = (_2b || !(_2b));
|
|
|
|
|
Greg Chelstowski wrote: On Writing to excel it will automaticallly insert new row to that table
I meant Table defined in Excel there.
Ok, I agreed with you.
Thanks.
|
|
|
|
|
Too much code in google , just google it
|
|
|
|
|
HI Greg,
Thanks for this ,but i am using visual studio 2003 and c#, can i use ur code in windows forms,i tried and it is not working as below:
OleDbConnection conn = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;data source=" + MapPath("data.xls",extended properties="Excel 8.0")); -- throws syntax error
please can u help.
Arpita 
|
|
|
|
|
Yes you can use this code in Windows Forms, for the most part.
As there is no
Server.MapPath class in Windows Forms you have to find a different way of pointing to the Excel spreadsheet (as in, provide the application with the physical path to your .xls file).
This is an ASP.NET forum, that's how i gathered you were using WebForms.
So it should really be:
string PathToFile = "";
OleDbConnection conn = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;data source="+PathToFile+";extended properties=Excel 8.0");
var question = (_2b || !(_2b));
|
|
|
|
|
hi friends ,
How to make a context menu to JQGrid ?  .Could you please help me ?
With Warm regards.
dyno.
|
|
|
|
|
I think you can use some javascript UI lib. etc jquery UI.
|
|
|
|
|
Hi, we need to create a site that is going to be developed by 3 people. We are going to use visual studio 2008. Once I heard that the best way to work is to create 2 solutions 1 for the code and one for the site. is this correct? If not how should we work? I have set up a source control service to keep all our source code in sync. We are students and never worked in a team to develop a site.
|
|
|
|
|
Clifweb wrote: We are students and never worked in a team to develop a site.
Fair enough.
Clifweb wrote: create 2 solutions 1 for the code and one for the site
This just plain won't work. Unless you mean to create a separate dll for the business layer, that's commonly done, but to try to create two seperate projects with the idea that you can work apart and bring them together at the end, that's fairly untenable. There's a number of free source control programs like Subversion and CVS, which you can use to set up a machine to hold the projects and then allow everyone working on it to grab code from the common repository and work on it that way.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
So I Should create one solution (Web Application)and all my friends use the subversion to keep it up to date?
|
|
|
|
|
I would read up on n-tiered development. It's a good idea to move the business logic away from the presentation tier, in a dll, but I would still use subversion to work together on the project, yes.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi,
I am developing web application, In which ,i have used Enterprise library 4.0 for data validation.
Previously it was single language(English) project but now another one language(Dutch)is added to this project.
Previously ,i have used english lang to display validation message now i want to displayed localized message for both language(English and Dutch).
Does anyone provide some information or link over this?
|
|
|
|
|
Hi guyz i have used script manager & update panel in my page...
i am getting error as:
Error 126 The type or namespace name 'ScriptManager' does not exist in the namespace 'System.Web.UI' (are you missing an assembly reference?)
Error 127 The type or namespace name 'UpdatePanel' does not exist in the namespace 'System.Web.UI' (are you missing an assembly reference?)
What kind of assembly referencei have to include in web.config file,
plz give me the set of lines have to include in that config file...,
I included web.extension assembly refrence eventhough i am egtting this error...,
Plz tell me to solve this error...,
Thanks & Regards,
Member 3879881,
please don't forget to vote on the post
|
|
|
|
|
I assume you don't have the ASP.NET AJAX library installed.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi Graus,
Thanks for ur reply...,
Actually i have installed ajax extension in my system...,
I a using only update panel & script mamager only...,
For that i need any mote thing to install?
Thanks & Regards,
Member 3879881,
please don't forget to vote on the post
|
|
|
|
|
add the reference of System.Web.Extensions
|
|
|
|
|
i am new in web making,i can not make a web page using asp.net
|
|
|
|
|
OK, what would you like us to do ? Obviously you're just learning for fun, right ? You're not at work or anything ? So, buy a book, take your time and learn how it's done. There's no pressure.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi,
I used encrypt method by using "RsaProtectedConfigurationProvider" in asp.net 2.0
and it encrypt my web connection string and works fine in my local server except this error:
The 'RsaProtectedConfigurationProvider' attribute is not declared
<connectionstrings configprotectionprovider="RsaProtectedConfigurationProvider" mode="hold"> <EncryptedData Type="http://www.w3.org/2001/04/xmlenc#Element"
xmlns="http://www.w3.org/2001/04/xmlenc#">
it works fine in my local iis server and there is no problem , when i upload encrypted webconfig i get error:
Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error message from the provider: The RSA key container could not be opened.
Plz help me
|
|
|
|
|
Advance thanx for ur interest in it.
my page is running one store procedure in back end it take at least 15 to 30 minutes to complete execution. but my page show time out error and i had expand my connection time out and command time out and AsyncTimeout="36000".
but the problem is not fixed.
Really i need things my page should only execute the store procedure i dont want to know about the whether it has been complete or not.
My code is going to generate (insert) 100 million records in database table.its one kind of game logic we are using in our game website.
i dont want to wait for such much time, until the execution of my query,i just want to execute it.
any idea on this ????
modified on Monday, February 23, 2009 4:07 AM
|
|
|
|
|
Hi,
First you should specify which type of query u executed in stored procedure, like as retreive more than 2000 records from ur query. so it will take so much time
|
|
|
|
|
actually your page expires out... It would be better to create a separate process that may run your stored procedure, if you dont need any result from it...
You can also use WCF for doing this ... if you need.
Abhishek Sur
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
