|
Ok.. here's what I'm trying to do
I have a windows form (VB.NET) with a datagrid that display the content of a table in a database. (let's say countries for example) I can edit, delete and add records in this grid.
In another windows form, I have a combobox. This combobox displays all countries. I want to add an item in this combobox (Add a country) and when I select it, I have to show the first form to allow the user to add, edit, delete countries and then select one. All changes applied in the grid have to be applied in the combobox and the (Add a country) item must not appear in the grid.
How can I add an item manually in the combobox when this one is binded to a datasource? I don't know if it's possible, but if it is, if someone could send me some tips, I would appreciate!
Thanks
Marc
|
|
|
|
|
pls explain ur problem.
do u want to add it at run time.
(why can't u add it by addItem method)
Arvi
|
|
|
|
|
It seems impossible to add an item in the combobox (using the AddItem method) when it's bound to a datasource. (And I talk about System.Windows.Form.Combobox here... I know it's possible with the dropdownlist in asp.net) ...
I want to override some methods in the combobox to allow me to add the item manually at runtime after the datasource have been affected to the combobox.
Marc
|
|
|
|
|
I think it might be easier to do 1 of two things:
1) add the "Add A Country" to the DataSource before you bind them. For instance, get the DataSet of all countries, add the new blank country to the top of the DataSet ( or whereever ) with the NewRow and Insert methods, and then set it as the ComboBox's DataSource
2) simply add a button to the form that opens the Country-editor form. Maybe you could make the control's label a "link" or something.
|
|
|
|
|
Hi, I'd created a database using SQL Server. Then I've created ODBC in the control panel.
I want to know  how I can deal with ODBC in VB6. I've tried to use "Adodc" but I think it saves just one record. I’ve used this statement"Adodc.Recordset.AddNew" , but it saved the new record and deleted the old one.
Also I want to be able to save whatever I want in the fields without using DataField property for TextBoxes.
Or, I wonder if I could use Data Control with ODBC. I've used these statments:
Data1.Connect = "DSN=DSNName"
Data1.RecordSource = "My TableName"
But seems that it needs to SET recordset. What should I use for it?
Thanks.
|
|
|
|
|
If you dont want to use the DataField and DataMember properties, it is best to just use ADO code.
Dim conn As ADODB.Connection
Dim rs as ADODB.Recordset
Set conn = new Connection
conn.Open "DSN=DSNName"
set rs = conn.Execute("SELECT * FROM table")
etc. etc.
--
David Wengier
Sonork ID: 100.14177 - Ch00k
|
|
|
|
|
Thanks![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif) for the replaying but I want to Add , Delete or Edit the Data
. When I used "rs.addnew" it gives me an error.
|
|
|
|
|
You can add, update and delete using SQL statements as I have said. If you notice the error message would probably have said something about having the wrong cursor type to use AddNew. Therefore, open the recordset using a different cursor. Try Dynamic.
--
David Wengier
Sonork ID: 100.14177 - Ch00k
|
|
|
|
|
When I use "rs.AddNew" it gives me this error:
The operation requested by the application is not supported by the provider".
Also, I Wonder if I can use OpenDataBase & OpenRecordSet with ODBC.
Thanks
|
|
|
|
|
I have the VB4 Programmer's Guide and Reference. I was wondering whether it was accurate enough to use for learning VB6 as well.
I have some knowledge in VB6 and have used it before, but I'd like to take the time and really get into it inside out, will these books do or are they not updated/thorough enough?
What other books would you suggest?
Thanks.
Isaac Sasson,
Small time programmer - complainer at large.
Sonork ID 100.13704
|
|
|
|
|
Make sure it references the 32-bit version of VB4. Also, the major things introduced in VB5 were native code compilation and the AddressOf operator. Outside of that, you'll find many things are (mostly) the same as far as the language goes.
When I was learning VB, I started with the learning edition, which came with some videos that got me going. I bought three books (they're old now)... VB Explorer, VB Secrets, and a MCSD exam prep book. However, the best resource is the Internet!
Good luck.
Jeremy L. Falcon
"The One Who Said, 'The One Who Said...'"
Homepage: imputek.com
|
|
|
|
|
Thanks for the tips mate!
Isaac Sasson,
Small time programmer - complainer at large.
Sonork ID 100.13704
|
|
|
|
|
Not to seem pushy or anything, but have you considered just learning VB.NET instead of VB6?
Nick Parker
|
|
|
|
|
Visual Basic 6.0 Professional Step by Step
from Microsoft Publishing. Trust me, it's really good  . I used it to learn a lot of VB, though you could probably abandon it 3/4 of the way and start learning on your own.
First Programmer: "How many bits are in a bite?"
Second Programmer: "You spelled bytes wrong."
First Programmer: *stares* "It's a joke, moron."
Second Programmer: "Joke...?"
|
|
|
|
|
How can i take control of Distiller writer into VB code ?
Thanks.
|
|
|
|
|
I wrote some VB code awhile back to create PDF via the print driver. The distiller product was to difficult to control.
caveat for the PDF print driver. You need to add a sleep function to your VB code to wait for the PDF file to be created. Check for the finished file then move on to the next file.
Good Luck
Alex McCool
amccool@socal.rr.com
|
|
|
|
|
Hi,
The .Net naming guidelines cannot be fully applied to Visual Basic. You can
almost do it because, despite VB's case insensitivity,
variable/method/property names and type names are in different namespaces
and so do not clash. I don't think this was the case in VB6. For example, in
VB .Net you can do:
Dim customer As Customer
and the compiler understands that customer is different from Customer.
But for properties you run into trouble
Private name
Public Property Name() As String
Get
Return name
End Get
End Property
name and Name clash so you end up having to do
Private m_name
or something.
If the compiler could distinguish between variables and methods then the
.Net conventions could be applied consistently for both VB and C#.
With C#, I've been trying to follow the new guidelines but I'm still using
Hungarian prefixes for controls. Microsoft don't say what to do for controls
but I guess we should use full suffixes, i.e.,
customerText
customerLabel
customerCombo
etc.
Comments anyone?
Kevin
|
|
|
|
|
Where are these naming guidelines?
I use m_iCount or miCount for member variables, iCount for local variables and Count for property names, and I dont have any problems.
--
David Wengier
TAC ad gone wrong: "Don't fool yourself, you're a bloody idiot."
Sonork ID: 100.14177 - Ch00k
|
|
|
|
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpgenref/html/cpconnetframeworkdesignguidelines.asp
Hungarian notation is not recommended in the the new guidelines. However, you cannot apply these guidleines consistently to VB .NET.
Though some are now suggesting that you can use what you like for private fields and locals. So for the Property problem in VB you can use
m_iCount or m_count, etc.
Kevin
|
|
|
|
|
Hi friends,
I'm trying to use oledb provider (MSDAORA) for personal oracle 7.3 and could not succeeded to the full length. giving errors at the time of adding new records
Can any one help me...
Thank you
Sudhakar
|
|
|
|
|
Hi
First and foremost, i need to thank you for spending your valuable time to read this document.
OK, let us not beat the bush. Let us get into some good action.
I have developed a new ActiveX control in VB. Let me take this time to eloborate the
functionality of that Control. If you are a S/w developer definetly you will be bored to do
the things again and again. Even i was also bored to repeat the same things and then finally i
got the idea to develope this control.
Many of us used to develope some small applications which interatcts with the Database and
manipulate the records. In all the cases we have to write the coding again and again to do the
basic functions. Say for example, If you want to save a record in a Database from a Form, then
you will have to write the codings to save and in the same way to retreive a record from the DB
again you will have to write some coding. The codes wont differ but the Form differs. So in all
Forms you will have to write the codes again and again.
To avoid this i have developed an ACTIVEX control which does all the works. You absolutely don't have
to write any code in your Form. You can get all your work done without writting even a single line
of code.
The control is now ready. But the problem is, I dont have anyone who can give either good or bad
comments about this control. I even dont know wether this is a revolutionary idea or an usual thing.
To get me out from all these questions, i really need some help from others. Unfortunately i dont
have much friends to help and so i treat the peoples whoever reads this as my friend. If you have
the tendency to help this friend please mail me to get the control and pass the comments to me.
It may be either good or bad. Any type of comments are welcome.
Please dont treat this document as a headache. If you think so, you have all the rights to
move this to trash. But dont forget Trash Bin is the first place where we will have to look for
some new ideas.
If you are intersted to know about this control and want a copy of this control, please mail to
vijooo@rediffmail.com
"Your work is a self portrait of urself. Autograph ur work with excellence"
Vijooo
|
|
|
|
|
i´m trying to build an ftp server with the winsock control and one of the options should be an ident lookup on connect. It seems that my connect to port 113 to the client on connect is fine, but now i have no clue how to get the response or at least how to react on a response of the client, would the same procedure like "finger" work ?
Any ideas , snippets, help ?
|
|
|
|
|
Hi all,
I am trying to use a vb dll from a VC++ app in which I want to show a form. All goes well except where I create and show the form. This is what I am doing from the class module:
Public Sub Class_Initialize()
Dim myForm As New Form1
Load myForm
myForm.Show
End Sub
With the Show part commented out, CreateDispatch(VBDLLNAME,&oleException) returns Operation returned Successfully or something like that in the exception variable, but when The Show line is uncommented and the program is run exception is thrown 'class not registered'.
I just started with VB yesterday and need to do this to support some legacy VB code. Please Help!
Cheers,
Zeeshan Razzaque.
|
|
|
|
|
Hello I had created an Activex component
I try to create it dynamically with :
Set MyTotoObject = CreateObject("TotoViewOCX.TotoView")
In this cas I can only acces the function of my object I can not access
the extender functions.
So I can not displaying it.
I try another method:
Set MyTotoObject = MMI.Controls.Add("TotoViewOCX.TotoView", "MyToto")
With this mode I can only acces the extender methods, And I can displaying it.
but I need to use the function I have created.
Is it possible to create the object and displaying it with the possibility
to Use the functionnality i add inside
Thanks a lot Michael
|
|
|
|
|
Do you have to use late binding? Can you just add it to the Components list of your project?
--
David Wengier
TAC ad gone wrong: "Don't fool yourself, you're a bloody idiot."
Sonork ID: 100.14177 - Ch00k
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
