Error while Reading excel file. - ASP.NET Discussion Boards

creating charts

alhomed4430-Jul-07 5:02

alhomed44

30-Jul-07 5:02

dear freinds,

can any body guide for a website or link for learning how to make charts 2D or 3D using VB.Net 2003

Re: creating charts

alhomed4430-Jul-07 5:03

alhomed44

30-Jul-07 5:03

sorry it's me again , using ASP.Net vb scripting

Re: creating charts

Christian Graus30-Jul-07 11:25

Christian Graus

30-Jul-07 11:25

There are a number of libraries you can buy, some free ones, etc. ASP.NET has nothing to do with it, it's pure graphics code that these libraries use, which generates bitmaps you can display on a form, or serve to a page.

Dundas has an excellent library that is AJAX enabled, if you're willing to pay for a library.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: creating charts

Paul Conrad30-Jul-07 14:22

Paul Conrad

30-Jul-07 14:22

What kind of 2D/3D charts are you looking to do? Line charts, pie charts, columns, etc?

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Re: creating charts

alhomed4431-Jul-07 0:22

alhomed44

31-Jul-07 0:22

I need to start my own code to make simple bar char , pie chart without help of charting control tools.

any e-book or link , website?

Re: creating charts

Paul Conrad31-Jul-07 3:03

Paul Conrad

31-Jul-07 3:03

There is a series of articles on this site about a bug tracking tool call Swat, and the author does it in ASP.NET. He includes a simple chart library. There are other chart libraries I've seen around here, do a search on charts in the article search and you may find them Smile | :)

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

ReportViewer Heigth

Nimua30-Jul-07 4:33

Nimua

30-Jul-07 4:33

Hello!

I have a local report, and a report viewer on the page.

When the report is too big, viewer truncates it : (

I tryed set heigth of report viewer to 100% or delete height property from tag. When I do export to excel, in excel everything is allright.

Error while Reading excel file.

vaminfosys30-Jul-07 3:55

vaminfosys

30-Jul-07 3:55

Hi all,

I am making oledb connection for reading excel file.
when this code is executed from the server which has this code then every thing is
ok but when this code is executed from other computer in a browser,
error occured related to opening the connection.

error message is:
-----------------

objEx {"The Microsoft Jet database engine cannot open the file 'C:\\Documents and
Settings\\lc\\Desktop\\CommissionReports\\Latestfiles\\latest
files\\Download0507tu.xls'. It is already opened exclusively by another user, or
you need permission to view its data."} System.Exception
{System.Data.OleDb.OleDbException}

BUT file is not opened by any other user.Every PC other than server(where code exists) gives this error message.
Server(where code exists) executes the code successfully.

code looks like:
----------------

string connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= "+ path1 + "
;Extended Properties=\"Excel 8.0;IMEX=1;\"";

OleDbConnection con = new OleDbConnection(connection);

string str1 = "select * from [" + sheetName + "$]";
OleDbDataAdapter adp = new OleDbDataAdapter(str1, con);

ds = new DataSet();
adp.Fill(ds);

Please give suggestion for this problem.

Master Page Issue

Mahesh.J30-Jul-07 3:33

Mahesh.J

30-Jul-07 3:33

Hi...
How can i perform the body Onload event of a content page, while using Master Page. Since there is only one body tag in the Master Page.

Thanks in Advance
Mahesh.J

Re: Master Page Issue

Guffa30-Jul-07 4:25

Guffa

30-Jul-07 4:25

Put an id and runat="server" in the body control so that you can reach it from code behind. Put a property in the master page that exposes the control publically, so that you can reach it from the content page. In the content page you have to cast the Page.Master property to the actual class of the master page to be able to reach the property in the master page.

---
single minded; short sighted; long gone;

Re: Master Page Issue

Nimua30-Jul-07 4:27

Nimua

30-Jul-07 4:27

Hello,

You can add the following code to the aspx page

<br />
<script type="text/javascript"><br />
<!--<br />
    function LoadPage(event)<br />
    {   <br />
        alert('Load')<br />
    }<br />
    <br />
    document.body.onload=LoadPage;    <br />
//--><br />
</script><br />

It's strange but it works only if you write rigth in aspx file, it did not work when I try to use RegisterStartupScript.

I hope this will help you : )

Image Combo in ASP.NET 2.0

sabyasachi_m30-Jul-07 3:07

sabyasachi_m

30-Jul-07 3:07

Hi,

I want have an image beside the text in a drop down(combo box).Is that possible in ASP.NET 2.0? If yes how should I go about it?
Thanks for your time.

Regards

Smile | :)

