I have 2 pages on my site and they are exact duplicates at least on the first part of the page with the exception of declaring an additional arraylist and a databable. Why are the results in my source code of the browser showing doubled up? These results are with the below code and the exit sub right where it is.scotking.comzlinkexchange.comscotking.comzlinkexchange.com
View 5 RepliesI have a table "yyy" in my database with one boolean attribute. I made entity data model and then added a gridview and objectdatasource to my page. I configured select, update, delete methods there. No problems with select. Works fine. Problem comes with updating.
View 3 Repliesi have one method which save datatable in viewstate.i am calling this method in. page_load2. Prerenderthe page was every heavy,i did tracing of page i found due to calling of method from preprnder it doubled the viewstate sizewhat was the reseon behind this.
View 2 RepliesI have a typical reporting application:
Large report <-- HTTP Compression --> ASP.NET Web Server <-- ??? --> SQL Server 2008
Since I have so much (repetitive) data to send to the client, I would like both network hops to have compression.
Is there a transport-level compression setting for SQL Server?
[Code]....
This results in the whole table when it should not. What am i doing wrong?
I'm working on an ASP.Net project to display information on a website from a database. I want to select the top 10 items from a news table but skip the first Item and I'm having some problem with it.
<asp:SqlDataSource ID="SqlDataSource1"
runat="server" ProviderName="System.Data.SqlClient"
ConnectionString="<%$ ConnectionStrings:ClubSiteDB %>"
[code]....
This is what I have so far but I can't find any info online about how to skip a record
I've been stuck on this one for a while, so it's time to consult the pros. I've created a charting application that uses javascript to do heavy DOM manipulation/generation on the client (creating barcharts made of colored divs, etc).
Long story short, I want to avoid sending my js library to the client. Is there any way to create the content on the server, using my existing javascript library, and only send the javascript-generated HTML to the client?
I am facing this error. My ASP.net website is running fine locally.
View 2 RepliesI have 2 tables:
Attributes
AtrributeVales
attrId(PK) name
id (PK) attrId(FK) value
1
color 1
1 green
2
size 2
2 small
3 1 red
4 2 medium
I need to build some query that will return something like this:
Color Size
Green small
Red medium
using sql server 2005.I need to output the results of a query to a csv file, how should i do this?
View 2 RepliesI just want to put together a SQL statement and load all my results into a table. I don't care about sorting or specifying which columns should be shown.
My SQL Statement changes what columns are returns, and I just want the results to show everything. I don't need bells or whistles at the moment - just all the results loaded into a table, every time.
I have a procedure that is used on a search page.. im trying to provide a highlevel resultset which you can then click on a record to view all records associated with it.
My expectation is to return 5 columns.. the ID and Date is what i want to group on.. so that if there are 10 records for ID=5 and Date=10/25/2010 then in my results i would have 1 record. Once im done with the page, you can then click on that line in the gridview to view the 10 records for that id. Does that make sense?
I have the following query, but for the criteria i entered, im getting back 3 records instead of just 2 since there is a differnet reboot count, BUT i really still just need overall data. so it should be only 1 record and seen below is what is returned and what is expected..
[Code]....
Here are the 3 records..
Currently returned
id Event Date Mount Errors Reboot Count J1939
225 11/01/2010 0 11 0
225 11/01/2010 0 11 0
225 11/01/2010 0 12 0
Expected returned
id Event Date Mount Errors Reboot Count J1939
225 11/01/2010 0 34 0
[Code]....
i want to insert the result of that query into nother table in my database. please help me find a way to do that.
I am having trouble getting a SQL query to post its results to a Session variable. I am close, but no success thus far. Here is what I have:
[Code]....
However, I keep getting this error when I click to a new page that is using this "PracticeID" Session variable: No mapping exists from object type System.Data.SqlClient.SqlCommand to a known managed provider native type.
I am executing the following T-SQL code, which runs successfuly according to message I see at end of its execution, but the file c:cptest.txt is never created. I have checked for this file and it doesn't exist. what is the issue here?
EXEC MASTER..xp_cmdshell 'bcp "SELECT top(10) from Person.Address" queryout "C:cptest.txt" -T -c -t,'
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. ' ' .
I have 3 procedures.
1. SP_General - Gives the output with 3 columns like: ID NAME DOB with multiple rows
2. SP_HTML - Gives the HTML formatted output like: <table><tr><td>ID</td><td>NAME</td><td>DOB</td></tr></table>
3. SP_Email - Sends email (written by using extended stored procedures). Input parameters: Body, etc
When I DO:
1. EXEC SP_Email @Body = 'Hello this is testing'. I recieve the email saying: Hello this is testing
2. EXEC @Results = SP_General
EXEC SP_Email @Body = @Results. I recieve the email saying: 0
3. SELECT @Results = EXEC SP_HTML
EXEC SP_Email @Body = @Results. I recieve the email saying: 0
4. SELECT @Results = '<table><tr><td>ID</td><td>NAME</td><td>DOB</td></tr></table>' (If hardcoded like this)
EXEC SP_Email @Body = @Results. I recieve the email with correct output in a nice formatted table: ID NAME DOB
Its working in 1 and 4 cases but not 2 and 3. As I cannot hardcode like that, can anyone tell me where I'm doing mistake in 2 or 3 cases?
I am running a sql script which Inserts 500 rows and after each insert, it calls a stored procedure which diplays result in the results window. So after executing 100 rows, it throws an error that maximum number od results in the results pane has reached its limit but the query executes successfully. How can we disable the stored proc output to not display in the results pane. I do not have access to the stored procedure.
View 4 RepliesI am having a lot of trouble with a seemingly simple thing. In an ASP.NET webform I have two ListBoxes, with Add and Remove buttons in between. The user can select items in one ListBox and using the buttons, swap them around. I do this on the clientside using javascript. I then also have a SAVE button, which I want to process on the server side when the user is happy with their list.
Problems : First I was getting the following problem when I clicked SAVE :
Invalid postback or callback argument. Event validation is enabled using in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation. I read that one of the methods to get around this was to put my ListBoxes into an UpdatePanel, which I did, and I am getting further.
However, now the event handler for the button's Click event is not being run if the user has used the clientside javascript to alter the contents of the Listboxes. If the user has not altered the contents of the listboxes, the handler does execute.
[code]....
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 RepliesI am actually using 2 type of queries in my website e.g
These Queries are from my stored procedures
SELECT * FROM TblName WHERE FREETEXT(ColumnName, @parameter)
AND
SELECT * FROM TblName WHERE CONTAINS((Column1, Column2), @parameter))
I have enabled Full Text Indexing on my tables both local and on my hosting company MS SQL Server.
The above queries are working fine on my local database and return results but these queries return nothing when i try to run them on hosting company MS SQL Server.
I have identical data on both MS SQL Servers and both servers are 2008.
In VS2010, when I "find in files", I often get doubled results in my find window.
View 5 RepliesI 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 RepliesWe are deveopingawebiste in asp.net. There are tempelates of each aspx page made in the form of excel sheet. Upon completion of the online calculation, the user is to be allowed to export the results to excel and save them. There would be obviously no formulae in such sheet
I do not want to install Excel on theserver and instead want to utilize the Excel installed on the user's computer for this purpose as every user's computer is expected to have Excel installed. Is this possible to do? How to do this?
I am not an expert in this. let me know if you would need any more information or clarification.
In my asp.net project I need to call another url with a parameter and display what the url returns in a label. What is the easiest way to do this?
View 2 Replies