C# - Use XMLHttpRequest To Execute A SQL Query And Return The Results?
Feb 9, 2011
I'm building a web app for my company that will run a query every few seconds against SQL Server, and the data that it returns is which database is restoring and how much % complete it is. I have the query already set up and it works fine.
What I want to do is on my Web Form, have a "div" element that will contain the % complete of a database restore, and have it update every few seconds using the JavaScript timer object:
setInterval(function, interval)
I figure I would need to use XMLHttpRequest to send the request to the web server which will run the SQL query. Am I on the right track? How would I even start to do this?
My SQL query is below:
Use master
Select der.session_id, der.command, der.status, der.percent_complete, *
From sys.dm_exec_requests as der
Where percent_complete > 0
View 1 Replies
Similar Messages:
Feb 13, 2014
I have a array list and am using like a database trying to search for ChildID and ParentID based on certain criteria.
My example below has the following keywords to search for:
Yellow, Mustard, Honey, Orange, Flame, Talisman
I also have a category volume value which I grab the first 2 characters to determine another filter.
My code isn't returning all matches with using 'Contains'. Right now it finds the 'Orange, Flame, Talisman'/AV record and returns 50, 28. My keywords also has 'Yellow, Mustard, Honey'/AV which should return 55 and 28 as well.
HTML Code:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="temp2.aspx.vb" Inherits="temp2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
[Code] ....
View 4 Replies
Sep 7, 2010
I cant seem to find a good example of how to build the query logic. We are allowing users to search based on lat/long and need to add radius as another parameter. So you enter 29.30125 as the latitude and -95.04590 as the longitude and pick say 15miles as the radius, i need to return all records that fall within that radius.. can someone suggest a good site to review this type of query?
View 1 Replies
Sep 15, 2010
How can I execute a stored procedure using sqldatasource and get the return value in vb.net.
View 2 Replies
Aug 31, 2010
A co-worker of mine just came back from a SQL Server Reporting Services class (we are using SQL Server 2005). In that class they were told that if they had a one to many relationship that they would have to flatten the results into one row of the resultset in order to show the 'many' portion of the relationship. For example, my company has two tables:Jobs Notes/Memo'sor each Job we can have 0 or more Notes/Memo's.According to my co-worker the Report Server must have each of the Notes/Memo's in one row of the resultset. That we therefore have to flatten the list of Notes into Note1, Note2, Note3...etc fields.Is this correct? How would I handle a situation where I didn't know how many Notes there were?
View 6 Replies
Aug 9, 2010
[Code]....
The code:
[Code]....
[Code]....
I getting the error:ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near
'@P1'.
View 2 Replies
Feb 27, 2011
i want my query to return results where the field address is not empty or null
however, the query i have is still returning results where address is empty i.e. ' ' .
View 2 Replies
Oct 15, 2010
It seems like this would be fairly straight forward. I've got a gridview that loads up using one stored proc, but I've got a searchbox to filter the grid, and when the user enters some criteria I want to use a different proc to return the results. Something tells me I should be doing this with one procedure, but I can't seem to make that work either. When the form loads, my grid is populated. And if I leave my search criteria blank and search anyway, my grid is still populated correctly. But if I enter search creteria, I get diddley squat. What gives? Here is the relevent snippets.
[Code]....
View 1 Replies
Feb 2, 2010
I've been reading around, and it sounds like this is somewhat common, though I'm missing something.
I have my filtering rerouted to my codebehind via DataGridSource_Selecting event handler per
http://weblogs.asp.net/scottgu/archive/2007/09/07/linq-to-sql-part-9-using-a-custom-linq-expression-with-the-lt-asp-linqdatasource-gt-control.aspx
I have a set of controls on my page, Start Date, End Date, User, Status
Start and End Date are expected to always contain a value
User and Status I want to also have an 'All' option, where in it would return all results/not filter.
One method I can think of using for this, is the put the queries in a If scenario, where
if(user == All), use linq query B
if(user != All), user linq query A
where linq query A contains the filtering on Users, and linq query B does not.
What I have so far is
[Code]....
What I need
[Code]....
where User == ??,
can the control that populates that contain a wild card option as well? ie *, so that if user == Name, it filters on Name, or if user == *, it returns all?
View 2 Replies
May 25, 2010
I am working on asp.net 3.5 and in MVC using Linq to SQL classes. In my MVC project i am calling stored procedure using linq to sql that conatin query joining two tables.Below is my code in Partial class
[
Function(Name="dbo.GetUserWiseThreadDetail_SP")]
[ResultType(typeof(Thread))]
[ResultType(typeof(Reply))]
public
IMultipleResults GetUserWiseThreadDetail_SP([Parameter(DbType="VarChar(30)")]
string userID)
{
ExecuteResult result = this.ExecuteMethodCall(this,
(MethodInfo)(MethodInfo.GetCurrentMethod())), userID);
return ((IMultipleResults)(result.ReturnValue));
}
In one of the controller i have made one more class
public class
MypostIndexData
{
public
IEnumerable<Thread> Thrds {
get;
set; }
public
IEnumerable<Reply> Repls {
get;
set; }
public MypostIndexData(IEnumerable<Thread>
thrds,IEnumerable<Reply> repls)
{
this.Thrds=thrds;this.Repls=repls;
}
}
finally coding of controller action method
ForumDataContext pmforum = new
PMForumDataContext();
public
ActionResult MyPosts(string userId)
{
IEnumerable<Thread>thrds;
IEnumerable<Reply>repls;
IMultipleResults result = pmforum.GetUserWiseThreadDetail_SP(userId); (this satement doesnot give any result,if i execute stored proc in
sql it give the results)
thrds = result.GetResult<Thread>();
List<Thread> thrdlist =
new
List<Thread>(thrds);
repls = result.GetResult<Reply>();
List<Reply> replylist;
if (repls !=
null)
{
replylist = new
List<Reply>(repls);
}
return View(new
MypostIndexData(thrds,repls));
I am unable to understand why i am not getting any results?
View 5 Replies
Jan 24, 2011
I need to excute one insert query basend on two different if conditins. If one of them conditions is true then excute block of code.
For Example,
if exists( select * from tablename where docid = @docid and adv_feed <> 'sent' ) or
if not exists (select * from usaa_audit_fields_log where docid = @docid)
begin
insert statement
end
I have tried using OR statement between them but it doesn't work.
View 2 Replies
Mar 17, 2011
datacontextclass dc=new datacontextclass ();
var news= dc.GetNewsCompany(Int64.Parse ( _idCompany));
if (news.GetEnumerator().MoveNext())
{
foreach (var item in news)
{
drpListNews.Items.Add(item.Title);
}
}
return error:{"The query results cannot be enumerated more than once."}
how can check result != null in LINQ;
View 3 Replies
Jun 3, 2010
I have five(5) asp.net textbox
example: textbox1,textbox2,textbox3,textbox4,textbox5
if (textbox1) has contain some value i need to execute some query and like this i need to check if textbox2 is contain some value and textbox1 is contain some value then i need to execute query based on textbox2... now we left query which has on textbox 1 coz now textbox 2 has value and like this i need to check if textbox3 is contain some value and textbox2 is contain some value and textbox1 is contain some value then i need to execute query based on textbox3...now we left query which has on textbox 1 and 2 coz now textbox 3 has value.
i need to check if textbox4 is contain some value and textbox3 is contain some value and textbox2 is contain some value and textbox1 is contain some value then i need to execute query based on textbox4...now we left query which has on textbox 1 and 2 and 3 coz now textbox 4 has value.
i need to check if textbox5 is contain some value and textbox4 is contain some value and textbox3 is contain some value and textbox2 is contain some value and textbox1 is contain some value then i need to execute query based on textbox5...now we left query which has on textbox 1 and 2 and 3 and 4 coz now textbox 5 has value. so let me know how to achieve this.
View 3 Replies
Aug 24, 2010
I've a resultset that returns some 55 rows which is typically a dynamic query like [Select column_name from table_name where column = condition].
I need to execute this query which is in resultset and insert the value of column_name into another table.
I dont get the way as how to make it. Kindly suggest me as how can I execute it.
View 1 Replies
Apr 12, 2010
Is there any possibility to execute the job in sql server. I want to create the Job. then through the quer i want to execute this Job by passing parameters. can we able to do this.Actucally i want to execute the SP from front end. but suddenly it should respond to the page. but that SP will run for nearly 5 minutes.
View 1 Replies
Dec 14, 2010
I have table for past four years. It had a records for around 10 Lacks it was taking lot of time to execute so i removed recordes from the table. Table size was reduced to 29 thousand. Still when i execute a query from my application it takes more than 2 minutes to return.
View 4 Replies
Dec 1, 2010
The SQL is below - each result is coming up 3 times rather than just once.
SELECT Consignments.LegacyID, TripDate, CollectionName, DeliveryName, Pallets, Weight, BaseRate, Consignments.FuelSurcharge, AdditionalCharges, BaseRate * Quantity AS 'InvoiceValue', Consignments.Customer, InvoiceNumber,
CASE
WHEN child.LegacyID = Consignments.Customer THEN child.LegacyID
WHEN parent.LegacyID = Consignments.Customer THEN parent.LegacyID
ELSE this.LegacyID
END AS 'InvoiceAcc'
FROM SageAccount this
LEFT JOIN SageAccount parent on parent.LegacyID = this.InvoiceAccount
LEFT JOIN SageAccount child on this.LegacyID = child.InvoiceAccount
JOIN Consignments on (Consignments.Customer = this.LegacyID AND this.Customer = 'True')
OR (Consignments.Customer = parent.LegacyID AND parent.Customer = 'True')
OR (Consignments.Customer = child.LegacyID AND child.Customer = 'True')
WHERE (this.LegacyID = @Customer) AND (TripDate BETWEEN @fromdate AND @todate) AND (InvoiceNumber IS NOT NULL)
The SQL was given to me for another similar query, but this time I have modified it to try to use it for the query I'm doing now, so I'm assuming that I'm doing something stupid.
View 2 Replies
Mar 5, 2011
I have a query using LINQ-to-SQL. It queries an underlying database table Rooms. It uses Where conditions to narrow down the results, namely:
Gender.
Current Occupancy < Max Occupancy
Available Flag is Checked
I know this should return results but it keeps returning an empty set. Any ideas? Code is below
Dim selectedHalls = (From sh In dbHalls.Rooms _
Where sh.gender = Session("gender").ToString _
Where sh.max_occupancy > sh.current_occupancy _
Where sh.is_available = 1 _
Select sh.building_name).Distinct()
UPDATE: I've verified that the issue is with the statement where sh.is_available = 1, which doesn't make sense since this is a bit field.
View 3 Replies
Oct 2, 2010
I've managed to use my MS Access database with repeaters and gridviews in my website. Basically, printing the result of a query directly to the website seems easy enough using something like this :
[Code]....
After quite a bit of googling this seems to be a common way to do this. My question then seems kinda silly.
I want to use some of the data from the query in for example a variable without sending the data to a repeater or gridview and so on. Say I just want the username and a password from a database and want to store the username in one variable and the password in another for further use in the code. What do I do?
View 1 Replies
Jan 26, 2011
I can't seem to change the order of the results coming back from a linq to sql query, I want just to return the distinct values from the field x.manufacturer in alphabetical order, this is what I have and it isn't working:
public IQueryable<string> Dropone()
{
return (from x in CAT.CatalogueDatas
where x.Parent == null
orderby x.Manufacturer
select x.Manufacturer).Distinct();
}
Currently I get the distinct values in non-alphabetical order, in fact I'm not sure what order they're coming out in, don't think it's the order in which they appear though.
View 5 Replies
Mar 11, 2011
i query a database for retreiving all the columns. I will probably have many rows. Im trying to output the query results into an html table. This is what i have so far:
[code]....
How could i store the many rows and output them using html as soon as i open a page?
View 3 Replies
Aug 2, 2010
I have an asp.net intranet site hosted on IIS on my computer.
On one page you can enter two user id's and get a side by side comparison of their roles in our (custom app) system.
I often use it to add roles when I'm setting up new users. After running the query, if i change a role and run the query again it will not show updated results. It's being cached somehow. I have to go to another page and come back and them run the query to get updated results.
How can avoid having to navigate away to get the updated query results displayed.n
[Code].....
View 2 Replies
Jan 16, 2011
I have a Query which I run as an SQL. This is my SQL:
"SELECT COUNT(*) As NoDup FROM [XXX Dir] WHERE (FileName Like 'XXX_YYY_20100916.txt')"
The "XXX Dir" is a table and "FileName" is a text field within that table.
When I execute the SQL in the Query development windows, it returns a single value like 2.
I would like to assign that value to a variable so I can use it in my VB code.
View 1 Replies
May 19, 2010
I am working on a website hosted with GoDaddy, SQL Server 2005. I have a table in my SQL Server database with a full-text index. On my website, a user can type in search terms and the terms are then passed to a stored procedure in the database which performs the search. The first search takes about 45 seconds to get results. Subsequent searches return results immediately. I found a description of this problem in a Microsoft knowledgebase article:http://support.microsoft.com/kb/915850/en-usGoDaddy tech support says I need to purchase a dedicated server to make the changes suggested in this article.Surely there is some other solution. Does anyone know how to avoid this delay without changing the server configuration?
View 1 Replies
Mar 16, 2011
I am trying to loop throug multiple sql server instances (connections) and execute one query for all those connections and ouput in one grid.I am using checkboxes to show all of my connections. So far i have the following code: ( but the code only just executes the query on the first selected instead of the 2 or more selected connections.
Sub executesqlquery()
Dim instance As String
Dim instance1 As String [code]....
View 4 Replies