Database

select coalesce(col1val,col2val,'')
from table1

Ashfield wrote:

There is also the coalesce function, which returns the first non-null value from a list

Update sales_master 
set un_rate = qtnmaster.un_rate 
from sales_master 
inner join qtnmaster 
ON sales_master.itemcode = qtnmaster.itemcode

DataGridViewRow dgvr = table1DataGridView.CurrentRow;
DataRowView drv = (DataRowView )dgvr.DataBoundItem;
bool isReadOnly = drv.Row["htreadonly"];

AussieLew wrote:

I am providing the edit/add fields ( as databound textboxes etc )separately elsewhere on the form

Mycroft Holmes wrote:

I am not sure I agree with (1) that you should be getting the data from the underlying datatable,

Mycroft Holmes wrote:

When you get he data for this do you use the DGV row or go back to the database get a row to bind to the textboxes.

// This can probably be more elegant/streamlined however it helps me visually. (Open to suggestions..)
 DataGridViewRow dgvr = MyTable1DataGridView.CurrentRow; // returns a DatGridViewRow
 DataRowView drv = (DataRowView)dgvr.DataBoundItem; // Cast as DataRowView - dgvr.DataBoundItem returns an object 
 DataRow dr = (DataRow)drv.Row;
 int pos = dr.Table.Rows.IndexOf(dr);
 bool boolColumnValue = MyDataSet.MyTable1[pos].HTReadOnly;// IDE checks and suggests
 // so no need to test that column name or column type is  correct 
 
 if (boolColumnValue)
    { 
    // Do stuff if true
    }
 else 
    { 
    // Do NOT do stuff if false
    }

SELECT *
FROM Currency C
	INNER JOIN 
		(SELECT CurrencyID, ROW_NUMBER() OVER (ORDER BY CurrencyID) RN FROM currency) R 
				ON R.currencyid = C.CurrencyID -- Join back to the currency table
WHERE R.RN BETWEEN 6 AND 10