|
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
|
|
|
|
|
Hi ,
i have one site in that i want to implement single singon service.
can u plz give me one idea
Thanks & Regarda
Sams
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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);
foreach (string dirPath in dirs)
{
if (Page.User is allowed to access dirPath)
{
}
}
foreach (string filePath in files)
{
if (Page.User is allowed to access filePath)
{
}
}
Any advice would be greatly appreciated 
Thanks,
Lea Hayes
|
|
|
|
|
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.
|
|
|
|
|
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"))
{
}
}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, 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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
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 of a user from Active directory using SID?
|
|
|
|
|
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
|
|
|
|
|
Well his post was to find SID from Active directory
my Question is to find Password from Active directory using SID
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
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.
|
|
|
|
|
thanks.
but cant I get any online resource for this?
Vijay V.
Yash Softech
|
|
|
|
|
|
thanks for the link but I m not looking for this.
Vijay V.
Yash Softech
|
|
|
|
|
Mind telling us what you are looking for then? I mean its one thing to ask people to STFW for you, but without giving us too much of a clue what you're after, its a little hard.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
