Employees

 server---


using System.Data.OleDb;
using System.Data;


public DataSet emp(string ename)
        {
            string sql;
            int row;
            OleDbConnection con = new OleDbConnection();
            OleDbCommand cmd = new OleDbCommand();
            OleDbDataAdapter adpt = new OleDbDataAdapter();
            DataSet ds = new DataSet();
            con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\samar\\Documents\\emp.accdb";
            con.Open();
            sql = "select * from Table1 where ename='" + ename + "'";
            adpt = new OleDbDataAdapter(sql, con);
            adpt.Fill(ds, "emp");
            return ds;
        }


client----

using System.Data;

ServiceReference1.WebService1SoapClient obj = new ServiceReference1.WebService1SoapClient();
            DataSet ds = new DataSet();
            ds = obj.emp(TextBox1.Text);

            GridView1.DataSource = ds;
            GridView1.DataMember = "emp";
            GridView1.DataBind();