I have the following piece of code which retrieves records from an Oracle database and loads it into a datagridview. The problem is that the first record returned by the query is never loaded into the datagridview. I already counted the records (on the commented part of the code) and the DataReaderOracle object counts allways one more record than the ones loaded into the datagridview.
[Code]...
I am leaning VB and have created a basic inventory app for work that consist of 4 tables, CurrentInventory, Surplus, Staff and Category. Each of these tables have a corresponding form. My question is with the CurrentInventory and Surplus form/tables. I want a button on the CurrentInventory Form that when clicked the current record would be transferred to the Surplus table and deleted from the CurrentInventory table.I am assuming that I could somehow use the INSERT command to copy the current record to the surplus table but I am not sure how to accomplish this.
View 5 RepliesI have two tables Products and Categories with a many to many relationship. I am trying to copy the categories linked to one product (OriginalProduct) to another product (newProduct). The problem is when I execute the SaveChanges() method, I not only get the records in my linking table, but it also creates another copy of the categories in the categories table. I've tried this in many ways but here are the last couple that I've attempted:
' Copy Product/Categories
For Each oneProdCategory In OriginalProduct.Categories
Dim relatedCategory = _productContext.GetObjectByKey(New EntityKey ("ProductInfoEntities.Categories", "RecordId", oneProdCategory.RecordId))
[code]....
My database : table1
ID FIRSTNAME AGE
1 Sumit 22
2 Sanjeev 23
i have gridview 1 and textbox1 and button1 i want when pages load the gridview displays the all records from table1 and also ...i i wanna search record for firstname by typing sumit in textbox1 and click on button1 then in gridview the record of sumit will be shown ..by default gridview display alll records from table1 How to do this My Selct Query is below : but it doesnot display all record ...but it can display record if you search for a particular record .
[Code]...
I use This Code To Save Data in Table First I delete record Then Insert record
View 4 RepliesI'm receiving the following error:"You cannot add or change a record because a related record is required in table 'FORN_NIB'."
I cannot understand this error fr the related record really existe on the FORN_NIB table. It is even picked up from there. Here's the code where the error occurs at the .Update instruction:
HTML With rst
.Open("DADOS_RECIBOS", conn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
.AddNew()
.Fields("NUM_FORN").Value = Me.TextBox1.Text
[Code]...
I got an error when I tried to save a deleted record in a table which I use to store username and password.
I can delete with no problems but the error message popped up when I clicked on the update icon
My login code is like this
Imports System.Data.SqlClient
Public Class Form1
Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As
[Code]....
i have some sample code on inserting a record from one table to another new table? Making the record on the first table to be deleted and been transfered to another table ..
View 7 Repliesi don't now where to but my question so if this is the wroung section i am sorry
i am designing a web site with a database using visual studio
and the code i use is visual basic
i use this code to insert in to tabel temp1
MySqlCommand.CommandType = CommandType.Text
MySqlCommand.CommandText =
"Insert into temp1 values(@id_card,@city,@name)"
[Code].....
am having a query regarding updating a table A records from table b on a button click...have created connection sting and commandtext to exexute d query am tryn ds query bt it seems to throw some syntax error
cmd.CommandText =
"UPDATE stockno_table SET(product_id,Sold,Rec_No)
=(SELECT product_id,Sold,Rec_No from stockno_temp_copy
where stockno_temp_copy.stock_no=stockno_table.stock_no) where(exists)(stockno_table.stock_no=stockno_temp_copy.stock_no)"
basically the fields are same bt the stockno_temp_copy is a temporary table which i want to empty always while it updates all the table records to stockno_table...all the records except the Sold which is YES/NO field changes...NB: Access DB is used?
I have two tables (unrelated) and a third table that is related to both the others by their id's. When I add a new record to table 3, I want both these related fields to be filled. I can only get one or the other to work (depending on which I set as the parent) but not both. Is there a way to do this or do I need to have a word with myself?
View 1 RepliesI am trying to add a new record to my database, using the code below; however nothing happens when i try to execute the code.
[Code]...
I am having a trouble on how to update my reocrds on my 2 tables. 1 table is sample and the other table is tbl_educ. my sample table which has a pk of emp_id while the tbl_educ has a field of emp_id they are related by one-many relationship.
sample table tbl_educ
emp_id(pk) emp_id
lname school_name
[code]....
the error that i encounter is emp_id is not a category of the table..how can i add record for my table.
I have an Access 2007 DB With 3 Tables I fill a form with information from 2 of the tables which works fine I then want to add a row to the third table with the information obtained from the form.(I know this may seem like duplicating data but there is a reason for doing this that I can explain if needed) This is where I am having the problem. I have tried several approaches with no success.The following code works fine I get no errors and it even says it added a new record but it does not. when I look at my access table there are no changes.Why can I get info from the DB but not Write back(yes I have the properties set to "update if newer"[code]...
View 2 RepliesI have two different tables (linked 2getha) my search code ' update etc etc working 100% ' i need to know how can i at run time when add rec that specific rec must get added in table 1.
View 1 RepliesAfter Deleted Record, Will Add To Another Table
View 2 Repliesi delete the row ID 3,paper,20 then the qty of paper will add to another table2 total field.how to write the code after delete record will add the qty field to another table2 ?
[Code]...
I have this assignment where I have had to attach a database into a vb file I have now done this bit. But now I need to add a new record into table when VB is running. But I am not sure on how to do it
Here is my code
Private Sub butadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles butadd.Click
Dim myconnection As OleDb.OleDbConnection
Dim strSQL As String
'this is using parameters
strSQL = "INSERT INTO Engineers " & _
" (EngineerNO, Surname , Firstname, Mobileno) "
I have a sql server database file which I have connected to a web service I am writting I have created a table adapter in a datase.t I have created a web method which has parameters for the fields in the database
<web Method> _
function add_record(byval a as integer , byval b as String)
dim ds as dataset
[code]......
I have two rich text boxes, and two buttons on my screen. The first button grabs HTML from a URL and then converts the HTML to XML which resides in rich text box 1.
The second button is to grab the XML from the rich text box1 and then parse it to grab all the input elements by their ID.
My issue is that my parser isn't doing anything. My guess is that I'm not quite getting the XML from the first rich text box.
What would be the best way to grab the XML from a rich text box load it into memory and then parse the XML to grab all the ID tags?
Here is my code --
Imports mshtml
Imports System.Text
Imports System.Net
[Code].....
I have two rich text boxes, and two buttons on my screen. The first button grabs HTML from a URL and then converts the HTML to XML which resides in rich text box 1. The second button is to grab the XML from the rich text box1 and then parse it to grab all the input elements by their ID.
My issue is that my parser isn't doing anything. My guess is that I'm not quite getting the XML from the first rich text box.What would be the best way to grab the XML from a rich text box load it into memory and then parse the XML to grab all the ID tags?
[Code]...
I currentt have three tables, using a table adapters and datagridviews I would like to add a new record to each table. the only problem is that the primary key from table 1 is a foreign key in table 2 and 3. Is there a way to add a new record in the table adapter without sending it to the DB and get a predicted primary key so I could put this as the foreign key in tables 2 and 3.
View 8 RepliesI've been trying for hours to do this and can't figure it out.. I'm trying to add a new record to a table in my local database.. Heres the SQL code im using at the minute.. I keep getting this error
"The data was truncated while converting from one data type to another. [ Name of function(if known) = ]" on the line
SQLCom.ExecuteNonQuery() Dim SQLCon As New SqlServerCe.SqlCeConnection
Dim SQLCom As New SqlServerCe.SqlCeCommand
[code]....
im trying to add data to an ms access table that I have created elsewhere in the app. The code I am using is below but I keep getting an error message (Update requires a valid InsertCommand when passed DataRow collection with new rows.)
con.Open()
sql = "SELECT * FROM attachment"
da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "Attachment")
[code]....
Does anyone know how to delete the record then the deleted record will add to another table.let said i want to delete record from table1 ID '3', description 'monitor', Qty '2'after deleted the Qty, will auto add 2 to the Table2 Total field.[code]
View 1 RepliesIhave created a system that allows an IT manager to log faults and assign them to available technicians, basically, you select a member of staff, a technician and describe the fault and then log it. But what I want to be able to do is take the technician out of the table until the fault is cleared and the technician is free. I have started this process but my head is spinning and I am not 100% where to turn next. I currently have a Busy field in the technician table and I have the code that allows the technician's busy status to change to 0 instead of 1 but I cannot for some reason get it to turn back to 1 when I clear the fault.
I think I may need some sort of If then statement like
If datagridview2.currentrow.cells(4) = 0
Then datagridview2.currentrow.remove
I've been using a FileSystemWatcher to detect changes and this is the code that changes the technicians busy status to 0:
Dim BusyM1 As String
BusyM1 = DataGridView2.CurrentRow.Cells(4).Value
sql = "update Technicians set busy=1 where busy='" & BusyM1 & "'"
Dim commandUpdate As New OdbcCommand(sql)
[Code] .....
And here is a code I tried to use to return the status back to 1 for the technician busy status
Dim NotBusy As String
NotBusy = DataGridView2.CurrentRow.Cells(4).Value
sql = "update Technicians set busy=0 where busy='" & NotBusy & "'"
Dim commandUpdate As New OdbcCommand(sql)
[Code] .....
I need the begintransaction function to add 3 record into 3 table.
Insert Rcd1 to Table 1
Insert Rcd2 to Table 2
Insert Rcd3 to Table 3
if all these 3 record successful, will commit the transaction else
either one of record fail, will auto rollback transaction
[Code]...
I want to retrive data from table into combobox ..when the user click combobox items it's corresponding data will be show.In details :I have PERSON table , my program allow to the user search by : Person Name When the user enters the name into TextBox the combobox items will be all names existed in database same which user entered. when the user selects item from combobox a new form will show all person' data
[Code]...
I have a tenant details form that has a field called TenantID, I also have a Lease table that also has a TenantID field, what I want to do is click the lease button, check to see if the lease already exists, if it does open the lease form to that record. If not then open the lease form to a New record so the user can enter all the information for that lease.
I am trying to use the below code but am having a little trouble understanding how it all works. What needs to be declared, what doesnt
HTML
Private Sub btnLease_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLease.Click
Dim fm2 As New LeaseDetails
[Code].....
I would like to know if its possible to discard changes of only one record of only one table in datacontext. I use databind to bind my controls on a form. I modify one record at a time. after the modification, the user have to hit save button to validate. But he can hit cancel. I would like that the cancel button discard all the changes that the user has done. Is it possible?
View 3 Replies