How to refer to specific column within datagrid

Asked Jan 25 '17 at 19:04

Active Jan 26 '17 at 12:55

Viewed 21 times

I am currently creating a system within visual studio connecting to SQL database Management System. I am trying to write an if statement which takes the value that is in the specific column and if its equal to 'y' then I follow with an update statement.

I'm having trouble with the line within the brackets, the rest I am able to do.

if( cmnpayment = "Y")
{
  //UPDATE STATEMENT
}

edited Jan 26 '17 at 12:55

Sebi

3,879
2
35
62

asked Jan 25 '17 at 19:04

G.McGonigal

Try using single quotes `if( cmnpayment = 'Y')` – Gurwinder Singh Jan 25 '17 at 19:05
if it's a string you could use `if(string.compare(cmnpayment,"y"))` – Gino Jan 25 '17 at 19:07
Can you post your declaration for cmnpayment? What type of variable is it? – Eric Burdo Jan 25 '17 at 19:52

How to refer to specific column within datagrid

0 Answers0