|
Hi Everybody,
Please help me to solve my problem.
I am developing an window application in C#, in that I have designed some crystal report. All this crystal reports are running properly on my development machine. But When deployed at client machine, whenever the user views the report it ask for login name and password.
I have given logon information through my code using TableLogInfo. But still While viewing the report, it asks for Login name and password.
Please Provide Me The Better Solution You Have.
Thanks & Regards
Sanket Patil.
.
|
|
|
|
|
it is asking your db login name and passowrd, anyways a lil bit of code will help you fast.
All work and no play make jacks a dull boy.
|
|
|
|
|
Hi Alok Sharmaji,
Thanks For Your Reply. But Let me know what type of lil bit of code will help me. If you have please send me an sample code.
Please help me.
Thanks & Regards
Sanket Patil.
.
|
|
|
|
|
have you tried what i said to you, if not do so, also from lil bit of code i meant of ur code snipt to see what you have done so far(LOL) anyways read here[^]
|
|
|
|
|
Thanks Once Again For The Reply. What I Have Done In My Code Is Here.
ALLEXE = new PayrollSoft.Report.AllowanceExempt();
tblinfo = new TableLogOnInfo();
foreach (Table Atbl in ALLEXE.Database.Tables)
{
tblinfo = Atbl.LogOnInfo;
tblinfo.ConnectionInfo.ServerName = objcon.GetServerName();
tblinfo.ConnectionInfo.DatabaseName = objcon.GetDatabaseName();
tblinfo.ConnectionInfo.UserID = objcon.GetUserId();
tblinfo.ConnectionInfo.Password = objcon.GetPassword();
if (objcon.GetTrustedConnection().ToUpper().Equals("YES"))
tblinfo.ConnectionInfo.IntegratedSecurity = true;
else
tblinfo.ConnectionInfo.IntegratedSecurity = false;
Atbl.ApplyLogOnInfo(tblinfo);
}
ALLEXE.RecordSelectionFormula = "{ALLOW_EXEMPT.IA_CM_CODE}= " + Masters.MainMaster.CMPID + " AND {ALLOW_EXEMPT.IA_YEAR}=" + cmbYear.Text.Remove(4, 1) + " AND {ALLOW_EXEMPT.IA_DELETE}=false " + Query;
StrCompanyName = objcon.GetColumn("Select CM_COMP_NAME from COMPANY_SETTING WHERE CM_COMP_ID=" + Masters.MainMaster.CMPID + "");
ALLEXE.SetParameterValue("companyname", StrCompanyName);
crystalReportViewer2.ReportSource = ALLEXE;
this.Show();
Hope This Is The Right Way to Provide Logon Information To Report.
Thanks & Regards
Pankaj Patil.
.
|
|
|
|
|
|
pls i want to generate a ten digit crypted value from a 4 digit number,
pls how do i get it done.
thank you.
|
|
|
|
|
Sorry, but you will have to explain your requirement rather more clearly.
You could use any method you like to generate a ten digit code from a 4 digit, so that it could be converted back, but what are you trying to achieve?
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
|
|
|
|
|
My plaintex is a four digit xters, after encryption i get a 24 digit set of xters,
i want to limit the encrypted values to just 10 digits,
is that posible?
if so pls how?
thank you.
|
|
|
|
|
Looking briefly at your code reply on the other thread, this is for password matching?
If so, then just do what everyone else does - don't use encryption, use hashing. MD5 or SHA will give you a 128bit hash of a password which you can store and check against. That is what most do - since it is a hash, it is not reversible (you don't need a key to generate it, just the password) and it can't be reverse engineered to get the password (particularly for SHA, MD5 can be revwerse engineeered in some circumstances).
It is also a good idea to include the UserId with the password before hashing, so that two users with the same password don't generate the same hash...
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
|
|
|
|
|
What method of encryption are you using that is resulting the the 24 character result?
What factors made you choose this method of encryption?
Why are you encypting the value?
Do you need to be able to decrypt the result in order to obtain the original value?
Are there any transport considerations e.g. 7-bit transmission restriction?
Need more info to help.
|
|
|
|
|
What code you have written?
If it is showing any error then put your error we will help you.
Regards,
Sathesh.
The best way to express one's gratitude to the Divine is to feel simply Happy..
|
|
|
|
|
here is my code:
public static string iEncrypt(string plainText, string passPhrase, string saltValue,
string HashAlgorithm, int passwordIterations, string initVector,
int KeySizes)
{
byte[] initVectorBytes = Encoding.ASCII.GetBytes(initVector);
byte[] saltValueBytes = Encoding.ASCII.GetBytes(saltValue);
byte[] plainTextBytes = Encoding.UTF8.GetBytes(plainText);
PasswordDeriveBytes password = new PasswordDeriveBytes(passPhrase, saltValueBytes, HashAlgorithm, passwordIterations);
byte[] keyBytes = password.GetBytes(KeySizes / 8);
RijndaelManaged symmetricaKey = new RijndaelManaged();
symmetricaKey.Mode = CipherMode.CBC;
ICryptoTransform encryptor = symmetricaKey.CreateEncryptor(keyBytes, initVectorBytes);
MemoryStream memoryStream = new MemoryStream();
CryptoStream cryptoStream = new CryptoStream(memoryStream, encryptor, CryptoStreamMode.Write);
cryptoStream.Write(plainTextBytes, 0, plainTextBytes.Length);
cryptoStream.FlushFinalBlock();
byte[] cipherTextBytes = memoryStream.ToArray();
memoryStream.Close();
cryptoStream.Close();
string cipherText = Convert.ToBase64String(cipherTextBytes);
return cipherText;
}
static void Main(string[] args)
{
//string plainText="Hello World!";
string plainText;
string passPhrase = "Pas5pr@se";
//string passPhrase = "123456789";
//string saltValue = "123456789";//s@ltValue";
string saltValue = "s@ltValue";
string hashAlgorithm = "SHA1";
int passwordIterations = 1;
//string initVector = "abcdefghijklmnop";//@1B2c3D4e5F6g7H8";
string initVector = "@1B2c3D4e5F6g7H8";
int keySize = 64;//256;
//Console.WriteLine(string.Format("Plaintext : {0}", plainText));
Console.WriteLine(string.Format("Type Plaintext : "));
plainText= Console.ReadLine();
string cipherText = dEncrypt.iEncrypt(plainText, passPhrase, saltValue, hashAlgorithm, passwordIterations, initVector, keySize);
Console.WriteLine(string.Format("Encrypted : {0}", cipherText));
}
|
|
|
|
|
Please remember to use the pre tags when posting code snippets.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi All,
I want to have an ASP C# WebSite that loads a simple CSV File and present it in a GridView control (at least for a start).
I already have a piece of code that do almost all of the work, what i miss / unable to make it work is setting correctly the "Data Source".
The CSV file that I want to load is located on different server in the network (path is "\\td47vc\public\Joe\ASP\Test").
Here is the code I wrote:
public DataSet GetCSVFile(string fileName)
{
string pathName = "\\td47vc\\public\\Joe\\ASP\\Test";
string file = System.IO.Path.GetFileName(fileName);
OleDbConnection excelConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathName + ";Extended Properties=Text;");
OleDbCommand excelCommand = new OleDbCommand(@"SELECT * FROM " + file, excelConnection);
OleDbDataAdapter excelAdapter = new OleDbDataAdapter(excelCommand);
excelConnection.Open();
DataSet ds = new DataSet();
excelAdapter.Fill(ds);
excelConnection.Close();
return ds;
}
I get the following error:
'\\td47vc\public\Joe\ASP\Test' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
Thanks,
GorovDude
|
|
|
|
|
Well you could try:
0)
@"\\td47vc\public\Joe\ASP\Test";
1) Using the IP of the server instead of the server name (10.xx.xx.xx instead of \\someserver01).
Maybe it's on a different VLAN and it does not know it by name
2) If it still doesn't work then it's clearly a matter of credentials/rights. That one only you and/or the admin can fix.
I used to think....
Finally I realized it's no good.
modified on Tuesday, December 7, 2010 4:28 AM
|
|
|
|
|
do you really want double backslashes everywhere?
|
|
|
|
|
Nice.
I missed it completely. Just focused on the start. Fixed.
I used to think....
Finally I realized it's no good.
|
|
|
|
|
you'll have to try again I'm afraid, if you want a double backslash, either give four, or use '@'; three backslashes is no good.
I prefer the '@' approach, as that takes and shows the string as intended.
|
|
|
|
|
Yep that's what I did. Just before you fixed my "code" the second time 
I guess I'm better of just fooling around.
I used to think....
Finally I realized it's no good.
|
|
|
|
|
looking great now.
|
|
|
|
|
See this[^].it might be helpful.
|
|
|
|
|
what about setting your connection string in web inf instead of code
|
|
|
|
|
|
Try mapping virtual path to physical path using Server object. For example where you are doing
string pathName = "\\td47vc\\public\\Joe\\ASP\\Test";
instead do it something like
string pathName = Server.MapPath("~/Joe/Asp/Test.csv");
Where you need to make sure you are passing correct virtual path to MapPath call. You need to specify it relative to your application root.
I Web Development Free Lancer
Share your experience with others
Check my Blog...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
