DataSource Controls :: Count Items Returned From ObjectDataSource?

May 27, 2010

I am viewing items returned from a dataset in an Infragistics chart control. My problem is that due to a weak point in the control, I am left looking for a way to manipulate the height of the chart based on the count/number of items returned by the ObjectDataSource(DataSet).

Does anyone one have an existing C# sample they could let me view of accessing the count of records returned within the code-behind of a page that I could then use within a case statement to set the hight of the control?

View 7 Replies

Similar Messages:

DataSource Controls :: Count The Number Of Rows Returned From The Database?

Jan 17, 2010

I have executed my query in VB with:


I now want to count the number of returned rows so that I can say:IF rows_returned = 1 then login else deny
I think you get the idea.P.S. I know this is not the most secure method of login but I do not want to use the ASP.NET configuration manager as I like to understand what is happening. I am starting off very simple and I shall work up from there.

View 1 Replies

DataSource Controls :: How To Get Total Count From An Objectdatasource

Mar 29, 2010

I have a gridview bounded to an objectdatasource.

I want to get total count of record when there is paging = true or false in gridview.

View 4 Replies

Forms Data Controls :: Gridview Row Count / How To Get A Count Of The Number Of Rows That Are Returned

Dec 17, 2010

When a user submits the query to SQL when clicking a button I need to get a count of the number of rows that are returned. Which event does the gridview.count code need to be place in?

Right now I have it in the btn_click event, but in order to get it to count the rows you have to hit the button twice since the query is not returned yet. Here is my code.


View 1 Replies

Count Number Of Returned Results And Print To Literal?

Apr 9, 2010

I want to count the number of results results returned by my query and print the number to a literal on the page.How would I do that?

View 2 Replies

Forms Data Controls :: Listbox Control Items Count Shows 0?

Jun 25, 2010

I am working on a screen where in it has a typical 2 listboxes & 2 buttons(add/remove), so when these buttons are clicked the items have to move from one listbox to another. its all working fine with javascript.but the issue is, I am not able to get the items of the 2nd listbox in the codebehind. I tried with html & listbox controls. I even tried to access the listbox using Request.Form["ControlName"] - which gives a null value.In the listbox1 the data's are coming from database.The data's choose from listbox1 will be moved to listbox2. And again i have to update this data to one of database table.

View 3 Replies

DataSource Controls :: Can Subquery Returned More Than One Value

May 5, 2010

have 2 tables in SQL 2000 developer edition identicals, Prereception and eceptions, on the table Recepcions I have the following trigger:

CREATE TRIGGER [AumentaInventario] ON dbo.Recepcion
declare @Codigo nvarchar (50)
,@Cantidad int

View 2 Replies

DataSource Controls :: Subquery Returned More Than 1 Value?

Feb 16, 2011

im working on visual Studio 2010, and i have an error on an update.

this is the code in VB.


