Re: How to count records from database.. - ASP.NET Discussion Boards

Sam.M9-Nov-06 23:58

9-Nov-06 23:58

Hi there...

I want to count the total records which retrieving from database. By using DataReader, how can i count the records and i store that in a textbox..

Regards n Thanks

Sam.M

Re: How to count records from database..

_mubashir10-Nov-06 0:05

_mubashir

10-Nov-06 0:05

Datareader fetches one row at a time as so you need to loop thru while end of Datareader (read) and increment an explicit counter variable to count the records.

Mubashir

Every job is a self portrait of the person who did it.

Re: How to count records from database..

Sam.M10-Nov-06 0:08

Sam.M

10-Nov-06 0:08

Hi ....

Very thks... but i want to get the total number of records using datareader

Thks n Advance

Sam.M

Re: How to count records from database..

_mubashir10-Nov-06 0:13

_mubashir

10-Nov-06 0:13

As far as i am concerned....this is not possible.......you need to loop thru with DataReader to get the count.......OR use datasets

Mubashir

Every job is a self portrait of the person who did it.

Re: How to count records from database..

Suresh Pirsquare10-Nov-06 0:24

Suresh Pirsquare

10-Nov-06 0:24

Try this code

dim i as integer=0
do while dr.read()
i=i+1
loop
Label1.Text="No of Records : " & i.toString()

Hope this may help u

Regards,

Suresh Dayma

Everything Is Possible!

Re: How to count records from database..

Britney S. Morales10-Nov-06 1:57

Britney S. Morales

10-Nov-06 1:57

The datareader is a secuencial reader.

so you must to loop all the datareader to know how many files you got.

<br />
sqldatareader dr = sqlcommand.executereader();<br />
<br />
int num_lines = 0;<br />
while dr.read()<br />
{<br />
  i++;<br />
}<br />
<br />
Message.Text = i.toString();<br />

Have Fun

keep Learning and you never will be out of date...

Re: How to count records from database..

Michael P Butler10-Nov-06 2:14

Michael P Butler

10-Nov-06 2:14

Sam.M wrote:
I want to count the total records which retrieving from database. By using DataReader, how can i count the records and i store that in a textbox..

You can't directly. DataReader classes read through a file sequential, so you'd have to read all records and increment your own counter.

Depending on how many records, you could load the data into a DataSet/DataTable and use the Rows.Count to find out how many rows.

Alternatively, run a SELECT Count(*) on your table and return that result via a DataReader.

Michael

CP Blog [^] Development Blog [^]

Re: How to count records from database..

postmaster@programmingknowledge.com10-Nov-06 2:19

postmaster@programmingknowledge.com

10-Nov-06 2:19

How about

SELECT Count(*) FROM

=======

http://www.programmingknowledge.com/simpleDataGrid.aspx[^]

"string to int"

ravikiranreddydharmannagari9-Nov-06 23:36

ravikiranreddydharmannagari

9-Nov-06 23:36

foreach(DataGridItem dataGridItem in DataGrid1.Items)
{
string r=(dataGridItem.Cells[2].Text);
Int32 sum=int.Parse(r);
Response.Write(sum);
}
iam using the above code and iam trying to convert an
string to int iam getting exception
Input string was not in a correct format. at System.Number.ParseInt32(String s,NumberStyles style, NumberFormatInfo info)
plz let me know asap

with regards
ravi

Re: "string to int"

_mubashir10-Nov-06 0:06

_mubashir

10-Nov-06 0:06

What string are you getting in variable 'r' ?

Mubashir

Every job is a self portrait of the person who did it.

Re: "string to int"

_AK_10-Nov-06 0:08

_AK_

10-Nov-06 0:08

Posted the same reply at the same time... Smile | :)

Best Regards,
Apurva Kaushal

Re: "string to int"

_AK_10-Nov-06 0:06

_AK_

10-Nov-06 0:06

What is the value you are getting in r(string)? It may not be a integer thats why you are getting the exception.

Best Regards,
Apurva Kaushal

Re: "string to int"

Suresh Pirsquare10-Nov-06 0:10

Suresh Pirsquare

10-Nov-06 0:10

This code may help u

// C# code
String sNumber = "123";
int iNumber = Convert.ToInt32(sNumber);

' VB.NET code
Dim sNumber as String = "123"
Dim iNumber as Integer = Convert.ToInt32(sNumber)

Thanks and regards,

Suresh Dayma

Everything Is Possible!

