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,.