How to take null values when update or insert query is execu

aravinth kandasamy

Update tbfacilityreceiptitems set itemID = 9345, Batchno = '' , mfgdate = 1/1/2012, expdate = 1/1/2020 , MRP =100.0000, SingleUnitPrice= 80.0000, marginPercentage = 20.00, sellingprice = 80.00, SaletaxID = 30, TaxPercentage = ? , TaxPercentage = ? , SaleTaxPercentage ='' , SaleTaxType = ' ' , sellingpricesku =?where facreceiptitemid = 2291

Please help me for how to replace a null values in question mark place...

Please rearrange the Query

2 Replies

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

aravinth kandasamy11y ago
string strQuery = "Update tbfacilityreceiptitems set itemID = " + txtitemID.Text + ", Batchno =' " + txtBatchno.Text + "' ,mfgdate = '" + txtmfgdate.Text + "', expdate = '" + txtexpdate.Text + "', MRP =" + txtMRP.Text + ", SingleUnitPrice= " + txtSingleUnitPrice.Text + ", marginPercentage = " + txtMarginPercentage.Text + ", sellingprice = " + txtSellingPrice.Text + ", SaletaxID = " + txtSaletaxID.Text + ", TaxPercentage = " + "COALESCE(" + txtTaxPercentage.Text + ", 0)" + ", SaleTaxPercentage =" + "COALESCE(" + txtSaleTaxPercentage.Text + " ,0)" + " , SaleTaxType =' " + txtSaleTaxType.Text + "', sellingpricesku = " + "COALESCE (" + txtSellingPricesku.Text + ",0) " + "where facreceiptitemid = " + mfacreceiptitemid; this is my query..Now how to take null value in c#?..please help me
11y ago
Its very simple, just place null insted of question mark like
if your want to execute from sql site then
Update tbfacilityreceiptitems set itemID = 9345, Batchno = '' , mfgdate = 1/1/2012, expdate = 1/1/2020 , MRP =100.0000, SingleUnitPrice= 80.0000, marginPercentage = 20.00, sellingprice = 80.00, SaletaxID = 30, TaxPercentage = null , TaxPercentage = null , SaleTaxPercentage ='' , SaleTaxType = ' ' , sellingpricesku =null where facreceiptitemid = 2291

from C#
"Update tbfacilityreceiptitems set itemID = 9345, Batchno = '' , mfgdate = 1/1/2012, expdate = 1/1/2020 , MRP =100.0000, SingleUnitPrice= 80.0000, marginPercentage = 20.00, sellingprice = 80.00, SaletaxID = 30, TaxPercentage ="+DbNull.Value+" , TaxPercentage ="+DbNull.Value"+ , SaleTaxPercentage ='' , SaleTaxType = ' ' , sellingpricesku ="+DbNull.Value+" where facreceiptitemid = 2291
Please market as answer, if it helps your and freely ask if you have any more questions