Trace Back Button in IE

Deepak the Cool9-Nov-06 23:35

Deepak the Cool

9-Nov-06 23:35

How can i stop back button(disable) when my home page is loaded or when user logout. so how can i trace back button.

provide code to trap back button.

Deepak

Smile a Lots,Its Costs Nothing

Re: Trace Back Button in IE

PavanPareta9-Nov-06 23:51

PavanPareta

9-Nov-06 23:51

i can give you a idea.

when a user is logoff you application that time you have to call a another form (like "logout.aspx" )for stoping in to user go back.

now you can write a javascript on Body tag window.open(index.aspx");
wirte in Header Tag

<code><javascript>
function logout()
{
window.open(index.aspx");
}
</javascript></code>

call this function on body load.

<big><b><body onload="logout()"></b></big>

i thing this is very help full for you.!

Cheer

Pavan Pareta

generating multiple line charts dynamically

bskvarma9-Nov-06 22:53

bskvarma

9-Nov-06 22:53

Hi All
I need to generate multiple line charts dynamically using ADO.NET data in ASP.NET 1.1 application.
If anyone can provide me a link to some example code to handle line charts. By "line
graphs" means,graphs that have dates on the X-axis and data on the Y-axis in several colored lines .
I'm limited of not using any readily available graph tools/controls.

The Graph with features i'm looking to generate will look in the manner as available in this link below:
(http://finance.yahoo.com/charts) or (http://finance.google.com/finance?q=CSCO)

Thanks in advance

Regards-
bskvarma

multi language application

Krishlibran9-Nov-06 22:24

Krishlibran

9-Nov-06 22:24

Hi,
I want to develop multi language application windows application using asp.net with c#.
please help me. I am new learner.

Thanks,
libra

Re: multi language application

PavanPareta9-Nov-06 23:36

PavanPareta

9-Nov-06 23:36

you can use resourse file for every form in C# but you have to define a file of each language. "Resource1.resx"

this file has a information of a form, and every form controls information also saved in this file.

when a form is add this file also created autometically. u can also Add new Resource File for another one language.

Like you have using 3 language is supported by your application. you have to create (3 Resource File for --> a single FORM)

try

Pavan Pareta

Re: multi language application

Suresh Pirsquare9-Nov-06 23:56

Suresh Pirsquare

9-Nov-06 23:56

Here is a very good article on multi language application, refer the below mentioned url

http://bhashaindia.com/Developers/MSTech/multilingualApp.aspx[^]

Thanks and Regards,

Suresh Dayma

Everything Is Possible!

ratildo9-Nov-06 21:06

ratildo

9-Nov-06 21:06

hi,

i am trying to make a login page in asp.net 2.0.

i have selected login

i have a database named as user.

i would like to know when i enter the username and password from my login page it should only allow me to enter as per the data's in my database.

and i am unable to connect the login page to my oracle database.

plz help me.

regards,
ratish.

Re: Login problem

ed^nrgc10-Nov-06 3:51

ed^nrgc

10-Nov-06 3:51

Is your connection string correct?

Re: Login problem

ratildo13-Nov-06 0:58

ratildo

13-Nov-06 0:58

tht's wht i am not understanding if u want i can send u the source code .

How To remove the cache

abufaizur9-Nov-06 20:19

abufaizur

9-Nov-06 20:19

I have a question regarding keeping a username in the cache in order to
prevent multiple logins. I read 'Preventing Multiple Logins in ASP.NET' by
Peter Bormberg (great article
http://www.eggheadcafe.com/articles/20030418.asp) and everything works fine,
however, I think we are going to have problems from our users having to wait
for their cache to clear out before they can login again. Is there a way to
clear the username out of the cache when they logout? I seem to be missing
something here.

rahman

Re: How To remove the cache

Suresh Pirsquare10-Nov-06 0:29

Suresh Pirsquare

10-Nov-06 0:29

You can remove the cache by using the Remove method

Cache.Remove("MyCachedItem")

Hope this may help u out of your problems.

Regards,

Suresh Dayma

Everything Is Possible!

data formatting in datagrid

yesu prakash9-Nov-06 20:00

yesu prakash

9-Nov-06 20:00

plz give me all the data formatting experssions which can be used in datagrid bounded columns
thank you

Last Visit: 31-Dec-99 18:00 Last Update: 3-May-24 15:19

Refresh

ᐊ Prev 1...5675 5676 5677 567856795680 5681 5682 5683 5684 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.