i want to fetch data from sql server 2008 using webservices via asp.net by providing some parameters to web services method?

See more:

ASP.NET

service

web

Hi,

i'm trying to fetch data from sql server using web services parameterized method in ASP.NET

BUT unfortunately i'm not getting this...

i want to know how to pass the parameters to web services method from/in ASP.NET


I M USING STORED PROCEDURES TO DO SO...


MYCODE:

_____________________
WEB SERVICES METHOD
_____________________

[WebMethod(Description="SQL CONNECTION")]
 
public XmlElement SQL_Conn(int select)
{


conn.Open();
SqlCommand cmd = new SqlCommand("sp_select", conn);
cmd.CommandType = CommandType.StoredProcedure;
 
cmd.Parameters.AddWithValue("@select", select);
 
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
// Create an instance of DataSet.
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
 

// Return the DataSet as an XmlElement.
XmlDataDocument xmldata = new XmlDataDocument(ds);
XmlElement xmlElement = xmldata.DocumentElement;
return xmlElement;

}

ASP.NET CODE
_____________

protected void btngnrt_Click(object sender, EventArgs e)
{

Service objUserDetails = new Service();

DataSet dsresult = new DataSet();
XmlElement exelement = objUserDetails.SQL_Conn();// method overload error
if (exelement != null)
{
XmlNodeReader nodereader = new XmlNodeReader(exelement);
dsresult.ReadXml(nodereader, XmlReadMode.Auto);
gdv_webservice.DataSource = dsresult;
gdv_webservice.DataBind();
}
else
{
gdv_webservice.DataSource = null;
gdv_webservice.DataBind();
}
}