Using DataTable with Microsoft SQL Server Database

Vuggi

Hi,
I am interested to use your Framework, but I have some questions.

I tried to search but could not find anything about.

I would like to connect to a SQL database and fill a table with the result of some query.

I can do it? how do I implement it?

I apologize for my bad English. I speak another language.
Thanks for your attention.

equisde

Hi,

DataTables is a plug-in for the jQuery Javascript library. That means you need to create a web application (i.e: ASP.NET/C# project for website) and add the plug-in and libraries into the headers webpage source code. This way you can integrate one or more tables in the web page just configuring them in the initialisation code.

Once is done, you will need to create the connection strings to the database and the SQL statement that gets the desired data from the db and fill the datatable with this data.

Vuggi

Thanks for responding to my question.

[quote]equisde said: DataTables is a plug-in for the jQuery Javascript library. That means you need to create a web application (i.e: ASP.NET/C# project for website) and add the plug-in and libraries into the headers webpage source code. This way you can integrate one or more tables in the web page just configuring them in the initialisation code.[/quote]

I've created a web application (specifically asp.net MVC project) and have already done the basic tests on the plugin. I know how it works and how to implement it in its basic form.

tricks like this:

[code]

$(document)...
$('#example').dataTable();
...



...

[/code]

I know how they work and I can easily make them.

Instead, things like this:

[quote]equisde said: Once is done, you will need to create the connection strings to the database and the SQL statement that gets the desired data from the db and fill the datatable with this data.[/quote]

are a little problem for me. because I did not understand how to implement them correctly.

can you show me an example or link me a guide?

Sorry for bad english..

allan

If you are stuck on how to get the information out of the DB, I'd suggest reading through a few tutorials on SQL server and whatever server-side environment it is that you are using. This forum is specifically about DataTables, and we can't offer any help for wider topics such as SQL Server, C# etc.

Allan

Vuggi

[quote]allan said: If you are stuck on how to get the information out of the DB, I'd suggest reading through a few tutorials on SQL server and whatever server-side environment it is that you are using. This forum is specifically about DataTables, and we can't offer any help for wider topics such as SQL Server, C# etc.[/quote]

Thanks alan,
I apologize if I went off topic or have not followed the rules.

knowing that I can use your plugin for my projects and know what to look for is enough for me.

You are doing a great job on this plugin. Thank you again!