Insert :) I Have Different Insert Code Lines (2 Insert Codelines) Which One Best ?

hello friends

my one insert code lines is below :) what does int32 mean ? AND WHAT IS DIFFERENT BETWEEN ONE CODE LINES AND SECOND CODE LINES :)Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)

Dim cmd As New SqlCommand("Insert into table1 (UserId) VALUES (@UserId)", conn)

'you should use sproc instead

cmd.Parameters.AddWithValue("@UserId", textbox1.text)

'your value

Try

conn.Open()Dim rows As Int32 = cmd.ExecuteNonQuery()

conn.Close()Trace.Write(String.Format("You have {0} rows inserted successfully!", rows.ToString()))

Catch sex As SqlExceptionThrow sex

Finally

If conn.State <> Data.ConnectionState.Closed Then

conn.Close()

End If

End Try

MY SECOND INSERT CODE LINES IS BELOWDim SglDataSource2, yeni As New SqlDataSource()

SglDataSource2.ConnectionString = ConfigurationManager.ConnectionStrings("ConnectionString").ToString

SglDataSource2.InsertCommandType = SqlDataSourceCommandType.Text

SglDataSource2.InsertCommand = "INSERT INTO urunlistesi2 (kategori1) VALUES (@kategori1)"

SglDataSource2.InsertParameters.Add("kategori1", kategoril1.Text)Dim rowsaffected As Integer = 0

Try

rowsaffected = SglDataSource2.Insert()Catch ex As Exception

Server.Transfer("yardim.aspx")

Finally

SglDataSource2 = Nothing

End Try

If rowsaffected <> 1 ThenServer.Transfer("yardim.aspx")

ElseServer.Transfer("urunsat.aspx")

End If

 

 

cheers