<%@ Page Language="VB" ContentType="text/html" debug="true" ResponseEncoding="iso-8859-1" %>
<%@ import namespace="system.data" %>
<%@ import namespace="system.data.OleDb" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Veri Tabanı</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script runat="server">
Sub kayit(src As object,E As eventargs)
Dim baglanti As New OleDbConnection
baglanti.connectionstring = "Provider = Microsoft.Jet.OLEDB.4.0;" & "data source=" & server.MapPath("tablo\kayit_listesi.mdb")
baglanti.open
Dim kayit1 AS New OleDbCommand
kayit1.Connection = baglanti
kayit1.CommandText = " insert into kisiler (no,ad,soyad,e-mail) values ('1 ','melike','53','x@c.m')"
Dim adap as New oleDbDataadapter
adap.selectcommand = kayit1
Dim dset as new Dataset
adap.fill(dset,"veriekleme")
data1.datasource = dset
data1.databind()
baglanti.close
End sub
</script>
<body>
<form runat="server">
<asp
ataGrid ID="data1" runat="server"></aspataGrid>
<asp:Button id="btn" Text="Veri Tabani" OnClick="kayit" runat="server"/>
</form>
</body>
</html>
Kırmızı yazan yerde
System.Data.OleDb.OleDbException: INSERT INTO deyiminde sözdizimi hatası veriyor sorunun ne olduğunu bir türlü bulamadım
yardımcı olursanız sevinirim TşkLer ..
<%@ import namespace="system.data" %>
<%@ import namespace="system.data.OleDb" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Veri Tabanı</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script runat="server">
Sub kayit(src As object,E As eventargs)
Dim baglanti As New OleDbConnection
baglanti.connectionstring = "Provider = Microsoft.Jet.OLEDB.4.0;" & "data source=" & server.MapPath("tablo\kayit_listesi.mdb")
baglanti.open
Dim kayit1 AS New OleDbCommand
kayit1.Connection = baglanti
kayit1.CommandText = " insert into kisiler (no,ad,soyad,e-mail) values ('1 ','melike','53','x@c.m')"
Dim adap as New oleDbDataadapter
adap.selectcommand = kayit1
Dim dset as new Dataset
adap.fill(dset,"veriekleme")
data1.datasource = dset
data1.databind()
baglanti.close
End sub
</script>
<body>
<form runat="server">
<asp
ataGrid ID="data1" runat="server"></aspataGrid><asp:Button id="btn" Text="Veri Tabani" OnClick="kayit" runat="server"/>
</form>
</body>
</html>
Kırmızı yazan yerde
System.Data.OleDb.OleDbException: INSERT INTO deyiminde sözdizimi hatası veriyor sorunun ne olduğunu bir türlü bulamadım
yardımcı olursanız sevinirim TşkLer ..
