CheckBox Selection

Vivek Joy

My need is

i have a radcheckbox and rad grid.while selecting or ticking the checkbox it will select whole row and after i press update button that row should be updated .How can I do This?Can anyone Help Me?

I have to do this in C#

My code is this

for (int i = 0; i < DeleteGridView1.Rows.Count;i++)

{

String cguid = DeleteGridView1.Rows[i].Cells[1].Value.ToString();

SqlCommand cmd = new SqlCommand();

Program.StrSql = "update QbCompany set ActiveFlag = 0 Where CompanyGUID='"+ cguid + "'";

cmd.Connection = Program.QbSysDbCon;

cmd.CommandText = Program.StrSql;

cmd.ExecuteNonQuery();

}

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vivek Joy11y ago
hi i get the solution
this is the code

for(int i=0;i
{
string strrtnval = DeleteGridView1.Rows[i].Cells[0].Value == null ? "false" : "true";

int intchecked = strrtnval=="true" ? 0 : 1;//It is a turnary operator.
if (intchecked == 0)
{
String cguid = DeleteGridView1.Rows[i].Cells[1].Value.ToString();
SqlCommand cmd = new SqlCommand();
Program.StrSql = "update QbCompany set ActiveFlag = 0 Where CompanyGUID ='" + cguid + "'";
cmd.Connection = Program.QbSysDbCon;
cmd.CommandText = Program.StrSql;
cmd.ExecuteNonQuery();

}

}

MessageBox.Show("Updated");
Raja T11y ago
Hi Vivek,

"Object reference not set to an instance of object for string a " means a contains value is empty(no data)

private void Delete_Click(object sender, EventArgs e)
{
SysConfig QbSysConfig = new SysConfig();
String StrCompanyGuid = QbSysConfig.ToString();
for (int i = 0; i < DeleteGridView1.Rows.Count;i++)
{
String a = DeleteGridView1.Rows[i].Cells[0].Value.ToString();
MessageBox.Show(a);
String cguid = DeleteGridView1.Rows[i].Cells[1].Value.ToString();
SqlCommand cmd = new SqlCommand();
Program.StrSql = "update QbCompany set ActiveFlag = 0 Where ' '='"+ a + "'";
cmd.Connection = Program.QbSysDbCon;
cmd.CommandText = Program.StrSql;
cmd.ExecuteNonQuery();
}
MessageBox.Show("Deleted");
} }

try to check with debug mode a contains value or not ?
Vivek Joy11y ago
Anyway Thank you for your help.
Vivek Joy11y ago
HI SIR
.............,it shows an error that Object reference not set to an instance of object for string a

Can you help me
Raja T11y ago
Hi Vivek, I have reviewed your code. In that no code for delete query in ur code

private void Delete_Click(object sender, EventArgs e)
{
SysConfig QbSysConfig = new SysConfig();
String StrCompanyGuid = QbSysConfig.ToString();
for (int i = 0; i < DeleteGridView1.Rows.Count;i++)
{
String a = DeleteGridView1.Rows[i].Cells[0].Value.ToString();
String cguid = DeleteGridView1.Rows[i].Cells[1].Value.ToString();
SqlCommand cmd = new SqlCommand();
Program.StrSql = "update QbCompany set ActiveFlag = 0 Where ' '='"+ a + "'";
cmd.Connection = Program.QbSysDbCon;
cmd.CommandText = Program.StrSql;
cmd.ExecuteNonQuery();
}
MessageBox.Show("Deleted");
} }

As per my understanding of ur requirement is in grid view contains check box. When click check box enable delete button and delete record in a table?

Or

When you click on check selected row I'd based update activeflag=1 ?

Please check and confirm which scenario u need?
Vivek Joy11y ago
yes i need the query to update base on given code.
I am able to delte but unable toupdate.My Question is how can update activeflag(another column) number to 0 while clicking on checkbox of a row .
Raja T11y ago
hi, Checkout bellow url

http://demos.telerik.com/aspnet-ajax/grid/examples/data-editing/commanditem/defaultcs.aspx
Raja T11y ago
Hi vivek, I am asking your scenario means (what you need query).For lExample like i have one gridview at load event gridviewloading. After that when gridvew selected row automatically open edit mode after change values click on update gridview will load (refresh) updated values.
Vivek Joy11y ago
this is my code

