Click here to Skip to main content

ASP.NET

Re: BC30201: Expression expected.

Anurag Gandhi1-Dec-09 2:52

1-Dec-09 2:52

Try the following:

<asp:CheckBox ID="chkBox" runat="server" önclick="updateSent(this.checked, <%# Container.PageRecordIndex %>)" Checked='<%# Container.Value == "True" ? "true" : "false" %>' />

Hope that this will work.

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

Re: BC30201: Expression expected.

alaminfad1-Dec-09 18:16

1-Dec-09 18:16

thnx for yr swift response, but it doesnt work

Re: BC30201: Expression expected. [Modified]

Dinesh Mani1-Dec-09 18:54

1-Dec-09 18:54

Why din't I think of this before?

Ok try this!

<input type="checkbox" onclick="updateSent(this.checked, <%# Container.PageRecordIndex %>)" Checked="<%# IFF((Container.Value = "True"), true, false)%>" />

Re: BC30201: Expression expected. [Modified]

alaminfad1-Dec-09 19:46

1-Dec-09 19:46

Thnx Sir,i tried but i got:
BC30451: Name 'IFF' is not declared.

i tried : Checked="<%# IF((Container.Value = "True"), true, false)%>" />

i got the old error : BC30201: Expression expected.

Re: BC30201: Expression expected. [Modified]

Dinesh Mani1-Dec-09 20:09

1-Dec-09 20:09

alaminfad wrote:
i tried : Checked="<%# IF((Container.Value = "True"), true, false)%>" />

mm, try this -

Checked="<%# IF(Container.Value = "True") Then True Else False)%>"

Download Excel data

Mugdha_Aditya1-Dec-09 1:57

1-Dec-09 1:57

hello,

i wants to dowload data from one website link with d help of OleDbConnection

Link from which i want data is http://www.cboe.com/LearnCenter/pricehistory.xls[^]

i have did as followes :
string sFileName = "http://www.cboe.com/LearnCenter/pricehistory.xls";

string connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; Data Source = {0}; Extended Properties=Excel 8.0;", sFileName);
OleDbConnection objConn = new OleDbConnection(connectionString);

using (objConn)
{
objConn.Open();
System.Data.DataTable dtSheetData = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
String[] excelSheets = new String[dtSheetData.Rows.Count];

// Add the sheet name to the string array.
foreach (DataRow row in dtSheetData.Rows)
{
excelSheets[iSheetCount] = row["TABLE_NAME"].ToString();
iSheetCount++;
}

OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [" + excelSheets[0] + "] ", objConn);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(objCmdSelect);
excelData = new System.Data.DataTable();
objAdapter1.Fill(excelData);
objConn.Close();
}

but it giving me an error at objConn.Open();
Frown | :(

Frown | :(

wht i have to do??

Re: Download Excel data

Ashfield1-Dec-09 2:14

1-Dec-09 2:14

Mugdha_Aditya wrote:
but it giving me an error at objConn.Open();

Well, we can either spend the rest of the day guessing, or you could tell us the FULL error message, including any inner exceptions. I suspect the latter will help us to help you rather quicker.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: Download Excel data

Mugdha_Aditya1-Dec-09 2:26

1-Dec-09 2:26

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 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

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

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 19:35

1-Dec-09 19:35

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

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

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 19:49

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 | :(

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.

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 20:16

1-Dec-09 20:16

no use...

Frown | :(

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

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.

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 21:42

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

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 | ;)

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

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

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

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

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 | :)

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

2-Dec-09 0:56

Heyyyyyyyyy......
Thanks a lotttttttttt

it works now... Smile | :)

Smile | :)

thnku so much Smile | :)

Smile | :)

General News Suggestion Question Bug Answer Joke Praise Rant Admin

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