How to select values from one table and insert into another table VB.NET

Question

0.00/5 (No votes)

See more:

syntax error, Incorrect syntax near 'SELECT'

Table Name abc
Feilds:
col DataType

Date Datetime
a navarchar(max)

What I have tried:

This is my code. Please do needfull


 Dim regDate As Date = Date.Now
        Dim strDate As String = regDate.ToString("MM/dd/yyyy")
        sqlconn = New SqlConnection(str)
        sqlconn.Open()
        Try
            cmd = New SqlCommand("INSERT INTO abc (Date,a) values('" & regDate.ToString("MM/dd/yyyy") & "',SELECT sum(StockValue) from StockValue)", sqlconn)
            cmd.ExecuteNonQuery()
            MsgBox("Your Data Saved Succesfully")


        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try
        sqlconn.Close()

Posted 29-Jul-18 18:13pm

Member 13313252

Updated 29-Jul-18 19:12pm

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bryian Tan · Answer 1 · 2018-07-29T19:13:00

Solution 1

Based on the posted code, I think the SELECT ... approach is more appropriate since the application is expecting a value from the table. See below.

VB

cmd = New SqlCommand("INSERT INTO abc (Date,a) SELECT '" & regDate.ToString("MM/dd/yyyy") & "', sum(StockValue) from StockValue", sqlconn)

The posted code might not subject to SQL injection, but you should try using parameterized query SqlCommand.Parameters Property (System.Data.SqlClient)[^]

Posted 29-Jul-18 19:13pm

Bryian Tan

Comments

Member 13313252 31-Jul-18 2:17am

Sir But Date is not in StockValue Table. I want do Save System Date and a from StockValue Table

Bryian Tan 31-Jul-18 9:58am

have you try the query?the date was being passed into the query not pulling out from the table.

How to select values from one table and insert into another table VB.NET

1 solution

Solution 1

Add your solution here

Preview 0

How to select values from one table and insert into another table VB.NET

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us