Sqldatasource is not working in Grid

[Joe]

Hi,

the SQLdatasource is not working with the grid.  I have no code-behind just using the SQLdatasource object.

Here is the code:

I used several examples on this forum but have had no luck in firing these events.

Thank You,

<telerik:RadScriptManager ID="ScriptManager1" runat="server">
       </telerik:RadScriptManager>
       <telerik:RadGrid ID="rdgBudget" runat="server" AllowFilteringByColumn="True" AllowPaging="True"
           AllowSorting="True" DataSourceID="SEMBudgetSource" GridLines="None" Skin="Office2007"
           AllowAutomaticInserts="true" AllowAutomaticUpdates="true" OnItemDataBound="Budget_ItemDataBound">
           <MasterTableView AutoGenerateColumns="False" DataSourceID="SEMBudgetSource" CommandItemDisplay="Top"
               DataKeyNames="SEMBudgetId">
               <EditFormSettings>
                   <EditColumn CancelImageUrl="../Images/Cancel.gif" EditImageUrl="../Images/Edit.gif"
                       InsertImageUrl="../Images/Insert.gif" UniqueName="EditCommandColumn" UpdateImageUrl="../Images/Update.gif">
                   </EditColumn>
               </EditFormSettings>
               <Columns>
                   <telerik:GridEditCommandColumn UniqueName="EditCommandColumn" ButtonType="ImageButton" />
                   <telerik:GridBoundColumn DataField="SEMBudgetId" DataType="System.Int32" ReadOnly="True"
                       UniqueName="SEMBudgetId" Visible="false">
                   </telerik:GridBoundColumn>
                   <telerik:GridBoundColumn DataField="Customer" DefaultInsertValue="" HeaderText="Customer"
                       SortExpression="Customer" UniqueName="Customer">
                   </telerik:GridBoundColumn>
                   <telerik:GridBoundColumn DataField="MarginBudget" DataType="System.Decimal" DefaultInsertValue=""
                       HeaderText="SEM Budget" SortExpression="MarginBudget" UniqueName="MarginBudget"
                       DataFormatString="{0:C}" ItemStyle-HorizontalAlign="Right">
                       <ItemStyle HorizontalAlign="Right"></ItemStyle>
                   </telerik:GridBoundColumn>
                   <telerik:GridBoundColumn DataField="BudgetSpent" DataType="System.Decimal" DefaultInsertValue=""
                       HeaderText="Budget Spent" SortExpression="BudgetSpent" UniqueName="BudgetSpent"
                       ReadOnly="true" DataFormatString="{0:C}" ItemStyle-HorizontalAlign="Right">
                       <ItemStyle HorizontalAlign="Right"></ItemStyle>
                   </telerik:GridBoundColumn>
                   <telerik:GridBoundColumn DataField="BudgetStartDate" DataType="System.DateTime" DefaultInsertValue=""
                       HeaderText="Start Date" SortExpression="BudgetStartDate" UniqueName="BudgetStartDate">
                   </telerik:GridBoundColumn>
                   <telerik:GridBoundColumn DataField="BudgetEndDate" DataType="System.DateTime" DefaultInsertValue=""
                       HeaderText="End Date" SortExpression="BudgetEndDate" UniqueName="BudgetEndDate">
                   </telerik:GridBoundColumn>
                   <telerik:GridCheckBoxColumn DataField="BudgetIsActive" DataType="System.Boolean"
                       DefaultInsertValue="" HeaderText="BudgetIsActive" SortExpression="BudgetIsActive"
                       UniqueName="Active">
                   </telerik:GridCheckBoxColumn>
               </Columns>
           </MasterTableView>
           <ClientSettings DataBinding-EnableCaching="true">
               <DataBinding EnableCaching="True">
               </DataBinding>
           </ClientSettings>
       </telerik:RadGrid>
       <asp:SqlDataSource ID="SEMBudgetSource" runat="server" ConnectionString="<%$ ConnectionStrings:myconnection %>"
           SelectCommand="SELECT [Customer], [MarginBudget], [SEMBudgetId], [BudgetStartDate], [BudgetEndDate], [BudgetIsActive], [BudgetSpent] FROM [mytesttable] WHERE ([companyid] IS NOT NULL) ORDER BY [Customer]"
           InsertCommand="INSERT INTO mytesttable(Customer, MarginBudget, BudgetStartDate, BudgetEndDate, BudgetIsActive) VALUES (@Customer, @Budget, @StartDate, @EndDate, @Active)"
           UpdateCommand="UPDATE mytesttable SET Customer = @Customer, MarginBudget = @Budget, BudgetStartDate = @StartDate, BudgetEndDate = @EndDate, BudgetIsActive = @Active WHERE (SEMBudgetId = @BID)">
           <UpdateParameters>
               <asp:Parameter Name="Customer" Type="String" />
               <asp:Parameter Name="Budget" Type="Decimal" />
               <asp:Parameter Name="StartDate" Type="DateTime" />
               <asp:Parameter Name="EndDate" Type="DateTime" />
               <asp:Parameter Name="Active" Type="Boolean" />
               <asp:Parameter Name="BID" Type="Int32" />
           </UpdateParameters>
           <InsertParameters>
               <asp:Parameter Name="Customer" Type="String" />
               <asp:Parameter Name="Budget" Type="Decimal" />
               <asp:Parameter Name="StartDate" Type="DateTime" />
               <asp:Parameter Name="EndDate" Type="DateTime" />
               <asp:Parameter Name="Active" Type="Boolean" />
           </InsertParameters>
       </asp:SqlDataSource>

