|
I want to select and rename the column name to PROD_ID( to product) and QTY( to total) in vb form and show resulting table in vb form
SALE_ID PROD_ID QTY
1 Tomatoes 30
2 Pears 20
3 Apples 10
4 Tomatoes 40
5 Oranges 15
6 Tomatoes 5
7 Apples 9
8 Apples 7
9 Pears 19
|
|
|
|
|
Use DataGrid Control, OleDbConnection, OleDbCommand, DataAdapter and DataSet like this:
Dim connectionString As String = "..."
Dim dbConnection As New OleDbConnection(connectionString)
Dim queryString As String = "SELECT [ZAM].* FROM [ZAM]"
Dim dbCommand As New OleDbCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dataAdapter As New OleDbDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)
dgZam.DataSource = dataset
'dgZam.DataBind() - if you use ASP.NET
David
|
|
|
|
|
I have deployed version 1.0 of a COM component that contains a CheckRequirements method in an interface called IData. The component is used by several VB client applications.I now discover that the data type of one of the arguments must be changed from Integer to Long.i have do to fix the component without breaking the existing clients?
|
|
|
|
|
If I remember correctly, you have to compile the new component with binary compatibility turned on. I think you can set this in the Project Properties dialog. You'll need to supply the path to the previous version of the component.
... I think ... It's been so long since I've been in VB6...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Normally what Dave said would be correct. As far as i know that works if you change the way a method works but i dont think it will work in this case as you are actually changing the method. even with binary compatability if you add/remove methods or properties or change arguments you will probably need to recompile the client application as well.
Sorry if forgot that even VB6 can support multiple interfaces. You could create a new interface that new clients can use and change the internals of the method to check the type and convert the int to long.
This way existing clients are handled although if the problem is the data type sooner or later the problem will need to be addressed in the client.
Jon
|
|
|
|
|
You know, you're right!  It didn't even hit me that he was changing the signature of a method call.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
how can i get an mdi child form to display in the client area of the core programs form, the mdi child forms are contained within plugin modules that are detected and loaded at run time ?
|
|
|
|
|
Your host application would have to apss a reference to the MDIParent form to any code that's going to create a child form. This is so the child form can be assigned the correct parent form.
Also, any child forms MUST be created on the same thread that the parent form was created on, otherwise, you'll never see the form.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanks. My plugins are running as separate threads.
so i would have to pass a reference to the mdiChild to the host and get the host to create the form.
|
|
|
|
|
You got that right...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
ListView isn't displayed, while its content invisibly praesents.
|
|
|
|
|
WHAT?????
Could you repeat that, in the form of a question...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Does someone know how to change color of ScrollBar, for example in ListBox. (VB, windows form, NET 1.1)? Thanks.
|
|
|
|
|
There are not direct properties to do this. The scroll bars are drawn using the Display control panel, Appearance tab, defined colors. You'll have to owner draw the ListView control to change the appearance and draw everything using your own colors.
Just search in the Articles for "custom listview" and you'll come up with examples.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello All,
I have one form name Form1 and from Form1 i have declared as follws
-------------------------------
Private frm2 as new Form2
frm2.showdialog(Me)
-------------------------
Now frm2 open and get some values in textboxes,in my case i want to retun back this values to previous Form's Datagrid ,(means Form1's Datagrid) for displaying,
How can i solve this,anybody can help me will be appreciated
|
|
|
|
|
u can do it
first strore the values in some global vaiable.
for that u can make a module. therefore that values will be accessible to all forms
then u can use those values in ur datagrid
|
|
|
|
|
Add new module to the project and there declare public variable (Public Value As Integer). Then You can use this variable in form1 and form2, as well.
David
|
|
|
|
|
you can do one thing
First you declare the friend or public variable in then you cn call us follows
In form1 Write as follows
dim frm as new Form2
frm.Showdialog(Me)
me.DataGrid = frm.PublicVarDataTable
In Form2
Public PublicVarDataTable as datatable
OkBut_Click()
// add rows in table
Me.DialogResult=ok
Me.Hide
End sub
I hope this helps
Ishak
|
|
|
|
|
whasup!
You just need to create properties which will contain the values read from the textbox. After you have those values simply dispose your form2 object.After this you still can access the properties of the object because only the visual were disposed you can retrieve the properties by doing:
myForm2Object.property1
myForm2Object.property2
(...)
myForm2Object = nothing
this way you won't need modules.
Never say never
|
|
|
|
|
Hi can anyone tell me how to build an application in VB 6. There is a play button on the Bar , but i think it compiles the application as well. How to Build it .
Be FaithFull To Your Work.
|
|
|
|
|
FIle > Make
<italic>Work hard, Work effectively.
|
|
|
|
|
Hi , please any one can help me how to make an application a service in VB 6 so that when the windows starts that application runs itself any don't have any need to start it.
i.e , it starts itself.
|
|
|
|
|
If you just want the application to runs itself when the windows starts, you don't need to make a window service application.
See this[^]
<italic>Work hard, Work effectively.
|
|
|
|
|
Do you want to run your app when Windows starts or when the user logs on?
If you want to run it when the user logs on, follow the link the other person posted.
If you want to run it when Windows starts, check here[^]. Warning! You'r application cannot have a user interface! If your app isn't completely autonomous, you'll run into problems with your application, and possible even stop Windows from shutting down! VB6 was not designed to create true, native Windows Services.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
can .net exe run on machine where .net Framework is not present. if yes how to make that exe.
ddd
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
