ASP.NET

postmaster@programmingknowledge.com

10-Nov-06 1:09

I think you have to add a server control to your datagrid.

<td><asp:Datagrid CommandName="ID"
Text=<%# DataBinder.Eval(Container.DataItem, "au_id") %>
runat=server/></td>

The above line will add a Button control within the Datagrid control. The CommandName property is used to uniquely identify the button; if there is more than one Button control, each control must have a different CommandName.

Next, we need to modify the <asp:Datagrid> element so that it knows which event to fire when the Button control is clicked. We need to specify the OnItemCommand property, indicating the event to service when the button is clicked:

<asp:Datagrid id="Datagrid1"
OnItemCommand="Button_ItemCommand" runat="server">

Lastly, code the routine for the Button_ItemCommand event:

Sub Button_ItemCommand(ByVal Sender As Object, _
ByVal e As DatagridCommandEventArgs)
If e.CommandName = "ID" Then
Response.Write("ID selected is " & _
CType(e.CommandSource, Button).Text())
End If
End Sub

Hope this may help u

Regards,

Suresh Dayma

Everything Is Possible!

Re: Datagrid Problem

monika_vasvani10-Nov-06 1:31

monika_vasvani

10-Nov-06 1:31

Hi

Thanks for your kind response , but you didn't get mt question.

i add one button in ItemdatBound event of datagrid.i give a command name to that button but itemcommand event not fired .

eg. dim btn as new button
e.item.cell(0).control.add(btn)
btn.commandname="edit"

how to create runtime button in itemcreate event of datagrid ?
and is it possible to fire itemcommand event when i clicked tht added button ?If is it possible give us example.

Thanks in advance ,
Monika

Re: Datagrid Problem

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

10-Nov-06 2:17

See an example about Add, Edit & Delete with DataGrid in ASP.NET at
http://www.programmingknowledge.com/simpleDataGrid.aspx[^]

How to count records from database..

Sam.M9-Nov-06 23:58

Sam.M

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

_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.

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

_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.

Suresh Pirsquare10-Nov-06 0:24

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!

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...

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 [^]

postmaster@programmingknowledge.com

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

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

_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.

_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

_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

Suresh Pirsquare10-Nov-06 0:10

Re: Trace Back Button in IE

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

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