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 RepliesThe following is an application sample downloaded from the Microsoft website.It shows how to use the serial port.However, it does not work as written.It sends data OK.When it receives data from the serial port and attempts to display it in textBox2, the program locks up and eventually shows an error message having to do with a thread error..Does anyone understand why this "sample program" written by Microsoft does not work?I see many posts about problems attempting to read the serial port and generating thread errors,[code]
View 2 Repliesim 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]...
I downloaded some VB 2008 sample project from the net.Initially they seemed to run fine. But then they stopped running. They fall over when an attempt is made to connect to the northwind database. The error messge says something like "the sql or sql express and the northwind database has to be installed ". Which of course they are .
One possible reason that the code stopped working is that I tried to move the SQL on my Pc from one drive to another ( I moved it to another hard drive using cut and paste ). When I realise the Vb code had stopped working I simply reversed the above procedure, i.e cut and pasted back to the original drive.I think I should also add that there any different versions of sql on my PC, and I think the one that I cut and pasted is not the one used by the sample project.
I am trying to make an application that will take the information entered into the program and generate a quote sheet using Microsoft word. Right now I am having trouble creating tables in the word document. The user can choose to quote between 1 to 4 different products. If 1 product is quoted, then it will create a 6x3 table. If 2 products are quoted, then it will create a 6x5 table with the 3rd column separating the 2 products. If 3 or 4 products are quoted then it will create another table under the first table and follow the same rules as the first table. The program works perfectly if I quote 3 or 4 products but when I try to quote 1 or 2 products then it results in an error.
Dim QuoteNumber As String
Dim RowsNeeded As Integer
QuoteNumber = NumberOfProducts.Text
[code]....
I am looking to select all the tables from a microsoft access database. I just need the SQL statement i think, i can connect to the database that is needed.
View 4 RepliesI want to create a table with an option of increasing rows on clicking a button which will be on the side of tableAfter user puts data into table, that should be updated in oracle database table.
View 1 RepliesI have some problem with working with tables which were created on previous form. Say we have a form Customers in which Customers are displayed in datagridview.Now to create or add ne customer to this customer table on sql server, another form is opened.In this form user enters all data like customer name, phone number etc. when changes are made to the sql server using a stored procedure this form is closed now I want to show this newly added customer in the datagridview of the previous form.Right now what I am doing is creating data set and command et. and again fetching data for all customers from sql server.
View 2 RepliesI am new to Visual Basic Studio 2008 Express and I also have upgraded my new Toshiba laptop with Windows 7 Home Premium. Anyway, while following a video from Microsoft about creating my first two VB programs, I discovered that I could not create a new connection to the sample Northwind database supposedly installed with Visual Basic 2008 Express. Fact is, I can't even get the program and sample db to install on my computer.
View 11 RepliesI have two DDBBs, one table (basic table) with basic data and another one (city table) with a list of cities and a code for each city. I want to add the city code into the basic table. The problem is that I am showing on the webpage the name of the city, no the code... but I am not able to get the code that I want to save into the basic table.
[Code]...
I am close to the end of the first lesson in VB 6. When I try to add the northwind DB to my app and test it I get "Access to the database file is not allowed". The link is to a screen shot: [url]
View 3 RepliesCurrently, I am attempting to send an email using VB.NET. Now, I have added a reference with this code: (I have added placeholders)[code]How can I get the references to work, for all of the Outlook items (Outlook.Application, Outlook._MailItem, Outlook, Outlook.Attachments, Outlook.Attachment) are either undeclared or undefined.
View 3 RepliesI have never used Sql Server before. I have Visual Studio 2010 and whatever SQL server that comes with it but am having trouble connecting to it.DO I have to set anything up beforehand in sql server. I used the connection string to connect to the northwind database from Microsofts website but it says it can't connect
View 3 Replieshow can i create a buffer with BufferCaps.ControlEffects set to false in order to clone it? Here's the documentation
Public AudioData(7, 15) As SecondaryBuffer
Dim dev As New Device
Public Sub LoadAllData(ByVal ph As IntP
[code]....
I have to use a northwind database to display customer and order information. Populate a combo box with the CompanyName sorted in alphabetic order. Display the customer information in bound labels and the order information in a grid. For customers, display id,name,title,phone. For orders display the order id order date required date and shipped date. how to connect the access database file to vb.
View 3 RepliesI want the Indexing server Query to Search any type of document by document name.Let assume i have ..
test.ppt
test.pdf
test.doc and so on.
If I enter the test name in my search text box the , I want the search result with these file. I am using the vb.net with the help of MicroSoft Indexing Serice. I need the query of MicroSoft Indexing Serice for search any type of document by document name or title.
Public Function GetSearchResultFromIndexServer(ByVal strSearchString As String, ByVal sPath As String, ByVal sLookIn As String, ByVal sSortBy As String, _
[code]....
I 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].....
I'm currently doing a project that includes access 2010 My question will be what driver can I use for an access 2010 *.accdb type file? For a *.mdb it works perfectly well with
ConnString ="Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Application.StartupPath & "\CITSDB.mdb;Uid=Admin;Pwd=123;"
But, when I changed the mbd to accdb:
ConnString ="Driver={Microsoft Access Driver (*.accdb)};Dbq=" & Application.StartupPath & "\CITSDB.accdb;Uid=Admin;Pwd=123;"
It resulted in errors:
ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'.
ERROR[IM006][Microsoft][ODBC Driver Manager]SQLSetConnetAttr failed
ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'
And then it shows me that my code for
If dsLogin.Tables(0).Rows.Count = 1 Then
IndexOutOfRangeException was unhandled
Cannot find table 0
I knew it must be the driver but I don't know what accdb driver I can use for the connstring.
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 RepliesI have a database with one table.I'd like to populate an array with the values in the table so that I can work with the data.How do I copy the data from the table to the array?I am able to view the data with a DataGridView but can't find any info on extracting the data to an array or variable.
View 2 RepliesI have an error ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. and I've been trying to solve this but unfortunately I couldn't get the hack of this error. I'm a newbie in dotNet.
Public Sub LogInContinue(ByVal senter As Object, ByVal e As EventArgs)
Dim LibDS As DataSet = New DataSet
Dim LibDA As OdbcDataAdapter = New OdbcDataAdapter("SELECT * FROM tblUserAccount WHERE Uname='" & txtUserName.Text & "'", LibConn)
[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 am building a VB 2008 Express Edition application.I have built a database (with a single table) using SQL Server Compact 3.5 and have connected it to the project. I am able to view and edit the data using a DataGridView on a second form (tutorial made this very easy). I need to work with the data in the table within the application. how to easily load the entire table into an array or even read the table a row or cell at a time so that I can make all of the data available for manipulation within the application (the tutorials only seem to show how to display the data).
View 7 RepliesI am developing a database system using Microsoft Visual Basic 2010 and Microsoft SQL Server 2008 R2. Honestly i don't have any knowledge on how to connect the data in VB to Microsoft SQL Server 2008 R2, so kindly anyone could support me with tutorial videos or ebook or any reference
View 4 RepliesI 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 created a sample ASP .NET app. I set the location to File System. When I tried to debug it I get an error message: "Internet Explorer cannot display this webpage". I was meant to understand that I can test this app. without Internet Connection. Why is it telling that?Only performance counts!
View 3 RepliesThis is the sample in C#
using System.Web.Script.Serialization;
var jss = new JavaScriptSerializer();
var dict = jss.Deserialize<Dictionary<string,string>>(jsonText);
Console.WriteLine(dict["some_number"]); //outputs 108.541
For I keep getting errors when I try to use an online converter to convert it to vb.net. Does anyone know how to rewrite this in vb.net?
The error I get from [URL] is: line 3 col 1: EOF expected