using system.Data;
using System.Data.SqlClient ;
[WebMethod]
public DataSet GetEmpData()
{
sqlconnection con=new sqlconnection("Data Source=serverName;User Id=id;password=password;Initial Catalog=DataBaseName");
sqlDataAdapter da=new sqlDataAdapter("select * from Emp",con);
DataSet ds=new DataSet();
da.Fill(ds,"a");
return ds;
}