Book

 Server

using System.Data;
using System.Data.OleDb;
 public DataSet book(string bookname)
        {
            string sql;
            OleDbConnection con = new OleDbConnection();
            DataSet ds = new DataSet();
            con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\ASUS\\Documents\\Database6.accdb";
            con.Open();
            sql = "select * from book where bookname = '" + bookname + "'";
            OleDbDataAdapter adpt = new OleDbDataAdapter(sql, con);
            adpt.Fill(ds, "res");
            con.Close();
            return ds;
        }


Client

using System.Data;

protected void Button1_Click(object sender, EventArgs e)
        {
            ServiceReference1.WebService1SoapClient obj = new ServiceReference1.WebService1SoapClient();
            string bookname = TextBox1.Text;
            DataSet ds1 = new DataSet();
            ds1 = obj.book(bookname);
            GridView1.DataSource = ds1;
            GridView1.DataMember = "res";
            GridView1.DataBind();
        }


database--

table- book

bookid
bookname