gridview

Sign in to answer this question.

• 

  Sukesh Marla14y agoPosted Aug 23, 2012, 12:54 PM

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

  vikas kanani14y agoPosted Aug 23, 2012, 12:44 PM

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

  Sukesh Marla14y agoPosted Aug 19, 2012, 7:27 AM

  Buddy i need aspx.
• VK

  vikas kanani14y agoPosted Aug 19, 2012, 7:24 AM

  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 < GridView1.Rows.Count; 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();

          //}

      }

  
  

  }
  
  
  
  
• 

  Sukesh Marla14y agoPosted Aug 19, 2012, 7:16 AM

  Paste ASPX here
  and Query for your Table
• VK

  vikas kanani14y agoPosted Aug 19, 2012, 7:15 AM

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

  Sukesh Marla14y agoPosted Aug 19, 2012, 7:11 AM

  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(',');
• VK

  vikas kanani14y agoPosted Aug 19, 2012, 7:07 AM

  yes id colum is primary key
• 

  Sukesh Marla14y agoPosted Aug 19, 2012, 7:03 AM

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

  Sukesh Marla14y agoPosted Aug 19, 2012, 7:02 AM

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

  vikas kanani14y agoPosted Aug 19, 2012, 7:02 AM

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

  vikas kanani14y agoPosted Aug 19, 2012, 7:00 AM

  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 < GridView1.Rows.Count; 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 Marla14y agoPosted Aug 19, 2012, 6:54 AM

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

  vikas kanani14y agoPosted Aug 19, 2012, 6:50 AM

  here is code n db
• 

  Sukesh Marla14y agoPosted Aug 19, 2012, 6:45 AM

  ya do it, 
• VK

  vikas kanani14y agoPosted Aug 19, 2012, 6:43 AM

  can i again send code n db?
• 

  Sukesh Marla14y agoPosted Aug 19, 2012, 6:39 AM

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

  vikas kanani14y agoPosted Aug 19, 2012, 6:31 AM

  i sent here code with database
• 

  Sukesh Marla14y agoPosted Aug 19, 2012, 6:18 AM

  Share Code and Db with me.
• VK

  vikas kanani14y agoPosted Aug 19, 2012, 6:17 AM

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

  Sukesh Marla14y agoPosted Aug 19, 2012, 6:06 AM

  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. 
  
  
  
• VK

  vikas kanani14y agoPosted Aug 19, 2012, 6:03 AM

  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 Marla14y agoPosted Aug 19, 2012, 5:33 AM

  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.
• VK

  vikas kanani14y agoPosted Aug 19, 2012, 5:30 AM

  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
• VK

  vikas kanani14y agoPosted Aug 19, 2012, 4:32 AM

  please give me a full description of code.
• 

  Akkiraju Ivaturi14y agoPosted Aug 19, 2012, 1:55 AM

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

  Satyapriya Nayak14y agoPosted Aug 18, 2012, 1:22 PM

  Hi Vikas,
  
  
  <%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>
  
  
  
  
  
     
     
  
  
     

  
     
              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 < GridView1.Rows.Count; 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 Marla14y agoPosted Aug 18, 2012, 12:53 PM

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