Here is my code--
<asp:AccessData Source ID="AccessDataS ource1" DataFile="Datab ase/thecliniq.mdb" SelectCommand=" Select * from tempr" runat="server"> </asp:AccessDataS ource>
<asp:GridView ID="GridView1" DataSourceID="A ccessDataSource 1" AutoGenerateCol umns="false" DataKeyNames ="id" runat="server" HorizontalAlign ="Left" Height="1px" Width="407px" EnableViewState ="False">
<Columns>
<asp:TemplateFi eld>
<HeaderTemplate >
<asp:CheckBox ID="CheckAll" onclick="return check_uncheck (this );" runat="server" />
</HeaderTemplate>
<ItemTemplate >
<asp:Label ID="lbl7" Visible="false" Text='<%# DataBinder.Eval (Container.Data Item, "id") %>' runat="server" />
<asp:CheckBox ID="deleteRec" runat="server" />
<asp:Label ID="addsymptoms " Visible="false" Text='<%# DataBinder.Eval (Container.Data Item, "additionalsymp toms") %>' runat="server"> </asp:Label>
</ItemTemplate>
</asp:TemplateFie ld>
<asp:BoundFie ld DataField="addi tionalsymptoms" HeaderText="Add itional Symtoms" />
<asp:TemplateFi eld HeaderText="sel ect">
<ItemTemplate >
<asp:DropDownLi st ID="DropDownLis t3" DataSource='<%# GetCategoryDesc riptions() %>' DataTextField=" nam" DataValueField= "nam" runat="server">
</asp:DropDownLis t>
</ItemTemplate>
</asp:TemplateFie ld>
</Columns>
<FooterStyle BackColor="Whit e" ForeColor="#000 066" />
<RowStyle ForeColor="#000 066" HorizontalAlign ="Center" />
<SelectedRowSty le BackColor="#669 999" Font-Bold="True" ForeColor="Whit e" />
<PagerStyle BackColor="Whit e" ForeColor="#000 066" HorizontalAlign ="Left" />
<HeaderStyle BackColor="#006 699" Font-Bold="True" ForeColor="Whit e" Width="9555px" HorizontalAlign ="Center" />
</asp:GridView>
this is a code inside click event of delete button--
protected void Delete_Click(ob ject sender, EventArgs e)
{
string gvIDs = "";
bool chkBox = false;
foreach (GridViewRow gv in GridView1.Rows)
{
CheckBox deleteChkBxItem = (CheckBox)gv.Fi ndControl("dele teRec");
if (deleteChkBxIte m.Checked)
{
chkBox = true;
gvIDs = gvIDs + ((Label)gv.Find Control("lbl7") ).Text.ToString () + ",";
}
}
string strConn = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" + Server.MapPath( "Database/thecliniq.mdb") + ";";
OleDbConnection conn = new OleDbConnection (strConn);
conn.Open();
if (chkBox)
{
Response.Write( gvIDs.Substring (0, gvIDs.LastIndex Of(",")));
string deleteOleDb = "DELETE from tempr WHERE id IN (" + gvIDs.Substring (0, gvIDs.LastIndex Of(",")) + ")";
OleDbCommand cmd = new OleDbCommand(de leteOleDb, conn);
cmd.ExecuteNonQ uery();
}
GridView1.DataB ind();
conn.Close();
}
29
