DB Connection in Jquery / JSON

Question

0.00/5 (No votes)

See more:

Dear Friends,

I need to execute a query and fill the value in Dropdownlist box.
I need to do this in JQuery or JSON not in C# end.
Can any one guide me on this please.

Posted 25-Nov-13 2:51am

Member 10318207

Add a Solution

Comments

Peter Leow 25-Nov-13 9:02am

You still need c# at the back end to query the database.

2 solutions

Solution 2

jQuery (JavaScript) cannot connect to a database such as MySQL, SQL Server, etc. in the traditional sense*.

You must have a script running on the server (in PHP, ASP.NET, etc.) that connects to and queries the database and then returns it to your client-side script over HTTP, usually in JSON, XML, CSV, or another text-based serialization format.

* There have been some ports of SQLite to javascript, which may be worth researching, but more likely are suited to server-side scripting such as in node.js.

Posted 25-Nov-13 3:39am

Yvan Rodrigues

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2013-11-25T03:35:00

Solution 1

You can't connect to Database with jQuery.

So, call one C# WebMethod by jQuery and connect to Database.
Then return one object containing all the options and then bind at client side.

Posted 25-Nov-13 3:35am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Member 10318207 26-Nov-13 1:59am

Dear Tadit Dash, As per your suggestion I have used Webmethod and accessing the same via JQuery but how get the value in array form. The existing below.

[WebMethod()]
public static string fillreqby(string dept)
{
CharbiServerData csd_sta = new CharbiServerData();
DataSet get_data = new DataSet();
SqlParameter[] param = new SqlParameter[27];
param[0] = new SqlParameter("@TYPE", "Ddl_req");
param[3] = new SqlParameter("@DEPARTMENT", dept);
get_data = csd_sta.ExecuteSPWithParameters("charbi..Usp_it_task_entry", param);
if (get_data.Tables.Count > 0)
{
if (get_data.Tables[0].Rows.Count > 0)
{
return "yes";
}
else
{
return "no";
}
}
else
{
return "error";
}
}

Where as in place of Return Yes - I need to store the value in array and bind to dropdownlist box.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 26-Nov-13 2:30am

Refer the article - Fill a Dropdownlist using jQuery in ASP.NET[^].

You have to serialize the DataTable like below...
JsonConvert.SerializeObject(dataTable);

Member 10318207 26-Nov-13 3:37am

Thank you, But can you say me where I will get the System.ServiceModel.Web.dll for supporting the JsonConvert. Also can you say me how to retrieve the data in jquery.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 26-Nov-13 4:15am

For System.ServiceModel.Web.dll - Right Click on Bin Folder -> Add Reference -> .NET Tab -> System.ServiceModel.Web

For the Data retrieval using jQuery, the article provides you the example.

Please accept this answer, if it has helped you in any way.
This will help others to find the answer in one go and you will also be awarded with some points for this action...

Member 10318207 26-Nov-13 7:03am

$.each(jQuery.parseJSON(data.d), function () {
$("#ddl_req_by").append($("<option></option>").val(this['REQ_BY']).html(this['REQ_BY']));
});

I am facing problem here, Error: Uncaught ReferenceError: data is not defined

Member 10318207 26-Nov-13 7:07am

Its not appending the data to Dropdownlist box.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Nov-13 0:09am

That means data is not received from code behind. Check the FireBug Net tab.
You can see the Ajax request there. See what is the data sent and received there.

Member 10318207 27-Nov-13 0:48am

Thank you so much, It works fine now.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Nov-13 1:44am

Great work. Most welcome. :)