DataSource Controls :: Does Not Perform A Session Based SQL Connection?

Mar 4, 2010

(1) "...this application is a very heavy SQL application, it does not perform a session based SQL connection, instead for every request it refers back to the base confirmation file on the web server and then opening or making a new SQL request the result being a very chatty SQL client!"(2)..." concerns specifically relating to the chattiness of the SQL client app. Please be cautious when "testing" the product for it may have a negative effect even on [the] faster WAN links"C. Example of Code(1) from a class helper file:

public Product GetProductByName(string name)


View 4 Replies

Similar Messages:

DataSource Controls :: How To Fetch Rows Based On Values In A Session Variable

Dec 23, 2010

How to Fetch Rows based on Values in a Session Variable

View 4 Replies

Forms Data Controls :: How To Perform Action Based On Selection

Feb 7, 2011

While retrieving table data in grid view. How can I particularly select a row and perform any button action on that selected row. I'm new to

View 2 Replies

DataSource Controls :: Retrieve Data From SQL Server Based On Login Username (session Data)

Oct 12, 2010

I'm trying to make a dropdown list with data available based on the users login name. Heres what I have as my SQL Query in the SQLDataSource:

SELECT Client_Name, Client_ID FROM Client WHERE (Client_Name LIKE '%@Client_Name%')

So say if the login username is "User1" but the database client name is "User1 Steel" I want the dropdownlist to pull "User1 Steel" as the display and Client_ID as the value from the dropdown list.

View 1 Replies

DataSource Controls :: Connection Pooling And Check Connection State?

Apr 7, 2010

In my DAL i have more than 100 methods/Function, each and every method am opening the sqlconnection and closing the connection, this is taking too much of time to establish the connection at every time. So what i expect is one common class will create the SqlConnection that will check if the connection is Broken or Closed then create the connection again else return the connection, how to do this(Also i would like to apply ConnectionPooling).

View 7 Replies

DataSource Controls :: Is It Possible To Perform A Query On A Datatable?

Feb 14, 2010

My web application calls a stored procedure and stores the result in a .NET datatable. I'd like to use this datatable and join it with other tables in my database. Is this possible?

Would the best way to set this up be to create another datatable and then use a dataview to join both datatables?

View 2 Replies

DataSource Controls :: Perform Sql Queries Onto And Display Them?

Apr 26, 2010

I get from SQL Server Server Data. I need to use datas form 2 colums of my SQL query for a VB.NET. The VB.NET need 2 values for both colums and produce 1 answer. I what to display the value on the same line instead of the 2 1st values. How can i store the 2 colums wich lot of SQL values on my script and diplay the result with the other data from the SQL query ?

View 3 Replies

DataSource Controls :: Perform SUM On Results That Repeat?

Mar 2, 2010

I have the following query:


The results look like this:

DocumentNumber NIIN QtyReq AvailBalance
12345 015551212 2 5
12346 015551212 1 5
12347 015551212 3 5
12348 015554787 10 12

As you can see, the first 3 documents are for the same NIIN, and their total QtyReq is 6, however there are only 5 Available for this NIIN.

I need a way to remove the document 12346 because it cannot be filled, the other 2 document can though. I cannot figure this one out, but it seems like it should be pretty easy.I am using MS SQL Server 200

View 3 Replies

DataSource Controls :: Perform A Search For Records In Linq-to-Entities?

Jan 26, 2010

I trying to create a search mechanism for records in a EDM based on text entered on a text box in a web page.

For example, if I enter a partial name of a customer and/or state abrebiation for that customer on the Text Box (abc, TX)s, I want to search name and state fields in a Customer table in my database for matching customers.

I found a solution with the namespaceSystem.Linq.Dynamic, but for some reason it is not working. It does not expose the Search() method. Here is the code I am using to perform the search;


View 3 Replies

DataSource Controls :: Can't Perform Create / Update Or Delete Operations

May 12, 2010

when i want insert a record i see an error like this

Can't perform Create, Update, or Delete operations on 'Table(MainMenuLink)' because it has no primary key.

with this codes:

MyLinqDataClassesDataContext db = new MyLinqDataClassesDataContext();
MainMenuLink li = new MainMenuLink { Link ="../error/error.aspx", LinkSubject = "subject" };

what is the problem?

my table have a primary key but i dont know why give an error!!!

View 3 Replies

DataSource Controls :: How To Read Data And Perform Action From The Database

May 3, 2010

i'm quite new to and have been working on a simple way for users to send messages to each other....

the messages work fine, users can send and reply, however, i want a way to tell the users when they have a message and how many...

how to do this in simple terms and supply vb code if possible.

View 2 Replies

DataSource Controls :: SQL UPDATE Command - Perform Math Function From Value

Jun 27, 2010

Is it possible to perform an update command which performs addition using a value from a textbox? For example: User inputs a number into TextBox1 (I use regular expression validation to ensure this is an integer).


Basically if the user inputs 5 into TextBox1, I want the update command to subtract 5 from that user's ballance.

View 2 Replies

Visual Studio :: Create Connection String To Perform Test With Text Book?

Sep 14, 2010

I have installed VS 2010 Ultimate and it came with SQL 2008. what version it is and also how to create a connection in place to keep using the Oreilly examples to hopefully learn how to develop in C#. I have been learning but it is getting more difficult. I try to follow the steps but it just does not make sense. provide some easy steps to check version and connection method to sql using 2010,