using System.Text;
using System.Windows.Forms;
using Telerik.WinControls;
using Telerik.WinControls.UI;
using System.Data.SqlClient;
using System.IO;
using QbSysInfo;
using System.Text.RegularExpressions;
using System.Collections.Specialized;
namespace company_form
{
public partial class FrmDelete : Telerik.WinControls.UI.RadForm
{
public FrmDelete()
{
InitializeComponent();
}
private void DeleteClose_Click(object sender, EventArgs e)
{
this.Close();
}
private void FrmDelete_Load(object sender, EventArgs e)
{
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
SysConfig QbSysConfig = new SysConfig();
QbSysConfig.SetFormControlsFont(this);
QbSysConfig.GetSqlSysDbConnection();
DeleteGridView1.Dock = DockStyle.Fill;
this.DeleteGridView1.AllowAddNewRow = false;
this.DeleteGridView1.AllowDragToGroup = false;
this.DeleteGridView1.AllowEditRow = true;
this.DeleteGridView1.AllowDeleteRow = true;
this.DeleteGridView1.AutoSize = true;
GridViewCheckBoxColumn checkboxcolumn1 = new GridViewCheckBoxColumn();
checkboxcolumn1.Name = "CheckBoxColumn1";
checkboxcolumn1.HeaderText = "";
checkboxcolumn1.FieldName = "CheckBoxColumn";
checkboxcolumn1.MaxWidth = 200;
checkboxcolumn1.TextAlignment = ContentAlignment.MiddleLeft;
DeleteGridView1.MasterTemplate.Columns.Add(checkboxcolumn1);
GridViewTextBoxColumn textBoxColumn1 = new GridViewTextBoxColumn();
textBoxColumn1.Name = "TextBoxColumn1";
textBoxColumn1.HeaderText = "Company GUID";
textBoxColumn1.FieldName = "Company GUID";
textBoxColumn1.MaxLength = 50;
textBoxColumn1.TextAlignment = ContentAlignment.MiddleLeft;
textBoxColumn1.Width = 150;
textBoxColumn1.IsVisible = false;
DeleteGridView1.MasterTemplate.Columns.Add(textBoxColumn1);
GridViewTextBoxColumn textBoxColumn2 = new GridViewTextBoxColumn();
textBoxColumn2.Name = "TextBoxColumn2";
textBoxColumn2.HeaderText = "Company Name";
textBoxColumn2.FieldName = "Company Name";
textBoxColumn2.MaxLength = 50;
textBoxColumn2.TextAlignment = ContentAlignment.MiddleLeft;
textBoxColumn2.Width = 300;
DeleteGridView1.MasterTemplate.Columns.Add(textBoxColumn2);
try
{
Program.StrSql = "select CompanyGUID,CompanyName from QbCompany";
SqlCommand cmd = new SqlCommand();
cmd.Connection = Program.QbSysDbCon;
cmd.CommandText = Program.StrSql;
SqlDataReader QbReader1 = null;
QbReader1 = cmd.ExecuteReader();
int i = 0;
while (QbReader1.Read())
{
DeleteGridView1.Rows.AddNew();
DeleteGridView1.Rows[i].Cells[1].Value = QbReader1["CompanyGUID"].ToString();
DeleteGridView1.Rows[i].Cells[2].Value = QbReader1["CompanyName"].ToString();
i++;
}
QbReader1.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERROR");
}
}
private void DeleteClose_Click_1(object sender, EventArgs e)
{
this.Close();
}
private void Delete_Click(object sender, EventArgs e)
{
SysConfig QbSysConfig = new SysConfig();
String StrCompanyGuid = QbSysConfig.ToString();
for (int i = 0; i < DeleteGridView1.Rows.Count;i++)
{
String a = DeleteGridView1.Rows[i].Cells[0].Value.ToString();
String cguid = DeleteGridView1.Rows[i].Cells[1].Value.ToString();

SqlCommand cmd = new SqlCommand();
Program.StrSql = "update QbCompany set ActiveFlag = 0 Where ' '='"+ a + "'";
cmd.Connection = Program.QbSysDbCon;
cmd.CommandText = Program.StrSql;
cmd.ExecuteNonQuery();

}
MessageBox.Show("Deleted");
} }
}
Raja T11y ago
Hi Vivek, I will share you sample code using c# and telerick grid. Please explain your scenario.
Vivek Joy11y ago
hi i'am using telerik.And this code doen't contain any c# code
Raja T11y ago
Hi,Are you got any error? if you got error show me here i will assist you.
Vivek Joy11y ago
not working yet
Raja T11y ago
Hi, Please checkout for this helpfull

http://demos.telerik.com/aspnet-ajax/grid/examples/overview/defaultcs.aspx