User-12021981 posted
So im kinda stuck i have to use a web service in asp to get, read , import data that u enter into a textbox to a Microsoft Access database, the code for the web service is as follows.This is only to add a new record i still have to find out how u read but
this doesn't work.
Please help if u can.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Text;
using System.Data.OleDb;
public partial class SubmitBook : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void submitbookbtn_Click(object sender, EventArgs e)
{
usedatabase useDb = new usedatabase(Request.PhysicalApplicationPath +
"App_Code\\Bookwebsite.mdb");
string Email = emailregTextbox.Text;
string Password = passregTextbox.Text;
string UserName = usernamelblreg.Text;
string Surname = SurnameRegTextbox.Text;
string Age = AgeRegTextbox.Text;
{
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\user-pc\source\repos\BookWebsite\BookWebsite\App_Code\Bookwebsite.mdb");
OleDbCommand cmmd = new OleDbCommand("INSERT INTO BookUsers ([Email], [Password], [UserName] , [Surname], [Age]) VALUES (@Email, @Password, @UserName, @Surname, @Age)", conn);
cmmd.Parameters.Add("@Email", OleDbType.VarChar).Value = Email ;
cmmd.Parameters.Add("@Password", OleDbType.VarChar).Value = Password;
cmmd.Parameters.Add("@UserName", OleDbType.VarChar).Value = UserName;
cmmd.Parameters.Add("@Surname", OleDbType.VarChar).Value = Surname;
cmmd.Parameters.Add("@Age", OleDbType.VarChar).Value = Age;
conn.Open();
cmmd.ExecuteNonQuery();
conn.Close();
}
}
