protected void Button1_Click(object sender, EventArgs e)
    {
        localhost.Service ms=new localhost.Service();
        localhost.Users newuser = new localhost.Users(); //יוצר אובייקט יוזרס ע"י גישה לוואבסרביס
        newuser.ID = ms.GetLastUserID();
        newuser.Name = nametxt.Text;
        newuser.Last_Name = lastnametxt.Text;
        newuser.Group = 1;
        newuser.Password = passwordtxt.Text;
        newuser.Phone = phonetxt.Text;
        newuser.Address=addresstxt.Text;
        newuser.City = citytxt.Text;
        
        ms.Insertm(newuser);
        
            ActionLabel.Text = "נרשמת בהצלחה חבר";
    }

using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.OleDb;
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Service : System.Web.Services.WebService
{
    public Service () {
        //Uncomment the following line if using designed components 
        //InitializeComponent(); 
    }
    [WebMethod]
    public DataSet Insertm(Users user)
    {
        string st, my_query;
        DataSet ds = new DataSet();
        int x;
        st = @"provider=Microsoft.jet.oledb.4.0;Data Source = " +
            Server.MapPath("~/Data/db6.mdb");
        OleDbConnection conn = new OleDbConnection();
        conn.ConnectionString = st;
        //my_query = "INSERT INTO friendsclients VALUES(" + user.ID + ",'" + user.Name + "','" + user.Last_Name + "','" + user.Phone + "','" + user.Address + "','" + user.Password + "'," + user.Group + ",'" + user.City + "','USERPIC'";
        OleDbCommand cmmd = new OleDbCommand("INSERT INTO friendsclients VALUES(@idparam,@nameparam,@lastnameparam,@phoneparam,@addressparam,@passwordparam,@groupparam,@cityparam,@picparam" , conn);
        cmmd.Parameters.Add("@idparam", OleDbType.Numeric).Value = user.ID;
        cmmd.Parameters.Add("@nameparam", OleDbType.VarChar).Value = user.Name;
        cmmd.Parameters.Add("@lastnameparam", OleDbType.VarChar).Value = user.Last_Name;
        cmmd.Parameters.Add("@phoneparam", OleDbType.VarChar).Value = user.Phone;
        cmmd.Parameters.Add("@addressparam", OleDbType.VarChar).Value = user.Address;
        cmmd.Parameters.Add("@passwordparam", OleDbType.VarChar).Value = user.Password;
        cmmd.Parameters.Add("@groupparam", OleDbType.Numeric).Value = user.Group;
        cmmd.Parameters.Add("@cityparam", OleDbType.VarChar).Value = user.City;
        cmmd.Parameters.Add("@picparam", OleDbType.VarChar).Value = "newpic";
        conn.Open();
        x = cmmd.ExecuteNonQuery();
        if (x != 0)
        {
            string my_quary2 = "Select * From friendsclients";
            OleDbCommand cmmd2 = new OleDbCommand(my_quary2, conn);
            OleDbDataAdapter da = new OleDbDataAdapter(cmmd2);
            da.Fill(ds);
        }
        conn.Close();
        return (ds);
    }
    [WebMethod]
    public int GetLastUserID()
    {
        DataSet ds = new DataSet();
        string st = @"provider=Microsoft.jet.oledb.4.0;Data Source = " +
          Server.MapPath("~/Data/db6.mdb");
        OleDbConnection conn = new OleDbConnection();
        conn.ConnectionString = st;
        conn.Open();
        string my_quary2 = "Select * From friendsclients";
        OleDbCommand cmmd2 = new OleDbCommand(my_quary2, conn);
        OleDbDataAdapter da = new OleDbDataAdapter(cmmd2);
        da.Fill(ds);
        conn.Close();
        if (ds.Tables[0].Rows.Count != 0)
        {
            return int.Parse(ds.Tables[0].Rows[ds.Tables[0].Rows.Count-1]["friend_id"].ToString())+1;
        }
        else
        {
            return 0;
        }
        
    }
}