Code:
UPDATE stockno_table inner join stockno_temp_copy on stockno_table.stock_no = stockno_temp_copy.stock_no set stockno_table.Sold = stockno_temp_copy.Sold
Mdoc
murtazadoc
Last Activity: Nov 5 '10, 01:46 PM
Joined: Aug 4 '10
Location:
-
anyways I found the solution for the above...
this is for those having similar probs...
Mdoc -
Update one table with another table record
Hy...
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
...Code: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)
-
wud ye mind elaborating it a bit more with context to my query...?
Cause hv been tring arnd lately bt havent found ny soln till yet...
have simplified d code
...Code:SELECT r.Proposed_Position, r.Firm_Name, r.Resume_Name, r.Dt_Birth, r.Country_Work, r.Profession, r.Years_Group, r.Nationality, r.It_Skills, r.Details_Task_Assignd, r.Staff_Member, r.Authorised_Rep, ed.Institution, ed.Years_Edu, ed.Edu_Description, em.From_Dt, em.To_Dt,
Leave a comment:
-
Although I didn't got your exact query, I think this is what you are looking for...
You can try adding a row in ds manner to a dataset
...Code:conn.Open() cmd.CommandText = "SELECT * FROM tablename where 1=2" cmd.ExecuteNonQuery() da.SelectCommand = cmd da.Fill(ds) Dim addRow As DataRow = ds.Tables(0).NewRow addRow("rowname") = txtName.Text ds.Tables(0).Rows.Add(addRow)Last edited by Frinavale; Aug 10 '10, 02:45 PM. Reason: Please post code in [code] ... [/code] tags. Added code tags. Please do not use SMS speak: Use proper English when replying.Leave a comment:
-
How to remove duplication of data in subreport
Hi...
Am developing a resume data retrieving software where data is stored in one parent table and 4 child tables as such:
Resume_table ----> Parent table
holds ----> Res_ID, Emp_ID, Lang_ID, Task_ID & some other static data
Employee_Table--->which is referenced directly to Resume_Table.Em p_ID
similarly ol other 3 tables are referenced to the main parent table
...
No activity results to display
Leave a comment: