|
How do I execute a stored procedure from VB6? 
|
|
|
|
|
Microsoft Knowledge Base Article - 146651
How To Call SQL Stored Procedures from Visual Basic
http://support.microsoft.com/default.aspx?scid=kb;en-us;146651
just in case:
Using Stored Procedures in Visual Basic .NET
http://msdn.microsoft.com/vbasic/using/columns/adventures/default.aspx?pull=/library/en-us/dnadvnet/html/vbnet09102002.asp
|
|
|
|
|
Hello,
I attach a "TREE CONTROL" in VB.net form and then add one parent node and one child node.
I want that when i click on "Parent Node", then it prints a Message,"PArent Node".
similarly, when i click on "Child Node", then it display or prints any message against it.
Kindly tell me that how can i do this.
I am positively waiting.
Regards,
Eshban
EsHbAn BaHaDuR
|
|
|
|
|
Private Sub TreeView1_AfterSelect(ByVal sender As System.Object, ByVal e As System.Windows.Forms.TreeViewEventArgs) Handles TreeView1.AfterSelect
MessageBox.Show(TreeView1.SelectedNode.Text)
End Sub
.NET Framework Class Library
TreeView.AfterSelect Event
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwindowsformstreeviewclassafterselecttopic.asp
|
|
|
|
|
Hello,
This is Srinivas from SIUE.I am working on an application to call Matlab from visualBaisc.Net. The main idea is to develop a GUI in Vb.Net for runnning Matlab programs in the background and hence sending Data input from Vb to Matlab. I am trying real hard at this, Anyone here can help me out with this.
Thanks.
Srinivas Rao Sambaraju
|
|
|
|
|
how to create a calendar with holidays marked in red
without using calendar controls.
is it possible to modify calendar contrl by changing eg:january to be written inanother language
sdf
|
|
|
|
|
.NET Framework Developer's Guide
Developing World-Ready Applications
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcondesigningglobalapplications.asp
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