I did see a post for sql management( FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en). I am going to download to hopefully be able to view the database. We have sql server 2008 at work and I have used the studio management for sql to run queries and would like to do the same with the version that was installed with the installation of 2010 ultimate. I can get the connection to the database so I can start learning how to build a dictionary and list for some queries. My goal is to create a aspx file that will show entries in a database we have at work.

View 2 Replies

DataSource Controls :: How To Perform DataView RowFilter Including Int32 And String

Mar 15, 2011

I got this error message when I use rowfilter

Line: 938 Error: Sys.WebForms.PageRequestManagerServerErrorException: Cannot perform '=' operation on System.Int32 and System.String.

My code is like this


When I check only string, it's okay

But I have to check string and int because some columns are only Integer such as LLMS_Id, Risk, RsidualRisk

View 1 Replies

Javascript - Web Based Chat, Using Ajax Timers , Will It Perform For Large Number Of Users

Jan 25, 2010

as all we know that we can create very simple chat using ajax timer & web service , it runs well for few users .

i want to leaverage same idea for site where 5000+ users will be there in chat room , messages are stored in queue hold in memory * dispatched as user request that is through java script timers calling page method or service ,

how well it will perform ? i know GTalk implements XMPP protocol(jabber) for the web chat
seems it will be difficult to got XMPP way ?

View 1 Replies

DataSource Controls :: Insert A Record Error - Can't Perform Create, Update, Or Delete Operations On 'Table?

May 11, 2010

when i want insert a record i see an error like this Can't perform Create, Update, or Delete operations on 'Table(MainMenuLink)' because it has no primary key. with this codes:

MyLinqDataClassesDataContext db = new MyLinqDataClassesDataContext();
MainMenuLink li = new MainMenuLink { Link = "", LinkSubject = "subject" };
db.MainMenuLinks.InsertOnSubmit(li); [code]....

View 2 Replies

DataSource Controls :: Variable Connection String Parameter In A DataSource Control

May 20, 2010

I have several web forms which use a GridView linked to a DataSource control which is defined at design time as follows:

connectionstring="<%&#36; ConnectionStrings:PgSqlConnection %>"
providername="<%&#36; ConnectionStrings:PgSqlConnection.ProviderName %>" >

As you can see, the connectionstring parameter is defined to a specific connection string name and I need to be able to set such a parameter to a different value, for example, to a session variable content.

View 1 Replies

DataSource Controls :: How To Use Server.MapPath As Datasource While Creating Connection With OLEDB

Nov 15, 2010

i am trying to create connection using OLEDB connection in my app. but i am not able to create the connection as in datasource i want to use Server.mappath, but cudn't find the right method to use it. i am trying to make connection with Access database file. following is code i have tried:

string path = Server.MapPath("~/uploadaccess/Production.mdb");
string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("~/uploadaccess/Production.mdb")&";";
and also
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path&";");
and tried this
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("~/uploadaccess/Production.mdb"));

and this is the error i am getting:

Operator '&' cannot be applied to operands of type 'string' and 'string'

View 3 Replies

DataSource Controls :: Ckeck Sql Query Perform With Load By Using Tools For Create Load?

Feb 16, 2010

how to check performance of sql server query with load ,also wants to create load by any tolls like load runner,if any url for download load runner or any other tolls by which we can create load please give me some idea related to it.

View 1 Replies

Web Forms :: How To Deserialize And Fetch Session Information Based On Session ID

May 6, 2014

I am trying to retrieve SessionItemShory column for given sessionid.The data stored is serialized so we need to deserialize the data to use it.I am trying to do that but its not working.

public class sessiondata {
public string username { get; set; }
public string country { get; set; }
public string city { get; set; }


View 1 Replies

Forms Data Controls :: Select Gridview Row Based On Session Value?

Aug 15, 2010

As the post subject I have a gridview;

the question is how can I select the row (not change bg color) during page load dedect a session value ?

View 8 Replies

Web Forms :: How To Perform Validation For A Textbox Based On Other Textbox

Jan 28, 2011

I'm using 3 text boxes for allowing user selecting different ranges. I want to perform below validations on three text boxes.

1.User should enter a value (i.e. a valid number,doesn't allow to enter zero,decimal numbers and negative numbers) in 1st text box.

2. 2nd text box value should be greater than 1st text box.

3. 3rd text box value should be greater than 2nd text box.

I want to perform validations on client side only using JavaScript. If anything goes wrong I want to populate a message box.

View 7 Replies

DataSource Controls :: Ftp Connection Through Asp?

Feb 23, 2010

i have an asp page through which i want to access FTP server And retrieve data (only file properties )from there and get it in excel (or just display it on the browser)is there any way i can keep it simple and acess the data from the server ???

View 1 Replies

DataSource Controls :: Access Property Of Object As Session Variable As Declarative Datasource Parameter Value

Oct 27, 2010

I am storing a custom "Organisation" object as a session variable. One of the properties of the Organisation object is "OrganisationID" (integer). I have a DataSource that requires a parameter value to run, and I want to use a SessionParameter to populate this. In a previous version, I stored the OrganisationID directly as a session variable. In that case, I could easily access it like this:


However, how do I now access the OrganisationID property of an "Organisation" type session variable (called "Organisation")? I have tried this, which does not seem to work: <asp:SessionParameter Name="OrganisationID" SessionField="Organisation.OrganisationID" Type="Int32" />

View 2 Replies

DataSource Controls :: Connection Errors

Mar 7, 2010

Connection Errors


View 5 Replies

Copyrights 2005-15, All rights reserved