delete selected row from datagridview and database in c#

This code will delete selected items of a dataGridView.

foreach (DataGridViewRow item in this.dataGridView1.SelectedRows)
    {
        dataGridView1.Rows.RemoveAt(item.Index);
    }

For rest, you need to refresh your datagridview source.Check..
Delete row from Datagridview and same updates in database[^]
How to delete a selected row from datagridview and database[^]
How to Delete selected row in data grid view and database by C#[^]

Use this code to Delete Row From DataGridView

if (this.dataGridView1.SelectedRows.Count > 0)
            {
                dataGridView1.Rows.RemoveAt(this.dataGridView1.SelectedRows[0].Index);
            }

and This code for Delete data from Database

first of all you find and store primary field data in a Temp variable and pass this variable in where clause

Ex:-

if your primary field name is Emp_Id and it's it's position in Grid is cell[0]
then

int Primary_Field_Value =dataGridView1[Column_Index,Row_Index].value.Tostring();

SqlCommand cmd = new SqlCommand ("Delete from table where id='"+ Primary_Field_Value +"'",ConnectionObject); 
cmd.ExecutenonQuery(); 

Thanks & Regard
Sham :)

In source part do this:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
        <Columns>
            <asp:TemplateField HeaderText="User Name">
                <ItemTemplate>
                    <%#Eval("userName")%>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Password">
                <ItemTemplate>
                    <%#Eval("pass")%>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Test">
                <ItemTemplate>
                    <%#Eval("test")%>
                </ItemTemplate>
            </asp:TemplateField>

             <asp:TemplateField >
                <ItemTemplate>
                    <a href="Default.aspx?id=<%#Eval("userId") %>&act=del">Delete</a>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>

// Then in code behind:

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string qact = Request.QueryString["act"];
            if (qact == "del")
            {
                string id = Request.QueryString["id"];
                string str = ConfigurationManager.ConnectionStrings["class28"].ToString();
                SqlConnection con = new SqlConnection(str);
                string sql = "delete from t_User where userId=" + int.Parse(id) + "";
                SqlCommand cmd = new SqlCommand(sql, con);
                con.Open();
                cmd.ExecuteNonQuery();
            }
        }
    }

deletedatagridrows.aspx[^]

how-to-delete-a-selected-row-from-datagridview-and-database[^]

Delete row from Datagridview and same updates in database[^]

Check the links..hope it will help..