Hi
i am using the textbox and button to search for user by UID and if i click on the button then the gridview will show the user information, i just would like to know how i can delete the row.
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<div class="banersboxinsrtUsrSrch">
<asp:TextBox ID="srchuserTxtBox" runat="server"></asp:TextBox>
<asp:Button ID="srchuserbtn"
runat="server" Text="Search" onclick="srchuserbtn_Click" />
<br /><br />
<asp:GridView ID="SrchUsrGrdView" runat="server" Width="600px"
AutoGenerateColumns="False" AlternatingRowStyle-BorderStyle="None"
GridLines="Horizontal" BackColor="White" BorderColor="#CCCCCC"
BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black"
>
<AlternatingRowStyle BorderStyle="None" />
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:ImageButton ID="UsrSrchDeltBtn" runat="server" CommandName="Delete" ImageUrl="~/iconsimg/Delete2.png"
OnClientClick="return confirm('Are you sure you want to Delete this Message?');"
CommandArgument='<%# Eval("UID") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="User ID">
<ItemTemplate>
<asp:Label ID="UsrSrchID" runat="server" Text='<%# Eval("UID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="First Name">
<ItemTemplate>
<asp:Label ID="UsrSrchFN" runat="server" Text='<%# Eval("FN") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Last Name">
<ItemTemplate>
<asp:Label ID="UsrSrchLN" runat="server" Text='<%# Eval("LN") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Country">
<ItemTemplate>
<asp:Label ID="UsrSrchContr" runat="server" Text='<%# Eval("Country") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#CCCC99" ForeColor="Black" />
<HeaderStyle BackColor="#333333" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Right" />
<SelectedRowStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F7F7F7" />
<SortedAscendingHeaderStyle BackColor="#4B4B4B" />
<SortedDescendingCellStyle BackColor="#E5E5E5" />
<SortedDescendingHeaderStyle BackColor="#242121" />
</asp:GridView>
</div>
</ContentTemplate>
</asp:UpdatePanel>
protected void srchuserbtn_Click(object sender, EventArgs e)
{
using (SqlConnection srchuserCON = new SqlConnection(sc))
{
string srchuser = "select * from UserInfo where UID=@search";
SqlCommand srchuserCMD = new SqlCommand(srchuser, srchuserCON);
srchuserCMD.Parameters.Add("@search", SqlDbType.NVarChar).Value = srchuserTxtBox.Text;
srchuserCON.Open();
srchuserCMD.ExecuteNonQuery();
SqlDataAdapter srchuserDAAD = new SqlDataAdapter();
srchuserDAAD.SelectCommand = srchuserCMD;
DataSet srchuserDS = new DataSet();
srchuserDAAD.Fill(srchuserDS, "UID");
SrchUsrGrdView.DataSource = srchuserDS;
SrchUsrGrdView.DataBind();
srchuserCON.Close();
}
}