Intersoft Community - DataSource

Remove column defined in aspx markup, from server-side

sinan.biondic@gmail.com — Tue, 16 Apr 2013 16:03:03 GMT

Hi,

I am trying to implement webgrid but the problem exists when I'm binding it to datasource. I have a stored procedure that returns some data.However, I don't know how many columns will be returned in that procedure, but I know the names of all columns that can be returned. So what I wanted to do, is to define all possible columns in aspx page, and in server-side PrepareDataBinding method remove columns from webgrid's column collection that don't have their match in datasource datatable that I'm binding it to.

This doesn't really work as I get an error stating that columne "XYZ" which is defined in aspx can't be found in datasource, although it was removed (I checked with debugger) in PrepareDataBinding event handler.

I presume this then is not possible, or am I wrong? The reason I am not creating columns from codebehind is simply that I would have to check datasource for every column to see if it exists and then create that column dynamically and add it to the column collection of webgrid. We did that in old version of our application and that PrepareDataBinding method has over 1600 lines of code, so I am looking for a better way of doing this. Please help me for the love of god!

This is my PrepareDataBinding method (column named "Check" is rowchecker column so i don't want it removed):

Dim dt As DataTable = CType(e.DataSource, DataTable)
 Dim grid As WebGrid = CType(sender, WebGrid)
 Dim colName As String
 For Each col As WebGridColumn In grid.RootTable.Columns
 colName = col.DataMember
 If Not colName = "Check" AndAlso Not dt.Columns.Contains(colName) Then
 grid.RootTable.Columns.Remove(col)
 End If
 Next

Problem Export DataSource

pujatolon@gmail.com — Wed, 11 Apr 2012 07:34:04 GMT

When I try to export data from a WebGrid that it's datasource is a datatable in code behind, it appears the screen that is in atachment.

If I try to export data from a WebGrid whith an aspdatasource (like in demo example), it works.

Can you please, say to me how can I fixed this problem?

Thank you

Tie WebFileUploader into DB?

jonathan.fischer@codelynx.com — Fri, 11 Feb 2011 15:29:07 GMT

I have a need to upload files into a database, where they will be stored and searched on. They will also be linked to other items in the database. My question is, how do I do this in WebFileUploader? Is it even possible? I have created a SQLDataSource and bound it to a table. Now, I just need to get WebFileUploader to upload files into it.

Thank you!

Jonathan Fischer, MBA

MySql DataSource for Web Scheduler

minococciolo — Fri, 13 Nov 2009 06:20:03 GMT

Hi all,

I would like to know if I could specify a MySql datasource for a web scheduler. I tried to generate a simple web scheduler with a ISDatasource and with just events binding, but it generates a long error server page. The code is:

<ISWebScheduler:WebScheduler ID="WebScheduler1" runat="server" Height="100%" Width="100%"
        DataSourceID="SqlDataSource1" EventsDataMember="appuntamenti">
        <ViewSettings SelectedDate="03/01/2008 08:00:00" SelectedViewMode="Month">
            <QuarterView Enabled="True" />
        <TimelineView DateHeaderMode="DateNumber"></TimelineView>
        </ViewSettings>
        <DataBinding>
            <EventsBinding EventIDField="IdAppuntamento"
             SubjectField="Motivazione"/>
        </DataBinding>
        <ImagesSettings BlackRecurrence="BlackRecurrence.gif" BlackRecurrenceException="BlackRecurrenceException.gif"
            BlackReminder="BlackReminder.gif" />

        <DefaultResource ResourceColor="#D96666" ResourceName="Default"></DefaultResource>
    </ISWebScheduler:WebScheduler>
        
        
        
    <asp:SqlDataSource ID="SqlDataSource1" ConnectionString="user=root;password=mypass;database=mydb;server=localhost" runat="server"></asp:SqlDataSource>

I'm sure you can help or give me any suggestion.

Thanks in advance. Regards,

Mino