[Mono-aspnet-list] Populating gridview from SQLServer

[Lars Ebeling]

Btw, hopefully you could see the working part (dropdownlist) at 
http://leopg9.no-ip.org/Sqltest/

Regards

Lars


----- Original Message ----- 
From: "Lars Ebeling" <lars.ebeling at leopg9.no-ip.org>
To: <mono-aspnet-list at lists.ximian.com>
Sent: Wednesday, March 14, 2012 8:49 AM
Subject: [Mono-aspnet-list] Populating gridview from SQLServer


> Dear All,
>
> I am attending a course Visual Studio and C# at the University of 
> Halmstad. One task we have done is to create a Forum. But since I got a 
> APache webserver I want to test if I could use mono and Apache. A lot 
> works, but I have a small problem
>
> I have a dropdownlist which I populate from a SQLServer table (works).
>
> My problem: Depending on selected value in the dropdownlist I want to fill 
> the gridview.
>
> I am running Mono on Ubuntu 10.04 LTS and Apache2. Sqlserver runs on 
> Windows XP.
>
> This is source works with Visual Studio 2010
> <asp:GridView ID="GridView1" runat="server" AllowPaging="True"
>
> AllowSorting="True" AutoGenerateColumns="False" CellPadding="4"
>
> DataKeyNames="IID" DataSourceID="SqlDataSource2" ForeColor="#333333"
>
> GridLines="None">
>
> <AlternatingRowStyle BackColor="White" />
>
> <Columns>
>
> <asp:BoundField DataField="FID" HeaderText="FID" SortExpression="FID" >
>
> <ControlStyle Font-Size="Small" />
>
> </asp:BoundField>
>
> <asp:BoundField DataField="IID" HeaderText="IID" InsertVisible="False"
>
> ReadOnly="True" SortExpression="IID" />
>
> <asp:BoundField DataField="datum" HeaderText="datum" 
> SortExpression="datum"
>
> DataFormatString = "{0:d} {0:t}" />
>
> <asp:BoundField DataField="inlägg" HeaderText="inlägg"
>
> SortExpression="inlägg" >
>
> <ItemStyle Width="350px" />
>
> </asp:BoundField>
>
> <asp:CommandField ShowDeleteButton="True" ShowEditButton="True"
>
> Visible="True" />
>
> </Columns>
>
> </asp:GridView>
>
> <asp:SqlDataSource ID="SqlDataSource2" runat="server"
>
> ConflictDetection="CompareAllValues"
>
> ConnectionString="<%$ ConnectionStrings:AAAAA %>"
>
> OldValuesParameterFormatString="original_{0}"
>
> SelectCommand="SELECT * FROM [my_inlagg] WHERE ([FID] = @FID)"
>
> 　
>
> <SelectParameters>
>
> <asp:ControlParameter ControlID="DropDownList1" Name="FID"
>
> PropertyName="SelectedValue" Type="Int64" />
>
> </SelectParameters>
>
> </asp:SqlDataSource>
>
> </p>
>
>
> -- 
> Med vänliga hälsningar/Best Regards
> Lars Ebeling
> Rentier
>
> http://leopg9.no-ip.org
>
>
> "I am not young enough to know everything."
> -- Oscar Wilde
>
>
>
> _______________________________________________
> Mono-aspnet-list mailing list
> Mono-aspnet-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-aspnet-list
>