Linking to a website - ASP.NET Discussion Boards

alexfromto14-Nov-06 3:05

14-Nov-06 3:05

Thank you. I know that the problem is with OldeDb. Like I've mentioned before it doesn't retreive values from Excel, they are just empty. In my research I found out that when you use OldeDb to extract data from Excel it uses first column's format, which is text in my example. I just thought there's a way around it.

Thank you again. If you hear anything let me know. And if I find something out I'll pst it here.

Alex.

Re: Create DataGrid from Excel File

alexfromto14-Nov-06 3:22

alexfromto

14-Nov-06 3:22

OK. I figured it out with the help of a samrt man of course. Smile | :)

Here's the code and it will work. I hope that I can save some time to others if they need to do the same thing I do now.

Enjoy.

Try<br />
            'Create DataSet and DataAdapter<br />
            ds = New System.Data.DataSet<br />
            da = New System.Data.OleDb.OleDbDataAdapter<br />
<br />
           con = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Session("ExcelFilePath").ToString() & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1;MaxScanRows=0""")<br />
<br />
            'Create command<br />
            cmdSelectExcel = New System.Data.OleDb.OleDbCommand("SELECT c.[Company], c.[Journal Entry], c.[Vendor] FROM [Sheet1$] AS c ORDER BY c.[Company]", con)<br />
<br />
            'Open connection<br />
            con.Open()<br />
<br />
            'Exectue command through adapter<br />
            da.SelectCommand = cmdSelectExcel<br />
            da.Fill(ds, "Company")<br />
<br />
            'Assign DataSourse of the DataGrid and bind it<br />
            dg.DataSource = ds.Tables(0).DefaultView<br />
            dg.DataBind()<br />
<br />
            'Close Connection<br />
            con.Close()<br />
        Catch ex As Exception<br />
            'Display error message<br />
            lblError.Text = "Error: " & ex.ToString()<br />
            lblError.Visible = True<br />
        End Try

Will I be limited by Crystal Reports licensing for this issue?

Goalie3513-Nov-06 5:54

Goalie35

13-Nov-06 5:54

I'm trying to find a definitive answer to this question:
How many users are allowed to view web reports on Crystal Reports 11 developer edition?

I keep getting different answers. Business Objects told me there was no limit however I keep reading online that there is in fact a limit.

I'm developing a website for our client that needs to generate PDF/excel reports for each of their sales reps(meaning each of their 1100 sales reps needs to have the ability to go onto the website and view their report).

The website will be located on one of our company servers but obviously, outside of our firewall.

Can I use crystal for this task of handling 1100 sales reps or is there a limit to the number of users who can use this? If not, can anyone recomend a better alternative?

Thanks.

-Goalie35

Web promotion

Nitin198113-Nov-06 5:45

Nitin1981

13-Nov-06 5:45

Hi May be this is not the appropriate place but still believe it will yield something. Pls guide me to a starting link for web promotion on search engine and marketing the web site for generating revenue.

Many thanks

Don't Quit

Re: Web promotion

PavanPareta13-Nov-06 19:48

PavanPareta

13-Nov-06 19:48

web promotion is very - very good and easy work for web site promotion if you want to gruid properly read on google search engine.Its make easy for you.

Pavan Pareta

DataGrid & GridView

Rahithi13-Nov-06 4:51

Rahithi

13-Nov-06 4:51

Hi all,

can any one tell me the difference b/w DataGrid & Gridview webserver controls?
is there any site which explains me about .NET 2.0 server controls other than Microsoft.com?
Thanks,
Rahi Sharma

If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

Re: DataGrid & GridView

Sam Heller13-Nov-06 6:12

Sam Heller

13-Nov-06 6:12

The GridView replaces the DataGrid in ASP.Net 2.0. I'm guessing they changed the name because of the great deal or new funcionality built in to it since version 1.1. EG Sorting

Linking to a website

kgotsob13-Nov-06 4:51

kgotsob

13-Nov-06 4:51

I just had my most embarasing moment when I realised that I cant link to a website from an event handler.

Can you show me the code to transfer to(maybe codeproject.com) from an eventhandler using VB.net in an ASP.NET page

Soon to be famous black south african programmer

Re: Linking to a website

indianet13-Nov-06 8:17

indianet

13-Nov-06 8:17

Response.Redirect("http://www.codeproject.com")

How to use Validation control

Sam.M13-Nov-06 4:45

Sam.M

13-Nov-06 4:45

Hi there.......

I used validation controls in my aspx applicaion, in local machine it's working fine. If i uploaded in remote server, it is showing error..

If i use this,

means, in remote server validation controls are working fine, but button click event was not generated.........

Please help me.....

Thks n Advance

Sam.M

Re: How to use Validation control

Parwej Ahamad13-Nov-06 5:54

Parwej Ahamad

13-Nov-06 5:54

pls provide full path of our javascript file like

Keep Smiling !!! Tomorrow Never Die
Parwej Ahamad
g_parwez@rediffmail.com

Unable to take websetup

Sivaprasad C13-Nov-06 3:41

Sivaprasad C

13-Nov-06 3:41

Hi,

I am not able to take the setup of my web application.I have right clicked on the solution and added new project. selected the primary output,content files etc.

Every thing is getting compiled when I rebuild the solution but the content files are not getting added.
I could only see the bin directory.
Please help..

Regards,
Sivaprasad

Free Web Service???

QuickerThanYourAverageTurtle13-Nov-06 3:32

QuickerThanYourAverageTurtle

13-Nov-06 3:32

Hi,

Can anyone suggest a free to use web service for a test bed application?

Something like a weather forecast service..

Any thought?

Kevin

proxy

biaali13-Nov-06 3:15

biaali

13-Nov-06 3:15

how can i create a proxy of ma web service

bia

Re: proxy

minhpc_bk13-Nov-06 14:02

minhpc_bk

13-Nov-06 14:02

Creating an XML Web Service Proxy [^]

How to execute a General WebPage and Get Response?

pubududilena13-Nov-06 2:57

pubududilena

13-Nov-06 2:57

Hi All,

We can use server.execute() to execute child webpages and get the response.

Suppose that we have a page on http://www.abc.com/default.asp;

Now How can I execute the url and get the whole response including javascript executions.

I need to do using ASP.NET ,C#

Please help me to solve the problem.

Thanks in advance.

Re: How to execute a General WebPage and Get Response?

Sandeep Akhare13-Nov-06 4:02

Sandeep Akhare

13-Nov-06 4:02

you can open the url using httpwebRequest and httpwebResponse but it will not run javascript for that you have load html page in the memory so that it allow the javascript to run .
Reply What you have to do (read data coming from java script function ?)

Re: How to execute a General WebPage and Get Response?

pubududilena13-Nov-06 17:57

pubududilena

13-Nov-06 17:57

Hi,
Yes I have used HttpwebRequest class for my work.But Javascript functions are not executing.

Suppose that in the the Response Page In side the Tag following javascript consists:-

How can get complete response page with executing Javascripts?

Please kindly help me.

Thanks in advance.

Re: How to execute a General WebPage and Get Response?

Sandeep Akhare13-Nov-06 19:02

Sandeep Akhare

13-Nov-06 19:02

You can do that by getting whole HTML page into memory
Use microsoft.mshtml.dll and AxSHDocVw.dll

string URL="http://www.Google.co.in";
object oMissing = null;
HTMLDocumentClass objects=new HTMLDocumentClass();
axWebBrowser1.Navigate(URL,ref oMissing,ref oMissing,ref oMissing,ref oMissing);
while(axWebBrowser1.Busy)
{
Application.DoEvents();
}
objects=(HTMLDocumentClass)axWebBrowser1.Document;

If you are using Windows application then it works fine but don't know for web application

Best of luck
Sandeep

Image in a datagrid

Dayekh13-Nov-06 2:55

Dayekh

13-Nov-06 2:55

Hi,

I am populating a regular datagrid with field data. One of those fields shows a "Severity" rating. There are 3 "Severity" ratings:

1 - Red
2 - Amber
3 - Green

Instead of displaying "Red", "Amber" or "Green" in the column of the datagrid, I would like to display a different image for each. ie. Green Circle for "Green", Orange Circle for "Amber" and a Red Circle for "Red".

I was informed that I have to use the ItemDataBound Event for this, but I don't know how. Please Help!

Thank you.

Re: Image in a datagrid

_AK_13-Nov-06 2:59

_AK_

13-Nov-06 2:59

Yes that is correct you can use OnItemDataBound event. This event gets fired for each row of the datagrid and there in that event you can check what you need to display(depending upon your condition).

Best Regards,
Apurva Kaushal

Thanks Mate ...

Dayekh13-Nov-06 3:25

Dayekh

13-Nov-06 3:25

Hi,

Thank you for the reply! =D

I am going to look further into the EVENT. If you can give me any more hints/examples, that would be great, as I have never used this EVENT before.

Re: Thanks Mate ...

_AK_13-Nov-06 17:23

_AK_

13-Nov-06 17:23

To use that event what you need to do is first the place where you are declaring the datagrid(HTML view) you have to mention this inside the datagrid tag
OnItemDataBound="dg_itembound"
and in your cs file you have to define that one like this:
public void dg_itembound(object sender, DataGridItemEventArgs e)
and here inside that you can do whatever you want.
BTW for more details you can have a look at this.[^] Here you can get so many examples.

Best Regards,
Apurva Kaushal

Re: Thanks a lot!

Dayekh15-Nov-06 2:38

Dayekh

15-Nov-06 2:38

Thanks Apurva, I have been ill for the past few days and havent had a chance to try this out. I will get back to it soon and give you a reply! =]

get file from client

hemant.kaushal13-Nov-06 2:50

hemant.kaushal

13-Nov-06 2:50

Hi,
In my application i have to provide facility to user to download data in excel format and then again upload that file after editing it so that changes in database can be done accordingly.

I have accomplish it but in the file i have to also gave option to user to upload image for each row i try it by giving the path of image but its not working.
Is their any way to access file from client end other than FileUpload
control as i already use it for uploading excel file?
Thanks in Advance.
Smile | :)

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