hi
Replace your Query with this
string strSql = "select txtPriceGold from PriceTable Where txtPriceGold="+txtPriceGold +"";
if txtPriceGold is your Textbox Field then
string strSql = "select txtPriceGold from PriceTable Where txtPriceGold="+txtPriceGold.Text+"";
Remember:
case1:when your datatype is string or varchar2
we need to pass the value with
'"+ +"'i.e single Quote,then Double Quote and then +
for example
"select name from Customer Where name ='"+name+"'";
case2 :when your datatype is numeric or integer
we need to pass the value with
"+ +"
string strSql = "select txtPriceGold from PriceTable Where txtPriceGold="+txtPriceGold +"";
Hope this helped
Happy Coding:)