Problem in loading gridview after deletion using asp.net(C#)

[Prabhua]

Hi,
can anybody clear my doubt in asp.net using c#.
i am deleting record in database using gridview control. the problem here is that record gets deleted in database but the changes is not reflected in the gridview control.i also used "gridview1.Databind()" after delete query. what should i do now?
regards,
a.prabhu

[dip_developer]

Hi,
can anybody clear my doubt in asp.net using c#.
i am deleting record in database using gridview control. the problem here is that record gets deleted in database but the changes is not reflected in the gridview control.i also used "gridview1.Databind()" after delete query. what should i do now?
regards,
a.prabhu

Please post your code snippet.....

[Prabhua]

Here is my code--

<asp:AccessDataSource ID="AccessDataSource1" DataFile="Database/thecliniq.mdb" SelectCommand="Select * from tempr" runat="server"> </asp:AccessDataSource>

<asp:GridView ID="GridView1" DataSourceID="AccessDataSource1" AutoGenerateColumns="false" DataKeyNames ="id" runat="server" HorizontalAlign="Left" Height="1px" Width="407px" EnableViewState="False">

<Columns>

<asp:TemplateField>
<HeaderTemplate>
<asp:CheckBox ID="CheckAll" onclick="return check_uncheck (this );" runat="server" />
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="lbl7" Visible="false" Text='<%# DataBinder.Eval (Container.DataItem, "id") %>' runat="server" />
<asp:CheckBox ID="deleteRec" runat="server" />
<asp:Label ID="addsymptoms" Visible="false" Text='<%# DataBinder.Eval (Container.DataItem, "additionalsymptoms") %>' runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>

<asp:BoundField DataField="additionalsymptoms" HeaderText="Additional Symtoms" />
<asp:TemplateField HeaderText="select">
<ItemTemplate>
<asp:DropDownList ID="DropDownList3" DataSource='<%# GetCategoryDescriptions() %>' DataTextField="nam" DataValueField="nam" runat="server">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="White" ForeColor="#000066" />
<RowStyle ForeColor="#000066" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" Width="9555px" HorizontalAlign="Center" />
</asp:GridView>




this is a code inside click event of delete button--

protected void Delete_Click(object sender, EventArgs e)
{
string gvIDs = "";
bool chkBox = false;
foreach (GridViewRow gv in GridView1.Rows)
{
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
if (deleteChkBxItem.Checked)
{
chkBox = true;
gvIDs = gvIDs + ((Label)gv.FindControl("lbl7")).Text.ToString() + ",";

}
}
string strConn = "Provider=Microsoft.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.LastIndexOf(",")));
string deleteOleDb = "DELETE from tempr WHERE id IN (" + gvIDs.Substring(0, gvIDs.LastIndexOf(",")) + ")";
OleDbCommand cmd = new OleDbCommand(deleteOleDb, conn);
cmd.ExecuteNonQuery();
}
GridView1.DataBind();
conn.Close();
}

[dip_developer]

Here is my code--

<asp:AccessDataSource ID="AccessDataSource1" DataFile="Database/thecliniq.mdb" SelectCommand="Select * from tempr" runat="server"> </asp:AccessDataSource>

<asp:GridView ID="GridView1" DataSourceID="AccessDataSource1" AutoGenerateColumns="false" DataKeyNames ="id" runat="server" HorizontalAlign="Left" Height="1px" Width="407px" EnableViewState="False">

<Columns>

<asp:TemplateField>
<HeaderTemplate>
<asp:CheckBox ID="CheckAll" onclick="return check_uncheck (this );" runat="server" />
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="lbl7" Visible="false" Text='<%# DataBinder.Eval (Container.DataItem, "id") %>' runat="server" />
<asp:CheckBox ID="deleteRec" runat="server" />
<asp:Label ID="addsymptoms" Visible="false" Text='<%# DataBinder.Eval (Container.DataItem, "additionalsymptoms") %>' runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>

<asp:BoundField DataField="additionalsymptoms" HeaderText="Additional Symtoms" />
<asp:TemplateField HeaderText="select">
<ItemTemplate>
<asp:DropDownList ID="DropDownList3" DataSource='<%# GetCategoryDescriptions() %>' DataTextField="nam" DataValueField="nam" runat="server">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="White" ForeColor="#000066" />
<RowStyle ForeColor="#000066" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" Width="9555px" HorizontalAlign="Center" />
</asp:GridView>




this is a code inside click event of delete button--

protected void Delete_Click(object sender, EventArgs e)
{
string gvIDs = "";
bool chkBox = false;
foreach (GridViewRow gv in GridView1.Rows)
{
CheckBox deleteChkBxItem = (CheckBox)gv.FindControl("deleteRec");
if (deleteChkBxItem.Checked)
{
chkBox = true;
gvIDs = gvIDs + ((Label)gv.FindControl("lbl7")).Text.ToString() + ",";

}
}
string strConn = "Provider=Microsoft.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.LastIndexOf(",")));
string deleteOleDb = "DELETE from tempr WHERE id IN (" + gvIDs.Substring(0, gvIDs.LastIndexOf(",")) + ")";
OleDbCommand cmd = new OleDbCommand(deleteOleDb, conn);
cmd.ExecuteNonQuery();
}
GridView1.DataBind();
conn.Close();
}

Databind () method binds gridview with the datasource you supply....
where is the updated datasource after deletion????? or am I overlooking something??

[Prabhua]

By default Gridview control will take data from Accessdatasource control,right? which is indicated in .aspx file.