[Pavlina]

Hi Joe,

Please review the online resources below and let me know if they help you to achieve the desired functionality:
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/net2datasourcecontrols/defaultcs.aspx
http://www.telerik.com/help/aspnet-ajax/grddeclarativedatasource.html

All the best,
Pavlina
the Telerik team

[Joe]

Hi,

Still didn't work.  The only new thing I added was

ProviderName

 

="System.Data.SqlClient"

 

Please review the code I've attached.  I'm hoping it's me, but I don't think so.


Thanks,

[Joe]

Hi,

Can someone assist.  I need the grid to work with the SQLSource Object.  The Select functionality works, however updating and inserting do not work.  I have attached the code.  

Can someone help me.  I'm trying to get this done.

Thank You

[Pavlina]

Hi Joe,

I suggest that you examine the code library below which represents how to perform automatic operations (update/insert/delete) with SqlDataSource control:
Automatic operations with SqlDataSource control

Best wishes,
Pavlina
the Telerik team

[Joe]

I've been through those avenues and used the examples provided.  This still doesn't work.  What am I doing wrong if anything or is there a problem with the grid.

[Pavlina]

Hello Joe,

I reviewed the provided code but I am not able to find the source of the problem there. To help you further I will need to debug the page locally. Therefore I would ask you to open a formal support ticket and send us a runnable sample for further investigation.

Regards,
Pavlina
the Telerik team

[Joe]

Hi,

Two things:

1. no code-behind that is the entire assocated code
2. My support description ran out I can't submitt a support ticket

What I did yesterday was created a test web page.  And got it working.  Now I need to recreate the webform in the application and see if it's an issue with the other controls.

Thank You,

[Joe]

Finally figure out the issue.  The bind variables of the SQLDatasource have to match exactly the same as the grid.

For example:
The Variables contain @ must be identical to the grid datafields

UpdateCommand="UPDATE myclientcenter SET Customer = @Customer, MarginBudget = @MarginBudget, BudgetStartDate = @BudgetStartDate, BudgetEndDate = @BudgetEndDate, BudgetIsActive = @BudgetIsActive WHERE (SEMBudgetId = @SEMBudgetId)">


[Pavlina]

Hi Joe,

I am glad that you have found a solution to your problem.

Sincerely yours,
Pavlina
the Telerik team

[Jack]

When I have had this problem in the past it is almost always related to the datafield names in my grid not matching up with my sqlDataSource Parameters. If the names all match the next thing you can do is to confirm that the data types in your grid match the data types of your parameters and that the data types of your parameters match the data types in your table. I have also found that checking for an error in the ItemInserted command can help point you in the right direction. For a grid called rgLeads you could do something like this

 

Private Sub rgLeads_ItemInserted(sender As Object, e As GridInsertedEventArgs) Handles rgLeads.ItemInserted
        If Not e.Exception Is Nothing Then
            e.ExceptionHandled = True
        End If
    End Sub

I then put a breakpoint inside of the If and review the value of e by hovering my mouse over it. What you put inside of the If really does not matter just anything that you can put a break point on. I am sure there is a better way but this works for me.

[Tsvetomir]

Hi Jack,

Thank you for sharing your ideas with the community on what to check first when an issue related to the Declarative Data Binding is encountered.

As a side note, when in debug mode, you can make use of the QuickWatch tool which could be used to observe variables and expressions. To open the Watch window, choose  Debug > Windows > Watch.

Kind regards,
Tsvetomir
Progress Telerik