I defined a database using SQL Server 2008 R2 Express, and connected to it using Visual Basic 2010 Express. For some reason though, when I use the database in the program, it wants to start off using a negative primary key.Is there any way to make the primary key only a positive number?
View 3 RepliesWhy when I add new item in my database table it will show negative increment?
how can i change it to positive increment or use only integer increment.
After days of labouring, debugging and researching, im on the 3rd to last line and im stuck. This isnt the full code, but the relevant parts.
Dim dbProvider As String
Dim dbSource As String
Dim con As New OleDb.OleDbConnection
[Code].....
I understand this means my table doesnt have a primary key, but i have set one.
I would like to have some explaination about the characteristics of a primary key in the table of such database. This is for vb 2008 express edition,since im new to this language,if this is true, as far as i understand about the characteristic in setting the primary key on each field for true.My question is if you are doing an updates/edit records in your table using the DataContext,if you setup the primary key for true of one of your field in the table it would edit all records in one datarow but if you put the primary key for true in all fields except one of them,all the records in the data column of that field which primary key is false could be edited.Basically its impossible to edit all records in the datarow and all the records in the datacolumn of the table in such one event. Is there any further explaination about the characteristics of primary key in the table?
View 1 RepliesI have an access database with 4 tables and two of the tables have absolutely no need for a unique field that would be a primary key. One will only have one record and the other is a detail table for two master tables. I of course get an error like "UpdateCommand is not supported against a SelectCommand that does not return any key column information." when I try to save. Do I have to just create a primary field key I don't need or is there a work around for this?
View 4 RepliesI have 1 access database with 3 tables How do I make the combobox get data from one table and input it to another table?ex.I have a table with all my Carriers and another table with jobs that are assigned to Carriers?
View 3 RepliesI am using VB.Net 2010 and SQL Server 2005 Enterprise Edition I have created a table named customer having columns (id int, fullname varchar(50)) and id is my primary key I have created a Class Library for inserting data into the customer table. to insert data I am using following code...
Public Function insertData(ByVal TableName As String, ByVal LinkToDb As SqlConnection, ByRef Adapter As SqlDataAdapter, ByRef DS As DataSet, ByVal MyArray As ArrayList) As Integer
' ----- inserts data into table
Dim sqlCmd As SqlCommand
[Code]...
[Code]....
It is returning all the columns by id. I need only the primary key. When I add the following line it is empty: WHERE SIK.indid = 1 Why is that? Is there other ways to do the same thing and working? Since I am in the rush
I'm having some problems trying to input records into a relational database. The design is really simple but I'm running into a wall when it comes to having the foreign key from my child table autopopulate the primary key from the parent table. I've made the connections in Access and from what I understood, so long as I committed a transaction, the child table would populate the primary key from the parent table. This is not happening.
my question is: is there a method that would do what I'm looking for? or am I cornered into using @@IDENTITY and manually inserting the primary key into the child table?
I've tried using datasets and data adapters and created a datarelation within the dataset, but it is still not doing what I need. everything I've tried thus far has allowed me to insert records into multiple tables, but won't relate them because of the missing primary key in the child table.
So I have a program that I am converting to .NET FW 3.5 and I am getting the titled exception on the following line:If IsNothing(dsTopPI.Rows.Find(profile.Item("GEMSID"))) Then Continue For
which is in a for each loop. The thing is, I have set the primary key and when I put in the following code:Dim columns() = DSTop30Profiles1.DTtop30profiles.PrimaryKey Console.WriteLine("Column count: " & columns.Length.ToString)For a = 0 To columns.GetUpperBound(0)Console.WriteLine(columns(a).ColumnName & " - " & columns(a).DataType.ToString)Next
I get this in the output:Column count: 1 GEMSID - System.Int32
That would seem to indicate that there is in fact a primary key, right?
Storage Unit application, 5 buildings, 107 Units split between the 5 buildings.frmBuildings is a form with:(from the botton up) 1 TLP 5 columns 2 rows5 Group Boxes, 1 per column, Group Box 1 & 2 each have a TLP with 2 columns & 3 rows. 107 buttons on the form that represent each building.The idea is that I want to change the BackColor of any button that represents an Available unit. This is a multi tier applaicationData Access Layer query function:
' Method name: getStorageUnitsAvailable
' Purpose: to return a Data Table from data base
' Parameters: none
[code].....
I would like to have some explaination about the characteristics of a primary key in the table of such database.This is for vb 2008 express edition,since im new to this language,if this is true, as far as i understand about the characteristic in setting the primary key on each field for true.My question is if you are doing an updates/edit records in your table using the DataContext,if you setup the primary key for true of one of your field in the table it would edit all records in one datarow but if you put the primary key for true in all fields except one of them,all the records in the data column of that field which primary key is false could be edited.Basically its impossible to edit all records in the datarow and all the records in the datacolumn of the table in such one event.Is there any further explanation about the characteristics of primary key in the table?
View 1 RepliesI have a job in my sql server which will execute every second and insert some data for me in my table. Now, I need to do vb.net application to check whether checkouttime column in that table got data or not and if there is data then I need to get the id of that row.
How can I monitor my table's data to check whether that column got data or not.
I have a datagrid with three columns of data and i need to save all those data to a table in SQL Server.
View 6 RepliesI'm trying to get a single field back from the data. (I am searching by a primary key so I should get 0 or 1 answer). Please help. The table that I am querying has one entry with user = someone, input to several columns with the ans column having "a good answer"
Code:
Dim reader As SqlDataReader
Dim par As SqlParameter
Dim result As String
[Code]...
How would i get the primary key id number from a Table WITHOUT making a second trip to the database in LINQ To SQL?
right now, i submit the data to a table, and make another trip to figure out what id was assigned to the new field (in an auto increment id field). I want to do this in LINQ To SQL and not in Raw SQL (I no longer use Raw SQL).
also, seond part of my question is: i am always careful to know the id of a user thats online because i'd rather call their information in various tables using their id as opposed to using a guid or a username, which are all long strings... i do this because i think that SQL Server doing a numeric compare is much (tentative use of the word 'much') more efficient than doing a username (string) or even a guid (very long string) compare.
I hope someone can help me. I have an ATM machine connected to a server. A form takes a textBox entry as a PIN number and matches it to a card number in the same table which is the primary key. The card number is in a comboBox.Selected Item. I have used a dataset to fill the comboBox as the form loads. I have tried for days and got nowhere.
View 6 RepliesWhat's the syntax for an Update query for a table without a primary key?Disclaimer: Frustratingly, adding a primary key is not an option. My program is a small program in a much larger system with poor data management. My development time does not include rewriting the other software.
Note: The database is Microsoft Access.
Note: Similar to: Excel: TableAdapter UpdateCommand for table without primary key
UPDATE: Am I correct in saying, "If the table in the database has no explicit primary key, then there can be no valid TableAdapter UpdateCommand?"
Ok i have 3 tables in a dataset
Table1 contains items for sale (referenced)
Table2 contains Stores (Parent)
Table3 Contains items in a particular store (Child)
the problem is the data in this case. Table 2 contains a StoreId field as a primary key. Table1 Contains an ItemId field. My problem is in table 3 this contains 3 fields, StoreId, Name and Quantity.
Now my Table1 contains a field called Name and one called PluralName, I need to determine which field in table one relates to the Name field in table3.
The following 2 constraints exist currently in my app
Table2 - StoreId (one) to Table3 - StoreId (many)
Table1 - Name (one) to Table3 - Name (one)
can i add another constraint :- Table1 - PluralName (one) to Table3 - Name (one) ???
I am presuming if i do i will get a constraint error as the property does not relate on a one to one level if the store has more than one item in stock and vice versa when it has only one in stock.
I'm trying to insert a row into a SQL Server table.
Using this...
cmd.CommandText = "INSERT INTO MyTable (firstname, lastname) VALUES (@firstname, @lastname)"
cmd.Parameters.AddWithValue("@firstname", "bob")
cmd.Parameters.AddWithValue("@lastname", "jones")
cmd.ExecuteNonQuery()
I get an error saying:
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@firstname".
But if I use this...
cmd.CommandText = "INSERT INTO MyTable (firstname, lastname) VALUES (?, ?)"
cmd.Parameters.AddWithValue("@firstname", "bob")
cmd.Parameters.AddWithValue("@lastname", "jones")
cmd.ExecuteNonQuery()
...it works fine. What do I need to do to make the first example work? I don't understand what the error message is telling me. How do I declare a "scalar variable"?
How to insert data from a populated datagrid into sql server table and how to make the values conform to the specified datatypes construct in the sql server side. Assuming the datagrid headings have already been created in the sql server side.
View 6 RepliesI am using visual basic 2008 and sql server 2008. I am trying to retrieve data from a table in sql server 2008. I am using the following code
Dim cn As ADODB.Connection
cn = New ADODB.Connection()
Dim rs As ADODB.Recordset
rs = New ADODB.Recordset
Dim cnstr As String
[Code]...
VB.NET:i want to select data from sql server 2005 DB table and displaying into text box that depends on combo box selection using VB.NET
View 1 Repliesi need to copy all the rows with data from a existing table to other existing table through button click
View 13 RepliesI am trying to append multiple rows in a SQL Server.I have connected to the MS SQL Server and with a DataAdapter, I have downloaded the Table into a DataTable and displayed it in DataGridView.I now want to programatically enter multiple rows into the DataTable and later to update the SQL Table.
I am trying to build an application to do this generically.The problem I have is that the Table and DataTable has an 'ID' Field. In the SQL DB, i is an Auto-incrementing field.When the code loops through creating new rows and entering field values, how do I handle the ID Field that is the Primary Key?
I am facing now a very frustrated simple project, I successfully imported .csv to datagridview using VB .NET 2010 but I have no idea how to import it to SQL SERVER 2008 specific data table.
View 7 RepliesHow to create a primary key as A1/D-M/100000 in SQL Server 2005 in Visual Studio 2008 ?
View 4 RepliesI THINK this should be a fairly simple fix, but my VB newbness is holding me back.I want to add data from various CSV files into a SQL Server staging table. Each CSV file has its own quirks as far as field names, more fields than the others, etc. go, so I'll need to map each CSV structure to the staging table in code.
[code]...
But it's no good, I get this error, "Input array is longer than the number of columns in this table." at "row.ItemArray = data".
SQL Server has a Data Type of "Float". Visual Studio has a Data Type of "Decimal". In other words, if I have a variable in a VB.Net app that is defined as a "Decimal" ...can I move that value into a SQL Server Data Table column defined as a "Float"?
View 4 RepliesI am using a number of tables on my application and two of which have a foreign key constraint I have set between them. When I change the account number on the main table via a combo box all of the relevant information for that table on the form is updated accordingly. However, the child table which has a foreign key reference to the Account Number of the main table is not updated when the acocunt number is changed. I have set the update to cascade in the references but still am having issues.
View 5 Replies