Comments by anghan22 (Top 7 by date)

round clearity color frm tom rap
BR IF D 0.15 0.17 500
BR VVS1 E 0.15 0.17 600
BR IF D 0.30 0.39 1000
BR VVS1 E 0.30 0.39 200
Above my table look like
when textbox value 0.32 insert enter then check Clearity="IF",color="D then textbox get record 1000

if i enter 0.16 then i have to select color y
then i enter 0.32 then to select color w

above my code when click onsingle time select image button at that time all row in griedview
change value in txtrap field griedview textbox...

i have to one by one get value in txtrap taxtbox...

please help..

if (e.CommandName == "select")
{

for (int i = 0; i < gv_rap.Rows.Count; i++)
{
var color = ((Label)gv_rap.Rows[i].Cells[3].FindControl("lblcolor")).Text.Trim(); //If its label
var cl = ((Label)gv_rap.Rows[i].Cells[4].FindControl("lblclearity")).Text.Trim();
var shape = ((Label)gv_rap.Rows[i].Cells[7].FindControl("lblshape")).Text.Trim();
string frm = ((DropDownList)gv_rap.Rows[i].Cells[12].FindControl("ddlfrm")).Text.Trim();
string to = ((DropDownList)gv_rap.Rows[i].Cells[13].FindControl("ddlto")).Text.Trim();

TextBox txtrap = ((TextBox)gv_rap.Rows[i].Cells[14].FindControl("txtrap"));
string str = "select rap from test where frm='" + frm+ "'and tom='" + to + "'and round='" + shape + "'and clearity='" + cl + "'and color= '" + color + "'";
SqlCommand cmd = new SqlCommand(str, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();

if (reader.Read())
{

txtrap.Text= reader["rap"].ToString();

reader.Close();

conn.Close();
}

}