Click here to Skip to main content
15,896,915 members
Home / Discussions / C#
   

C#

 
Questionpassing values between 2 Forms Pin
Moham'd27-Dec-06 11:34
Moham'd27-Dec-06 11:34 
AnswerRe: passing values between 2 Forms Pin
Colin Angus Mackay27-Dec-06 11:59
Colin Angus Mackay27-Dec-06 11:59 
GeneralRe: passing values between 2 Forms Pin
Paul Conrad27-Dec-06 18:34
professionalPaul Conrad27-Dec-06 18:34 
GeneralRe: passing values between 2 Forms Pin
Moham'd30-Dec-06 3:15
Moham'd30-Dec-06 3:15 
QuestionMdiForm Pin
md_refay27-Dec-06 11:15
md_refay27-Dec-06 11:15 
AnswerRe: MdiForm Pin
Mairaaj Khan28-Dec-06 1:12
professionalMairaaj Khan28-Dec-06 1:12 
Questionfrom vb.net to C# Pin
microuser_200027-Dec-06 11:09
microuser_200027-Dec-06 11:09 
AnswerRe: from vb.net to C# Pin
Colin Angus Mackay27-Dec-06 12:08
Colin Angus Mackay27-Dec-06 12:08 
What I want to know is, why are you instantiating an OleDbParameter then attempting to write over it. In other words: Why are you creating an object then not using it?


microuser_2000 wrote:
OleDbParameter MyPara = new OleDbParameter();
------->>>> 'MyPara = new OleDbParameter("@Indx",SqlDbType.Int, 4);


Well, looking at the documentation for OleDbParameter[^] it would appear that you are passing a SqlDbType when it expects an OleDbType.

microuser_2000 wrote:
---->>>> 'ContractIndx = OleDbCommand.Parameters("@Indx").Value();


This is because you have not translated the VB.NET code. The indexer property uses square brackets in C#. [] not parenthesis ()

Some other questions:

This appears to be connecting to a SQL Server database, why not use the equivalent classes in System.Data.SqlClient? It would be more efficient.

Why are you injecting values into the SQL statement? It blows a great big hole through any security you have in your application (if you have any at all) that allows an attacker almost direct access to the database. You might want to read about SQL Injection Attacks and some tips on how to prevent them[^]


Upcoming Scottish Developers events:
* Glasgow: Tell us what you want to see in 2007


My: Website | Blog | Photos

GeneralRe: from vb.net to C# Pin
microuser_200030-Dec-06 4:19
microuser_200030-Dec-06 4:19 
GeneralRe: from vb.net to C# Pin
Colin Angus Mackay30-Dec-06 7:22
Colin Angus Mackay30-Dec-06 7:22 
QuestionEncrypting files & usernames/passwords - What are the normal practises? Pin
Cormac M Redmond27-Dec-06 9:26
Cormac M Redmond27-Dec-06 9:26 
AnswerRe: Encrypting files & usernames/passwords - What are the normal practises? [modified] Pin
Judah Gabriel Himango27-Dec-06 10:09
sponsorJudah Gabriel Himango27-Dec-06 10:09 
GeneralRe: Encrypting files & usernames/passwords - What are the normal practises? Pin
Dan Neely27-Dec-06 10:41
Dan Neely27-Dec-06 10:41 
GeneralRe: Encrypting files & usernames/passwords - What are the normal practises? Pin
Judah Gabriel Himango27-Dec-06 11:15
sponsorJudah Gabriel Himango27-Dec-06 11:15 
GeneralRe: Encrypting files & usernames/passwords - What are the normal practises? Pin
Cormac M Redmond27-Dec-06 11:24
Cormac M Redmond27-Dec-06 11:24 
GeneralRe: Encrypting files & usernames/passwords - What are the normal practises? Pin
Judah Gabriel Himango27-Dec-06 16:15
sponsorJudah Gabriel Himango27-Dec-06 16:15 
GeneralRe: Encrypting files & usernames/passwords - What are the normal practises? Pin
Cormac M Redmond27-Dec-06 18:30
Cormac M Redmond27-Dec-06 18:30 
GeneralRe: Encrypting files & usernames/passwords - What are the normal practises? Pin
Cormac M Redmond27-Dec-06 11:23
Cormac M Redmond27-Dec-06 11:23 
GeneralRe: Encrypting files & usernames/passwords - What are the normal practises? Pin
Judah Gabriel Himango27-Dec-06 16:27
sponsorJudah Gabriel Himango27-Dec-06 16:27 
GeneralRe: Encrypting files & usernames/passwords - What are the normal practises? Pin
Cormac M Redmond27-Dec-06 18:28
Cormac M Redmond27-Dec-06 18:28 
QuestionHow to persist collection entries added or removed by the CollectionEditor, when returning from a CollectionEditor????? Pin
Dinesh Jayadevan27-Dec-06 9:21
Dinesh Jayadevan27-Dec-06 9:21 
QuestionC# and Excel 2000 [modified] Pin
73Zeppelin27-Dec-06 8:08
73Zeppelin27-Dec-06 8:08 
AnswerRe: C# and Excel 2000 Pin
Judah Gabriel Himango27-Dec-06 10:11
sponsorJudah Gabriel Himango27-Dec-06 10:11 
GeneralRe: C# and Excel 2000 Pin
73Zeppelin27-Dec-06 10:15
73Zeppelin27-Dec-06 10:15 
GeneralRe: C# and Excel 2000 Pin
73Zeppelin27-Dec-06 10:49
73Zeppelin27-Dec-06 10:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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