Working sample for .net c#?

abemanden

Hi I've searched around the forum and google, and have a hard time finding a tutorial of how to make the datatable to work with .net c# + mysql.

Does any one have a working sample or a tutorial i can try out?
The ones i've tried on the forum doesn't work for some reason..

allan

There are a couple of articles that have been written by others describing how C# can be using with DataTables for server-side processing - have a look at the news feed: http://datatables.net/news.php . I'm no C# expert though, so a C# forum might be a better place to ask if you want help with the language.

Allan

Ebbs

Hi Abemanden,

Look at my post: http://datatables.net/forums/comments.php?DiscussionID=4688&page=1#Item_4

That was an example that I used for a question earlier, but you can adapt it so as to retrieve a datatable from sql and then build up a string with containing the HMTL for that table and injecting it into the innerhtml of a div tag.

Use ClientScript.RegisterStartupScript to inject the javascript/jquery needed to initialize the jeditable table before you inject the html into the div tag.

When you edit a row, it will post back a comma seperated string with all the info for that row with which you can do all the serverside processing you want. Use JSON to update the values of that row when you are done.

Kind regards
Ebbs

bikithalee

In C# the easiest way is to populate a datatable from dataset. The other ways are like create dynamic datatable through coding etc.. http://csharp.net-informations.com/dataset/csharp-dynamic-dataset.htm the link shows how to create a dynamic data table through coding.

bikitha.