gridview

Question

how to delete multiple records from gridview using templatefield.(do not use of sqldatasource or object datasource)

Sukesh Marla · Answer

Paste ASPX here and Query for your Table

Sukesh Marla · Answer

you are welcome buddy Check answer as correct answer if it helped

vikas kanani · Answer

thank you,your code is worked.thank you so much for helped.

Sukesh Marla · Answer

Buddy i need aspx.

vikas kanani · Answer

public partial class checkbox : System.Web.UI.Page { SqlConnection CONN = new SqlConnection("Data Source=.;Initial Catalog=dandk;Integrated Security=SSPI"); string str; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) retrievedata(); totalrecords(); } private void totalrecords() { // con = new SqlConnection(connStr); //cmd.Connection = con; CONN.Open(); str = "select count(*) from d_and_k "; SqlCommand cmd = new SqlCommand(str, CONN); int row = (int)cmd.ExecuteScalar(); Label3.Text = row.ToString(); CONN.Close(); } private void retrievedata() { // if (ViewState["Products"] != null) // return (DataSet)ViewState["Products"]; SqlCommand cmd = new SqlCommand("select * from d_and_k", CONN); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); GridView1.DataSource = ds; da.Fill(ds); GridView1.DataBind(); } protected void GridView1_DataBound(object sender, EventArgs e) { } protected void btn_delete_Click(object sender, EventArgs e) { StringCollection idCollection = new StringCollection(); string strID = string.Empty; //Loop through GridView rows to find checked rows for (int i = 0; i { CheckBox CheckBox1 = (CheckBox) GridView1.Rows[i].Cells[0].FindControl("CheckBox1"); if (CheckBox1 != null) { if (CheckBox1.Checked) { strID = GridView1.Rows[i].Cells[1].Text; idCollection.Add(strID); } } } //Call the method to Delete records DeleteMultipleRecords(idCollection); // rebind the GridView GridView1.DataBind(); } private void DeleteMultipleRecords (StringCollection idCollection) { //Create sql Connection and Sql Command // SqlConnection con = new SqlConnection(CONN); SqlCommand cmd = new SqlCommand(); string IDs = ""; foreach (string id in idCollection) { IDs += id.ToString() + ","; } // try // { string strIDs = null; if (IDs.IndexOf(",") != -1) { strIDs = IDs.Substring(0, IDs.LastIndexOf(",")); } else { strIDs = IDs; } strIDs = IDs.TrimEnd(','); string strSql = "Delete from D_and_k WHERE ID in ('" + strIDs + "')"; cmd.CommandType = CommandType.Text; cmd.CommandText = strSql; cmd.Connection = CONN; CONN.Open(); cmd.ExecuteNonQuery(); CONN.Close(); // } //catch (SqlException ex) //{ // string errorMsg = "Error in Deletion"; // errorMsg += ex.Message; // throw new Exception(errorMsg); //} //finally //{ // CONN.Close(); //} } }

vikas kanani · Answer

yea value is not in perfect way.only varchar values r displayed in idcollection.other values not display.

Sukesh Marla · Answer

Check idCOllection values by putting Break Point, I am 90% sure values are not comming properly in that collection. Also check the vaue of strIDs in final method also change string strIDs = null; if (IDs.IndexOf(",") != -1) { strIDs = IDs.Substring(0, IDs.LastIndexOf(",")); } else { strIDs = IDs; } To strIDs =IDs.TrimEnd(',');

vikas kanani · Answer

yes id colum is primary key

Sukesh Marla · Answer

Are you sure cell[1] contains your Id->Primary Key...?

Sukesh Marla · Answer

do one thing, Put a break point and see what all values are coming in idCollection

vikas kanani · Answer

table name d_and_k datatype id= int name varchar state varchar city varchar dob date active bit

vikas kanani · Answer

public partial class checkbox : System.Web.UI.Page { SqlConnection CONN = new SqlConnection("Data Source=.;Initial Catalog=dandk;Integrated Security=SSPI"); string str; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) retrievedata(); totalrecords(); } private void totalrecords() { // con = new SqlConnection(connStr); //cmd.Connection = con; CONN.Open(); str = "select count(*) from d_and_k "; SqlCommand cmd = new SqlCommand(str, CONN); int row = (int)cmd.ExecuteScalar(); Label3.Text = row.ToString(); CONN.Close(); } private void retrievedata() { // if (ViewState["Products"] != null) // return (DataSet)ViewState["Products"]; SqlCommand cmd = new SqlCommand("select * from d_and_k", CONN); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); GridView1.DataSource = ds; da.Fill(ds); GridView1.DataBind(); } protected void GridView1_DataBound(object sender, EventArgs e) { } protected void btn_delete_Click(object sender, EventArgs e) { StringCollection idCollection = new StringCollection(); string strID = string.Empty; //Loop through GridView rows to find checked rows for (int i = 0; i { CheckBox CheckBox1 = (CheckBox) GridView1.Rows[i].Cells[0].FindControl("CheckBox1"); if (CheckBox1 != null) { if (CheckBox1.Checked) { strID = GridView1.Rows[i].Cells[1].Text; idCollection.Add(strID); } } } //Call the method to Delete records DeleteMultipleRecords(idCollection); // rebind the GridView GridView1.DataBind(); } private void DeleteMultipleRecords (StringCollection idCollection) { //Create sql Connection and Sql Command // SqlConnection con = new SqlConnection(CONN); SqlCommand cmd = new SqlCommand(); string IDs = ""; foreach (string id in idCollection) { IDs += id.ToString() + ","; } // try // { string strIDs = null; if (IDs.IndexOf(",") != -1) { strIDs = IDs.Substring(0, IDs.LastIndexOf(",")); } else { strIDs = IDs; } string strSql = "Delete from D_and_k WHERE ID in ('" + strIDs + "')"; cmd.CommandType = CommandType.Text; cmd.CommandText = strSql; cmd.Connection = CONN; CONN.Open(); cmd.ExecuteNonQuery(); CONN.Close(); // } //catch (SqlException ex) //{ // string errorMsg = "Error in Deletion"; // errorMsg += ex.Message; // throw new Exception(errorMsg); //} //finally //{ // CONN.Close(); //} } }

Sukesh Marla · Answer

getting the same error again dear. Do one thing Copy Ur ASpX Code then code behind code here

vikas kanani · Answer

here is code n db

Sukesh Marla · Answer

ya do it,

vikas kanani · Answer

can i again send code n db?

Sukesh Marla · Answer

Unable to download, Getting error on download http://www.c-sharpcorner.com/Forums/pagenotfound.aspx

vikas kanani · Answer

i sent here code with database

Sukesh Marla · Answer

Share Code and Db with me.

vikas kanani · Answer

application is perfectly run but records r not deleted.dnt know why

Sukesh Marla · Answer

string strSql = "Delete from D_and_k WHERE ID in ('" + strIDs + "')"; try with this. Hope it helped check this is correct answer if it is.

vikas kanani · Answer

STILL IT GENERATE ERROR.ALL IS PERFECT APPLICATION RUN TOO.BUT LITTLE PROB I CANT FIND.PLZ CHEK IT. LINE NUM : string strSql = "Delete from D_and_k WHERE ID in (" + strIDs + ")"; error:Incorrect syntax near ')'.

Sukesh Marla · Answer

ya its because IDs contain single value this time, so do like string strIDs=null; if( IDs .indexOf(",")!=-1) { strIDs =IDs.Substring(0, IDs.LastIndexOf(",")); } else { strIDs = IDs ; } Hope it helped check this is correct answer if it is.

vikas kanani · Answer

it generate error online { string strIDs =IDs.Substring(0, IDs.LastIndexOf(",")); } error is Length cannot be less than zero. Parameter name: length it code on Akkiraju Ivaturi.plz check it n reply me

vikas kanani · Answer

please give me a full description of code.

Akkiraju Ivaturi · Answer

I think it will be useful to you: http://csharpdotnetfreak.blogspot.com/2009/04/delete-multiple-rows-gridview-checkbox.html

Satyapriya Nayak · Answer

Hi Vikas, Untitled Page function ConfirmOnDelete(item) { if (confirm("Would you like to delete selected item(s)?")==true) return true; else return false; } onrowdatabound="GridView1_RowDataBound" > Text="Label"> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; using System.Collections.Specialized; using System.Collections.Generic; using System.Text; public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand cmd = new SqlCommand(); SqlConnection con; string str; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) BindGridView(); totalrecords(); } private void totalrecords() { con = new SqlConnection(connStr); //cmd.Connection = con; con.Open(); str = "select count(*) from employee "; SqlCommand cmd = new SqlCommand(str, con); int row = (int)cmd.ExecuteScalar(); Label2.Text = row.ToString(); con.Close(); } private void BindGridView() { con = new SqlConnection(connStr); cmd.Connection = con; cmd.CommandText = "Select * from employee"; con.Open(); GridView1.DataSource = cmd.ExecuteReader(); GridView1.DataBind(); con.Close(); } private void DeleteRecords(StringCollection sc) { con = new SqlConnection(connStr); StringBuilder sb = new StringBuilder(string.Empty); foreach (string item in sc) { const string sqlStatement = "DELETE FROM employee WHERE EmpId"; sb.AppendFormat("{0}='{1}'; ", sqlStatement, item); } try { con.Open(); SqlCommand cmd = new SqlCommand(sb.ToString(), con); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } catch (System.Data.SqlClient.SqlException ex) { string msg = "Deletion Error:"; msg += ex.Message; throw new Exception(msg); } finally { con.Close(); } } protected void ButtonDelete_Click(object sender, EventArgs e) { StringCollection sc = new StringCollection(); string id = string.Empty; for (int i = 0; i { CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox1"); if (cb != null) { if (cb.Checked) { id = GridView1.Rows[i].Cells[1].Text; sc.Add(id); } } } DeleteRecords(sc); BindGridView(); totalrecords(); } protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.Header) { Button b = (Button)e.Row.FindControl("ButtonDelete"); b.Attributes.Add("onclick", "return ConfirmOnDelete();"); } } } Thanks If this post helps you mark it as answer

Sukesh Marla · Answer

Just put a checkbox inside gridview using GridView , And Create a separate delete button outside grid... And on Delete loop the grid(using for each loop) , and find checkbox control on every gridviewrow and if its checked delete it. Let me knw if anythng required If it helped check this is correct answer,.

gridview

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (28)