how to select the particular record?
hi i am doing search window .here i am using callback method . depending upon what ever value we entering in
text box i getting value at keyup evevnt and fetching record and showing that record in gridview.
now my question is how to select the particular record from gridview . for this i given
grvProducts.AutoGenerateSelectButton = true , that select button is coming but link is not there
Mycode :
aspx :
<table width ="50%" >
<tr>
<td><b>Search On</b></td><td align ="left" >
<asp:DropDownList ID="drp_customer" runat="server">
<asp:ListItem Value="c_code">Code</asp:ListItem>
<asp:ListItem Value="c_name">Name</asp:ListItem>
<asp:ListItem Value="c_add1">Add1</asp:ListItem>
<asp:ListItem Value="c_add2">Add2</asp:ListItem>
<asp:ListItem Value="c_add3">Add3</asp:ListItem>
<asp:ListItem Value="c_city">City</asp:ListItem>
<asp:ListItem Value="c_area_code">Areacode</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td><b>Enter the Text</b></td><td align ="left">
<asp:TextBox ID="TextBox1" runat="server" onkeyup ="CallSrv(this);"></asp:TextBox></td></tr>
<tr>
<td colspan = "2">
<div id="grvProducts"> </div>
</td></tr></table>
Aspx.cs:
string RenderedOutput;
protected void Page_Load(object sender, EventArgs e)
{
ClientScriptManager scriptMgr = Page.ClientScript;
String cbReference = scriptMgr.GetCallbackEventReference(this, "arg","ReceiveServerData", "");
String callbackScript = "function CallServer(arg, context) {" + cbReference + "; }";
scriptMgr.RegisterClientScriptBlock(this.GetType() , "CallServer", callbackScript, true);
}
public void RaiseCallbackEvent(string eventArgument)
{
string[] commands = eventArgument.Split(",".ToCharArray());
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM customer where " + commands[0] + " like '" + commands [1] + "%' ", "SERVER=(local);DATABASE=ramag;TRUSTED_CONNECTION= true;");
DataTable table = new DataTable();
adapter.Fill(table);
GridView grvProducts = new GridView();
grvProducts.AutoGenerateSelectButton = true;
grvProducts.DataSource = table ;
grvProducts.DataBind();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter(sb);
HtmlTextWriter htw = new HtmlTextWriter(sw);
grvProducts.RenderControl(htw);
this.RenderedOutput = sb.ToString();
}
public string GetCallbackResult()
{
return RenderedOutput;
}
|