how to use jquery to write sql queries. consider a webservice call using jquery to asp.net webservice, sending an sql query and getting back the results in json format. but there's a problem with the connection string because it must not be available if a user views the source of the page.
View 1 Replies
Suppose we want to select the data from the database then we write the query for that. Example:
SqlConnection con=new SqlConnection(Connetion name) string selectPkId = @"SELECT PK_ID FROM TABLE" SqlCommand cmd=new SqlCommand(selectPkId ,con);
So,my question is that why we basically use @ before the sql query.If I don't use @ before that then it again work fine (does not give any error), then what is need of using "@"?
SELECT 1000000*QuantityNC/Quantity AS PPM FROM [table1] However I need my WHERE clause to do thisI need the above calculation depending on BusUnit, which is linked to PartNumber, which is in the above table. also it has to be by Company (which is selected from a dropdown). And also based on the current month and year.
PartNumber and CompanyName are in [table1]
BusUnitID, PartNumber, SupplierID, are in tblParts
BusUnitID and BusUnit are in tblBusUnits
eg: thiss is the ordinary query
[Code]....
how in linq??
Is it possible to write multiple queries on a single button click? if yes then how?
View 5 Replies i'm trying to write out an html output using jquery from a table
see below
[Code]....
On the alert msg i can print out
[Code]....
But i don't want to append it to any <div> or any element.I just want it to output the html to the screen.
I'm doing tis because i have a jquery that displays the blockquotes and if i have a parent DIV or any other element it doesn't work.
How can i achieve this
<a href="" onclick="openMyModal('~/DocMove.aspx?a=5'); return false;">Document Move</a>
onclick="openMyModal('~/DocMove.aspx?a='); return false;
var= 12
onclick event with parameter pass in
ocMove.aspx?a=f
UPDATE:
The service cannot be activated because it does not support ASP.NET compatibility. ASP.NET compatibility is enabled for this application. Turn off ASP.NET compatibility mode in the web.config or add the AspNetCompatibilityRequirements attribute to the service type with RequirementsMode setting as 'Allowed' or 'Required'.
when i try to access wcf service i get this error: the reason is HttpContext.Current is null, what should i do in this case?
Object reference not set to an instance of an object.
System.Web.Script.Serialization.JavaScriptSerializer s = new System.Web.Script.Serialization.JavaScriptSerializer();
Person p = new Person() { FirstName = "First name", LastName= "last name" };
string json = s.Serialize(p);
System.Web.HttpContext.Current.Response.Write("jsoncallback" + json);} //error
How to create progressbar in jquery + Asp.net(C#) without adding progress plunging.
View 2 RepliesIs it mandatory to write $(document).ready(function () {... }) every time ?
Can't we do it without this line?
I am trying to write an ajax based tooltip for a website. The JS file searches the html page for certain keywords, which are fetched from an xml file. The keywords are searched using searchhighlight Jquery plugin. Then I use ajax to fetch the description of that keyword (or help) from aspx file(which just parses the xml doc for description of keyword)
I have been able to do everything except position the call to my mousehover functions. What has been happening is, when I hover over the first word, the tooltip gets displayed properly, but when I go over to the next word, the first tooltip gets displayed for a split second before the new tooltip loads. how to resolve the issue and make my code run smoothly? Here is the js file:
[Code]....
i need to be able to expose information to a page, and I need to write the information in xml on my webserver which will be dynamically created from the database.
I need to use json to pass the data from the screen back to the server two way communication xms back and forth. Is it actually any good using a wcf endpoint to serve the json back to the page and use query with wcf? Is this possible?
Or is it easier to use standard pages .aspx and just do a call to a url and get the json with jquery....
We will probably want to send this information to other locations at some point in the future too....
I have a usercontrol with an asp.net checkbox in it. I'm attempting to write a jquery script to convert that normal checkbox into a three-state checkbox. The states are 'checked', 'unchecked', and 'intermediate'. Clicking on an intermediate state should change the state to checked, clicking on an unchecked state should change the state to checked, and clicking on the checked state should change the state to unchecked. My idea was to be able to insert a normal asp.net checkbox into the page and then call the jquery function to make it three-state.
Here's my jquery function, which is rough but working:
function SetTriStateCheckBox(checkboxfinder, initialval, originalCkbxUniqueID) {
var i = 0;
var chks = $(checkboxfinder);
if (initialval){ chks.val(initialval); }
chks.hide().each(function() {
var img = $('<img class="tristate_image" src="../Images/tristateimages/' + $(this).val() + '.gif" />');
$(this).attr("checked", ($(this).val()=="unchecked"?"false":"true"));
$(this).attr("name", "input" + i + "image" + i);
img.attr("name", "" + i + "image" + i);
i++;
$(this).before(img);
});
$(".tristate_image").click(function() {
t = $("[name='input" + $(this).attr("name") + "']");
var tval = t.val();
$(this).attr("src", "../Images/tristateimages/" + (tval=="checked" ? "unchecked" : "checked") + ".gif");
switch (tval) {
case "unchecked":
t.val("checked").attr("checked", "true");
break;
case "intermediate":
t.val("checked").attr("checked", "true");
break;
case "checked":
t.val("unchecked").removeAttr("checked");
}
setTimeout('__doPostBack('' + originalCkbxUniqueID + '','')', 0);
});
}
Here's a simplified version of my OnPreRender event handler which registers a startup script:
protected override void OnPreRender(EventArgs e)
{
string tristatescript = " SetTriStateCheckBox('input[id$="ckbx1"]', 'intermediate','"
+ ckbx1.UniqueID + "'); ";
ScriptManager.RegisterStartupScript(this, this.GetType(), "ckbx1_tristate", tristatescript, true);
base.OnPreRender(e);
}
Everything seems to work correctly, except that I'm not hitting the event handler of the original checkbox when I post back, after clicking my newly inserted image. It does hit Page_Load. If I take out the .hide() part of the jquery, and click on the original checkbox, Request.Params['__EVENTTARGET'] is the same as when clicking the newly inserted image.
I am working on a feature to throw a warning message if the user has unsaved values in a form. I can see that in the next post there is a explanation about how to do that [URL]now the problem is that i need to do the same but using a ascx control and i don't know where put the next code in my ascx control.
<body onunload="checkSave()">
NB: I'm working on dnn so that i don't have any change to add this code in the parent page of the control.
I need to to export a file to the user. It takes 1-2 min to generate the file so I'd like to have the page go into a kind-of modal mode with a layover on the page and a 'Working' spinner showing. The problem is I can't make the modal stuff go away after Save File dialog is closed.
How can I remove the layover after the dialog is done?
I am reading in a file into a string. Then I am writing this string to a stream. I know this code works fine.
The only problem that I have is with the line that write the data in chunks where the parameters is not supported for the Write method.
The line that has the problem is this line. What do I need to change here?
OutPut.Write(buffer, 0, Math.Min(to_write, WRITE_CHUNK));
[Code]....
i am calling a function which is inside Homescroll.ascx.cs from Homescroll.ascx so i wrote on Homescroll.ascx as <% Response.Write(scroll()); %> but all this is in update panel,and i am getting errors. so is their any other way to call function from homescroll.ascx to homescroll.ascx.cs,instead of response.write();
View 3 RepliesI've added a database to one of my projects and I'm wondering how I can get intellisense for them.
Basically I have no how I can query the database that I've added to the project. I know SQL fairly well, but I don't know how I can write queries within vb.net and have them display.
I can get, so intellisense will probably be invaluable.
I have a query which gets the text from a textbox and inputs it into the database.
It works fine if the value is something like Taylor but errors when it's O'Neill because the apostrophe gives a syntax error unclosed quotation mark Is there a way to add O'Neill to the database with the apostrophe still there?
I don't want to replace it with a double single quote I want it to be put in the database as it shows.
I want to write a page where user's can write a blog post and publish it to the blog. I've downloaded blog engine .NET and looked at the code and I like the way they do it, but it's completely an overkill of what I need. What I need is only a title, author, date, and the blog post it self. I don't even want users to post comments or anything like that. My approach is to save all those blog post information into an xml and then when a page loads it loops around those xml files to show the blog post.
View 1 RepliesWhat would be equivalent linQ query for:
I am using linQ for get these data to silverlight so I cant use execute query in silverlight and have to go with LInQ. can someone point me for easier way to convert similar queries or any tips.
[code]....
In my web application, I need to run a lot of sql queries for a specific operation. For example, first I run a select command , get results. If they fulfill my requirement, I insert some values by insert command, else I update and insert...and so on. I need to execute 8-10 commands for each specific operation. For this , I have created a <asp:Sqldatasource> in aspx page and I run queries by SqlDataSource1.Select, SqlDataSource1.InsertCommand etc. I dont think , its a right approach . Further, I need to preserve data consistency. Say my 5 commands executes successfully and then sql or something else, throws an error and 5 commands left untouched. Then, it will create me a problem. And my current logic will fail, as it works on step by step basis.
View 3 RepliesWhen i see MVC Music store. They have used ADO.NET entity data model and used LINQ language to perform operation in DB.. Is there any way to use normal sql queries?
View 3 RepliesI'm going to try to use the WebClient object in .NET to grab the response querystring values sent back by the resource.
I'm familiar with grabbing xml, json, etc. but typically I haven't worked with many NVP type of APIs in terms of grabbing the query immediately from an response sent back from a resource server-side. So how is a query sent back, in the body of a response, header, what? How do you grab it, with the stream object just like you do anything else? This questions relates to the environment I work in C# but really it relates to the web as a whole as well which is why I tagged this in multiple categories as a Request/Response is not MS specific however I am also at the same time trying to utilize the .NET WebClient object.
How to convert SQL Queries to Linq.is their any tool available to convert SQL Queries to Linq
View 2 Replies
