Interview Question in SQL Server Security
Interview Question :: Please can you help me
please write code asp.net because connection with acsess data base and insert on table in data base
i have data base on acsess name this data base score
and i have table name table1
and contain is two field "name,score"
but if i run this page error on the inser statement error
this code
<script runat="server">
Protected Sub form1_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Dim cnc As New Data.OleDb.OleDbConnection
Dim udl As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\game\score.mdb;Persist Security Info=False"
Dim cmd As New Data.OleDb.OleDbCommand
Dim sql As String = "INSERT INTO table1 (name,score) values "&name&","& a &")"
cmd.CommandText = sql
cnc.ConnectionString = udl
cnc.Open()
cmd.Connection = cnc
Dim DR As Data.OleDb.OleDbDataReader = cmd.ExecuteReader
DR.Close()
End Sub
</script>
Loading ...