Drill down functionality stored procedure

[Tim]

Dear Telerik,

I'm following your demo on 
http://blogs.telerik.com/aspnet-ajax/posts/13-05-07/how-to-implement-drill-down-functionality-in-telerik-s-pivotgrid-for-asp.net-ajax-part-1

My question is how can I modify my code to use stored procedure with parameter selection if I have a sqldatasource in the aspx page in front?

Thanks for the assist.

Best regards.

[Tim]

Hi All,

I figured to syntax which will be 

 [quote] public DataTable GetDataTable(string PivotFilter)
        {
            String ConnString = ConfigurationManager.ConnectionStrings["Telerik"].ConnectionString;
            SqlConnection conn = new SqlConnection(ConnString);
            SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = new SqlCommand("SP_Telerik", conn);
            adapter.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;

            DataTable myDataTable = new DataTable();
            conn.Open();
            try
            {                
                adapter.Fill(myDataTable);
            }
            finally
            {
                conn.Close();
            }
            
            return myDataTable;
        }[/quote]

However, my new problem is the myDataTable is always null, any thought?


Cheers.

[Konstantin Dikov]

Hello Tim,

Thank you for contacting Telerik Support.

I am glad to see that you were able to fix the initial issue.

As for your new problem, since the data retrieval is not related to our controls in any way, the only thing that we can suggest is that you take a look at the following help articles and ensure that your stored procedure is correctly set:

• How can i retrieve a table from stored procedure to a datatable 
• How to Populate a DataTable from a Stored Procedure 
• SQLDataSource call stored procedure in code behind

Hope this helps.


Regards,
Konstantin Dikov
Telerik