Add New Row In Database, Get -1 For ID Field

Aug 6, 2009

I'm trying to make an appointment scheduler here. The table has an AppID column which just increments 1 every time a new appointment is added. That works fine. It also has an ID column that gets a unique doctor ID assigned to it so the program knows which doctor has which patient.

Now, when I try to add a new row, no matter what I try, the ID field gets a -1. I've tried assigning it the doctor's ID that I'm currently browsing as well as hard coding it to be a "3" and it still shows as -1. So this means that while it [B]does[/B] save and update the new row, it adds that -1 in the ID column and thus the program can't tell which doctor has it so it won't show in my program. I don't know if this is because I've tried so many data sets that it's getting them confused or what, but here is the code that I am using to try to save this:

[Code]...

View 7 Replies


ADVERTISEMENT

Make Gridview Checkbox Field Update Boolean Field In Database?

Feb 7, 2011

There are lots of questions about this but I've not been able to solve my problem using the answers to any of them (after many, many attempts..)

I'm working in vb.net creating an asp.net web application. I have an SqlDataSource and a GridView on my page.

I want to change the DoNotMail boolean value represented by a Gridview checkbox and automatically update in the database if the checkbox is checked from 0 (False, Will Mail) to 1 (True, Won't Mail) here is the code I used. [code]...

is it possible to do a two way sync on the entire gridview when the user hits a button so you don't have to do an update every time a row is changed? because the user might check the box and then check another box then uncheck a box and it would be a lot of updates...

View 3 Replies

VS 2008 Connect Database Field To Database Field?

Feb 16, 2011

I created a local Database in VB2008 with 4 tables, the problem is that I have a textbox in one table and a combobox in other table and I want that the information that I put in textbox appear after in combobox from the other table... that's possible?

Table: Filmes ... Field: NomeTextBox
Table: Tempo de Aluguer ... Field: Nome_FilmeComboBox

View 10 Replies

Make Database Field A DateTime Field Currently Is Set To String?

Oct 5, 2010

Dim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query

View 1 Replies

Transferring Data From One Field In A Table In A Database To Another Field In A Different Table But Same Database In .NET?

Jul 22, 2010

I am creating a database in VB.NET for a movie rental place. I currently have three forms;

Member Information
DVD Information
Borrow DVDs

What I would like to do is when I am viewing a member's details, if I click a button 'Borrow DVD for Member', the member's ID number transfers over to the Borrow DVDs table in the Member ID which also would hold some information from the DVD Information table, but I'm sure if i can figure out how to do this firstly, I will be able to apply the same rule and work it out myself.I have been trying to use a query statement like;

INSERT INTO [Borrow DVDs].[Member ID] [IN goodstuffvideos.mdb]
SELECT [Member Information].[Member ID]
FROM [Member Information]

but that has been coming up with error codes and completely not working.

Borrow DVDs table fields are: Borrow ID, Member ID, DVD ID Number, Hiring Fee, Borrowing Limit?

DVD Information table fields are: DVD ID Number, Title, Rating, Hiring Fee, Borrowing Limit Member?

Information table fields are: Member ID, Family Name, Given Name, Address, Town/Suburb, Postcode?

The error coming up is; Error in INSERT statement. Unable to parse query text.And under that it says The query cannot be represented graphically in the Diagram and Criteria Pane.

View 1 Replies

Dataset Link To Database - Add One Field Inside The Database

Jul 2, 2009

I had a dataSet which link to a database. I need to add one field inside the database, After adding the field, how can I update and link it to the dataSet?

View 4 Replies

Can Save Data To Access Database And In Access Database Field Set It To Date / Time

Jun 4, 2011

I can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.

View 2 Replies

CSV To Database Field Mapping

Nov 17, 2011

I have a form with a button that says "Open CSV".I want to be able to click that button. Then browse for a .CSV file, and after I select the file, populate a combobox with all of the headers of the .CSV.I would then be mapping these headers to fields in my database, then import the .CSV data into my database.

View 3 Replies

How To Access Database Field

Jul 9, 2009

i have a table name product , when i m inserting data into product i need to first check if Product Name already exist in database if yes i want to exit. basically i want to know how to get data from the database and how to access columns in asp.net .

View 4 Replies

Overwriting A Database Field?

May 16, 2012

I have a database called NurseLocationI have a table called CoverList with two fields UserId and CoveringI can connect to the database fine and read the fields into variables that I can use in my program. w I want to take an existing variable called userFullName and put it into the Covering field where the UserId is = to "LHV"This is my code on button click to do that.But I was told I shouldn't use INSERT because it creates a new field

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Declare variables and get username from active directory

[code].....

View 2 Replies

Select More Than One Field From A Database?

Dec 28, 2008

im trying to gather information from 3 tables at once

[Code]...

View 1 Replies

Sum Number Value To Database Field?

Sep 30, 2011

How to sum the number value(textbox) to my database field ?

the red section doesn't sum the value(textbox) to my data field.[code]...

View 14 Replies

VS 2008 Add New Row In Database / Get -1 For ID Field

Aug 4, 2009

The table has an AppID column which just increments 1 every time a new appointment is added. That works fine. It also has an ID column that gets a unique doctor ID assigned to it so the program knows which doctor has which patient.Now, when I try to add a new row, no matter what I try, the ID field gets a -1. I've tried assigning it the doctor's ID that I'm currently browsing as well as hard coding it to be a "3" and it still shows as -1. So this means that while it does save and update the new row, it adds that -1 in the ID column and thus the program can't tell which doctor has it so it won't show in my program.[code]I'm only trying to get the ID column populated, the rest should be fine as they're all from textboxes.

View 8 Replies

Copy Data From One Database Field To Another?

Oct 6, 2010

I am a bit in a pitch here. We have got a development environment and a sat environment for our oracle databases.Here is what I want to achieve. I want to copy data from an x number of columns of my dev. environment to the same x number of columns of my sat enviroment. I've already tried some stuff and have created a couple of functions that copy all records to my sat environment( meaning from all the columns or fields if you will ).[cde]...

View 1 Replies

Create A Field In Database Access?

Jan 8, 2010

I need to create a field in my database access throught code... I had this code in VB6 to do the job,but i'm a little confused with the way to do this in VS2008.Off course I know the way to open the database,but the way for create the field I don't know!

Dim tdf As TableDef, fld As Field, Top As TableDef
Dim nCtr As Integer
Dim bFound As Boolean

[Code]....

View 5 Replies

Database - Checking The Value Of A Field And Updating It

Aug 18, 2011

I'm a little confused about checking values in a database. What I want to do is see if a tuple such as the following exists:

[Code]...

The invoice_num is not null, it's blank: " ". What I want is to find if such an entry exists, where the invoice_num is " " and update it with a number entered into a textbox. I'm a little confused about if statements and cases in SQL, so if someone could point me in the right direction, that would be great!

View 3 Replies

Editing A Single Field Of A Database?

Mar 9, 2010

with editing a single field of a database. variable dS is my dataset variable in which i have filled with the tables of my database. since its my first time in database management with vb.net

Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
If txtPOno.Text = "" Or txtDate.Text = "" Or txtSuppCode.Text = "" Or rBOM < 0 Or

[Code].....

inorder to pass. honestly, i really think that im using a BRUTE FORCE method.

View 2 Replies

Getting The Highest Number From A Field (Row) In A Database?

May 8, 2011

I created a code that inserts a number into a row every time someone submits a form.I am able to read the data back to the form using a loop.My confusion is I would like to get the highest number from the data field(column)Lets say the Field(column) has five numbers from 1 to 5.How do I get the highest number?I was looking at using a loop to go through the field and bring out the highest number, but should I use an array?

View 5 Replies

Got A SQL Database With The Field Type Date?

Nov 22, 2010

I've got a SQL Database with the field type Date, when i load any data such as 06/04/2010 into my masked textbox it shows as 64/20/10 (without the leading zero's so the date shows wrong.

Also how can I set it to be dd/mm/yyyy and not mm/dd/yyyy?

View 1 Replies

Inserting New Field Into Database - Getting Error?

Apr 13, 2010

I've got this code. But I keep getting an INSERT INTO error when I try to insert a new field into the database

Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
Dim recordsadded As Integer
Dim strSQLString1, strSQLString2, strSQLString As String
strSQLString1 = "INSERT INTO tblParts (PartName, PartPrice, Part Supplier) "
[Code] .....

My 3 datatypes are text values, and I have another form adding entries to my database in another table, which are all text values.

View 5 Replies

Matching Text Box With Database Field

Jun 9, 2011

I'm trying to design a words game that's give you the first two letters from the word and you insert the rest to make a word (for now I'm just using "co" as example and I have just one table in the database for it). The word will be written in textbox to be compared to a database field. If the word exist in the field the word will be displayed in a label with blue color and the score will increased by one if not the word will be displayed in the label with red color. This should happen three times with three words and I have different label for each one.

the name of my database is database1 and it have one table "A" wich contain "Comp" and "word". I tried this game with array of word before and it was working. Now I'm trying to use database instead of arrays but its not working. [Code]

View 6 Replies

Read Field From Database Into Variable?

Feb 27, 2010

I simply wont to read one field in a databasetable into a variable.[code]....

View 6 Replies

Search A Varchar Field In A Sql Database?

Aug 16, 2010

how do i search a varchar field in a sql database and get rid of the char unless it is an number 0 thru 9 and then add that number to the monthly calendar todays date to determine a due date?

View 4 Replies

Show Value Of First Database Field In Column1?

Mar 11, 2010

I have following codes to to show data in listview.It displays first column empty. The value of first column is displayed in column2.How to show value of first database field in column1

[Code]...

View 1 Replies

Store Value In Database Field Without Any Literals?

Sep 2, 2009

I have a masked textbox on my form for a phone number. I want to store its value in my Database without the literals as the database field for that phone is only 10 characters long. How do I store this value in the database field without any literals.

View 3 Replies

Update A Database Field With A Richtextboxfield

Mar 15, 2012

What I am trying to do? update a database field with a richtextboxfield.

I have tried using Dim range1 As New System.Windows.Documents.TextRange(RichTextBox1.Document.ContentStart, RichTextBox1.Document.ContentEnd)

But this did not work for me either.

CODE:

View 2 Replies

Update Row In Database But Skip One Field?

May 13, 2009

I have written this set of code that will update an Access Database row: (Total_RAM, Model, etc are just string variables)

Dim Record As InventoryDataSet.InventoryRow
Record = frmMain.InventoryDataSet.Inventory(0)
Record.BeginEdit()
Record.Total_RAM = Total_RAM
Record.Model = Model

[code]....

My problem is the fact that one specific record called "Record.Asset_Tag" exists in the database, but I don't want to programically alter it. That will need to be typed in manually. However, even if I don't put in the line "Record.Asset_Tag = ...", it will overwrite anything in the field with a blank.How do I keep whatever is in the database unaltered in the Asset_Tag column?

View 2 Replies

Use Loop To Edit Field In Database

May 19, 2010

I would like to loop through my database and edit a field. For some reason the last value of the FOR loop is being saved in the field. What should happen is that the ZonePos field should be filled with value 1 to how many records in the table. Currently lets say there are 5 records in the table, the value 5 is saved in all the rows.

[Code]...

View 1 Replies

Access Database - Filter Characters In Field

Nov 2, 2011

I have a database that I would like to filter characters from anywhere in the field. Example the letter A is typed into textbox1 and in the grid every field that contains an A is show. Like dash, lap, trap, apple. Currently with the query I'm using it will just go from the beginning of the field. I get "Index was outside the bounds of the array". The code is as followed:

Dim filter1() As String
filter1 = TextBox2.Text.Split(" ")
Sheet1BindingSource.Filter = "Stationary_location like '" & filter1(0) & "' Stationary_location like '" & filter1(1) & "'"
VB 2008 using access database.

View 2 Replies

Add A Blank Value In A Field In Access Database By Vb 2008?

Aug 13, 2011

I want to add a blank value to a field in access database with vb 2008 command.

Problem 1: Here is my code, it shows conversion to string not possible errors

Private Sub btnRedThrow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRedThrow.Click
Dim dbCnct As New DBUtills

[Code]....

notice the fifth and last value is empty. But it is not being added into the database, how do I do that?

Problem 2: Why does an additional field from my access database disappear even after I manually created the field?? (access database 2003 version, extension is .mdb) I'm using visual studio 2008

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved