Re: Download Excel data - ASP.NET Discussion Boards

Re: Download Excel data

Vimalsoft(Pty) Ltd1-Dec-09 2:26

Vimalsoft(Pty) Ltd

1-Dec-09 2:26

What is the Error ?

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: Download Excel data

Mugdha_Aditya1-Dec-09 17:50

Mugdha_Aditya

1-Dec-09 17:50

Error as
Invalid internet address.

at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at PrjBussExtEltParser.clsBussExtEltParser.USElementsDataExcel(DataSet dsElements) in C:\Projects\DailyUpdatesExtEleSchedule\PrjBussExtEltParser\clsBussExtEltParser.cs:line 1275
at PrjBussExtEltParser.clsBussExtEltParser.USElementsData(Boolean bIsHistoric) in C:\Projects\DailyUpdatesExtEleSchedule\PrjBussExtEltParser\clsBussExtEltParser.cs:line 1253
at DailyUpdatesExtEleSchedule.Form1.GetUSElementData() in C:\Projects\DailyUpdatesExtEleSchedule\DailyUpdatesExtEleSchedule\Form1.vb:line 2188

Re: Download Excel data

Vimalsoft(Pty) Ltd1-Dec-09 19:14

Vimalsoft(Pty) Ltd

1-Dec-09 19:14

What is this

Data Source = {0}

You can add just anything in the Connection string

Re: Download Excel data

Mugdha_Aditya1-Dec-09 19:35

Mugdha_Aditya

1-Dec-09 19:35

i have got tht code from online..so i dnt knw.. Frown | :(

Re: Download Excel data

Vimalsoft(Pty) Ltd1-Dec-09 19:38

Vimalsoft(Pty) Ltd

1-Dec-09 19:38

The Datasource Should be the name of your SQL instance, but that is incorrect just change it to the name of your SQl instance and try it again

Re: Download Excel data

Mugdha_Aditya1-Dec-09 19:49

Mugdha_Aditya

1-Dec-09 19:49

<add name="DbIndigoTrack" connectionString="Data Source=192.168.1.7\indcountry; Initial Catalog=Data_Team ; User ID=devuser; Password=devuser@reval" providerName="System.Data.SqlClient"/>-->

tht is my connection string
i hve replaced code as

string connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; Data Source = 192.168.1.7\indcountry; Extended Properties=Excel 8.0;", sFileName);

still there is error as Cannot update. Database or object is read-only.

Frown | :(

Re: Download Excel data

Vimalsoft(Pty) Ltd1-Dec-09 19:52

Vimalsoft(Pty) Ltd

1-Dec-09 19:52

ok now tell me

192.168.1.7\indcountry

The above Server name , Go to SQl Management Studio and try to connect to SQl using that in the server option and tell me if it connects , use the same credentials that you used in the above connection string.

Re: Download Excel data

Mugdha_Aditya1-Dec-09 20:16

Mugdha_Aditya

1-Dec-09 20:16

no use...

still its giving error

Data Source ={0}

means...it will take file name
http://www.cboe.com/LearnCenter/pricehistory.xls

Provider=Microsoft.Jet.OLEDB.4.0; Data Source =http://www.cboe.com/LearnCenter/pricehistory.xls; Extended Properties=Excel 8.0;

like this....

Re: Download Excel data

Mugdha_Aditya1-Dec-09 20:19

Mugdha_Aditya

1-Dec-09 20:19

If file is saved on my location machin..n if i have given path of tht
then it works..grd...
but for this its nt working...

may b i have to save tht file first in default location

do u know..hw to save file in default loaction without opening it..

Re: Download Excel data

Vimalsoft(Pty) Ltd1-Dec-09 20:59

Vimalsoft(Pty) Ltd

1-Dec-09 20:59

Your Question was not clear from the Start now i see what is your Problem. You are Uploading the Excel file and the file does not Exists on the Server. What you need to do is to copy the file to the Server save it in the App_Data Folder and Processes it from there.

Re: Download Excel data

Mugdha_Aditya1-Dec-09 21:42

Mugdha_Aditya

1-Dec-09 21:42

sorry for inconvinence
but i wants to save that files through coding..code behind

how to do tht??

dnt want to open it..but i have to save tht file in default location...how to do tht through coding

i dnt want to create xcel object..bcz i have to update huge data with diff excel

so it will create prb if excel create objects

so..without creating excel object how to save file in default location?

Re: Download Excel data

Abhishek Sur1-Dec-09 3:13

Abhishek Sur

1-Dec-09 3:13

Hey you cant have direct access to a file using web address like
http://www.cboe.com/LearnCenter/pricehistory.xls

You need to download the file to your local system and then you can use MDAC to access its data.

Wink | ;)

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: Download Excel data

Mugdha_Aditya1-Dec-09 6:03

Mugdha_Aditya

1-Dec-09 6:03

can i save tht excel in server side..through coding??
if yes thhn hw to do tht??

Re: Download Excel data

Abhishek Sur1-Dec-09 8:56

Abhishek Sur

1-Dec-09 8:56

Check this :

http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=115[^]

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: Download Excel data

Mugdha_Aditya1-Dec-09 17:49

Mugdha_Aditya

1-Dec-09 17:49

I want to know..without opening hw to save XLS File at default location

Re: Download Excel data

Abhishek Sur1-Dec-09 21:32

Abhishek Sur

1-Dec-09 21:32

If you are to download the file in the server, you can use WebClient.DownloadFile as I mentioned in the link.

Try this :
http://www.onedotnetway.com/code-sample-programmatically-download-file-using-c/[^]
Smile | :)

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: Download Excel data

