Tracking Forums, Newsgroups, Maling Lists
Home Submit Tracker Forums
  Advanced Search

 - Get The Number Of Rows Returned By OleDbDataReader?

After connecting to a database using DataReader, how can I count the number of rows ?

View 2 Replies (Posted: Jun 18 10 at 0:30)

Sponsored Links:

Related Forum Messages For ASP.NET category:
ADO.NET :: Get Number Of Returned Rows By Data Reader?
I have a web page where I want to return number of returned rows by datareader as I need to get Count of rows. My code is as follow :

SqlCommand cm = new SqlCommand(); SqlDataReader dr;sqlconnection cn; public int Returndatareader( int x)
int s;
string sqlstr = "SELECT COUNT(*) FROM P_Events as Counter";
cm.CommandText = sqlstr;
cm.Connection = cn;
dr = cm.ExecuteReader();
if (dr.Read())
int y = dr.RecordsAffected;
s = y;
//return y;
return x;

but the rows affected count is -1 everytime i run my code.

Posted: Feb 24, 2011 04:26 PM

View 5 Replies!   View Related
Trying To Get The Number Of Rows Returned In A Query In Visual Basic?
Trying to get the number of rows returned in a query in Visual Basic.The queryreturns 3 rows.Dim td As Integer = dataset1.Tables(0).Rows(0).ItemArray(0) has a value of 1.Dim tg As Integer = GridView1.DataSource.tables(0).rows.counthasa value of 3.1. Why do aren't they both 3 ?2. Is there a best way of getting the number of rows?3. Where can I find a tutorial or book that explains the notation above ?

Posted: Feb 11, 2010 02:07 PM

View 3 Replies!   View Related
DataSource Controls :: Count The Number Of Rows Returned From The Database?
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.

Posted: Jan 17, 2010 05:37 PM

View 1 Replies!   View Related
DataSource Controls :: SQL Select Union And Total Number Of Returned Rows?
SQL Select Union and total number of returned rows?

Posted: May 01, 2010 02:37 PM

View 3 Replies!   View Related
Forms Data Controls :: Check Total Number Of Rows Returned From DB When Using Repeater?
Using C#, how can I check the total number of rows returned from a database when using a Repeater? The reason I need to check is I need to alter the presentation of the data when there is only 1 row returned.

Posted: Feb 06, 2010 01:52 AM

View 9 Replies!   View Related
Forms Data Controls :: Gridview Row Count / How To Get A Count Of The Number Of Rows That Are Returned
When a user submits the queryto SQL when clicking a buttonI 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.


Posted: Dec 17, 2010 05:25 PM

View 1 Replies!   View Related
Forms Data Controls :: Count Number Of Rows For Certain Rows?
i have a gridview with following column

Origin | Destination | Month | Total Passenger
A B 1 500
A B 2 670
A B 3 730
B A 1 320
B A 2 500
B A 3 669

is it posible to count number of rows which Origin "A" and Destination "B" from my gridview?

Posted: Nov 25, 2009 04:47 AM

View 6 Replies!   View Related
Count Number Of Returned Results And Print To Literal?
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?

Posted: Apr 09, 2010 09:51 AM

View 2 Replies!   View Related
SQL Server :: Use Cursor To Loop Through Number Of Records Returned?
using sql server 2005.

i need to query a table which normally will return multiple records for the id and I need to loop through probably using a cursor and pull values out from each record to make a string.

what is the syntax for this? i've seen cursors using a set number (EX: loop through 5 times) but I need to create a query so that I can loop through once for each row returned from my query.

Posted: Mar 25, 2011 07:10 PM

View 13 Replies!   View Related
Security :: Filtering The Rows Returned By Membership.GetAllUsers()?
In our application, we use Membership.GetAllUsers() in order to allow the administrator work with the site's membership.

Is there a way to filter the rows returned by Membership.GetAllUsers() method? I'd like to be able to have a textbox where (part of) the user's first name / last name is entered and then call GetAllUsers() - or a different method - to get only the users whose name begins with value in the text box.

Posted: Dec 22, 2010 09:51 PM

View 4 Replies!   View Related
SQL Server :: Desired Rows Not Returned Because Of Null Values
I have a property table and an image table.

I want this query to return all distinct properties and a thumbnail image. However some properties don't have thumbnail images and they don't get returned by the query. If the imgid is null I still want to return the property. Not sure of how to do this.



Posted: Sep 26, 2010 11:48 PM

View 4 Replies!   View Related
DataSource Controls :: How To Get Number Of Records A Query Has Returned Using SqlDataSource Control
I'm using SqlDataSource control.Is there a way to know how many records a query has returned?

Posted: May 17, 2007 11:01 AM

View 3 Replies!   View Related
Forms Data Controls :: Limiting Number Of Records Returned In XML Feed?
Currently I have

