im new on SQL databases and im working with the "Northwind" sample from microsoft there are 4 tables with this realtion Customer->Orders->OrderDetails->Products.i want for every customer to list the products ordered... how can i link those 2 tables?
View 1 RepliesI have a Database with the following tables, PolicyHolder, Beneficiary, FinacialDetails, Gender, Nationality, Relationship, Income. They are all linked by ClientID primary key of the PolicyHolder table.
When i'm adding my data in the Beneficiary table using a DataGridView i get an error when im adding the second entry saying - FK ClientID already has a value and this value cannot be duplicated. I want the FK ClientID value to be saved on every record i enter under Beneficiary.
Im not too sure if this is the correct place for this question, but I couldn't find anywhere else..Heres what i want to do. I have two tables in an Access DB. TableA and TableB. Each Table has only one column called Picture, and that column is filled with the names of pictures (picture1, picture2, picture3, etc)
Thing is, that The pictures in TableA have equivalent pictures in TableB. They are not named the same, but the pictures themselves are the same i.e.: TableA Picture1 = TableB Picture3, TableA Picture2 = TableB Picture5.
What i Would like to create is a form that has two datagrids, or Listboxes populated with the data from each table. One for TableA, One for TableB. When the User selects a picture from one of these controls, The other control must show which picture the selected one corresponds to (if i select TableA Picture1, TableB Picture3 becomes selected showing that they match)
I think that most of the work will be at the actual DB, somehow linking each and every field, maybe a one to one link between fields/cells in the DB, then in VB calling that one record that was clicked on, seeing what relation it has to the other table,
[Code]...
Im new on SQL databases and im working with the "Northwind" sample from microsoft. there are 4 tables with this realtion Customer->Orders->OrderDetails->Products. i want for every customer to list the products ordered... how can i link those 2 tables?
View 4 RepliesI'm looking for a front-end that's very simple, to access a to-be-built MySQL Database. I actually need it for only one table. I was thinking that the user could search in a way that would ask for values for each field of that table, and give the option of leaving it blank. Then, it would return all the entries that match up with the query.
View 3 RepliesIs there anyone can post a simple code using vb,that start building a simple games ?
View 2 RepliesI am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
have a datagridview containing 2 tables left joined, so that:table1 LEFT JOIN table 2 ON table1.id=table2.idI get an error whenever I try to edit my datagridview."invalidOperationException was unhandled by the user codeDynamic SQL generation is not supported against multiple base tables."The error points to this line:
da.FillSchema(dt, SchemaType.Mapped)
da.Update(dt) << This line
'da = dataadapter
[code].....
In my datagridview I was fill in using join tables (table1 = pr_employees, table2 = pr_employee_deduction). My problem now is during save button I want to update records from table2 only.[code]
View 3 RepliesTrying to make a simple browser with some simple addon's. What Ive done is setup a menu(forum) for the user to enter their email providers web address and it will save it in a xml file. When they click on the email link, it should load the email xml iformation and place that info in the tb_html.text and navigate. I keep getting a null exception and im not sure what going on here. Here is the code:
Browsers:
Private Sub btn_Email_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_Email.Click
'Load Action
Dim SavedEmailObj As Storage
[code].....
We are presently developing an application, let's call it APP1, which uses a SQL Database which have about 800 stored procedures, 600 tables, etc. APP1 was originally created in order to replace another application, APP0, from which we do not have source code but only SQL tables, Stored Procedures, views, etc. Previous programers of APP1 used some DB objects from this same database and added some other objects specific to APP1 because it becomes bigger than APP0. And we do not need APP0 anymore as APP1 does all what we want, and more.
So, now, we are thinking about a way to find out which objects are used by APP1 in order to remove objects which are ONLY used by APP0.What is the best approach to discover all objects used by APP1 without having to open every single class and form?
Once we will have a complete list of these objects, it will be easy to use a program we bought which detects all dependencies for all SQL Objects specified directly from SQL and remove objects which do not return from any dependencies. Any ideas of how I could get this list without having to go through all our program that have many, many, many classes and forms?
Note : I know, in a perfect world, all calls to PSs and tables should be in a DAL but in the case of the application we're presently working on ... this is not our case! Yippy! (sarcastic yippy) ;)
Note 2 : This application is not using any ORM. So all queries are directly using SqlCommand. So any call to any DB objects are in string format.
I have a 5 tables in my database and i want to access all my tables togather at a time.e.g.I have a code for one table i.e. rs.Open "select * from Group_info", con, adOpenDynamic, adLockBatchOptimistic. instead of Group_info table i want to access 5 tables also as Login_table,User_info table,group_name table etc. How i do that
View 11 RepliesI am currently doing a project which is to be linked with another project. I.e., when I click on some button in my current project's page I should get a page from the other project..
View 2 RepliesI have an e-mail that i send out and everything works fine exceptthe hyperlink doesn;t link.
taskMessage = <a href="C:\Program Files\Microsoft Office\OFFICE11\powerpnt.exe"> Powerpint </a>
myEmailClass.SendEmailMessage("myemail", "your email", "You have a new stalker",
[code].....
I got 3 tables in database namely A,B,C. how am i going to link the column a in A and column b in B to table C so that table C can have both my data a and b?
View 3 Replieswas just wondering if it's possible to link up excel and vb so that data can be inputted into vb and then transferred to excel which would carry out calculations using functions and send the data back.
View 2 RepliesI'm trying to do is access a DLL that is outside the original EXE's file structure. So like this
C: estexe estexe.EXE 'The EXE that needs to access the DLL
C: estdlls
eturnstring.dll 'The DLL I'm trying to access.
So far everything I've tried has failed. I keep getting a FileNotFoundException.
I've added the following code to my app.config
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
[Code]....
I've recently decided for my VB final that I'd like to tackle something my professor and I discuss constantly; portable game server apps.
What I'm wanting to do, essentially, is create just a rudimentary programme that allows you to check the server status of either the north American or European servers for the game Rift and just (instead of opening your default browser, which I know how to do already) displaying the info in a listbox inside the programme itself.
The information I have to work with (aside from the obvious direct .php link to the web page) is two separate .xml links that contain all the information that is contained on their webpage. I could easily just turn these .xml files in an access database but I want something dynamic rather than static, but I honestly have no clue of how to turn this info I have into something I can actually use in my programme lol.
I'm creating a system (for a project) that is based on a vet.I want to create a combo box that has a list of different animals (e.g. Dog or Cat etc.)and when an animal is selected,a group box, with loads of checkboxes inside appears. Then the user can tick a check box (a vaccine to be given to the animal) and the record is saved to a database.I have hard coded this to work, but I want a more sophisticated code set, that links to SQL so that when a new vaccine is to be added, I would only need to add it in a table, in the database. I don't know where to start for this could any one give me a nudge in the right direction?
View 2 RepliesIndividually the Draw red and draw white work. The delays work.When in series the only color seen is the last color. Why? [code]
View 5 RepliesWhat are the main functions needed to create a .dll file in vb.net which needs to be Explicitly linked i.e at run time to an application Plz post me an equivalent code snippet in VB.Net
Explicit run-time linkingDLL files may be explicitly loaded at run-time, a process referred to simply as run-time dynamic linking by Microsoft, by using the LoadLibrary (or LoadLibraryEx) API function. The GetProcAddress API function is used to lookup exported symbols by name, and FreeLibrary — to unload the DLL.
[Code]...
i've been searching everywhere to try to get this setup. I am running Visual Basic 2008 I have 1 Combo Box that Has 3 Entries, Kyocera>Konica>Toshiba I have a 2nd Combo Box that has entries for each of those manufactors ...Kyocera has 3035,4035,5035....the konica has c250,c352,c452......the Toshiba has c3520, 4520
[Code]...
i've been searching everywhere to try to get this setup. I am running Visual Basic 2008 I have 1 Combo Box that Has 3 Entries, Kyocera>Konica>Toshiba I have a 2nd Combo Box that has entries for each of those manufactors...Kyocera has 3035,4035,5035....the konica has c250,c352,c452......the Toshiba has c3520, 4520
I want it so when i click on Kyocera the 2nd combo box only reads 3035,4035,5035 and when i click konica it only reads c250,c352,c452 etc etc
I have created a form in VB 2010 and I want a executable file (.exe) to open when the user clicks on that button. What do I need to do to accomplish this?
View 2 RepliesI have a database (sql server) where i store activity information example (activityid,id,summary,signs etc.) I can successfully save this information to the database. what I also want to achieve is to add this information to a listbox so that it can be displayed in the corresponding textboxes at runtime for an encounterid.
View 6 RepliesI have several resource files I would like to be able to access in my Visual Basic program by using code. I have added them in folders in the projects folder, and have also chose the "Include in project" option for them all. However, I am a bit confused when it comes to the correct format for linking them with the code. I didn't think using a full path (starting from the C: drive), then linking to my main project folder, would be a good idea since when the end user installs it, the path would be invalid. I tried to type the path like this: "ResourceVideoABCImage000.jpg" however, I receive an Invalid Parameter error. The only way to make it work is to enter the entire path name.
View 2 RepliesI have one main form and another dialog box that is used to search records. What code is used to declare a public variable in the dialog box form in order to get the record found by the user displayed back into the main form?
View 4 RepliesI need to link different arrays of data that I am gathering from different Select Cases.For Example:Araray A, B and C from Case 1Array C, D and F from Case 2 Note: Array C is common between two cases.I know in C++ I could have used Pointers and use SQL in Java.
View 1 RepliesI have two forms. In form 1, I have a textbox1 and in form two, I have a textbox2 and a button1. Now what I want to do is, write in textbox2 (That is in FORM2) and when I press the button, it just go to textbox1 (That is in FORM1)
View 3 RepliesI am new to vb.net. I am currently programming Space Invaders. Firstly i have two forms What is code for linking form 1 to form 2?
Secondly i have coded and tried to understand arrays. I currently Have
Private Sub tmrUFO_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles tmrUFO.Tick
[code].....