开发者

To SQL Database record error

I want to record from listbox with the following code into a sql database.But,it's gives me error.Here is my code.I show error line the following code.

Public Class Form1

Dim baglanti As New SqlClient.SqlConnection("Data Source=localhost\SQLEXPRESS;Initial Catalog=dedektor;Per开发者_运维百科sist Security Info=True;User ID=test;Password=test1")
Dim adaptor As SqlClient.SqlDataAdapter
Dim kayit As New DataSet
Dim datakayit As DataRow

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

    Dim a As Integer
    For a = TextBox1.Text To TextBox2.Text
        ListBox1.Items.Add(a)
    Next

      Error line -->  adaptor = New SqlClient.SqlDataAdapter("INSERT INTO Table_2([po])VALUES('" + ListBox1.Items.Add(a) + "') ", baglanti)
        adaptor.Fill(kayit, "table_2")

   End Sub

Thanks,


Here is the quick Recap.

    Dim sqlquery As String = ""INSERT INTO Table_2([po])VALUES(@po)" //sql string
    Dim cmd As SqlClient.SqlCommand = New SqlClient.SqlCommand(sqlquery, con) //Insert             

    Dim a As Integer
    For a = TextBox1.Text To TextBox2.Text   

    cmd.Parameters.AddwithValue("@po",ListBox1.Items.Add(a)) //use parameters to avoid sql injection
    cmd.ExecuteNonQuery() //execute insert Command

    Next
        //You must call another query to populate your DataSet
        adaptor.Fill(kayit, "table_2")

Regards

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