|
I'm trying to import excel workbook into Vb.Net. Any idea on how to do it? As I have data and graph which is done in excel but now would like to put it in Vb.Net. Or is there any alternative?(eg: Drawing 2 chart in a graph, as the original excel file display an overlay of Bar-Chart and XY scatter chart.)
|
|
|
|
|
How to automate Microsoft Excel from Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;301982
|
|
|
|
|
Hi,
I would like to perform some run-time coding such as:
s1 = "testing"
s2 = "s1"
s3 = evaluate(s2)
Then, s3 will become "testing".
Is it possible to do this in VB.NET or VB6?
Many thanks, Wilfred
|
|
|
|
|
If your attempting to do what I think your are, the short answer is no.
During the debugging session, most changes you make while the code is running will cause your app to restart. You'll have to run your app again in order to get your app back to the point where you made the changes.
If your talking about writing your own language interpreter, sort of like your own version of VB, then you would have to research expression evaluation. You could start with Runtime Compiled Symbolic Expressions[^] here on CodeProject. It's written in C#, but is can be converted to VB.NET. You might check out Exploring the Microsoft Script Control
[^] on MSDN. This article has some root into what you might be looking at doing.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello i am new to vb.net, and am learning it in tafe. I was wondering how to store certain information. I have done coding in another language which i used hash tables for, and i really liked them, so i was wondering if i can do hash tables in VB.Net and if so are they easy for storing data? Also is there a tutorial for them ?
The overwhelming power of death is there just to inspire. Translation; life is different ways of not dying.
|
|
|
|
|
Setting and retrieving a Dataset in a Hashtable
http://www.thecodeproject.com/vb/net/TinguHashTable.asp
|
|
|
|
|
The Scenerio is as follows..
I have a DAtabase server... The connection to database can be made by just one ip.. I have to make my middle tier and insatll it on that ip.. And I have to make Client VB.Net Desktop Applications.. Which will reference to that Middle tier.
The bottom line is no Client Applications can make DAtabase Connection.
Which technique is best suited .. plz help me onto this..
|
|
|
|
|
Hi to all!
Please tell me how can I draw on Graphics to another.
For example: I have an Graphics object gr1 that was received from the window handle to and another object gr2 that was received from the button handle. How can I draw gr2 on to the gr1?
Thanks
Alex
|
|
|
|
|
I fetch a record from databse using SQL query. The result is in my command object. But i don't know that how to retrieve the values from command objects and how to iterate through it. Can any one help me ?
Dim rs As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("select * from customer")
SQLREADER = rs.ExecuteReader
rs.ExecuteNonQuery()
Imtiaz
Imtiaz
|
|
|
|
|
From the code you have given the result will not be in the Command Object as there are no output parameters.
Second, the rs.ExecuteNonQuery() won't do anything useful because your SQL is a SELECT statement. ExecuteNonQuery is for when you do not expect any results back.
Your results are in the SqlDataReader object. Use the SqlDataReader.Read()[^] method to extract each record. The return value of this method will be true if a record was read, or false if there are no more records.
The data reader holds tha values of the current record, it has a number of Get...[^] methods to assist you in getting the values for each of the fields.
After you have the values you need for a record, loop around again calling the Read method until you have all your data.
Does this help?
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!
|
|
|
|
|
Try this if you want a data reader:
<br />
Dim cnn as SqlConnection = New Connection(connectionString)<br />
Dim cmd as SqlCommand = New SqlCommand("SELECT * FROM Customer", cnn)<br />
Dim rdr as SqlDataReader = cmd.ExecuteReader()<br />
<br />
'Now iterate through the reader<br />
While rdr.Read()<br />
Console.WriteLine(rdr("CustomerName"))<br />
End While<br />
...<br />
Dan Morris
|
|
|
|
|
Hello I am building an application for work and they are running windows 98 and when I run the unfinished application on the computer it crashes it. The computer appears to run out of resources. But on my windows xp laptop I can run multiples of the program and not crash it. Does the file system matter NTFS or FAT?
|
|
|
|
|
Normally, no. But that and what's causing it to crash depends on what your app is doing and with what resources.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
it's not a file system metter ur did code the wrong event may be when the form activate of another check it out
Imtiaz
|
|
|
|
|
In my opinion, it is not relatet to the file system (FAT or NTFS). I used to use windows 98 and found it is very difficult when it have a problem. Its always display kernel error when there is lack of the memory resource. While windows 2000 and windows xp, change the style to manage error handling in windows environment. It seem that most of application could run very stable whether its have some error occure.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
Win 98 has a very limited amount of GDI resources, which can cause this sort of problem.
1) On XP, open the task manager
2) Choose View/Select Columns...
3) Check the GDI Objects checkbox
4) Monitor this value in the listview as you use the application.
If it continues to rise, without ever dropping, then you probably have some sort of resource leak in your app. If it is just very high, the app will probably crash on Win 98.
my blog
|
|
|
|
|
Thank you for you help. The GDI object on my app went up to 128 max, and now has settled as 126. Well now all can do is take this information to my boss as see what he has to say about upgrading.
|
|
|
|
|
The filesystem is irrelevant. do you write this program in visual basic .net or with common visual basic ? if your write with .net then check whether .net framework is still installed. if your wirte in common visual basic check your ocx or activeX files or check they are correctly registered.
Thomas Wilkop
|
|
|
|
|
Being written in visual basic .net the framework is fine because I have the same problem on two different computers running 98. But the one computer running 2000 can handle the program just fine.
If I break up the GUI in to more then one form it does work in 98 just looks like crap.
Thanks for the help
Dale Burmeister
|
|
|
|
|
is it possible to add a total field in one column of the datagrid which caluculates the total price of a product.
say, if one field has price one field has quantity (editable) the total should be display on the total column as soon as the focus from the quantity is gone.
thanks for ur time
srikanth
|
|
|
|
|
How to sum the fields in a Windows Forms DataGrid control and then display the calculated totals in a footer by using Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;836672
|
|
|
|
|
thank u for ur suggestion ........
i am looking for having total field not only at the footer but on each and every row
|
|
|
|
|
summers over school is in, yet again.
heh, well, for the past 5 months or so on my school vacation, i hadnt used VB.net. now im lost again :S
first off: im not asking you to do my homework, im asking for help..
my project is as follows: two text boxes, and one button. i need to write a program to find the difference (number of days) between 2 entered days (ex, day1 = monday, day2= friday, difference = 4 days.
i have an enum like this:
Private Enum DaysOfWeek
Monday = 1
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
End Enum
i also have 2 variables that i made of the enum type (startDay and endDay). i set startDay and endDay's value = their respective textboxes.text, which the user enters a day of week. i get cast from string to integer error (i know, because enums must only be integer values, right?)
so how can i do this? (sorry if being broad, again, im not asking you to do my homework for me, im asking for help.)
thank you
------------------------
Jordan.
III
|
|
|
|
|
Instead of casting string to enum use the Enum.Parse method to convert the string to Enum.
|
|
|
|
|
im off to bed, but, i WILL definetly check it out. iv never heard of that method before, ill look into it!
thank you very much!
------------------------
Jordan.
III
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
