SQL Server database to kendo Data Source

Thread is closed for posting
12 posts, 0 answers
  1. Pradeep
    Pradeep avatar
    3 posts
    Member since:
    Jan 2010

    Posted 25 Jan 2012 Link to this post


    I will make my query really simple,

    I have a database in my local sqlServer

    I need to bind a table to Kendo Data Source using sql connection

    Is there any way to achive this ?

    please post a sample application in asp.net.
  2. Bobby Pack
    Bobby Pack avatar
    2 posts
    Member since:
    May 2008

    Posted 25 Jan 2012 Link to this post

    https://github.com/telerik/kendo-examples-asp-net
  3. Kendo UI is VS 2017 Ready
  4. Pradeep
    Pradeep avatar
    3 posts
    Member since:
    Jan 2010

    Posted 31 Jan 2012 Link to this post

    Thanks Bobby Pack ,

    I was able to create a grid and managed to show data in the grid.

    But was not able to do create, update or delete.

    Moreover when I give the model in schema data wont populate.

    Please let me know where did it went wrong.

    I am also attaching the files I have created
  5. Bobby Pack
    Bobby Pack avatar
    2 posts
    Member since:
    May 2008

    Posted 01 Feb 2012 Link to this post

    I do not know, haven't made it that far yet.
  6. Chris
    Chris avatar
    10 posts
    Member since:
    Jul 2011

    Posted 01 Feb 2012 Link to this post

    It would be nice if we could get some projects that are hooking up asp datasource controls to a kendo data source (or even just an example showing how to hook up kendo data source to a connection made via C# (for example, an SQL connection that is filling a data table) Is this a possibility?
  7. Atanas Korchev
    Admin
    Atanas Korchev avatar
    8462 posts

    Posted 02 Feb 2012 Link to this post

    Hello,

    Kendo UI widgets cannot be bound to the SqlDataSource control. The latter supports only ASP.NET controls. 

    You can check the following project that show Kendo UI grid CRUD configuration in ASP.NET:
    https://github.com/telerik/kendo-examples-asp-net/tree/master/grid-page-methods-crud
    https://github.com/telerik/kendo-examples-asp-net/tree/master/grid-wcf-crud
    https://github.com/telerik/kendo-examples-asp-net/tree/master/grid-web-service-crud


    Regards,
    Atanas Korchev
    the Telerik team
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
  8. Chris
    Chris avatar
    10 posts
    Member since:
    Jul 2011

    Posted 02 Feb 2012 Link to this post

    Atanas, 

    Thanks for your response, it lead me in the right direction. However, I am not sure how the WCF service was generated in the grid-wcf-crud example, I chose to use open access to generate my .svc and so my .cs files are quite different and it's difficult for me to figure out how to update the javascript to use my service since our generated service files are so much different (at least to an intermediately skilled developer such as myself). Is there any way someone could throw together the example but using open access to generate the service? It only took me a couple minutes to generate the service with open access so I wouldn't think it would take much time to get a project set up that way.


    Thanks!
  9. Atanas Korchev
    Admin
    Atanas Korchev avatar
    8462 posts

    Posted 06 Feb 2012 Link to this post

    Hi, 

    I just created a project which shows how to use an OpenAccess service with the Kendo Grid. There are a few modifications required in order to make things work:
    1. The service endpoint needs to be accessible via the browser (by default it is not). Check the web.config.
    2. The Create method should return an instance of the DTO and set its identity property (ProductID in this example). Check the CreateProduct method.
    3. The DtoKey property must map to the value of the key itself. The default Converter should be modified a bit.
    Regards,
    Atanas Korchev
    the Telerik team
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
  10. Adam
    Adam avatar
    1 posts
    Member since:
    Feb 2012

    Posted 27 Feb 2012 Link to this post

    Is there anyway to create these services in Java rather then c#?
  11. Roger
    Roger avatar
    183 posts
    Member since:
    Sep 2007

    Posted 28 Feb 2012 Link to this post

    Hi,
    am trying to run the demo "grid-web-service-crud" and get an error that "Cannot serialize interface System.Collections.Generic.IEnumerable".


    But have found the problem...am using SQL Server 2008 R2 instead of Express and it doesn't like User Instance in the connection string
  12. fedonman
    fedonman avatar
    4 posts
    Member since:
    Aug 2012

    Posted 03 Aug 2012 Link to this post

    Hello,
    i am quite new to web development, so this may sound silly.
    If you have a sql database and fetch the data with php, is it a bad practice to populate a javascript item with php<->js interaction, and pass this item as the data of DataSource?
  13. Agostino
    Agostino avatar
    1 posts
    Member since:
    Aug 2012

    Posted 18 Aug 2012 Link to this post

    In the links of this thread we can understand how to access a "Northwind" sample database whose file is included in the project.

    Could you please make an example of the <connectionStrings> content in web.config, if I want to connect to a remote Sql server database? And how does the rest of the code change in this case?

    Thanks a lot for any feedback.
Back to Top
Kendo UI is VS 2017 Ready