Re: Can't retrieve data out of a GridView Control - ASP.NET Discussion Boards

DavidNohejl7-Feb-07 5:02

7-Feb-07 5:02

Try to be more concrete.. Negative amounts of what? Negative numbers? And, what did you try? What it did you didnt like?

"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus

Re: Negative Amounts?

Murthy Puvvada7-Feb-07 5:19

Murthy Puvvada

7-Feb-07 5:19

Sorry that i am not clear.

but I have this $ Amount field and the negative dollar amounts come up as follows:

-36000$ displayed as ($360000)

I hope it makes my issue clear.

Thanks,

Murthy here

Re: Negative Amounts?

Guffa7-Feb-07 6:20

Guffa

7-Feb-07 6:20

Murthy Puvvada wrote:
but I have this $ Amount field and the negative dollar amounts come up as follows:

-36000$ displayed as ($360000)

Yes, that is how the culture that you are using is defined to display a negative amount.

I hope it makes my issue clear.

As you haven't said anything about what you think is wrong about this, the issue is not clear at all.

---
single minded; short sighted; long gone;

Re: Negative Amounts?

Murthy Puvvada7-Feb-07 6:38

Murthy Puvvada

7-Feb-07 6:38

sorry again,

how can i change the culture to display $amounts as -$36,000 instead of ($36000)?

thanks again,

Murthy here

Can't retrieve data out of a GridView Control

Quecumber2567-Feb-07 4:08

Quecumber256

7-Feb-07 4:08

I’m populating a GridView control on an ASP.NET web page using a SQL Server 2005 stored procedure. The following subroutine is how I populate the GridView Control:

Protected Sub Load_grdEmployees()
'Purpose: Loads the grid control grdEmployees
' with employee information
'Parameters: None
'Returns: Nothing
Dim dr As SqlDataReader
Dim cn As SqlConnection = New SqlConnection(MRMFunctions.WebConfigConnString)
cn.Open()
Try
Dim cd As SqlCommand = New SqlCommand("mrmsp_EmployeeList", cn)
cd.CommandType = Data.CommandType.StoredProcedure
dr = cd.ExecuteReader
grdEmployees.DataSource = dr
grdEmployees.DataBind()
Catch ex As Exception
Msg = ex.Message
lblErr.Visible = True
lblErr.ForeColor = Drawing.Color.Red
lblErr.Font.Bold = True
lblErr.Text = Msg
Finally
cn.Close()
End Try
End Sub

The problem I’m having is I don’t know how to read the data stored in the first column on the GridView Control. I use the ID number stored in the first column to perform edits on selected records. I’m not using a SqlDataSource control on this web page.

Does anyone have any ideas on how to do this?

Thank you,

Quecumber256

Re: Can't retrieve data out of a GridView Control

minhpc_bk7-Feb-07 13:58

minhpc_bk

7-Feb-07 13:58

Quecumber256 wrote:
The problem I’m having is I don’t know how to read the data stored in the first column on the GridView Control.

+ You can get reference to the first cell of a row to get the value.
+ Another option is to store the key values using the DataKeyNames[^] property and you can access the value from the DataKeys collection.

Re: Can't retrieve data out of a GridView Control

Quecumber2568-Feb-07 3:12

Quecumber256

8-Feb-07 3:12

I didn't place a SqlDataSource Control on the web page. I think because I don't have this control on the page there are no references to the DataKeyNames and DataKeys properties.

I spent the whole day trying to find examples on how to set these properties through code. However, everything I did find required that a SqlDataSource Control be present.

My web page requires a greater amount of control than the SqlDataSource will allow.

Thank you for your help,

Quecumber256

Re: Can't retrieve data out of a GridView Control

minhpc_bk8-Feb-07 15:57

minhpc_bk

8-Feb-07 15:57

Actually, you can set the DataKeyNames property either in the control definition or in code, the values should be taken from the result data reader. For example:

GridView1.DataKeyNames = new string[] { "Id" };

....

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
    object key = GridView1.DataKeys[e.NewEditIndex].Value;
}

URGENT: Datalist question and Javascript

Nada Adel7-Feb-07 3:14

Nada Adel

7-Feb-07 3:14

I'm using Visual Studio.Net 2003, Asp.Net1.1.
I have a datalist bound from a database and loaded with some Names.
I want to fire an "onClick" event when I select an element from the datalist.
How can I do that from the HTML code.

Please it's very urgent.

Re: URGENT: Datalist question and Javascript

Not Active7-Feb-07 3:47

Not Active

7-Feb-07 3:47

Since you have been around here for 2 years, 10 months according to your profile, I'm sure you realize posts flagged as URGENT are usually ignored.

only two letters away from being an asset

Re: URGENT: Datalist question and Javascript

Nada Adel7-Feb-07 7:24

Nada Adel

7-Feb-07 7:24

Never knew about that..lol

Reporting Problem

Sarfaraj Ahmed7-Feb-07 3:08

Sarfaraj Ahmed

7-Feb-07 3:08

Hi EveryBody
Im using ASP.NET with VS 2005 and trying to make report with Microsoft Reporting Service. Those error Im getting is follows.

1.Report Viewer cant change the report. Example I got a TextBox under a Button where I can put a CustomerID in TextBox. I have put a CustomerID 1001 inside the TextBox and Clicked the Button, 1st Time Im getting the whole informations about that particular Customer. When I have changed the CustomerID like 1002 then !!! inside the code is working properly and the DataSet shows the information about that CustomerID 1002 but ReportViewer cant change the Customer Informations its remain same. Still its showing 1001 informations.

