ASP.NET Discussion Boards

Clicking in a datagrid row anywhere and on postback retreiving a cell value

SandeepkKumbhar10-Oct-07 5:15

10-Oct-07 5:15

hi,
i have got a datagrid. i want to allow the user to click anywhere in a datagrid row anywhere. on postback i want to retreive a column value of that selected row and then proceed further. how can i go ahead in asp.net 2005

Sandeep Kumbhar

Re: Clicking in a datagrid row anywhere and on postback retreiving a cell value

N a v a n e e t h10-Oct-07 18:15

N a v a n e e t h

10-Oct-07 18:15

No inbuilt functionality is available. Datagrid will be rendered as HTML tables. So you need to override postback functionality to make it happen

My Website | Ask smart questions

Re: Clicking in a datagrid row anywhere and on postback retreiving a cell value

SandeepkKumbhar10-Oct-07 18:32

SandeepkKumbhar

10-Oct-07 18:32

hi,
thanks for ur valuable reply.
if we use the same thing in gridview it happens. like in gridview in rowdatabound we define e.row.attributes["onclick"]....., on clicking the row anywhere it calls the selectindexchanged event. But in datagrid this is not happening. in datagrid itemdatabound i am defining e.item.attributes..

i am not getting which method to override.

ASP.Net IDE general questions..

Dio2210-Oct-07 5:11

Dio22

10-Oct-07 5:11

I'm pretty new to working with ASP.net on Visual Studio 2k5. Is there any reason why when you move more than a couple of controls on the web form at a time, it takes a long time for them to actually move. The development environment seems to be slower/more clunky when it comes to manipulating web forms as opposed to normal forms. Also, is their any way to enable snap lines in the web form designer? And why does everything that is dropped onto the form automatically jump to the top left corner?

Re: ASP.Net IDE general questions..

scicorp10-Oct-07 7:25

scicorp

10-Oct-07 7:25

This is bcoz u dont know the actual usage of the page in asp.net purpose.
there r 2 pages in asp.net
1. aspx
2.ascx
so actual controls r placed in ascx page and entire ascx page is draged to the aspx page.

why u hav 2 do all this is understood if u do a project.

Hope this will clear ur question.

mallika

Access GridView's full data table

GreenGiant8310-Oct-07 3:39

GreenGiant83

10-Oct-07 3:39

I am creating a class that inherits from the GridView control and addes a bit of functionality. One bit of functionality that I want to add is the ability to select from a drop down list the unique values on each column header to filter, similiar to the functionality you get in excel with its filters. So if you have the column header for "Department" when you mouse over it, it shows a drop down list of the unique values for the department column and lets you select one, that would then filter the displayed records to just the ones containing that department.

Right now I am dynamically adding DropDown extenders to the header label on the OnRowDataBound() event. To make the list of unique values I was processing the values of the data row by row also in the OnRowDataBound() event. Everything works great until you turn on paging. Then the list of unique values only contains the values that are displayed on that particular page, whereas I want to be able to have the unique values from the entire data table that the grid is bound to. I understand why I only get the data for each page (because I am using e.Row.DataItem from the RowDataBound() event, which only fires for the displayed records). What I think I need is access to the gridview's full datatable to select the results out of it that I want. How can I do that? Or is there a better way to approach this?

Thanks,

Re: Access GridView's full data table

GreenGiant8310-Oct-07 5:49

GreenGiant83

10-Oct-07 5:49

To answer my own question. I am using the GetData function that returns a DataSourceView, and then running an async select statement on it. If there is a better way to do this please let me know. For the moment this appears to work

//Loop over each column in each row and compare it the existing unique values<br />
        //If the column value is unqiue add it to list.  OnDataBound()<br />
        //uses this data to generate filtering list <br />
        void DataSourceViewSelectCallback(IEnumerable e)<br />
        {<br />
            bool isUnique;<br />
            data = new ArrayList[Columns.Count];<br />
            for (int i = 0; i < data.Length; i++)<br />
            {<br />
                data[i] = new ArrayList();<br />
            }<br />
<br />
            foreach (DataRowView drv in e)<br />
            {<br />
                for (int i = 0; i < data.Length; i++)<br />
                {<br />
                    isUnique = true;<br />
                    foreach (object o in data[i])<br />
                    {<br />
                        if (object.Equals(o, drv.Row[i]))<br />
                        {<br />
                            isUnique = false;<br />
                            break;<br />
                        }<br />
                    }<br />
                    if (isUnique) data[i].Add(drv.Row[i]);<br />
                }<br />
            }<br />
        }<br />