dlRSS.DataSource = GetRSSFeed("")
Function GetRSSFeed(ByVal strURL As String) As DataTable
'Get the XML data
Dim reader As XmlTextReader = New XmlTextReader(strURL)
'return a new DataSet
Dim ds As DataSet = New DataSet()
Return ds.Tables(2)
End Function
<asp:DataList ID="dlRSS" runat="server" Width="100%" >
<strong><p><div><asp:HyperLink ID="TitleLink" runat="server" Text='<%# Eval("title") %>' Target="_blank" NavigateUrl='<%# Eval("link") %>'/></div></p></strong>
<strong><p> <div><asp:Label ID="SubtitleLabel" runat="server" Text='<%# Eval("description") %>' /></div></p></strong>

But is returning all rows in RSS Feed I would only like top 5 or so

Posted: May 18, 2010 02:21 PM

View 1 Replies!   View Related
SqlHelper.ExecuteReader Results Varying And Unexpected When Certain Number Of Records Are Returned?
Note: You may not need to read the whole thing to know what's wrong... skip down to the part about the 3 scenarios if you'd like. Only read the begin if you'd like some background info on how I've tried implementing this and where the errors occurred.To begin with, I'm trying to retrieve a list of Clients stored in the CRM_Clients table for a given callerId.I retrieve the clients from my Controller with the SelectLiveClientsForCaller method. The message is then passed on to the DAL through the static Instance method in the DataProvider class:

public List<Client> SelectLiveClientsForCaller(int callerID)
List<Client> results = new List<Client>();


Posted: Jul 4 10 at 2:21

View 3 Replies!   View Related
Can Check Rows Returned In A QueryString Parameter Based Entity Framework Query
I need to check if any rows are returned in a QueryString here's what I have so far.not sure what code to put to see if the row count is greater than 1

private void BindDataToGrid()
//MessageBoardEntities3 is ThemeableAttribute connection string name
int TID = Convert.ToInt32(Request.QueryString["ThreadID"].ToString()); // if Post ID is int
var context = new MessageBoardEntities3();
gvPosts.DataSource = from p in context.Posts
where p.ThreadID == TID
select new { p.Post1, p.PostID };
lblNoPosts.Text = "No posts found for this thread.";

Posted: May 29, 2010 02:19 PM

View 1 Replies!   View Related
Forms Data Controls :: Make Visible A Label If The Returned Rows Are 0 In The Repeater?
I am trying to make visible a label if the returned rows are 0 in the repeater. The problem is that when it returns 0 results, I get an error

{"The IListSource does not contain any data sources."}

How do i bind the returned dataset so that I don't get that error and the footer template's lable is made visible ?


protected void Page_Load(object sender, EventArgs e)
DataSet ds = db.GetDataset("GetWebcasts");
this.rptWebcasts.DataSource = ds;
//if (ds.Tables.Count > 0)


Posted: Oct 08, 2009 07:08 AM

View 6 Replies!   View Related
Access :: OleDbDataReader Is Null Even When Data Exists?
I'm writing a small app that uses an access db. I'm using a layered architecture and business objects. In my dataaccess class, I have tis method that returns all records by UserID:


The problem is that the reader object is null, even though the records with the specified userid exist in the db.Using the debugger, I can see that the parameter passed to the method is correct, and the SP is as simple as:


I have tried using an AccessDataSource directly on the aspx page and hooking it up to a grid, and then the records are returned. Also, using my dataaccess class, I can insert new records without problems, so the connection works just fine.

I have used this model in many apps with sql server, and it allways works. So, my question is if there are any known issues when using OleDbDataReaders with Am I using it correctly, or am I missing something?

Posted: Dec 08, 2009 07:46 AM

View 6 Replies!   View Related
Databases :: OleDbDataReader Can't Read Excel Cell With Bracket
I have an excel header that has the following header title : "REMARKS (i.e. awarded etc.)"

but it seems that it can't read the cell with the brackets or it is there is a certain length of the excel header?

While reader.Read()
Dim DataRow As DataRow = dtDataTable.NewRow()
DataRow("Remarks") = Trim(reader("REMARKS i.e. awarded etc.").ToString)
End While

Posted: May 21, 2010 08:00 AM

View 3 Replies!   View Related
ADO.NET :: How To Get The Number Of Rows From Sqldatareader
how to get the number of rows from sqldatareader

Posted: Mar 29, 2011 02:50 PM

View 2 Replies!   View Related
Databases :: Importing Excel Sheet Into Sql Server Table Using OleDbDataReader?
I am trying to Importing Excel sheet into Sql server table using OleDbDataReader

the problem is it is not fetching the cell values with contains "," (comma) ex: cell value ="03280, 03281"

