how to use sql select statement in java script with using sql server

Question

0.00/5 (No votes)

See more:

, +

Hi,

I am using vs2010,asp.net and sql server 2008.

how to use sql select statement in java script using sql server 2008.

how to get datatable form above select statement.

help will be appreciate .......

Regards
Mukesh

Posted 16-Jun-13 23:57pm

mukesh_panth

Add a Solution

Comments

Zafar Sultan 17-Jun-13 6:02am

What exactly you want to achieve? Since javascript is a client side scripting language it can not directly call select statement using sql server. If you will tell us what is your requirement, we might help you in an alternate way. BTW, have you written some code for it?

mukesh_panth 17-Jun-13 7:20am

i have an array and my requirement is to use it datatable so that i can fire query on datatable..

2 solutions

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)

Prasad_Kulkarni · Answer 1 · 2013-06-17T00:00:00

Solution 1

Please refer following thread:
sql query using javascript[^]

Posted 17-Jun-13 0:00am

Prasad_Kulkarni

mukesh_panth · Answer 2 · 2013-06-19T04:09:00

Use simple page method ................

use sever side code........in .aspx page

using System;
using System.Web.Services;

namespace GoogleChartASPDEMO
{
public partial class _Default : System.Web.UI.Page
{

[WebMethod]
public static string PerformDatabaseQuery(string strpass)
{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand cmd = con.CreateCommand();
con.Open();
cmd.CommandText = " SELECT * FROM Shipments_Data ";

cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable Dt = new DataTable();
Dt = ds.Tables[0];
con.Close();
}
}
}

client side code .................

$(document).ready(function () {
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
data: "{strpass:'" + pass_value + "'}",
url: "Default.aspx/PerformDatabaseQuery",
dataType: "json",
success: function (data) {
alert("success")
},
error: function (result) {
alert("Error");
}

use this code..... it is useful ....