display fields in excel based on user role or id

=?Utf-8?B?TmFuY2Vl?=

Hi All,

Here is the scenario. I need a solution/suggestion how to work around this
problem.
My application has users with different roles. When they click on a button
"Download Spreadsheet" in aspx page, they should be able to download a
spreadsheet with necessary columns. Based on the role the spreadsheet has to
have the necessary fields. Then they save this spreadsheet on to the local
drive and update with the info.

My questions is how to get this task done? Any kind of suggestion is
appreciated.

Let me know if anyone needs more info.

Thanks,

Jun 22 '07 #1

Subscribe Reply

1322

Mark Rae

"Nancee" <Na****@discuss ions.microsoft. comwrote in message
news:B7******** *************** ***********@mic rosoft.com...

My questions is how to get this task done? Any kind of suggestion is
appreciated.

First question, I suppose: (why) does it have to be Excel...?
--
http://www.markrae.net

Jun 22 '07 #2

=?Utf-8?B?TmFuY2Vl?=

"Mark Rae" wrote:

"Nancee" <Na****@discuss ions.microsoft. comwrote in message
news:B7******** *************** ***********@mic rosoft.com...

My questions is how to get this task done? Any kind of suggestion is
appreciated.

First question, I suppose: (why) does it have to be Excel...?
--
http://www.markrae.net

I don't understand if I am answering your question or not......It has to be
excel because its easy for non technical users to update info easily and lot
of them have the systems in place to work with excel.

But this is what we do. ............... .....

The user after updating the information, need to send us the information
back to us. We upload this info to our database. The data they update in the
excel is very important for us to analyze, evaluate.....

Regards........ ..
PR

Jun 22 '07 #3

Mark Rae

"Nancee" <Na****@discuss ions.microsoft. comwrote in message
news:1B******** *************** ***********@mic rosoft.com...

>First question, I suppose: (why) does it have to be Excel...?

I don't understand if I am answering your question or not......It has to
be
excel because its easy for non technical users to update info easily and
lot
of them have the systems in place to work with excel.

But this is what we do. ............... .....

The user after updating the information, need to send us the information
back to us. We upload this info to our database. The data they update in
the
excel is very important for us to analyze, evaluate.....

Er, yes, but that's the whole point! If the user simply filled in the data
directly on your website, maybe through some sort of grid, then there would
be no need for Excel at all...

You want to store data from your users in a database and then analyse it -
why do you need to use Excel for this...???
--
http://www.markrae.net

Jun 22 '07 #4

Similar topics

2319

header problem - want to display html AND download a file

by: mike | last post by:

ok here's the problem: I have a page that displays a form for user to select individual fields and to specify their own criteria which is used to query a database and then create an excel spreadsheet and download it to their PC. when the user clicks on the "create a custom query" link on the reports page the file customss.php displays the form that list the various fields and criteria to specify for the search. This part

PHP

2919

threading and Principal question - from Role-based security to declarative security.

by: hazz | last post by:

If I successfully run a VS.NET app which includes the following; ************************** APP 1 **************************** m_iIdnt = new System.Security.Principal.GenericIdentity(t.UserName,"MyAuthentication"); //user and My authentication type added to Identity string roles = {"Chief Cook and Bottle Washer", "Master Gardener"};

C# / C Sharp

1940

ARCHITECTURE : Enabling and disabling functionality in ASP.NET based on roles.

by: VSK | last post by:

Hi all, In our ASP.NET web application we have to enable or disable features in each ASP.NET page based on role assigned to user. Ex: if user who logs in is superisor then he can change phonenumber in page1.aspx if user who logs in is finaceofficial then he can just view the phone number in page1.aspx

ASP.NET

2017

Role Based Security Question

by: Mike Logan | last post by:

Questions about Role Based Security in ASP.Net: I have a few questions about role based security in an ASP.Net application. Below are some points about our system: - We have a hierarchical roles system stored in a database. - We are also using Windows for authentication. - Page - Role relationships are also held in a database. - We have created a shared assembly for ease of use in applications.

ASP.NET

3145

Role Based Personalization

by: bradgatewood | last post by:

I am in the process of developing a highly customizable application and I'm looking for a way to allow personalization by role. This is different than shared scope in the fact that I want to allow multiple clients to make modifications to properties, placement, controls on page, etc... and have all users see the customizations that apply to them. Customizations will take place at Client > Branch > Division levels. So when a user logs into...

ASP.NET

1695

design guidance please :user controls and centralizing roles-related display stuff

by: | last post by:

I'm looking for some design guidance on a collection of projects I'm working on. The project involves a bunch of websites constructed out of a collection of user controls. Different user populations with different access rights and "roles" will be visiting the site. I will be using ASP.NET 2.0's membership, roles, and profiles stuff to manage access. User controls need to be visible or not visible depending on user role. In some...

ASP.NET

1295

How to build role based app?

by: JohnC | last post by:

I'm in the concept stage of putting together a web application. Certain featues will be available only if the person has been given access. This is based on their particular subscription. I can create database tables that have an entry for each user and the features they have access to. The logic that decides whether the feature should be diplayed or not (reading values from tables) will be at the .NET class level. I want to make...

ASP.NET

1393

Authentication and user based content

by: John Devlon | last post by:

Hi, I've created a small application with some user-authentication and roles. I would like to show/hide some navigation parts based on the users role. Could someone please tell me what the best solution is? Do I have to create different pages for each role and check the users role when logged in?

ASP.NET

2437

How to display individual and summary records in a query?

by: randyse | last post by:

Hello all, This is my first post, please let me know if I've missed any relevant data or guidelines. I'm using Access 2003 for the database and Excel 2003 for the reporting to avoid having everyone reading the reports install the snapshot viewer. I'm also porting this application to SQL Server/ASP.NET eventually, and there is not a way to install reporting services on the server, so my hope is to use Excel there as well. I'm using two...

Microsoft Access / VBA

7962

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8443

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8107

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

5971

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5467

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

3945

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3989

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2452

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1565

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP