This is a migrated thread and some comments may be shown as answers.

How to Create a RadScheduler using SQL dataTable

1 Answer 115 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Venkata
Top achievements
Rank 1
Venkata asked on 25 Mar 2010, 09:10 PM
Hi,
i am using Telerik.Web.UI  version: 2009.2.826.35
I have a sql DataTable which contains id,startDate,End date and text.
basically i want to display all text between the date range in RadScheduler. this is only view purpose.
I could not find any good example to use SQL DataTable.
Can any one help me please...

here is my code to get data from SQL Database

private DataTable GetSelectedCitations(string strCitationIDs)
        {
            DataTable objDT = null;
            using (SqlConnection objConn = new SqlConnection(DBConnectionString))
            {
                SqlCommand objCmd = new SqlCommand("uspCITGetCitationInfo", objConn);
                objCmd.CommandType = CommandType.StoredProcedure;
                objCmd.Parameters.AddWithValue("@ID", m_ID);
                objCmd.Parameters.AddWithValue("@CitationID", strCitationIDs);

                SqlDataAdapter objDA = new SqlDataAdapter(objCmd);
                objDT = new DataTable();
                objDA.Fill(objDT);

                objDA.Dispose();
            }
            return objDT;
        }

thanks
Ramnaa

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 29 Mar 2010, 02:36 PM
Hi Venkata,

Please, refer to the Data Binding  and Database structure help topics. You can also review the Optimized Queries demo. If you need to run it as a stand-alone project, you should follow these instructions.


Greetings,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Tags
Scheduler
Asked by
Venkata
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or