Directory/File Permissions with ASP.NET - ASP.NET Discussion Boards

amit20119-Sep-08 5:21

amit2011

9-Sep-08 5:21

i am using Visual Studio 2005 and Sql Server 2000.
pl could u tell me how to Search database elements from the given textbox fields so that the comparison is independent of Case senstivity..

hope i made myself clear..
thanx

Re: Text search from database

Manas Bhardwaj9-Sep-08 5:27

Manas Bhardwaj

9-Sep-08 5:27

Select something from sometable where somefield like '%somevalue%'

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Text search from database

amit20119-Sep-08 5:54

amit2011

9-Sep-08 5:54

hey manas..
i dint get u..
i mean to say that in a textbox the value inputed has to be compared with that from database table.and i want that the search must be independent of capitalization of the textbox value.
example.
if table has "Sunday" then the textbox value "SuNdAy" must also match wid it..
pl explian it in detail,m a bit new to it..
thanx

Re: Text search from database [modified]

Rutvik Dave9-Sep-08 6:28

Rutvik Dave

9-Sep-08 6:28

as far as i know, SQL Server is not case sensitive for text comparision, so just compare like

select * from t where xyz = 'abc'
or
select * from t where xyz = 'ABC'
both are same.

'Sunday' and 'SUNDAY' are same in SQL Server.

or if you want to make sure than you can use either UPPER() or LOWER()

i.e. select * from t where upper(xyz) = 'ABC'

Also Manas is trying to tell you that if you want to do partial search then use 'Like' with '%'

ex.

select * from t where Day like 'S%'

will return both 'Saturday' and 'Sunday'

while select * from t where Day like 'Su%';
will return only 'Sunday'

in short % is like * in DOS.

modified on Tuesday, September 9, 2008 12:48 PM

how to implement single signon service?

srinivassam9-Sep-08 4:48

srinivassam

9-Sep-08 4:48

Hi ,
i have one site in that i want to implement single singon service.

can u plz give me one idea

Thanks & Regarda

Sams

Re: how to implement single signon service?

Manas Bhardwaj9-Sep-08 5:28

Manas Bhardwaj

9-Sep-08 5:28

How about this[^]

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

ASP.NET Treeview not refreshing

Blumen9-Sep-08 4:46

Blumen

9-Sep-08 4:46

Hi,

I'm populating a treeview in a form at page load when data inserted from another form and submitted. But Treeview data is not refreshed.

I input data into a form, click submit, user is redirected to a new page with a Treeview, this treeview data is not updated. I tried debugging, query is fetching correct data, but once treeview is bound and when it appears on the page, it shows previous data, nodes are not getting refreshed. I have called the DataBind() after setting DataSource of the TreeView.

I tried clearing the Nodes before setting DataSource property, but it was of no use!

Could someone tell me whats going wrong here?

Regards,
Blumen

Directory/File Permissions with ASP.NET

Lea Hayes9-Sep-08 4:36

Lea Hayes

9-Sep-08 4:36

Hi guys!

I have just created a simple user control which displays a directory listing of a specified root location on the server.

I then discovered that the Directory.GetDirectories and Directory.GetFiles methods ignore the access permissions of the logged in user. So, even though the user may not be able to view a particular resource, it is still being shown within the directory listing.

What I want to do is somehow filter out directories and files which the user does not have access to.

I am controlling directory/file access via 'Web.config' files. And this works a treat. I just cannot find an option to verify whether a user has access to a particular directory or not. Below is some pseudo-code which describes what I am trying to achieve, but I do not know what goes in the two if statements.

string[] dirs = Directory.GetDirectories(rootPath);
string[] files = Directory.GetFiles(rootPath);

// Fetch directories and files.
foreach (string dirPath in dirs)
{
    if (Page.User is allowed to access dirPath)
    {
       // Render directory entry.
    }
}
foreach (string filePath in files)
{
    if (Page.User is allowed to access filePath)
    {
        // Render file entry.
    }
}