2.A data source instance has not been supplied for the data source 'DataSetAUDITLOG_CountLessons'. I have created 2 tables inside the DataSetAUDITLOG after that I have deleted CountLessons table from DataSET and Im not using this Table anymore and there is no relation with table anywhere. So why Im getting this error.

3. On the otherhand I want to send a CustomerID value to another page from a ReportViewer. Could you please tell me. How can I do it? If you have any project example about this please send me.

I need your help
Thanks

Sarfarj Ahmed

Sarfarj Ahmed

Error in datagrid paging

NetBot7-Feb-07 2:23

NetBot

7-Feb-07 2:23

How can i change the page index of a datagrid from code??? I want that everytime the grid loads the default should be page1.In my code this doesn`t happen. I have created a div which acts like calendar control ie it displays currently selected month,prevmonth & nextmonth link. I show employee info i a datagrid for the selected month. The problem is with paging . Here`s the problem.

Suppose for current month i have information which is 2 grid pages long and for next month it has only 1 page. when i select page 2 in current month and clickthe nextmonth it retains its pageindex2 and thus gives an error "Page index must be >=0 and <pagecount.

Help!!!

-- modified at 8:49 Wednesday 7th February, 2007

How to make secure login page ?

Member 20728477-Feb-07 2:21

Member 2072847

7-Feb-07 2:21

Hi all ...

How to make secure login page like on-line banking ?

1. How to prevent, the same user try to open in a new window (CTRL + N) ?
2. How to prevent, the same user try to open in another client machine ?

advance thanks and i hopfully awaiting for good solution from some one

thanks & regrds

Jai

Jai Sankar N

Re: How to make secure login page ?

badgrs7-Feb-07 2:46

badgrs

7-Feb-07 2:46

Not possible. Go to an online banking page and you'll see you can do both those things easily.

How to make secure login page ?

Member 20728477-Feb-07 2:20

Member 2072847

7-Feb-07 2:20

Coding Multi parameter methods in ASP.NET 2.0

Omkar Ghaisas7-Feb-07 1:54

Omkar Ghaisas

7-Feb-07 1:54

Hi,
I have been working in the Procedural language domain using VB and similar technologies.
As we know in VB, we can define functions or Sub with multiple parameters like

Private Function DisplayData(int Param1, string Param2..., int Param10)
End Function

and Call it as DisplayData(2,"stringData", ... 10)
But the prob is that we have to pass in 10 parameters in single line and there is no concept of Data Hiding.

How does ASP.NET 2.0 introduce the concept of encapsulation in here ?
How to do coding for functions / subs like these in ASP.NET 2.0 using C#.

Pls guide me.
Omkar

Re: Coding Multi parameter methods in ASP.NET 2.0

Tristan Rhodes7-Feb-07 4:10

Tristan Rhodes

7-Feb-07 4:10

You could try looking at the 'param' keyword in C# (not sure what VB equivalent is).

This enables you to specify an unknown number of arguments as the final parameter. You need to specify the type of objects in the param collection.

See the string.Format() function for an example of where this is used.

T

Security Concern

Tristan Rhodes7-Feb-07 1:44

Tristan Rhodes

7-Feb-07 1:44

I have a security concern with a website i'm working on, and i'm curious, how easy would it be to catch a Response.Redirect("url"), and tamper with the URL values?
Is the Response.Redirect executed under the hood? And could a simple home brewed browser function set enable that to be caught, modified, and resumed?

Cheers

T

Re: Security Concern

badgrs7-Feb-07 2:43

badgrs

7-Feb-07 2:43

I'm not entirely sure what you mean. Are you asking whether the url can be tempered with? Well yes, the user will see the url they are being redirected to and be able to change it in the address bar.

Do you mean can they intercept the Response.Redirect()? Not exactly cos thats all server-side. What the method actually does is send an HTTP 302 (I think, could be another 300 code) redirect code to the browser with the new url.

Re: Security Concern

Tristan Rhodes7-Feb-07 3:40

Tristan Rhodes

7-Feb-07 3:40

I actualy have a system which is a set of daisychained Response.Redirects, and i'd like to know if they can be caught and modified at each step.

By the looks of it, no. But i thought that the Response.Redirect went back to the client first, with the response.

Re: Security Concern

badgrs7-Feb-07 3:50

badgrs

7-Feb-07 3:50

Then the answer is yes, they can be caught and modified at each step. As I said, each one sends an HTTP redirect to the browser so yes it goes back to the client first, its very easy to see each one.

Re: Security Concern

Tristan Rhodes7-Feb-07 3:56

Tristan Rhodes

7-Feb-07 3:56

Ok, thanks. Just needed confirmation.

*sigh*

Time to write up that report. Frown | :(

Regarding persistance

Kissy167-Feb-07 1:32

Kissy16

7-Feb-07 1:32

Hai to all,
I have developed a webapplication.Presently i have declared and using variables which are used in all the application using module1.vb(ex:public i as integer,different variables for different purposes).
But this type of declaration will give a great problem in the future,in maintainace??It is true.Wats the solution for this???
Is it true that using more Session Varibles causes the application slow????
But still i am using both of them.
Give me correct idea wat i have to use for the best maintaince???
Thank in advance.

kissy

Re: Regarding persistance

Sandeep Akhare7-Feb-07 1:53

Sandeep Akhare

7-Feb-07 1:53

Hi Don't make your application more complex ............
i think you should store all those varaibles in datacontainer class
having private variables and public properties
Populate your data to this datacontainer class and enjoy coding

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