|
that crossed my mind, but would that work if I'm using form auth?
|
|
|
|
|
|
I was not able to edit the existing reply...here is sample code:
Use this in the web.config:
<forms name="Testproject"
path="/"
loginUrl="~/Login.aspx"
protection="All"
timeout="20"
requireSSL="false"
slidingExpiration="true"
defaultUrl="Home.aspx"
cookieless="UseDeviceProfile"
enableCrossAppRedirects="false" />
</authentication>
<authorization>
<deny users="?"/>
</authorization>
<identity impersonate="true" userName="domain\user" password="xyz@123"/>
with kudos,
Pradeep
|
|
|
|
|
No offense, but most production systems that I've ever worked on would consider embedding a password in plain text in a file, a security violation and not allow it. Even if that file is on a server with access permissions.
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
I agree Chris..this was just to show how impersonation can be done using Forms authentication.
This section can be easily encrypted using one of these methods:
http://msdn.microsoft.com/en-us/library/zhhddkxy.aspx[^]
Thanks for raising the point tough...
with kudos,
Pradeep
|
|
|
|
|
Hi
Does anyone know how to make aplhanumerical sorting for SQL Server CE ?
CE does not support Isnumeric-function, so it cannot be used.
CE version is 3.5, VisualBasic 2010 does not support CE 4.0.
jtpaa
-- Modified Thursday, August 4, 2011 7:28 AM
|
|
|
|
|
Did you check this google result[^]?
I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.
www.cacttus.com
|
|
|
|
|
Hi
Yes, I have searched this topic with google.
But I have not found usable solution.
If You check those google results and if You find something useful, could You then send notification
jtpaa
|
|
|
|
|
Dear
Get the list of Customers where Company Name's 2nd letter is Consonant. (Table: Customers)
i am using northwind database.plz tell me how to solve that problem.
any comments are highly appreciated.
Shafik
modified on Thursday, August 4, 2011 3:45 AM
|
|
|
|
|
What have you tried?
Are you using SQL? ADO.NET? LinQ?
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
You haven't mentioned what database you are using. For MS SQL Server, it would be:
SELECT * FROM Customers WHERE SUBSTRING(CompanyName,2,1) NOT IN ('a', 'e', 'i', 'o', 'u')
|
|
|
|
|
What is the second character in the computer name is not a letter, like O'Darby?
|
|
|
|
|
Oh, well then...
You'll need two more tables:
CharacterClass
ID CharacterClass
1 Vowel
2 Consonant
3 Digit
4 Symbol
5 Whitespace
Character
Character CharacterClass
A 1
B 2
...
Then simply JOIN.
|
|
|
|
|
PIEBALDconsult wrote: Oh, well then...
You'll need two more tables:
I know that.. I wanted others to think the answer through...
|
|
|
|
|
Chances are the O' folks never made it into the database because parameters were not used for the input, and no one did a .Replace("'","''") on the SQL string, so it's not an issue.
|
|
|
|
|
Or because the GUI specifically excludes those because the developer doesn't know anyone with a name like that.
|
|
|
|
|
Isn't that just the luck of the Irish.
|
|
|
|
|
I thought I was being facetious in my over-engineering way.
|
|
|
|
|
The code was just a heads-up to get the OP started with something. I'd have suggested something better if the OP came back with the specifics.
|
|
|
|
|
Dear sir
Please explain me how i can get the reference of a primary key colun in a database. what exactly i want to do....
I have a table "[plan]"
"PK column is PlanId"
how many tables are using this column reference(foregin key reference) in mydatabase, i wana get these tables name.
Waiting for your favorable reply.
Regards
Digvijay
|
|
|
|
|
There is not an easy answer here, it is down to your database schema.
One way I would approach this is to buy a bottle of good scotch and take it to the DBA. Ask the DBA "what tables link to plan using planId ?"
If he can't help then you'll need to do some mining.
First find the candidate field names. Not knowing which DB you are using I can give a generic idea:
SELECT DISTINCT COLUMN_NAME FROM SYSTEM_COLUMNS
Here the table SYSTEM_COLUMNS is the system table containing all the column definitions and COLUMN_NAME is the field with the column name.
If you know the definition of the field planId you could add it into the query to narrow down the search.
Once you have your fields, you can then query to get the tables that contain these fields. It is /relatively/ easy SQL but does need a bit of leg work to read through the results and ensure you have no false positives.
If the table and column names do not follow a structure then I am afraid you may well have to use educated guesses.
Panic, Chaos, Destruction. My work here is done.
Drink. Get drunk. Fall over - P O'H
OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre
I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer
Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett
|
|
|
|
|
Could you please tell us what RDBMS you are using? Oracle? MySQL? Microsoft SQL Server? This will help us to better help you with an answer.
|
|
|
|
|
Dera Sir,
Thanks for your quick response.
I'm using SQL server 2008 and SQL server 2008R2
|
|
|
|
|
Since you mentioned in one of your comments that you are using SQL Server 2008, you can query the sys.foreign_keys table to get the information you want.
|
|
|
|
|
I second that suggestion.
|
|
|
|