Thank you, I´m having trouble understandig parameters from gridview to
sqldatasource.
everything goes fine, but not update done. No error, but not update.
Thank again
<asp:GridView ID="GridView1" runat="server" AutoGenerateCol umns="False"
CellPadding="4"
DataSourceID="S qlDataSource3" ForeColor="#333 333" GridLines="None "
Width="544px">
<FooterStyle BackColor="#5D7 B9D" Font-Bold="True" ForeColor="Whit e" />
<Columns>
<asp:BoundFie ld AccessibleHeade rText="id_solic itinscr"
DataField="id_s olicitinscr"
ReadOnly="True" ShowHeader="Fal se" Visible="False" />
<asp:BoundFie ld AccessibleHeade rText="Jugador" DataField="id_j ugador"
HeaderText="Jug ador"
ReadOnly="True" >
<ItemStyle Font-Bold="True" />
</asp:BoundField>
<asp:BoundFie ld AccessibleHeade rText="Fecha" DataField="soli _fecha"
DataFormatStrin g="{0:d}" HeaderText="Fec ha" ReadOnly="True" />
<asp:TemplateFi eld>
<HeaderTemplate >Estado</HeaderTemplate>
<ItemTemplate >
<asp:Label Width="50px" ID="Label5" runat="server" text='<%#
Eval("est_ped_d esc")%>'></asp:Label>
</ItemTemplate>
<EditItemTempla te>
<asp:ListBox Rows="1" runat="server" ID="id_estado"
DataSourceID="S qlDataSource5" DataValueField= "id_estados "
DataTextField=" est_ped_desc"></asp:ListBox>
</EditItemTemplat e>
</asp:TemplateFie ld>
<asp:CommandFie ld CancelText="Can celars" EditText="Edita r"
InsertVisible=" False" ShowEditButton= "True" SelectText="Sel eccionar"
UpdateText="Gra bar">
<ItemStyle Width="50px" />
</asp:CommandFiel d>
</Columns>
<RowStyle BackColor="#F7F 6F3" ForeColor="#333 333" />
<EmptyDataTempl ate>
<asp:Label ID="Label2" runat="server" Font-Bold="True" Text="Sin
Solicitudes"></asp:Label>
</EmptyDataTempla te>
<EditRowStyle BackColor="#999 999" CssClass="mk_ce llitem" />
<SelectedRowSty le BackColor="#E2D ED6" Font-Bold="True" ForeColor="#333 333"
/>
<PagerStyle BackColor="#284 775" ForeColor="Whit e" HorizontalAlign ="Center"
/>
<HeaderStyle BackColor="#435 97F" BorderStyle="No ne" BorderWidth="0p x"
Font-Bold="True"
ForeColor="Whit e" HorizontalAlign ="Left" Wrap="True" />
<AlternatingRow Style BackColor="Whit e" ForeColor="Blac k" />
</asp:GridView>
<asp:SqlDataSou rce ID="SqlDataSour ce3" runat="server" ConnectionStrin g="<%$
ConnectionStrin gs:ClubSiteDB %>"
ProviderName="< %$ ConnectionStrin gs:ClubSiteDB.P roviderName %>"
SelectCommand=" SELECT mkg_juginscript soli.id_solicit inscr,
mkg_juginscript soli.id_jugador , mkg_juginscript soli.soli_fecha ,
mkg_estados_sol icit.est_ped_de sc FROM mkg_juginscript soli INNER JOIN
mkg_estados_sol icit ON mkg_juginscript soli.soli_estad o =
mkg_estados_sol icit.id_estados INNER JOIN aspnet_Users ON
mkg_juginscript soli.id_jugador = aspnet_Users.Us erName WHERE
(mkg_juginscrip tsoli.id_torneo = @id) ORDER BY
mkg_juginscript soli.soli_fecha "
UpdateCommand=" UPDATE mkg_juginscript soli SET soli_estado = @id_estados
WHERE id_solicitinscr = @id_solicitinsc r">
<SelectParamete rs>
<asp:Paramete r DefaultValue="1 " Name="id" />
</SelectParameter s>
<UpdateParamete rs>
<asp:Paramete r Name="id_estado s" />
<asp:Paramete r Name="id_solici tinscr" />
</UpdateParameter s>
</asp:SqlDataSour ce>
<asp:SqlDataSou rce ID="SqlDataSour ce5" runat="server" ConnectionStrin g="<%$
ConnectionStrin gs:ClubSiteDB %>"
ProviderName="< %$ ConnectionStrin gs:ClubSiteDB.P roviderName %>"
SelectCommand=" SELECT id_estados, est_ped_desc
F ROM
mkg_estados_sol icit">
</asp:SqlDataSour ce>
"clickon" <cl*****@discus sions.microsoft .com> escribió en el mensaje
news:46******** *************** ***********@mic rosoft.com...
As below:
<asp:ListBox Rows="1" runat="server" ID="id_estado"
DataSourceID="S qlDataSource5" DataValueField= "id_estados "
DataTextField=" est_ped_desc" SelectedValue=' <%#Bind("Parame terName")%>'</asp:ListBox>
"Manekurt" wrote:
Thank you, I´ve made it this way.
<HeaderTemplate >Estado</HeaderTemplate>
<ItemTemplate >
<asp:Label Width="50px" ID="Label5" runat="server" text='<%#
Eval("est_ped_d esc")%>'></asp:Label>
</ItemTemplate>
<EditItemTempla te>
<asp:ListBox Rows="1" runat="server" ID="id_estado"
DataSourceID="S qlDataSource5" DataValueField= "id_estados "
DataTextField=" est_ped_desc"></asp:ListBox>
</EditItemTemplat e>
</asp:TemplateFie ld>
Do you know how I can pass the parameter of the value to the
sqldatasource?
Thank you
"clickon" <cl*****@discus sions.microsoft .com> escribió en el mensaje
news:51******** *************** ***********@mic rosoft.com... > Use a templatefield, you can put what you like in it
>
> "Marcos Beccar Varela | GamaCom Argentina" wrote:
>
>> Hello Everyone. I need to use a gridview, that when I use the Update
>> command
>> one of the colums, instead of showing a textbox where the user can
>> write,
>> I
>> need
>> a combobox (listobx), where there are 3 options.
>> EG OF GRIDVIEW:
>> USUER AGE
>> carlosg old
>> rominat young
>> gonzalor normal
>> florenciat young
>> roberto old
>>
>> Thank you!
>>
>>
>>