i am usingOleDbConnection oconn =

OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="
+ Server.MapPath("Files\LineItems.xlsx") +
";Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1';");

Posted: Feb 12, 2010 06:53 AM

View 1 Replies!   View Related
Bulkinsert From CSV Into Db (C#) -> Max Number Of Rows In A Web Application?
Web application - C#, .Net, SQL 2k5.I recently used bulkinsert on an other application and I thought I would like to give it a try.

I am going to receive a CSV file with 1000 rows, which will most likely add 500 000 (that is five hundred thousand) records in the database.I don't have any idea yet about this huge amount if it's going to work out well. I am afraid that it will time out.

I didn't do any testing yet, but I am pretty sure it would time out eventually.

Is there a way to make it not time out (I don't know ... split the bulkinsert into 1000 pieces :D) or I should try to do something like BCP, with a SQL job ...

Posted: Apr 28 10 at 11:11

View 3 Replies!   View Related
Restricting Number Of Rows In Datalist
In my I am using Datalist in that I want to limit row count and want the sort to be in vertical. Let me know how to do this. Ex: I want my list to be like this

1 4
2 5
3 6

Posted: Jun 17 10 at 7:51

View 1 Replies!   View Related
Checking Number Of Rows In Dataview?
I want to check that the row index I specify is below the row count so it doesn't throw the error

Index 2 is either negative or above rows count.

how would I achieve this with my code?

Using connection As New SqlConnection(connStr)
Dim command As New SqlCommand
command.Connection = connection
Dim a As New SqlDataAdapter("SELECT top(3) name, (SELECT TOP (1) ImageId FROM Images WHERE(productid = products.Id)) AS imageId FROM Products WHERE beginnerdiscount = '1' ORDER BY Dateadded", connection)
Dim s As New DataSet()......

Posted: Feb 02, 2011 09:57 PM

View 11 Replies!   View Related
How To Limit The Number Of Rows To Be Displayed On A Webpage
i have so many rows which i want to display on the pages maximum 10 rows on the page and next 10 on the other page n so on or i want next and prev. functionality

Posted: Dec 16, 2008 06:24 PM

View 4 Replies!   View Related
How To Count The Number Of Rows In Gridview Automatically
I want to count the number of rows in Gridview ,thru JS. When SelectAll is executed,alert message 'a' is displayed,then page posts back to the server.1) It do not display the alert message gridLength 2)WHy the page is postbacked,I write return false???

function SelectAll()
var gvET='<%=GrdCostPetroleum.ClientID%>';
var gridLength = gvET.rows.length;
alert (gridLength );
return false ;

Posted: Feb 3rd, 2010, 01:49 PM

View 7 Replies!   View Related
How To Find Total Number Of Rows In Gridview
m using c# .net and oracledatabase with 3 tier architecture.

i want to find the total number of records in the entire gridview.

M sending the source code of my gridview and the method which i m using to display records in gridview.


Posted: Apr 8, 2009, 01:31

View 8 Replies!   View Related
Binding A Fixed Number Of Rows To A Dropdown?
Suppose there is drop down list which bind first 20 rows from a table from database. then on a button click next 20 rows(means row no 21-40 from database) from the table will be bound & then again on the button click next 20 rows(row no 41-60) will be bound... like this. I need the answer in C# language.

Posted: Dec 09, 2008 03:07 PM

View 10 Replies!   View Related
Web Forms :: How To Set Bullted List Number Of Rows
i have a bullted list and would like it to show only 5 values but it currently displays 10 how do i change that

Posted: Nov 02, 2010 03:53 PM

View 5 Replies!   View Related
SQL Reporting :: Limit Number Of Matrix Rows?
I've got a report in SSRS 2000 that I'm having a bit of difficulty with. I'm pulling my data into a matrix and need to limit said matrix to 10 rows (not per page). Due to the grouping, I cannot simply use the TOP command in my SQL query. What I've done is set a filter on one of my row groups to show only the top 10 records, but to do this by counting (actually summing with an inline if) the records for each group. My result is something like this

Result 1 Subresult 1 20

Subresult 2 10

Total 30

Result 2 Subresult 1 25

Total 25

Result 3 Subresult 1 12

Subresult 2 5

Subresult 3 4

Total 21

As you can see, it is sorting by the total amounts and will only show the top 10 totals. The problem comes in when say what would be records 9, 10 and 11 normally all have the same total. What happens is instead of showing 10 records, since those last 3 have the same total, it doesn't know where to cut it off, so it just shows 11.

Posted: Oct 27, 2009 01:20 PM

View 1 Replies!   View Related
ADO.NET :: Get Number Of Rows Affected By Using Procedure In Linq?
i have create the object of

1 dataclassContext obj=new dataclassContext();

2 now i call the updateProc

