|
Any help with this is appreciated VERY much.
My trouble: I have a mini-CRM app that I am writing and I have a SQL database with multiple tables - Account, Region, etc. Each row in the Accounts row has an ID column that is the primary key and is auto-incremented. The same goes for the Region table. In the region table, each row had a region of the state (ie. Central, South). Let's say the table is as follows:
ID Desc
1 Central
2 South
On the form to create a new account, I want to display the Desc column values but insert the ID field into the Account table, so there is less data to store. I am trying to use a combobox to display all regions, and have so far been unsuccessful in inserting only the ID field into the Accounts table. I am using VB.Net, VS 2003 beta, and am using VS-created datasets and data adapters. Am I going down the correct path, or should I buy another book and read more. On the new Account form I have info from multiple tables with which I am trying to do the same thing, so I don't want to use a large number of datasets to store all data.
Thank you all for you help.
- Robert W. Dempsey
|
|
|
|
|
if some one can tell how can i lock the system date/time from my vb.net application so that it can not be changed.
Please tell me with source code.
|
|
|
|
|
What do you mean?
Do you want to stop windows users from changing the date/time?
The system time originates from the system clock which any user can change from windows/dos ect. If you have Win2k or NT4 there may be a way for you to stop them from accessing these options by restricting thier accounts although i'm not sure how.
As for locking the date/time from your app. surely if you dont include code that sets the date time which is accessable to the user, then they won't be able to do so.
I think you need to clarify what you are trying to do.
Regards
Wayne Phipps
|
|
|
|
|
 We are trying to developing small DNA application using VB .NET. We have defined one interface project. Ther are two types of class one is for property (IAc) & other is for method (IAcExec). We implement IAc in business tier & IAcExec in Data Tier. Data tier is resides on MTS. We are using ActivatiopType is server. We have faced problem like When we pass ByRef Me (i.e Implements class of IAc) from Business tier to data tier using function/sub. (Function fill the value of interface class.)At that time we have not received values at business tier through ME object. In brief it just treat as ByVal Me. Same when we declare varible for business tier class (i.e Implements class of IAc) and pass object then we have recd. values with same function/sub.
Please give me suggestions on it.
|
|
|
|
|
Can I compile VB6 code in VB7?
Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!
|
|
|
|
|
you can convert VB6 to vb.net
but compile vb6 as it is .. i don't think so
|
|
|
|
|
okay, I was wondering because my school will give me VB6 very soon, but I already own VS.NET so I don't want to install VB6 unnecessarily! 
Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!
|
|
|
|
|
VB6 and VB.Net can both be installed on the same PC (side by side) without affecting each other.
Regards
Wayne Phipps
|
|
|
|
|
Rickard Andersson wrote:
okay, I was wondering because my school will give me VB6 very soon, but I already own VS.NET so I don't want to install VB6 unnecessarily!
Then, you have asked the wrong question; the correct is: can VB.NET code be compiled on VB6? And the answer is no.
It's not the fall that kills you: it's the sudden stop - Down by Law, Jim Jamursch (1986)
|
|
|
|
|
 We are trying to developing small DNA application usnt VB .NET. We define one interface project. Ther are two types of class one is for property (IAc) & other is for method (IAcExec). We implement IAc in business tier & IAcExec in Data Tier. Data tier is resides on MTS. We are using ActivatiopType is server. We have feced problem like When we pass ByRef Me from Buseiness tier to data tier using function. (Function fill the value of interface class.)At that time we have not received values at business tier. In brief it just treat as ByVal Me. Same when we declare varible for business tier classes and pass object then we have recd. values. Please give me suggestions on it.
