|
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
|
|
|
|
|
u r absolute Ok
can u give some idea or links about how to create separate process to execute such a store procedure by using MFC.
Advance thanx for interest in it.
|
|
|
|
|
What Exactly is your SP doing if it takes this long?
To have an infinite timeout Option set your Command object to zero. You need to Optimize your sp.
"A call for SP optimization, is a result of bad design from the begining"
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
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 ???
|
|
|
|
|
Really that is too heavy for a Web page.
Does your users interact with your page? ,or this is some admin thing that you do it at certain time ? . If that's the case,I suggest you create an SSIS package and leave the web page out of this.
Lets here what the other guys say.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