Thats the code and the error is:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.`

View 4 Replies

DataSource Controls :: ObjectDatasource And Class As Datasource

Jun 24, 2010

I am really having a hard time trying to write something from scratch I created a 'Person' Class.Public Class Person

Private _FirstName As String = ""
Private _LastName As String = ""
Private _Age As Integer = 0
Public Sub New(ByVal FirstName As String, ByVal LastName As String, ByVal Age As Integer)
FirstName = FirstName
_LastName = LastName
_Age = Age

View 1 Replies

DataSource Controls :: How To Evaluate Nothing Value Returned By Sql Datareader In

Aug 24, 2010

When a sql query returns NULL , I can use the following code to evaluate:


When a sql query returns nothing, neither IsDBNull nor is Nothing works. I don't know why some sql queries return null while some return nothing when there are no data returned. But anyway, can somebody tell me how to evaluate nothing value returned in sql datareader in When I put the cursor over signInfo variable in debug mode, I can see Nothing show as its value. But the line does not work


View 3 Replies

DataSource Controls :: Getting A Single Value From A Returned Dataset?

Feb 18, 2010

I've managed to connect to the database and return a record based upon a login name. I can itterate through the rows printing out the password but I know there's only 1 row (or can test for that) so how do I get the value of the password for the one row without the loop?

Dim supervisorAdapter As New SupervisorTableAdapters.SupervisorTableAdapter
Dim supervisors As Supervisor.SupervisorDataTable
supervisors = supervisorAdapter.GetSupervisorByLogin(login)
For Each count As Supervisor.SupervisorRow In supervisors

View 3 Replies

DataSource Controls :: NULL Value Returned From Database And Handling It

Feb 14, 2010

I'm developing a website using 2.0 . I have retrieved a record from database through the query.

SqlConnection con = new SqlConnection(connectionstring);
String SQL = "SELECT * FROM Table where attribute1 = value";
SqlCommand cmd = new SqlCommand(SQL, con);
SqlDataReader reader = cmd.ExecuteReader();

Sometimes, there is no record matching this query and so null value is retrieved. My question is how to find that the null value is returned. Since If (no record found i.e NULL) certain actions needs to be done and if (records found i.e NOT NULL) ceratin different actions needs to be carried out.

View 10 Replies

DataSource Controls :: How Do Access The DataSet Returned By A SqlDataSource

Feb 17, 2011

I want to run a SUM on a particular against the DataSet returned by a SqlDataSource. How can I access the DataSet stored in memory that is returned by the SqlDataSource to run this calculation?

View 2 Replies

DataSource Controls :: Access Data Returned In Dataset?

Feb 26, 2010

I am having some difficulties with a particular task. I am creating a support desk intranet application and I am trying to write a method within a class within a namespace which will form a generic database connection which can be called from any of the aspx pages so that I have the dbconnection logic in one place; you know, going along with the 'DRY' (Don't Repeat Yourself) mantra.

The Namespace:


Objective of the method:

To provide any aspx code behind file with an SQL Server 2005 Express Connection and if possible return the data from an SQL Query. This is where I need advice do I create the method such that it simply forms the connection and returns a DataSet or that it returns an SQLConnection object? If i've got things back to front and upside down don't worry I'm a beginner with ASP.NET. The Method so far:


If I'm on the right track how do I access the data returned in the DataSet?

View 3 Replies

DataSource Controls :: Run A Sql Stored Procedure And Access The Returned Value?

Mar 30, 2010

I have a stored procedure 'RoomIfExists' on my sql server (it does work). It takes a string variable for the Room_No and returns either '1' or '2' depending on the result of the query.


I need to know how to run the sp in c#, passing the variable Room_No and then pull the result from it.I am using a data reader.

View 2 Replies

DataSource Controls :: Linq Group Cannot Get The Data Returned

Feb 8, 2010

I'm attempting to further reduce a dataset/table by various user input. Part of this process is grouping the data by a timestamp prior to a summation. I'm trying to use LINQ and cannot get the data returned that I need.


View 7 Replies

DataSource Controls :: Need To Check To See If Any Data Has Been Returned From The SQL Query?

Apr 15, 2010

I am trying to run the following SQL query

string strConString = ConfigurationSettings.AppSettings[ "conString" ];
myConnection = new OdbcConnection(strConString);
myConnection.Open(); // open connection
string strSelect= "select * from tbl_howells_product_data where title like" + "'" + strsearch + "%" +"'" + "order by product_id asc";
OdbcCommand myCommand = new OdbcCommand(strSelect, myConnection);

The problem is I need to check to see if any data has been returned from the SQL query, if there are no rows/ data returned by the query then I need to display a message to say that there aren't. I know that there isn't a 'number of rows method' for the dtrReader, so does anybody know how I could do this?

View 3 Replies

DataSource Controls :: Inside Procedure, Sql Returned Records Or Not?

May 11, 2010

inside procedure, how to know a sql returned records or not?

View 7 Replies

DataSource Controls :: Objectdatasource Does Not Run?

Jan 26, 2010

I have set the objectdatasource in the web form. Does I need to check anything as I find that method "objProductSuppliment_Inserted" does not run??


<asp:ObjectDataSource ID="objProductSuppliment" runat="server"


View 6 Replies

How To Get The Count Of Items From 2 Dates

Sep 15, 2010

How to get the count of items from 2 dates, which has been modified in last 30 days.


How to get the count of items, which have been modified in last 30 days.

View 5 Replies

DataSource Controls :: Stored Procedure Does Not Indicate Table Returned In Dataset?

Apr 23, 2010

This may not be the correct place to put this as it is both a stored procedure AND Visual Studio 2008 problem.

I have the following stored procedure:


I have been mokeying around with it because of what is happening. I have a dataset, call it dataset1. I drag this stored procedure onto the dataset. I EXPECT a datatable to appear, instead the data set adds this store procedure to the queries table adapter and sets the exec mode to 'NonQuery' which unless I am very mistaken, means "don't expect a dataset back from this' when in fact you DO expect a dataset back from this.

The SQL server is a Windows 2000 Server running SQL 2000. It has never caused us a moments grief since we set it up oh-so-many years ago.

If I connect to a different database and drag a query into the same dataset I get a datatable as I expect. I cannot see where / how this procedure could be wrong. The query when executed returns exactly the data I expect, in the format I expect (looks like a table, acts like a table in the Query analyzer).

View 3 Replies

DataSource Controls :: Objectdatasource Does Not Bind The Name And ID?

Jan 16, 2011

I've created a query in the table adapter for retrieving customer name based on the first letter. The query is executed fine, and the output is the customer name and ID. A Customer BLL accesses this query, and sends the results to an objectdatasource. This control is configured to use this customer-by-letter query. However for some reason, this objectdatasource does not bind the name and ID, but instead all the other fields produced by the main query in the table adapter (i.e. name, address, phone, etc....).

I'm probably not configuring something correctly, but I'm not sure what.

The BLL code:


The .net code:


View 4 Replies

DataSource Controls :: BLL Add Method & ObjectDataSource?

Jan 4, 2011

My Business Logic Layer has AddItem method that add's to Items table in db along with an entry in Balance table.AddItem method uses two TableAdapters Items & Balance. Both these have corresponding Business Objects as Item and Balance.

Here is the AddItem method :


ASPX Page with DetailsView & ObjectDataSource


Now executing this page generates error as

ObjectDataSource 'ObjectDataSource2' could not find a non-generic method 'AddItem' that has parameters: _item, _balance, ItemName, GroupId, CategoryId, AuId, Rate, TotalStrScale, OffsStrScale, OffsAE [code]...

View 1 Replies

DataSource Controls :: ObjectDataSource With BLL Methods?

Jun 22, 2010

I'm creating an website with 3 layers (Presentation, BLL and DAL).

BLL and DAL are 'class library'. DAL has a typed dataset. Presentation refers BLL and BLL refers DAL.

I wanna populate my GridViews with ObjectDataSource, but it only shows me the DAL. Nothing from BLL...

What am I doing wrong?

View 2 Replies

DataSource Controls :: Complex ObjectDataSource And ASP?

Apr 17, 2010

Consider a fairly complex business object. For the sake of discussion, let's think about a "ClassRoom" object - that will have some attributes which occur once, such as "capacity" and "area". It will also have some repeating attributes - perhaps "desks" which will itself be a collection of desk objects. The desk object will in turn have attributes such as "width" and "height".My example is more complex, but that should show where I am coming from. The business object, as you would expect, exposes methods to get the attributes in and out. There is also logic included to perform the underlying database updates. Of course, the necessary business validation is also in there.

In terms of binding to the ASP page, I will need to bind the attributes of "ClassRoom" to a set of fields on the page (using one method on the object). I will also want to bind the desks collection to a Repeater or GridView (using another method on the object).Presumably, I need to find a way to use a single instance of the ObjectDataSource so that the updates to the two (or more) disparate sets of data can be kept in step. I suspect that if I simply put two data sources on the page, I will get two instances and therefore no correlation between them.This can't be a unique problem, but I'm struggling to find any useful information.

View 3 Replies

Copyrights 2005-15, All rights reserved