|
|
|
|
|
Hi everybody,
I have added a property inside the propertygrid through am getting the collection editor.Am also able to add items to the collection but unable to edit the names of the object.Bydefault,it is getting System.Object as the item.
Regards
Ranjeet
Ranjeet Ranjan Kumar
|
|
|
|
|
Hi all,
I want to add NumericUpDown control corresponding to a property using property grid.If anybody knows it please let me know ASAP.
Regards
Ranjeet
Ranjeet Ranjan Kumar
|
|
|
|
|
Hi all,
I would like to pop-up the custom form using property grid corresponding to a property defined.If anybody knows please convery me asap.
Best Regards
Ranjeet
Ranjeet Ranjan Kumar
|
|
|
|
|
I am using visual basic 5 and I am using a crystal report object on the form. I am using the following code to bring up a template with the report which then has a button to print it.
svrId = .LogOnServer("p2sodbc.dll", "SystemDSMName", DbPath, "admin", "")
.WindowTitle = reportType
.ReportFileName = PROGRAM_PATH + "\reports\" + rptName
.PrintReport
.LogOffServer svrId, False
Everything works fine most of the time but on some client machines, when the ".PrintReport" line is reached when printing the report instead of a template coming up with the report that is displayed and can then be printed, no template or a ghost template comes up and the hour glass stays up for a while and then disappears. Its as though the system is making an attempt to bring up the template with the report, but is unsuccessful. No error message is displayed. Any other file prints fine on these machines and printer setup seems to be fine. The problem also seems to be intermittent on these machines as sometimes it works. Any help would be greatly appreciated!!
|
|
|
|
|
I have a problem with Combo Boxes that I just can't fathom.
I'm creating a database front end working in VB.net. The front end requires loads if lists such as UK Counties, Suppliers etc. To handle these I've created Class Objects to hold an ID as an Integer and a KnownAs name string . These Objects are stored in an ArrayList inside a second Class which provides methods to supply the appropriate data when asked - I've split the data descriptive Class from the data handling Class as I eventually will use remoting and will pass an ArrayList of my data Objects to my data handling Object. These lists are shared and either static as in the case of Counties or have a Time To Refresh as in the case of Suppliers and exist for the life of the Application. The records, say Customer details are stored in their own Classes with the County value being stored as an ID. The values are written to the Form fields manually - I've not used binding. In the case of the Combo Box I set the DataSource to my data handling Class, the DisplayMember to my KnownAs string and the ValueMember to my ID (both values are Methods in my Class). On applying my record to the Form I set the Combo Box SelectedValue to the appropriate record ID value.
Here's my problem - If my lists are sorted by ID it all works as expected. If, however, I set the Combo Box to sort the DisplayMember it all goes pear shaped. I realise that a Combo Box stores the ValueMember as a string and sorting the DisplayMember scrambles the ValueMember order, but I find it hard to believe that something I've been doing in Access for years doesn't work here. Apart from these niggling problems I'm very much in favour of DotNet. Any ideas ?
Steve
Answered my own problem:
Sort the data within the query and turn ComboBox sorting off.
The ArrayList is zero based as is the ComboBox list so provide a GetIndex procedure that searches the ArrayList for the required ID and returns the corresponding Index (Incremented Count from zero).
PS ValueMember is an Object and not a String as I've previously stated.
|
|
|
|
|
Hi!
I'm trying to find a way of, by code, to register a file type (Ex .vmn) and to assign an icon to that extention, i would also like to know how to make that file type only openable by a pre-defined program!
Thank you for your time
|
|
|
|
|
I have a picturebox control i want to save the image of the picturebox into sqlserver database ,how is it possible using insert query in VB.NET.please help me with code
|
|
|
|
|
you can just store the image path in the database and then use the load picture function and use the path stored in the database if you dont know these functions i know i have the code somewhere i would have to find my .net version but i know exactly where my vb6 version is so let me know if you need further help
|
|
|
|
|
|
Thanx a lot Thats what i was needed
|
|
|
|
|
How can i use a dll in VC++ which is written in VB???
please help me as soon as possible.
thanks
sukhdeep
|
|
|
|
|
Yes..
If you make a VB project ActiveX DLL and create Class modules you can cerate objects of these classes in VC++
but VB can't expose functions that can be called using Declare in vb6 or ::LoadLibraryin VC++
|
|
|
|
|
Hi,
How can I print pdf files from a batch file without user interaction and to any specific printer. Its important the printer selection.
Regards
Pedro
|
|
|
|
|
|
i am in the process of writing a game called bunco and i have hit one of those walls. Basically i have an 12 element array and at the end of the game i need to find out which element holds the highest value,which holds the second highest, and what holds the third highest but i also need to find out if there is a tie for any of those spots now i know the long way to do this but was hoping that someone might know a shorter and more effiecient way
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
