Ado.net Problem...
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
sub Add(Source As Object, e As EventArgs)
dim sql as string
sql="insert into info values(@n,@a,@t,@e)"
dim insCom as new OleDbCommand(sql,OleDbConnection1)
OleDbDataAdapter1.InsertCommand=InsCom
OleDbDataAdapter1.Insercommand.Parameters.Add(new OleDbParameter("@n",oledbType.Char,30))
OleDbDataAdapter1.Insercommand.Parameters("@n").Va lue=TextBox1.text
OleDbConnection1.open()
OleDbDataAdapter1.InsertCommand.ExecuteNonQuery()
OleDbConnection1.Close()
end sub
</script>
This is the code which is giving me an error like..
----------------------------------------------------------
Compiler Error Message: BC30451: Name 'OleDbConnection1' is not declared.
http://localhost/Web_dev/Databse_Conne/Info_Add.aspx(7) : error BC30451: Name 'OleDbConnection1' is not declared.
dim Com as new OleDbCommand(sql,OleDbConnection1)
~~~~~~~~~~~~~~~~
http://localhost/Web_dev/Databse_Conne/Info_Add.aspx(8) : error BC30451: Name 'OleDbDataAdapter1' is not declared.
OleDbDataAdapter1.InsertCommand=Com
~~~~~~~~~~~~~~~~~
http://localhost/Web_dev/Databse_Conne/Info_Add.aspx(9) : error BC30451: Name 'OleDbDataAdapter1' is not declared.
OleDbDataAdapter1.Insercommand.Parameters.Add(new OleDbParameter("@n",oledbType.Char,30))
~~~~~~~~~~~~~~~~~
http://localhost/Web_dev/Databse_Conne/Info_Add.aspx(10) : error BC30451: Name 'OleDbDataAdapter1' is not declared.
OleDbDataAdapter1.Insercommand.Parameters("@n").Va lue=TextBox1.text
~~~~~~~~~~~~~~~~~
http://localhost/Web_dev/Databse_Conne/Info_Add.aspx(11) : error BC30451: Name 'OleDbConnection1' is not declared.
OleDbConnection1.open()
~~~~~~~~~~~~~~~~
http://localhost/Web_dev/Databse_Conne/Info_Add.aspx(12) : error BC30451: Name 'OleDbDataAdapter1' is not declared.
OleDbDataAdapter1.InsertCommand.ExecuteNonQuery()
~~~~~~~~~~~~~~~~~
http://localhost/Web_dev/Databse_Conne/Info_Add.aspx(13) : error BC30451: Name 'OleDbConnection1' is not declared.
OleDbConnection1.Close()
~~~~~~~~~~~~~~~~~
Any ANswres Pls...
Thanx!!
|