Any advice would be greatly appreciated Smile | :)

Thanks,
Lea Hayes

Re: Directory/File Permissions with ASP.NET

Manas Bhardwaj9-Sep-08 5:31

Manas Bhardwaj

9-Sep-08 5:31

lhayes00 wrote:
I just cannot find an option to verify whether a user has access to a particular directory or not

By Web Princliples, a web user will never have access to any directory on Web Server.
What you can do here is the impersonation.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Directory/File Permissions with ASP.NET

Lea Hayes9-Sep-08 12:06

Lea Hayes

9-Sep-08 12:06

Hi,

Let's assume that the series of web.config files allows the user 'Bob' to access anything and everything. If 'Bob' tries to access the URL "webserver.com/users/bob/picture.jpg", he can...if anyone else tries to access this file a not authorized page appears to the user. This part works fantastic.

The Directory.GetDirectories method returns an array of paths which are relative to the server itself (i.e. "c:\wherever\users\bob\"). I have just found out that I could use the UrlAuthorizationModule. This would mean doing something like the following:

string[] files = Directory.GetFiles(path);

string rootPath = Page.ResolveClientUrl("~/filesroot");
foreach(string file in files)
{
   string tempPath = file.Replace(rootPath, "~/filesroot/");
   if (UrlAuthorizationModule.CheckUrlAccessForPrincipal(tempPath, Page.User, "GET"))
   {
       // Do rendering here...
   }
}

I have two questions:

1) Is there a better way of doing this, or a way which uses mapped paths instead of virtual paths? I tried using the FileAuthorizationModule but got completely lost as this takes an IntPtr token instead of an IPrinciple.

2) What do you mean by impersonation?

Thanks,
Lea Hayes

i want to connect Secure Ftp(SFTP) through my web application......

Shaik Haneef9-Sep-08 4:15

Shaik Haneef

9-Sep-08 4:15

i want to connect Secure Ftp(SFTP) through my web application, I found some but they are all Trail version, i want free software, Is there any website providing such type of service.Can any one help me in regards.

what is the problem with this piece of code?

snouto9-Sep-08 3:12

snouto

9-Sep-08 3:12

protected void Page_Load(object sender, EventArgs e)
{
//detecting the browser capability
IDictionary caps = Request.Browser.Capabilities;
IDictionaryEnumerator enumerator = caps.GetEnumerator();
string cap = string.Empty;
enumerator.Reset();
while (enumerator.MoveNext())
{
cap += enumerator.Key.ToString() + " : " + enumerator.Value.ToString() + "
";
}
Label1.Text = cap;

}

it gives me nullreferenceException :object reference not set to an instance of an object

but what is the problem , eveything is fine in the code ????

Human knowledge belongs to the world.

Re: what is the problem with this piece of code?

Manas Bhardwaj9-Sep-08 3:31

Manas Bhardwaj

9-Sep-08 3:31

snouto wrote:
it gives me nullreferenceException :object reference not set to an instance of an object

while (enumerator.MoveNext())
{
    cap += ((System.Collections.DictionaryEntry)(enumerator.Current)).Key.ToString() + " : " + ((System.Collections.DictionaryEntry)(enumerator.Current)).KeyValue.ToString() + " ";
}

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

SID is same for every User

Piyush Vardhan Singh9-Sep-08 2:01

Piyush Vardhan Singh

9-Sep-08 2:01

i am writing code for getting SID .
CODE:-
Dim _Sid As String = "S-1-5-21-1817689559-1280207852-1215589284"
Dim _sidTest3 As String = "S-1-5-21-1817689559-1280207852-1215589284 "
Dim path As String = "LDAP://d" 'Idea Cellular Ltd.
Dim ROOT As DirectoryEntry = New DirectoryEntry(path, "test2", "password", AuthenticationTypes.Secure)

