i made table with 5 drop-down menues. On update first 4 drop-down menues are ok (last entered value is preserved), but i have problem with fifth drop-down (red lines around).
In this drop-down menu last value is not preserved, instead of last entered value this drop-down menu is giving me value wich is first in sort order.
The code is the same for all 5 menues...
5th drop-down
$column = new GridDropDownColumn();
$column->HeaderStyle->Align = "center";
$column->DataField = "kategorijaStruja"; $column->HeaderText = "struja_kategorija";
$column->Align = "center";
$column->AllowFiltering = true;
$result3 = mysql_query('select kategorijaStruja from struja_kategorija order by kategorijaStruja');
while($row3=mysql_fetch_assoc($result3))
{
$column->AddItem($row3["kategorijaStruja"],$row3["kategorijaStruja"]);
}
$grid->MasterTable->AddColumn($column);
Update...
$ds->UpdateCommand = 'update napomena
set id="@id",
klijent="@klijent",
distr="@distr",
struja="@struja",
strDtmDo="@strDtmDo",
kategorijaStruja="@kategorijaStruja",
plnDtmDo="@plnDtmDo",
kategorijaPlin="@kategorijaPlin",
aktivnost="@aktivnost",
strucna_napomena="@strucna_napomena",
username="@username"
where id="@id" AND username= "'.$_SESSION['login_user'].'"';