using
vb
my problems in insertion the code part display data is working but insetion part reported error
ERROR [42000] [Microsoft][ODBC driver for Oracle][Oracle]ORA-00936: missing expression
my code is
Code:
<%@ import Namespace="System.Data.ODbc" %>
<%@ Import Namespace=" System.Data"%>
<script runat="server">
Sub submit(sender As Object, e As EventArgs)
dim dbconn,sql,dbcomm,dbread
dbconn=New ODbcConnection("dsn=oracle;uid=starter;pwd=starter;")
dbconn.Open()
sql="SELECT * FROM students"
dbcomm=New ODbcCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
customers.DataSource=dbread
customers.DataBind()
dbread.Close()
dim isql,idbread,idbcomm
isql="Insert Into students(id,first_name,last_name,major) values (@fname,@id,@lname,@major)"
idbcomm=new odbccommand(isql,dbconn)
idbcomm.Parameters.Add( "@fname",fname.text)
idbcomm.Parameters.Add( "@id",id.Text)
idbcomm.Parameters.Add( "@lname",lname.Text)
idbcomm.Parameters.Add( "@major",major.Text)
idbcomm.ExecuteNonQuery()
dbconn.Close()
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<th>
Id Number:</th>
<asp:TextBox id="id" runat="server"></asp:TextBox>
<br />
<br />
<th>MaJor:</th>
<asp:TextBox id="major" runat="server"></asp:TextBox>
<br />
<br />
<th>First Name:</th>
<asp:TextBox id="fname" runat="server"></asp:TextBox>
<br />
<br />
<th>Last Name:</th>
<asp:TextBox id="lname" runat="server"></asp:TextBox>
<br />
<br />
<asp:Repeater id="customers" runat="server">
<HeaderTemplate>
<table border="1" width="50%">
<tr bgcolor="#2D80DB">
<td>
ID</td>
<td>
Major</td>
<td>
First Name</td>
<td>
Last Name</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr bgcolor="#C1C8D2">
<td>
<%#Container.DataItem("id")%></td>
<td>
<%#Container.DataItem("major")%></td>
<td>
<%#Container.DataItem("first_name")%>
</td>
<td>
<%#Container.DataItem("last_name")%>
</td>
</tr>
</ItemTemplate>
<alternatingitemtemplate>
<tr bgcolor="#D1D9CC">
<td>
<%#Container.DataItem("id")%></td>
<td>
<%#Container.DataItem("major")%></td>
<td>
<%#Container.DataItem("first_name")%>
</td>
<td>
<%#Container.DataItem("last_name")%>
</td>
</tr>
</alternatingitemtemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
<asp:Button id="Button1" onclick="submit" runat="server" Text="Submit"></asp:Button>
</form>
</body>
</html>
sanjeev
ERROR [42000] [Microsoft][ODBC driver for Oracle][
