How to insert multiple data into mssql without using loop?i'm developing a clinic management system, while doctor may give few medicines to patient,therefore i hope inside my database,the data will look like [code]
View 2 Repliesi have a big problem here when i want to insert 6 data into 6 different row in 1 click.
in field @ form it have name, staff no.,items, quantity and date. We can select 6 items to insert which i use ComboBox for save the data in form. In this case, each name can choose 6 items in one time and i want to save it in database just in 1 click. that mean it will put a same name in 6 rows in a table. the look like this but it not complete...
[Code]...
This happens occasionally in my app. How can I prevent this:INSERT statement conflicted with the FOREIGN KEY.[code]
View 1 RepliesmyCommand = New SqlCommand(
"INSERT INTO tblBook(BookCode, BookTitle, Author, PublishingYear,
Price, EnterDate, CatID, RackID, Amount)
VALUES('" & txtBookCode.Text & "','" &
txtTitle.Text & "','" &
[Code]...
The INSERT statement conflicted with the FOREING KEY constraint "FK_tblBook_tblCategory". The conflict occurred in database "CIEDC", table "dbo.tblCategory", column 'CatID'. The statement has been terminated.
Was that because of my database's relationships?
I am new to VB.net and have created a simple master detail windows form. I created a two table data set and then dropped the master table on the form as a continues form or a detail form with several text boxes to enter data. The child form is a data grid and was simple drag and drop from the data-set. All of this was done with drag and drop and I have added nor changed any code.test data that I have added directly to the database shows up with the proper parent child relationships on the form. I can also enter new records into the database using the parent only portion of my form. I can also update a child record.When I attempt to enter a complete record with data in both the parent form and the child data grid I get this error.
The INSERT statement conflicted with the FOREIGN KEY constraint FK_tblComplainant_tblUseOfForce. The conflict occurred in database "C:\SQLFILES\CCTS_2.MDF", table "dbo.tblUseOfForce", column 'UOFID'. The statement has
[code].....
I want to insert data into my tables. Table 1 (Recipes1) has a primary key (Autonumber) Table 2 (Ingredients) has a Foreign key with the same name as the primary key in Table2 ("RecipeNumber) this is a normal number field. The problem is that when i update the tables, it does not even make it past table1 , which should be ok.
[Code]...
How to insert multiple data into mssql without using loop?
i'm developing a clinic management system, while doctor may give few medicines to patient,therefore i hope inside my database,the data will look like
[Code].....
this is my 2 tables, i hope when storing data ,the recordID will not increase based on how many ItemID inserted.
I have two tables:
*Transaction Record
*Account Details
Account details table has the field "Account Number" as its primary key.
Transaction record has the field "transaction number" as its primary key and "account number" as its foreign key. This is a table created in ms access. I am creating a program in vb.net to maintain this database.
When i try to find rows using an oledb_data_adapter, an error occurs stating that there are muliple values.
i think this is due to the fact that the records in the transaction details table are being selected by the account number. Many records in the transaction details table can have the same account number.
i need a coding to help me display the most recent 10 transaction records of one account number, one after the other.
P.S: transaction record table also contains "transaction date" field.
It looks like the next version of our application is going to have to be multilingual. People may be using it in Israel, Singapore, Japan, and who knows what other places. Consequently we'll have to change our text in labels, on message boxes, etc. to match the language where the app is installed.I know, or at least I think, that there are features built into the .net framework that can assist with this, but where is a good place to look for documentation or guidance as to what to use and what sort of design considerations to address?
View 2 Repliesmy system is kinda doctor gives prescription and medicine, and store related information into database. The case is when a doctor give few medicines to patient, those information have to store in a "RecordID" with few"ItemID" [Code]. anyone knows how to solve my problem, or any similar sample project can give me to refer? [Code].
View 4 Repliesi am doing a project for my schooli am having difficulties in inserting data in mysqland also inserting multiple data in just a submit button
View 1 RepliesI'm creating a program that uses sql statments to input data into a data base, but I'm having a problem with this error:The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Job_ProductCode". The conflict occurred in database "FabList.mdf", table "dbo.ProductCode", column 'ProductID'. The statement has been terminated.
[Code]...
I am not particular with the database approach of Foreign Key a manner wherein a data related to another data. Table1 > Relations > Table2 How to make a foreign key and how to use that in coding ?
View 9 RepliesI have a header table and a related details table with a one-to-many relationship from master to details.I understand that I will have problems saving details if the master data isn't already there, and I've been working around this. (VS 2008, SQL Express 2008, app is running on XP)
I've been getting around this by checking if there's any detail data on the save click event and warning the user that they need to save the master first before adding details.So the user then removes the detail, clicks save, and then adds the details and clicks save again. Although not good, that's been working OK, but now I need to make the details mandatory. So at the moment they can add a new record, save it and no details.What I would really like to do is to save everything at once. I saw a related post that said I needed to use a transaction, Is that the best approach? Or is there a way to save the master first then the related details all when the save button is pressed?
How do I fetch the loginID and display the student data on the textbox?E.g. I login with loginID of 18 but it only display the data of 12
Private Sub frmLibrary_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'LibraryDataSet.Student' table. You can move, or remove it, as needed.
Me.StudentTableAdapter.Fill(Me.LibraryDataSet.Student)
End Sub
I have master detail form with two datagrids. customer and order detail.I have relationship between customer and order detail on customerid.How do i delete record from order detail when i click delete button to delete record from customer datagrid.Here is the code so far.
Private Sub btndelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btndelete.Click
'Me.CustomerTableAdapter.Fill(Me.CustomerDataSet.Customer)
[code]......
im in the middle of doing sql queries i can search my data base usingGetDateFrom (Select, from, where) Me.nameTableAdapter.FillBy(namenDataSet.descip, Me.box1TextBox.Text,Me.box1TextBox.Text, Me.box2TextBox.Text, Me.box2TextBox.Text)i have this working fine im struggling with inderting data to my databse i have made the query ..
INSERT INTO `details` (`Forename`, `Surname`, `Username`, `Password`)
VALUES (''& ForenameTextBox.Text &'', ''& SunameTextBox.Text &'', ''& UsernameTextBox &'', ''& PasswordTextBox &'')
[code]....
I have run into a problem. When I insert some data into a table with the Insert Function, I want it to return to me Id key.Say a table is like this
ProductId
Product
Quantaty
If I run
Code
Insert Into [table](Product, Quantaty)Values(Cd, 3)
I want it to return to me the value of the ProductId so that I can use it, is this possible?
I am developing vb.net windows application. I am trying to insert data with insert command.I am getting the insert data as long as the application is running. But when i close the application and reopen again the inserted data was not in the access database and i am getting no result. what is the problem, is it in code? i am using like
strsql=" Insert into table(col1,col2) values(val1,val2)"
selectCommand as new oledb.command(strsql,strConn)
selectCommand.ExecuteNonQuery()
Not inserting in the database but showing in application. how?
I have a table for users (username, password .. etc) and another one for products (product name, price, quantity, username .. etc)
I want the username from the first table to be inserted (with the rest of the product info) into the product table when the user put it for sale.
How can I do this?
I'm using visual web developer 2008 express
I am using C# and MSAccess as my database.
Code:private void ExecuteQuery(string strempname,string strQuestion,string IndividualRating,string OverallRating, string Comment1, string Comment2,string Comment3, string SessionName) { string strQuery= string.Empty; try { strQuery = "insert into FeedbackDetails(EmpName,Question,IndividualRating,OverallRating,Comment1,Comment2,Comment3,SessionName)"
[code]....
so this actually opens and close connection for every method. but i need to open and close the connection only one time. so how to customize this code to achieve my need. now i am hitting database for 14 times in a button click as of now. instead i need to hit only once but all the rows has to be inserted in my database.i am using MSAccess as Database.
queryStr = "INSERT INTO tbl_user_ldr_responses (rec_num, ques_no, response, comment) " & _
recnum & ", " & "1, " & "'', " & reader.GetValue(1) & " UNION ALL" & _
recnum & ", " & "2, " & "'" & reader.GetValue(2) & "', " & "''"
How can I fix my string so that it will resemble the below SQL code to insert multiple records with one insert command?
INSERT INTO thetable (field1, field2)
SELECT value1, value2
UNION ALL
[Code]......
I have a listview that can contain up to roughly 2,000 listview items I need to loop through the listview and insert each item into a mysql database
is there a better, bulk way, to insert the data instead of doing an insert for each item like follows:
for each itm ...
insert into whatever ( id ) values ( itm.text ) ...
next
My files are being inserted but the byte array is showing as a 0x0000... etc for every file after the first inserted file. The first inserted image is correct. The database is set up as an Image type. The problem exists in the code here\
Dim uploads As HttpFileCollection
uploads = HttpContext.Current.Request.Files
For i As Integer = 0 To (uploads.Count - 1)
[code].....
How can I insert multiple rows from one table to another. I have query(SELECT which returns multiple rows)from table A and would like to insert all rows (as a result of query) into new tabel B.
View 2 RepliesI have the following code to add a new row into a datatable and then bind it to a gridview.I need to add a new row anytime i click the Button2.What do i need to change in the code so i can have multiple rows before i submit them to a database?
Private Sub BindGrid()
Dim DT As New DataTable
Dim Row As DataRow
[code]....
I have a vb express 2010 program where users submit issues to different persons. The issue is emailed to teh selected persons and also saved in SQL on a server. Question is if they select multiple names from the list box to send the messsage to, how do I insert the multiple names into the SQL table? Here is the insert command I use. It will insert one name but will only do one if multiple names are selected. What am I missing?
[Code]...
I'm working on a program that inputs a text box text into a RichTextBox via a button click. But when I click a button, it over writes the text that is already in the RichTextBox. How can I prevent this?
View 2 Repliesi have a datagrid contol with multiple rows. my database structure and datagridview stucture is same.
now how to insert multiple rows from datagrid to database in vb.net
I am not sure how I would go about this I have a decision matrix that retains values which are boolean.The application receives a spec and rev from the database when the app is called.The questions asked as like " is it a car?" Yes/No etc.After the battery of questions I need to write the responses to an access database
Here is my db persistance class
Imports System.Data.OleDb
Public Class DBPersistance
[code].....