<br />
        protected override void OnDataBound(EventArgs e)<br />
        {<br />
            DataSourceView dsv = GetData();<br />
            DataSourceSelectArguments args = new DataSourceSelectArguments();<br />
            dsv.Select(args, new DataSourceViewSelectCallback(DataSourceViewSelectCallback));<br />
            ....<br />
        }<br />
<br />

unable to run xp_cmdshell from inside a stored procedure

MissionSuccess10-Oct-07 3:33

MissionSuccess

10-Oct-07 3:33

i want to run a DTS package from inside a procedure like this

ALTER PROCEDURE [dbo].[usp_ImportData] AS
begin
DECLARE @DTSRUNCommand as varchar(255)
SET @DTSRUNCommand =
'DTSRUN /N ' +
'DumpPRMasterToRadhika /E /S ' +
'@@MyServer'
EXEC master..xp_cmdshell @DTSRUNCommand

end

its giving me the error
sql server does not exist or access is denied

please tell me which access rights i require to run it..

i am the system admin on sql-server.

Re: unable to run xp_cmdshell from inside a stored procedure

kubben10-Oct-07 4:58

kubben

10-Oct-07 4:58

Have you tried google?

Here is a link:
http://msdn2.microsoft.com/en-us/library/Aa260689(SQL.80).aspx[^]

Ben

Re: unable to run xp_cmdshell from inside a stored procedure

MissionSuccess10-Oct-07 19:13

MissionSuccess

10-Oct-07 19:13

sir i am running it under the administrator account.

i logged in to sql-server analyzer through windows authentication.
That means i m running it under administrator account.
Administartor are already under the sysadmin role.
Still the same error....

Please i am little bit confused.

help me out

Re: unable to run xp_cmdshell from inside a stored procedure

kubben11-Oct-07 2:36

kubben

11-Oct-07 2:36

Pretty sure you need to enable xp_cmdShell. Something like this:
USE master
GO
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'show advanced options', 0
GO

Check out this link about half way down the article:
http://sqlserver2000.databases.aspfaq.com/how-do-i-prevent-linked-server-errors.html[^]

Ben

splash screen on login screen

snir_ya10-Oct-07 2:36

snir_ya

10-Oct-07 2:36

Hi,

I'm trying to run a flash intrudction on the login screen.
The flash should run for a few seconds then disappear and the login control should apprear. This should happen on the same page.

Does anyone have an idea how to implement it, or maybe direct me to a good source of info about it?

Thanks in advnace,

Snir.

Re: splash screen on login screen

kubben10-Oct-07 5:02

kubben

10-Oct-07 5:02

Sounds like you need to auto refresh your page. There are a couple ways to do it. You can use javascript. Or you can put in a meta tag.

The meta tag looks like this:

Where n is seconds before refresh
and url is the url to refresh to. You can leave the url blank and it will just refresh the page. I am in process of writing an article about this.

Hope that helps.
Ben

Re: splash screen on login screen

snir_ya10-Oct-07 5:23

snir_ya

10-Oct-07 5:23

Hi Ben,

Thank you for the answer.

I've figured it out:

The flash file (FLA file) need to have a naviageToUrl command in its last row that's directed to your login page.
When publishing the FLA file using a common a flash editor (for example adobe flash CS3 pro) it creates an html page that runs the flash file and when it ends it navigates it to the login page.

That's it. So simple. So little documentation on the web about it.

Hopefully a lot of preplexed folks would read this post.

Snir.

Re: splash screen on login screen

Pete O'Hanlon10-Oct-07 10:36

Pete O'Hanlon