Sabyasachi

Re: Image Combo in ASP.NET 2.0

N a v a n e e t h30-Jul-07 3:11

N a v a n e e t h

30-Jul-07 3:11

No predefined controls available. You need to write one from scratch.

My Website | Ask smart questions

Re: Image Combo in ASP.NET 2.0

sabyasachi_m30-Jul-07 3:16

sabyasachi_m

30-Jul-07 3:16

Hi,

Navaneeth thanks for your prompt response. Can you give me a guideline on how to go about it? Thanks for your time.

Regards

Sabyasachi

Re: Image Combo in ASP.NET 2.0

N a v a n e e t h30-Jul-07 3:31

N a v a n e e t h

30-Jul-07 3:31

I am not sure about what I am telling, but you need to start WebControlLibrary project to start with control creation. You will get overrided Render() method which have HTMLTextWriter object as parameter. Using this, write HTML code for your combo box to the response. You won't be able to use classical HTML select control. Create a div element and add image tags into it. Using javascript you can make a feel of dropdownlist.

Before doing all these, do a quick search for any opensource projects. If you are developing one like this, I am sure it is time consuming.

My Website | Ask smart questions

getting a element value from an xml file

pradeep kumarappagari30-Jul-07 2:23

pradeep kumarappagari

30-Jul-07 2:23

how to get particular element value from xml file.

Pradeep Reddy

Re: getting a element value from an xml file

N a v a n e e t h30-Jul-07 3:09

N a v a n e e t h

30-Jul-07 3:09

XMLDocument XDocument = new XMLDocument();
XDocument.Load(YourXMLFile);
Response.Write(XDocument.GetElementByTagName("YourElement")[0].InnerText);

My Website | Ask smart questions

Adding items in listbox

manowj30-Jul-07 2:00

manowj

30-Jul-07 2:00

Hi Everyone,

I have added a statement in both C# and VB (code-behind) as follows:

Listbox1.items.add("\x2260"); //C#
Listbox1.items.add("\x2260") //VB

I found the output varies. I need the same output as in C#. Can anyone help me in this regard.

Regards,
Manowj

Re: Adding items in listbox

kimo code30-Jul-07 2:09

kimo code

30-Jul-07 2:09

Dear u have to make the code like this

Listbox1.items.add("\\x2260"); //C#

just adding another \ in the code

Kareem Elhosseny

Re: Adding items in listbox

manowj30-Jul-07 2:38

manowj

30-Jul-07 2:38

Hi kareem,

Can you place this statement in aspx.vb file and run the application
Listbox1.items.add("\\x2260")
It is not showing the correct output.

U can check this placing in aspx.cs file
Listbox1.items.add("\\x2260"); //The output should be same for above statment.

Regards,
Manowj

Re: Adding items in listbox

kimo code30-Jul-07 2:53

kimo code

30-Jul-07 2:53

My Dear
I'm trying this code in C# and it work correctly but not in vb
u know where is the problem the problem in / because its a keyword so we have to add anoter one / to be like this //
really dear I'm sure i try it now
i hope to B usefull 4 u

Kareem Elhosseny

Re: Adding items in listbox

manowj30-Jul-07 3:05

manowj

30-Jul-07 3:05

Hi kareem,

I have tried as you said, it seems not working in aspx.vb
can you send me the statement which you have checked with aspx.vb

I have tried with c# before posting this issue, it works fine. I need to implement using vb.

Regards,
Manowj

Re: Adding items in listbox

Imran Khan Pathan30-Jul-07 3:00

Imran Khan Pathan

30-Jul-07 3:00