Re: "string to int" - ASP.NET Discussion Boards

First Prev Next

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

Re: data formatting in datagrid

_AK_9-Nov-06 20:18

_AK_

9-Nov-06 20:18

If you just want to format the data displayed in datagrid then you can take help of this.[^] Here you get the details of how to format the strings.

Best Regards,
Apurva Kaushal

Re: data formatting in datagrid

ed^nrgc10-Nov-06 3:53

ed^nrgc

10-Nov-06 3:53

This may help you also:
http://msdn2.microsoft.com/en-us/library/fht0f5be.aspx

Regarding displaying images in datagrid

sdaniel_cst9-Nov-06 19:53

sdaniel_cst

9-Nov-06 19:53

I tried to display images from a database in to a datagrid....
The images are coming one below the other.
I would like to display images as 4 rows and 4 columns in a page
and the rest of the images in another page..

In a datalist it is possible but there is no paging in datalist..
so i cant use it..

the code i have written
<asp:datagrid id="DLFotos" runat="server" cellpadding="2" cellspacing="2" allowpaging="true" autogeneratecolumns="False" pagesize="3">
<columns>
<asp:templatecolumn>
<itemtemplate>

&IdPadre=<%# DataBinder.Eval(Container.DataItem, "IdPrenda") %>"><asp:image id="Image1" runat="server" borderwidth="0">

Please Help....
Thanks in advance

sdaniel_cst

Re: Regarding displaying images in datagrid

_AK_9-Nov-06 19:56

_AK_

9-Nov-06 19:56

I think datalist will better suit for your requirement. And for paging you can implement custom paging with the datalist.

Best Regards,
Apurva Kaushal

Re: Regarding displaying images in datagrid

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

postmaster@programmingknowledge.com

10-Nov-06 2:21

There is an example at
http://www.programmingknowledge.com/ImageUpload.aspx[^]

Last Visit: 31-Dec-99 18:00 Last Update: 6-May-24 15:28

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.