Prizes & Awards
My Profile
Active Members
TodayLast 7 Days
more...
|
Resources » Code Snippets » ASP.NET GridView »
Edit,Update,Cancel,Delete and multiple checkbox select to delete in vs2003 DataGrid?
|
Hi!
Edit,update and select multiple checkbox to make it delete in vs2003 Datagrid....ASP.net, c# code as follows... it's work fine...Datagrid Header include Checkbox1...itemtemplate include CheckBox2.....
aspx code as follows:
function selectAll(obj)
{
var theTable = obj.parentElement.parentElement.parentElement;
var i;
var j = obj.parentElement.cellIndex;
for(i=0;i {
var objCheckBox = theTable.rows[i].cells[j].firstChild;
if(objCheckBox.checked!=null)
{
objCheckBox.checked = obj.checked;
}
}
}
aspx.cs code as follows:
using System.Data.OleDb;
OleDbConnection conn;
OleDbCommand com;
OleDbDataAdapter adp;
DataSet rs;
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
if(!IsPostBack)
{
this.display();
}
}
public void display()
{
try
{
conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=E:/test/New Proposal Management 2003.mdb");
conn.Open();
com = new OleDbCommand("select EUserID,EPassword,EType,Empid,EmpName from elogin", conn);
adp = new OleDbDataAdapter();
rs = new DataSet();
adp.SelectCommand = com;
adp.Fill(rs);
DataGrid1.DataSource = rs;
DataGrid1.DataBind();
conn.Close();
}
catch (Exception ex)
{
Response.Write(ex);
}
}
private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex=e.Item.ItemIndex;
this.display();
}
private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
CheckBox cm=new CheckBox();
string str="";
if(e.CommandName=="cmddel")
{
foreach(DataGridItem objItem in DataGrid1.Items)
{
if(((CheckBox)objItem.Cells[6].FindControl("CheckBox1")).Checked == true)
{
str+=((Label)objItem.Cells[0].FindControl("lbl_id")).Text+",";
}
}
conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=E:/test/New Proposal Management 2003.mdb");
conn.Open();
com=new OleDbCommand("delete from elogin where Empid in("+ str+ ")",conn);
com.ExecuteNonQuery();
conn.Close();
Label4.Text="Deleted ..!";
}
this.display();
str="";
}
private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
TableCell EmpId=e.Item.Cells [0];
TableCell Userid=e.Item.Cells[1];
TableCell Password=e.Item.Cells[2];
TableCell Rights=e.Item.Cells[3];
Label lbl=(Label)(EmpId.Controls[1]);
TextBox tb1=((TextBox)(Userid.Controls[1]));
TextBox tb2=((TextBox)(Password.Controls[1]));
DropDownList tb3=((DropDownList)(Rights .Controls[1]));
string userid,password,rights;
userid=tb1.Text;
password=tb2.Text;
//rights=(string)tb3.Text;
rights=tb3.SelectedItem.ToString();
conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=E:/test/New Proposal Management 2003.mdb");
conn.Open();
com=new OleDbCommand();
com.Connection=conn;
com.CommandText="update elogin set EUserID=?,EPassword=?,EType=? where Empid=?";
com.Parameters.Add("EUserID", userid);
com.Parameters.Add("EPassword", password);
com.Parameters.Add("EType", rights);
com.Parameters.Add("Empid",Convert.ToUInt32(lbl.Text));
com.ExecuteNonQuery();
conn.Close();
DataGrid1.EditItemIndex=-1;
Label4.Text="Updated Sucessfully....!!!";
this.display();
// Response.Write(lbl.Text);
}
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex=e.NewPageIndex;
this.display();
}
private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
TableCell EmpNameCell=e.Item.Cells [0];
Label lbl=(Label)(EmpNameCell.Controls[1]);
conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=E:/test/New Proposal Management 2003.mdb");
conn.Open();
com = new OleDbCommand("delete from elogin where Empid=?", conn);
com.Parameters.Add("Empid",lbl);
Response.Write(lbl.Text);
}
private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
this.DataGrid1.EditItemIndex=-1;
this.display();
}
}
|
Responses
|
| Author: kalai 30 May 2009 | Member Level: Bronze Points : 0 | fine
|
|