[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; }
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(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)