[Mono-aspnet-list] Populating gridview from SQLServer

[Lars Ebeling]

Don't bother I got it to work


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


> 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
>>
>
>