10-Oct-07 10:36

Arggh - flash intros on web pages. Do you have any idea how this really annoys users? It's generally considered to be one of the worst things you can do on a site. Think about it - users want to get into a web site and start using it as quickly as possible. Metrics suggest that customers will navigate away of content isn't displayed in less than 5 seconds - losing you customers and making your competitors happy. Just because you can use Flash doesn't mean that you should.

Deja View - the feeling that you've seen this post before.

Javascript????

Vanamaindia10-Oct-07 2:24

Vanamaindia

10-Oct-07 2:24

How Can I disable Refresh button In IE using Javascript?
remember Not F5 ,it's refresh Button??

Re: Javascript????

Sandeep Akhare10-Oct-07 2:46

Sandeep Akhare

10-Oct-07 2:46

Open the a new window without having Address bar but keyboard short cuts will still available for user

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

Re: Javascript????

Vanamaindia10-Oct-07 2:31

Vanamaindia

10-Oct-07 2:31

This Code is For disabling Right Click on IE..I want to disable refresh button?

Re: Javascript????

Sathesh Sakthivel10-Oct-07 2:34

Sathesh Sakthivel

10-Oct-07 2:34

There is no way AFAIK to disable the refresh button, but you can hide it in a new window. But the user can always hit F5 or right-click to refresh....

Why would you want to take away the refresh button anyway?

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

Session Woes

Andrew S. Kloos10-Oct-07 1:43

Andrew S. Kloos

10-Oct-07 1:43

We're running asp.net 1.1 on iis 6.0 and we're running into all kinds of problems with our in proc sessions. Last week we had a user that actually had an element another users shopping cart and it did not contain what the user had entered. This week we had two orders come thru with 0 items due to dropped session. The users assured us that they had not been on the website for the alloted session timeout. Nothing changed programmaticly for this section of our site. Any Idears?

Re: Session Woes

N a v a n e e t h10-Oct-07 2:24

N a v a n e e t h

10-Oct-07 2:24

crazidiamond wrote:
we had two orders come thru with 0 items due to dropped session.

This shows your programs loop holes. Don't you validate all these before an order is placed ? What is your actual problem here ? How you are storing shopping details in session ?

My Website | Ask smart questions

Re: Session Woes

Andrew S. Kloos10-Oct-07 4:04

Andrew S. Kloos

10-Oct-07 4:04

I was handed an amazingly sloppy site. I've been correcting pieces of it as I go along but their aren't enough hours in the day. Since this issue came up I added some logic to determine if in fact the cart is populated. but the bigger problem is that we show no errors when users are placing items into the cart which is stored in "in proc session" and then at a later time we try to access the session contents and the session is not present. We have a Serializable Cart class and we stored the class instance in session. We also determined that the session was not dropped due to timing out. I'm at a loss...

indexing server

venky45610-Oct-07 1:26

venky456

10-Oct-07 1:26

hi,
how to display .rtf files in indexing server.
plz help me to get results asap.
regards

venkat

Get Roles For a Specific

Brendan Vogt10-Oct-07 1:17

Brendan Vogt

10-Oct-07 1:17

Hi,

I am writing a system where I log on to a backend where I can see a list of all the user/customers that have registered on the system. When I click on a specific user I can see his/her details. Including the roles. How do I use the roles provider to get the roles for a specific user? What I mean is, I don't to see the roles of the currently logged on user, but for a user that I select.

Must go and write my own method to get this, or is there a way of retrieving a user's roles?? I know there is something like a GetRolesForUser method, but that seems to be the roles for currently logged on user.

Please can someone advise.

Brendan

Find out the Session in a application

Aavesh Agarwal10-Oct-07 1:16

Aavesh Agarwal

10-Oct-07 1:16

hi,
is there any way by which i can find out that how many session variables i have used in a particluar project.

Thanks and Regards
Aavesh Agarwal

Last Visit: 31-Dec-99 18:00 Last Update: 1-May-24 1:42

Refresh

ᐊ Prev 1...4163 4164 4165 416641674168 4169 4170 4171 4172 Next ᐅ

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