Hello all . I have WebMethod in WebServis.asmx file in my project . Also i have asp.net page where i have textboxes where i input parameters for Query that will be datasource for Gridview .
I want to bind datasource to Gridview from WebMethod .
Can I make this or i need to use SqlDataReader to export data from my Query ?
I need something like this :
mkTabl.DataSource = SqlDataSource1;
mkTabl.DataBind();
Webmethod
[System.Web.Services.WebMethod]
public void CheckCat(string fam, string im , string ot )
{
SqlDataSource SqlDataSource1 = new SqlDataSource();
SqlDataSource1.ID = "SqlDataSource1";
SqlDataSource1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlDataSource1.SelectCommand = "SELECT id , org, code FROM Tabl where (@fam like Tabl.FAM ) or (@im like Tabl.IM) or ( @ot like Tabl.OT) " ;
SqlDataSource1.SelectParameters.Add("@fam", fam);
SqlDataSource1.SelectParameters.Add("@im", im);
SqlDataSource1.SelectParameters.Add("@ot", ot);
<asp:TextBox ID="FamBox" runat="server" MaxLength="10" />
<asp:TextBox ID="ImBox" runat="server" MaxLength="10" />
<asp:TextBox ID="OtBox" runat="server" MaxLength="14" />
<asp:GridView ID="mkTabl" Visible="true" CssClass="ts1" runat="server" AutoGenerateColumns="False" PageSize="5" AllowPaging="True" AutoPostBack="True" >
</asp:GridView>