Response.Write(New SecurityIdentifier(CType(ROOT.Properties("objectSid")(0), Byte()), 0).Value) 'CType(ROOT.Properties("objectSid")(0).Value, Byte)))

i am getting same SID When i change The user name(test1,test2,test3......)

i want to know it's right or wrong SID is same for every User

Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com

Reading from excel file.

hemant.kaushal9-Sep-08 1:50

hemant.kaushal

9-Sep-08 1:50

Hi,
In my application I m using excel file to enter the values in database.
It is working fine but it is giving a strange error.
If in a column let A

If we have value "DMIX00008" and "65400004"

Then it is reading values like "65400004" but values like "DMIX00008" are coming blank.

I think it is reading that column datatype as integer or numeric.
But i want that column to display values as they are entered.
How to rectify this problem?

Re: Reading from excel file.

Dilip H. Patel9-Sep-08 2:08

Dilip H. Patel

9-Sep-08 2:08

Hi Hemant,

I think that you are filling the datatable directly from the excel. and your first value in excel is numeric. that's why this problem is occured.

Try this one.
first you create columns of datatable, which you want to fill. make sure that column's datatype is string. and then try to fill it.

Regards,

Dilip Patel

Re: Reading from excel file.

hemant.kaushal9-Sep-08 3:01

hemant.kaushal

9-Sep-08 3:01

Thaks dilip_rollwala,

I change the first value to alphanumetic and it works.
But I cant create columns of datatable first.

How to find Password from Active directory using SID?

sumit70349-Sep-08 1:14

sumit7034

9-Sep-08 1:14

How to find Password of a user from Active directory using SID?

Re: How to find Password from Active directory using SID?

Ashfield9-Sep-08 1:49

Ashfield

9-Sep-08 1:49

Well, if you scroll down about 5 questions you will find someone (probably one of your classmates) has asked this very same question and received some replies.

Bob
Ashfield Consultants Ltd

Re: How to find Password from Active directory using SID?

sumit70349-Sep-08 1:56

sumit7034

9-Sep-08 1:56

Well his post was to find SID from Active directory

my Question is to find Password from Active directory using SID

Re: How to find Password from Active directory using SID?

Ashfield9-Sep-08 4:37

Ashfield

9-Sep-08 4:37

sumit7034 wrote:
Well his post was to find SID from Active directory

..and if you looked at the link in the reply it shows you how to get all sorts of data back.

Just take the code from the link, run in debug mode and look at all the properties available.

Bob
Ashfield Consultants Ltd

Re: How to find Password from Active directory using SID?

Abhijit Jana9-Sep-08 17:58

Abhijit Jana

9-Sep-08 17:58

sumit7034 wrote:
How to find Password of a user from Active directory using SID?

what does it mean ? you want to retreive user password from AD.
i think this is not possible, you can use password only for Authentication purpose and you can Reset it.

cheers,
Abhijit
Think Sharp | Code Sharp | C Sharp

creating dynamic pages in asp.net c#

VijayVishwakarma9-Sep-08 0:32

VijayVishwakarma

9-Sep-08 0:32

hi,

can anyone tell how to create dynamic pages in asp.net

I wanted to know how the pages in this site are created with the names in the menu links(brand products)

http://www.kixclusive.com/c-10-New-Arrivals.aspx[^]

thanks

Vijay V.

Yash Softech

Re: creating dynamic pages in asp.net c#

eyeseetee9-Sep-08 0:46

eyeseetee

9-Sep-08 0:46

I think you need to look at some beginners articles on how asp.net works before you go any further.

The answers posted by me are suggestions only and cannot be used in anyway against me.

Re: creating dynamic pages in asp.net c#

VijayVishwakarma9-Sep-08 0:50

VijayVishwakarma

9-Sep-08 0:50

thanks.
but cant I get any online resource for this?

Vijay V.

Yash Softech

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