|
I was commented my query, only 1 reply i got....than there is no further communcation for my question!!!!!
y is that, if any problem or u cant understand just feel free to ask, instead of disconnecting
Iam facing some problem in reading a excel sheet from server, how to make connection string.
My code.
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://justmypixels.com/escorts/sms/sms.xls; Extended Properties=Excel 8.0";
Iam getting the error " Invalid internet address "
What could be the DATA SOURCE ?????
Any good responsible person over there ?....pls feel free to help me
krishna
|
|
|
|
|
This is obviously not an ASP.ENT question - you're writing a client app that grabs an XLS over the web, right ? In that case, you need to write a web service to pass your file back, this has the advantage of allowing you to make your files secure.
If this is a website that tries to read an XLS file on the server, from a different website, well, that seems messed up to me, but I'd still look at a web service to serve the file. Ultimately, I'd just copy the file onto the server and be done with it, but why would a web page use an excel spreadsheet as a data source ? Can you even have concurrent users looking at a single XLS ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Just type
http://justmypixels.com/escorts/sms/sms.xls[^]
on your addressbar and press enter.. you will see the same error there too...
I think you must provide UNC path to the datasource(I didnt tried it with http path may be it is possible, i dont know though). Rather than going for internet address it would be simplier to download the excel to your server, or upload that file from the address to your server and then try connecting using UNC path.
Hope it helps
|
|
|
|
|
krishnavaradharajan wrote: escorts
just what kind of web site is this..
|
|
|
|
|
i wana do when edit button clicked the value of selected row is saved in table2 with remarks "before edit" and when click update button it update table1 and also make new entry in table2 with remarks "after edit"
prateek
prateekfgiet@gmail.com
modified on Monday, March 9, 2009 3:59 AM
|
|
|
|
|
...then what is your problem ?
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
i m able only make edit it will update the value of table which contain the material incoming detail,but anable to save before edit value and after edit value in second table(edit_val)
how cani do it
|
|
|
|
|
prateekfgiet wrote: ,but anable to save before edit value and after edit value in second table(edit_val)
Is this an audit table? You can write a trigger on the first table and insert the data into edit_val table from this trigger. Hook this trigger for all required events(insert,update and delete).
BTW, you need a spell checker first.
|
|
|
|
|
|
prateekfgiet wrote: i m able only make edit it will update the value of table which contain the material incoming detai
Good.
prateekfgiet wrote: but anable to save before edit value and after edit value in second table(edit_val)
What does it mean? I am still confused . Sorry.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
i m working on inventory managment project here when raw material come in store it creats entry in table1 reciept no.,name ,quantity and all that.
user can see all the entry by gridview if user makes any mistake he can mend it,but when he click edit button it creats a new entry in table2 with remarks "value before edit" and when user click update button it again make new entry in table2 with remarks "value after edit" and backgroundcolor of that perticuler row should be changed
|
|
|
|
|
Looks like you are new to CP. I recommend you to read the posting guidelines[^]. Read this[^] and learn to write quality questions. Now go and rephrase your question, so that we all can understand it.
|
|
|
|
|
ya i m new in CP but i m trying to explain to u
well i m working on inventory managment project here when raw material come in store it creats entry in table one reciept no.,name ,quantity and all that.
user can see all the entry by gridview if user makes any mistake he can mend it,but when he click edit button it creats a new entry in secon table with remarks "value before edit" and when user click update button it again make new entry in table2 with remarks "value after edit" and backgroundcolor of that perticuler row should be changed
|
|
|
|
|
Hi,
I can show my report (CR of VS 2005) well in my development machine (ASP.Net with C#). But after deploying in my sever, the toolbar images of the report is not displaying well. It show as red color (X) mark.
I googled and tried in different ways. But I could not solve it. I tried in four ways so far such as by pasting aspnet_client in my project folder, creating another virtual diretry in my prj and linking with aspnet_client, adding CR of VS2005 in pre-requisitis while building and finaly building with Merge module. But I never got help from the above mentioned 4 ways.
Anybody can help me? I'm being struck in this for more than 5 days.
Note: Report is generating well with toolbar images in my development machine in both of running the application and deploying the application.
Balasubramanian K.
|
|
|
|
|
can you paster code of the report (CR)? it's must request one data source, and (CR).rpt files must in one directory.
|
|
|
|
|
In my report, I am using command. I've written some queries over there itself.
rptDocument = new ReportDocument();
rptDocument.Load(Server.MapPath("Reports/rptPendingCredit.rpt"));
crvPendingCredit.ReportSource = rptDocument;
crvPendingCredit.DataBind();
This followng is my code of my Crystal Report Viewer control
<CR:CrystalReportViewer ID="crvPendingCredit" runat="server" AutoDataBind="true" />
Previously I added some more in my control. But I removed again
<CR:CrystalReportViewer ID="crvPendingCredit" runat="server" AutoDataBind="true" HasCrystalLogo="False" EnableDatabaseLogonPrompt="false" EnableParameterPrompt="false"
GroupTreeImagesFolderUrl="/aspnet_client/system_web/2_0_50727/CrystalReportWebFormViewer3/images/tree/"
ToolbarImagesFolderUrl="/aspnet_client/system_web/2_0_50727/CrystalReportWebFormViewer3/images/toolbar/" />
Balasubramanian K.
|
|
|
|
|
I have completed an aspx application, which I wanted to provide the url for testing from my system. Means, the testers need to access my local system for testing the application.
Since I'm getting the url as http://localhost:(routing number)/directory/Default.aspx, I cannot give this url to them as they cannot access it. I tried to put my IP Address and computer name also, but it fails.
I published the site, and then provide the link. But I am getting an xml parser error: not well formed. It was not happening locally when I run from my system. How to solve this? How to provide the url?
Can anybody please help?
Thanks
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
meeram395 wrote: Since I'm getting the url as http://localhost:(routing number)/directory/Default.aspx, I cannot give this url to them as they cannot access it. I tried to put my IP Address and computer name also, but it fails.
I published the site, and then provide the link. But I am getting an xml parser error: not well formed. It was not happening locally when I run from my system. How to solve this? How to provide the url?
You have to create a Virtual Directory in IIS for your web application. After Deploying the web application it can be accessible in your network using IP address like
http://yourip/directory/default.aspx.
Step1: Install IIS in your system/ server.
Step 2 : Create Virtual Directory for that web application
Step3 : Set the default page,authentication mode and most importantly .Net framework version.
Read this article.[^]
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
if you syste/server don't install iis or .Net framework, At first ,you must install it's.
The .Net framework version and you application version must samed.About application version,you will look for application directory web.config file.
|
|
|
|
|
Thanks. It worked well. I performed all the above steps and it is working fine now.
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
i want full file in database not only file name how can we do it.
|
|
|
|
|
you want export excel file from database, example application in this web,you'll search keyword of database to excel. I do it also.
|
|
|
|
|
Hi,
I write connection coding in Web config file.
The code is
<connectionstrings>
<add name="conn" connectionstring="Data Source=techdbserver;Initial Catalog=project;<br mode=" hold=" /> user name=sa;password=sa;<br mode=" providername="System.Data.SqlClient">
When i called it in the web form as
con = new SqlConnection(ConfigurationManager.ConnectionString["conn"].ConnectionString);
the following error appears.
'System.Configuration.ConfigurationManager' does not contain a definition for 'ConnectionString'
Can any one tell whats the error?
|
|
|
|
|
Hi,
You have not posted the code you wrote in Web.config file.
Secondly Please note and correct the syntax for accessing the connection string from web config in C#
con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
Thanks
Padmanabh
|
|
|
|
|
<br />
con = new SqlConnection(ConfigurationManager.ConnectionString["conn"].ConnectionString);<br />
This code contain two 'ConnectionString', So error appears does not contain a definition for 'ConnectionString'
it's right:
<br />
con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);<br />
|
|
|
|