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
I have two listview in a separate form, basically what i want to do is whenever I select a row in my first listview the items in that selected row will be copied in my second listview which is empty.
View 5 RepliesHow 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'm attempting to insert rows form a ListView into an access DB. Here is the code from the Finish button. From line 55 down is my trouble area.
[Code]...
i 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 want to insert records from a datagrid with multiple rows, into the database, is it possible?
View 1 RepliesI am using datarepeater on my windows form to populate records from a temp table. I want to write query to insert records for an employee in a single row rather than multiple rows. For example: I am displaying records of one month only. so i know the definite number of columns. Normally if we use select * from Temp ' it will display and i can populate in a datagrid.
[Code]...
I have a Windows application form. Directly on the form I have a lable ("Customer Names"), a ComboBox (pulling actually names from a database) , and a Buton to add a customer to the database if i choose. Additionally I have ControlTab(3 tabs) that has "fields" and its own Buttons to insert data into a different table. The first 2 tabs have textBoxes, which are completely functional, but the 3rd tab has a "DataGridView"
[Code]....
right now i'm trying to google some related article about LINQ to better understand it. But I came across with this issue been googling to find some answer but I didn't get lucky so here my problem.
For Each lvItem As ListViewItem In lv_orderlist.Items
passSQL = "INSERT INTO t_selling_history (f_product_id_fk, f_qty, f_qty, f_user_id_fk, f_created_dt, f_trans_status)" _
[code].....
I am working on Treeview control and Gridview Control VB.NET08. In the Treeview i have Parent and Child Nodes. Like:
- 31
3101
3102
[Code].....
I am looking for a howto or someone expert in ADO.NET who can explain me how to properly solve the following scenario:I have two datatables in a dataset:
ParentTable (ParentID, Name) for user data ChildTable (ParentID, ActivityID, ...) for schedule data
Tables are linked together at the database level by ParentID which is an Identity column in ParentTable.
Both tables are data bound to a separate DataGridView on the GUI. There supposed to be a "1 parent/N children" relationship between the tables, meaning if I create a new entry in the ParentTable (a new user) I get a clean DataGrid in the child grid to type schedule data for the user. So I setup two DataAdapters for each table to fill their result into a DataSet. I also set up a DataRelation object and assign it to the DataSet to link the two tables by their ParentID columns. Also when I add a row into the ChildTable via DataGrid I use SetParentRow to set the parent row.
[Code]...
I have a vb.net web application and when a particular function runs , i get data timeouts in the rest of the application..(ie..row not found errors or column does not belong to table but it does) The function is adding multiple rows in multiple tables in the database and is running in a for loop. It seems to be all SQL related but I am not seeing anything in the error logs in SQL or in the application Right now I am assuming it is memory related where to start note..the for loop will be replaced with a bulk insert but right now I jest need to resolve the issue of the timeouts
View 1 Repliesvisual basic 2008 express
access 2007 db
I am attempting to fill a form with multiple rows from an access table based off of a parameterized query. My query works fine but I don't want to return one row at a time, I want to return all rows that match my query in multiple text boxes. I know that I can use a datagrid view to accomplish this, but I would prefer the look of a textboxes on a form. I have read through many books and searched the internet forums but think I may just not know what to search for as nothing has worked yet. Can anyone point me in the right direction. So far I have tried setting the text box value to the row().item(), creating a different dataset for each row, and even setting variables for the results of the query to then be passed to the text boxes. Since none of this work, I don't really have any starting code to post. If I could just get a starting point I could work from there, so don't feel the need to code anything for me, just set me in the right direction.
i 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]...
Load from database to datagridview
Call ConnectAccess()
Dim da As OleDbDataAdapter = New OleDbDataAdapter("SELECT ProductName,Quantity,UnitPrice,Extention, InvNomer,ProductId, InvDetId " _
+ " FROM InvoiceDetail where InvNomer ='" & pbInvNomer & "' ", mConn)
[Code]...
I have a dgv and I want to insert rows in this dgv, the position is depending on the selected row. The cells in the new rows are populated from a database.
I have this code:
Dim
ind As
Integer
[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'm creating a Datagridview for user input. When the Datagridview shows on screen, the user can open a ContextMenuStrip that includes Copy, Cut, Insert, Delete, .[code]...
View 6 RepliesHow to insert more than one rows of data to Access??
All my textboxes are created during runtime and I want to add the text in textboxes to database. some times i want 3 rows and some times maybe 10 rows This is the code to create textboxes.
For Me.count = count To number
Dim label1 = New Label
With label1
[Code].....
I have a datagridview that is filled in this way:
Dim da As New OleDb.OleDbDataAdapter
da.SelectCommand = New OleDb.OleDbCommand("Select * from propietarios order by pnombre", cnmain)
[Code].....
If I insert new rows into the DataGridView, how can I make these changes are reflected in the table in the database?
Some example code to insert rows of datagridview into a sql express database table? Also, how do I manage concurrency as it is a multi user application.
View 5 RepliesI am trying to write code to insert selected rows from Table1 to Table2 ,, so i find code do that with DataGradView and i try to Modifies it to work with Multi records " Without DataGradView"[code]...
View 5 RepliesI have a question similar to this one, but reading the (accepted) answer didn't give me much insight, so I'm hoping to state it more clearly and get a clearer response back.
I'm attempting to insert a data row into a table. I'm using TableAdapter's custom "insert nonQuery" that I wrote (it works, I tested) to accept some parameters. I'm fairly new to this business of communication with a database via .NET and what I'm doing is probably wrong by design. My questions are why is it wrong and what's the right way to do it? Both are equally important, IMO.[code]...
I'm using the TableAdapter to Insert rows into a database, when I use execute from the Query Builder, the line gets entered into the database, when I enter it via Form button, it doesn't get entered to the database using the same commands.
[code]...
I'm creating my first software but I have a problem: I have two tables in my database and I managed to transfer data from table1 to table2. How can I just insert specific rows from table1 to table2. I don't want to copy all the data in table1 to table2; I just want to copy the selected rows.
Here's my code:[code...]
I have a listbox which has a sourcebinding which is borrow and I only want the selected items single row to be transferred to my table returns but I don't know how to do it. Whenever I click the button, everything in table borrow will be copied to table returns.
I have a word document with multiple tables. How can I specify in VB.NET to find a specific table and insert rows only into that one? I've successfully implemented the Find&Replace in the document... but the problem is that I have an unknown number of things that must be added into the table based on the data I'm querying from my database. So there is no simple solution as far as putting placeholders in the table and using the find and replace function.
View 1 RepliesI would like to insert, delete and add rows in tablelayoutpanel1. On my right I have numericupdown1. So, when I chose let say number 5 and then click button1, I would like that in my tablelayoutpanel1 VB add or insert row 5. Same thing with button2 - but this button deletes selected row.[code]...
View 2 RepliesI have a datagridview with a column checkbox, now my problem is how can i insert those checked checkbox into my table in sql database???
and one more thing,how can i remove the addnew thing at the last row of my datagridview? because it represents null..
i am trying to write code to insert selected rows from Table1 to Table2 ,, so i find code do that with DataGradView and i try to Modifies it to work with Multi records " Without DataGradView"
Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UsersDellXPSDesktopDBtest.accdb"
Using connection As New OleDbConnection(connectionString)
[Code].....