int row=ob.MyupdateProc(QuestionID,peronID);
do some thing

but row always retrun 0 even procdure do update in database

Posted: Dec 18, 2010 08:39 AM

View 1 Replies!   View Related
Sort Accroding To Number Of Rows In Dataset?
My dataset having 6 tables.I want to get the table with minimum row first and the next and show on.

Posted: Dec 19, 2008 11:48 AM

View 2 Replies!   View Related
How Do Display Total Number Of Rows In A Table Into A Label
i use sql server 2005 and Visual Studio 2008.

I am using and for my website.

i have a table with number of rows 50,000.

i want to display the number of rows at my table in a Label when the page is on load.

so can u give me the code or the hint?

my second question is.

my table has around 50,000 items.

and i have a search box, it look like this

str= select * from mytable where item='car'

the item Car is located in my table in row number of 45,000.

i guess when i search from the table where the item is car, then it will search row by rows, then as the number of rows become huge, it will be so late to find the result.

so is there any method how to search from table with good speed of searching?

Posted: Oct 6th, 2010, 01:32 AM

View 8 Replies!   View Related
Web Forms :: Drop DownList Limit Number Of Rows
I have a dropdown list. This is a bound to a column in Table which has around 200 entires.Now when a user clicks on the drop down list I want him to see not more than 10 rows. The rest he should navigate by using scroll bars.

Posted: Sep 17, 2010 01:43 PM

View 5 Replies!   View Related
Setting Label Text To Number Of Rows With JQuery?
This is my code but nothing happens.

$(document).ready(function() {
var totalRows = $("#<%=GridView3.ClientID %> tr").length;
document.getElementById('Label6').InnerHTML = totalRows;

this is what i ended up using

var rqnum = $("#<%=GridView3.ClientID %> tr").length - 1;
document.getElementById('rqnum').innerHTML = rqnum;
var oknum = $("#<%=GridView4.ClientID %> tr").length - 1;
document.getElementById('oknum').innerHTML = oknum;
var xlnum = $("#<%=GridView5.ClientID %> tr").length - 1;
document.getElementById('xlnum').innerHTML = xlnum;
var dynum = $("#<%=datalist1.ClientID %> tr").length / 3;
document.getElementById('dynum').innerHTML = dynum;

this way it subtracts the header, however, how can i make it so if it is 0 dont subtract the -1 because i dont want negatives

Posted: Feb 18 at 20:29

View 3 Replies!   View Related
Dynamically Generate Checkbox List For Number Of Rows In Asp .net Using C#
i needed to have the number of rows,agianst every row there should be list of checkboxes which can be checked / unchecked.

Example :

SNO Employee Name ChkBox1 ChkBox2 ChKbox3 etc...

Finally when you submit, Employee name and the list ofCHECKED items will be stored in a database table.

Posted: Aug 19, 2009 04:56 PM

View 3 Replies!   View Related
How To Enforce A Certain Number Or Range Of Affected Rows In SQL Server Or C#
for some SQL queries I know the expected number of rows that must be affected by UPDATE, DELETE or INSERT statements. It could be a number such as 1 or a range such as 0-1 or 1-2 etc.

What is the best way to enforce that this is the number of affected rows and that otherwise an exception is thrown?

Also, can I limit the number of rows affected for UPDATE/DELETE/INSERT to say 1 row and otherwise get an exception?

Posted: Feb 17 at 10:09

View 4 Replies!   View Related
DataSource Controls :: How To Count Number Of Rows In Database
i am using sql 2005 db. i have created a table called attendance where i store employee attendance, i want to separate number of absence for a particular employee and particular month. It have to show number of absence of a particular employee and particular month. Also i have to count no of absence. for eg: if an employee absence for two days for a particular month, it have to display 2 count.. how to do this? also how to write the store procedure for this?

Posted: Jan 08, 2010 06:08 AM

View 4 Replies!   View Related
Forms Data Controls :: Getting Number Of Rows In Repeater?
I would like the number of records returned in a repeater i.e Repeater.Count or something so I can check if it is empty or not.

<asp:Repeater ID="rptJobsList" runat="server" DataSourceID="SqlDataSource1">
<!--============================================= EVENT ==========================================-->
<%# Eval("dateAdded").ToString() %>
<%# Eval("jobTitle").ToString() %>
<%# Eval("jobDescription").ToString() %>

Posted: Dec 07, 2009 11:13 AM

View 7 Replies!   View Related
Web Forms :: Vwd 2008 Table Creation - Initialize With Number Of Rows?
when i want to create a table in a form using visual web developer 2008 express how can i initialize the table with no of rows that the table contains

Posted: Feb 28, 2011 05:03 AM

View 5 Replies!   View Related
Copyright 2005-08, All rights reserved