ASP.NET

using System.Data.OleDb;
using System.Data;
using System.Web.Services;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;


[WebService(Namespace = "http://localhost:51557/Week3Lab/clsWebServices.asmx/FindAddress")]
public class clsWebServices : System.Web.Services.WebService {
    
    public clsWebServices () {

        //InitializeComponent();
        
    }
    
       [WebMethod(Description = "This method call will get the LastName and return the Dataset.", EnableSession = false)]  
        public dsAddress FindAddress(string LastName, string Path)
        {
            
            
            string connectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" + Path;
            string commandText = "select * from tblAddressBook where LastName like "+LastName ;


            dsAddress DS = new dsAddress();
            using (var connection = new OleDbConnection(connectionString))
            using (var command = new OleDbCommand(commandText, connection))
            {
               
                var adapter = new OleDbDataAdapter(command);
                adapter.Fill(DS.tblAddressBook);
            }

            // Add your comments here
            return DS;

        }
        
    
    
    
}

protected void btnFindLastName_Click(object sender, EventArgs e)
   {
       lblMessage.Text = "";
       lblMessage.Text = txtFindLastName.Text;
       try
       {
           clsWebServices serviceObj = new clsWebServices();
           dsAddress dsFindLastName = new dsAddress();
           string TempPath = Server.MapPath("~/App_Data/AddressBook.mdb");

           dsFindLastName = serviceObj.FindAddress(txtFindLastName.Text.ToString(), TempPath);

           if (dsFindLastName.tblAddressBook.Rows.Count > 0)
           {
               DataRow r = dsFindLastName.tblAddressBook.Rows[0];
               txtFirstName.Text = r["FirstName"].ToString();
               txtLastName.Text = r["LastName"].ToString();
               txtEmail.Text = r["Email"].ToString();
               txtPhoneNumber.Text = r["PhoneNumber"].ToString();
           }
           else lblMessage.Text = "No records found!";
       }
       catch (Exception ex)
       {
           lblMessage.Text = lblMessage.Text + ex.Message;
       }
   }

<form id="form1" runat="server" action="clsWebServices.asmx/FindAddress" method="post">

System.InvalidOperationException: Missing parameter: LastName. at System.Web.Services.Protocols.ValueCollectionParameterReader.Read(NameValueCollection collection) at System.Web.Services.Protocols.HtmlFormParameterReader.Read(HttpRequest request) at System.Web.Services.Protocols.HttpServerProtocol.ReadParameters() at System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()

WickedFooker wrote:

When I submit the FORM it has this in the submit:

C#

<form id="form1" runat="server" action="clsWebServices.asmx/FindAddress" method="post">

manoj.jsm wrote:

free version of iTextSharp