C# Discussion Boards - CodeProject

Re: How to scroll ListView from your source code?

7-Dec-10 22:53

Sorry, I overlooked that. Could the EnsureVisible() method help you out?

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, and update CP Vanity to V2.0 if you haven't already.

#realJSOP7-Dec-10 23:30

#realJSOP

7-Dec-10 23:30

You could use pInvoke to set the scroll position.

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

Logon Failed Error For Crystal Report.

Sanket.Patil7-Dec-10 1:28

Sanket.Patil

7-Dec-10 1:28

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.

Alok Sharma ji7-Dec-10 1:51

Alok Sharma ji

7-Dec-10 1:51

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.

Sanket.Patil7-Dec-10 18:04

Sanket.Patil

7-Dec-10 18:04

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.

Alok Sharma ji8-Dec-10 0:45

Alok Sharma ji

8-Dec-10 0:45

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[^]

Sanket.Patil8-Dec-10 0:55

Sanket.Patil

8-Dec-10 0:55

Hello Alok Sharma Ji,

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.

thatraja8-Dec-10 1:48

thatraja

8-Dec-10 1:48

You need to set login at runtime. Refer this C# Crystal Reports Dynamic Logon parameters[^]

thatraja |Chennai|India|

Brainbench certifications
Down-votes are like kid's kisses don't reject it Smile | :)

Do what you want quickly because the Doomsday on 2012 Smile | :)

10 digit Crypted Value

Enobong Adahada6-Dec-10 22:48

Enobong Adahada

6-Dec-10 22:48

pls i want to generate a ten digit crypted value from a 4 digit number,
pls how do i get it done.
thank you.

OriginalGriff7-Dec-10 0:40

OriginalGriff

7-Dec-10 0:40

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.

Enobong Adahada7-Dec-10 0:59

Enobong Adahada

7-Dec-10 0:59

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.

OriginalGriff7-Dec-10 1:09

OriginalGriff

7-Dec-10 1:09

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.

Yvan Rodrigues12-Dec-10 13:59

Yvan Rodrigues

12-Dec-10 13:59

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.

Sathesh Sakthivel7-Dec-10 0:52

Sathesh Sakthivel

7-Dec-10 0:52

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..

Enobong Adahada7-Dec-10 1:03

Enobong Adahada

7-Dec-10 1:03

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));

}

ASP C# WebSite to load a simple CSV File

Not Active7-Dec-10 2:16

Not Active

7-Dec-10 2:16

Please remember to use the pre tags when posting code snippets.

I know the language. I've read a book. - _Madmatt

gorovdude6-Dec-10 21:54

gorovdude

6-Dec-10 21:54

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

Re: ASP C# WebSite to load a simple CSV File [modified]

Dan Mos6-Dec-10 22:17

Dan Mos

6-Dec-10 22:17

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.
Smile | :)

I used to think....

Finally I realized it's no good.

modified on Tuesday, December 7, 2010 4:28 AM

Luc Pattyn6-Dec-10 22:26

6-Dec-10 22:26

do you really want double backslashes everywhere?

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, and update CP Vanity to V2.0 if you haven't already.

Dan Mos6-Dec-10 22:27

Dan Mos

6-Dec-10 22:27

Nice.
I missed it completely. Just focused on the start. Fixed.
Smile | :)

I used to think....

Finally I realized it's no good.

Luc Pattyn6-Dec-10 22:30

6-Dec-10 22:30

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.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, and update CP Vanity to V2.0 if you haven't already.

Dan Mos6-Dec-10 22:31

Dan Mos

6-Dec-10 22:31

Yep that's what I did. Just before you fixed my "code" the second time Laugh | :laugh:

I guess I'm better of just fooling around. Smile | :)

I used to think....

Finally I realized it's no good.

Luc Pattyn6-Dec-10 22:32

6-Dec-10 22:32

looking great now.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, and update CP Vanity to V2.0 if you haven't already.

TweakBird7-Dec-10 1:35

TweakBird

7-Dec-10 1:35

See this[^].it might be helpful.