Movie

 server---

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


public DataSet dislay(string aname)
        {
            string sql;
            OleDbConnection con = new OleDbConnection();
            DataSet ds = new DataSet();
            //establishe connection
            con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\samar\\Documents\\Database7.accdb";
            con.Open();

            sql = "Select * from movie, actor where movie.mno = actor.mno and aname='" + aname + "'";
            OleDbDataAdapter adpt = new OleDbDataAdapter(sql, con);
            adpt.Fill(ds, "res");
            con.Close();    //connection close
            return ds;
        }


client---

using System.Data;

ServiceReference1.WebService1SoapClient obj = new ServiceReference1.WebService1SoapClient();
            string aname = TextBox1.Text;
            DataSet ds1 = new DataSet();

            ds1 = obj.dislay(aname);

            GridView1.DataSource = ds1;
            GridView1.DataMember = "res";
            GridView1.DataBind();