-----------------------------------------------------------

New Message on BDOTNET

-----------------------------------------------------------
From: true-developer
Message 1 in Discussion

I am trying to insert data in a assess Database table using ASP.net,  but code is 
doing nothing. No error message but complete failure in insertion. Here is code   <%@ 
Page Language="vb" Debug="true" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
 sub Page_Load
 
  dim dbconn,sql,dbcomm
  dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & 
server.mappath("DB\dbTest.mdb"))
  dbconn.Open()
  
  sql= "INSERT INTO tblEmployees(EmailName, FirstName, HomePhone, LastName, 
MiddleName) " & _
 "VALUES ('[EMAIL PROTECTED]', 'Test', 'Test', '123456', '-')"   
  dbcomm = New OleDbCommand(sql,dbconn)
  
  dbcomm.ExecuteNonQuery()
  
  dbconn.Close()
 end sub
</script>

-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the "Remove" link below. On the pre-addressed 
e-mail message that opens, simply click "Send". Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]

Reply via email to