Mugdha_Aditya2-Dec-09 0:56

Mugdha_Aditya

2-Dec-09 0:56

Heyyyyyyyyy......
Thanks a lotttttttttt

it works now... Smile | :)

thnku so much Smile | :)

Re: Download Excel data

Abhishek Sur2-Dec-09 20:20

Abhishek Sur

2-Dec-09 20:20

You are most welcome...

And ...

Dont forget to click on Good Answer if it helps you. Laugh | :laugh:

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Crystal Report in Asp.net

Udayaraju1-Dec-09 1:34

Udayaraju

1-Dec-09 1:34

Hi Dudes, Plz Solve these

I am trying to implement a sample report in asp.net using crystal reports10.0.
But i get an error of Object reference not set to an instance of an object
Here's my code

public void btn_Click(object sender, EventArgs e)
        {
            frmPreview Preview = new frmPreview();
            rptInformation Info = null;

            TableLogOnInfo logOnInfo = DBManager.getCrystalLogInfo(); //CorrectStatment
            Info = new rptInformation();

            Info.Database.Tables[0].ApplyLogOnInfo(logOnInfo); //Correct

            formulaFieldDefs = Info.DataDefinition.FormulaFields;

            formulaFieldDef = formulaFieldDefs["CompanyName"];
            formulaFieldDef.Text = "'" + Global.CompanyName + "'";

            Preview.crystalRptViewer.ReportSource = Info; //Error
             
        }

Here I placed CrystalReportViewer in frmPreview

Re: Crystal Report in Asp.net

Abhishek Sur1-Dec-09 9:10

Abhishek Sur

1-Dec-09 9:10

It seems that you are doing this in Winforms...

I think this is not the right section to post this. Mad | :mad:

On this ... you didnt mentioned where exactly the error you are getting...?

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: Crystal Report in Asp.net

Udayaraju1-Dec-09 18:21

Udayaraju

1-Dec-09 18:21

I am trying to Implement in Asp.net itself. I tried in these way.. Is there any better approach

I have specified the error

Preview.crystalRptViewer.ReportSource = Info; //Error: Object reference is not set to an instance of an object

Re: Crystal Report in Asp.net

Abhishek Sur1-Dec-09 21:40

Abhishek Sur

1-Dec-09 21:40

Did you bind the data source properly?

Are you trying this in your Development environment or in Production server.
Generally this sort of error comes when Crystal report is not found in the server.

Confused | :confused:

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

connection string problem

m@dhu1-Dec-09 0:36

m@dhu

1-Dec-09 0:36

im using vs2003 and sql2000 im getting error in connection string.....

Keyword not supported: 'use procedure for prepare'.

Line 51: {
Line 52: string str= "select * from table1";
Line 53: SqlConnection cnn=new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=new;Data Source=NETZOOM;Use Procedure for Prepare=1;Packet Size=4096;Workstation ID=NETZOOM;Use Encryption for Data=false;Tag with column collation when possible=False");
Line 54: SqlCommand cmd=new SqlCommand(str,cnn);
Line 55: DataSet ds=new DataSet();

SqlConnection cnn=new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=new;Data Source=NETZOOM;Use Procedure for Prepare=1;Packet Size=4096;Workstation ID=NETZOOM;Use Encryption for Data=false;Tag with column collation when possible=False");

i tried by removing that keywords still this error

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

modified on Tuesday, December 1, 2009 6:46 AM

Re: connection string problem

Abhishek Sur1-Dec-09 0:47

Abhishek Sur

1-Dec-09 0:47

Just remove
Use Procedure for Prepare=1; from the connectionstring.

Refer to
www.connectionstrings.com[^]

for writing your connectionstring.

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: connection string problem [Modified]

Dinesh Mani1-Dec-09 1:04

Dinesh Mani

1-Dec-09 1:04

If i'm not wrong you will only need this part of your connection string to connect to the database

"Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=new;Data Source=NETZOOM;"

All other information is not necessary. Just try with this!

I would also suggest you to use Server Explorer to connect to the database to test the connectivity. You have a wizard there to help you and at the end of it you can get the connection string from the registered server's properties.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.