C# Discussion Boards - CodeProject

13-Feb-09 0:06

i'm trying to pass values to db through a query.this ia the update query.

" UPDATE T_PRECORD 
  set PR_FIELD10= @singhalaname ,PR_FIELD8 =@singhaladesignation 
  where PR_FIELD21 = @regno";

i used

command.Parameters.Add("PR_FIELD10", SqlDbType.VarChar);
               command.Parameters.Add("PR_FIELD8", SqlDbType.VarChar);
               command.Parameters.Add("PR_FIELD21", SqlDbType.VarChar);

               command.Parameters["PR_FIELD10"].Value = cadbn.Name_singhala;
               command.Parameters["PR_FIELD8"].Value = cadbn.Desig_sinhala;
               command.Parameters["PR_FIELD21"].Value = cadbn.Regno;

but when i execute this i get the exception saying that to declare the
@singhalaname,@singhaladesignation, @regno

can anyone tell me how to pass vales as parameters to sql 2000 DB

musefan13-Feb-09 0:14

13-Feb-09 0:14

when you add params you need to type the param name not the fieldname

that maybe the problem

If only MySelf.Visible was more than just a getter...

A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting

ABitSmart13-Feb-09 0:26

ABitSmart

13-Feb-09 0:26

How about this ?

command.Parameters.Add("@singhalaname", SqlDbType.VarChar);<br />
                command.Parameters.Add("@singhaladesignation", SqlDbType.VarChar);<br />
                command.Parameters.Add("@regno", SqlDbType.VarChar);<br />
ommand.Parameters["@singhalaname"].Value = cadbn.Name_singhala;<br />
                command.Parameters["@singhaladesignation"].Value = cadbn.Desig_sinhala;<br />
                command.Parameters["@regno"].Value = cadbn.Regno;

prasadbuddhika13-Feb-09 0:44

13-Feb-09 0:44

thanks , but i still getting the same exception? any other idea?

ABitSmart13-Feb-09 2:01

ABitSmart

13-Feb-09 2:01

How are you executing the query ? Can you paste the code/error for better understanding ?

Make sure,
column names PR_FIELD10,PR_FIELD8,PR_FIELD21 do exists in the table and there is no typo
All your datatypes are varchar ?

Try doing it with this string,

string updateQuery = <br />
" UPDATE T_PRECORD <br />
  set PR_FIELD10= '" + cadbn.Name_singhala + "' ,PR_FIELD8 = '" + cadbn.Desig_sinhala + "'  where PR_FIELD21 = '" cadbn.Regno "'";

Edit - Also, make sure you are updating the right columns

prasadbuddhika13-Feb-09 17:07

13-Feb-09 17:07

sorry i couldn't answer you, but the way you suggest is the way this was done previously, the problem is for these fields i used other language(sinhalese)so when that values are put into the bean they are stored in english characters, so there is a high possibility for sql exception or injections (ex:set PR_FIELD10= 'hahal'kf' because of the ' in middle the query fails)

musefan13-Feb-09 0:53

13-Feb-09 0:53

command.Parameters.Add("@singhalaname", SqlDbType.VarChar).Value = cadbn.Name_singhala;
command.Parameters.Add("@singhaladesignation", SqlDbType.VarChar).Value = cadbn.Desig_sinhala;                
command.Parameters.Add("@regno", SqlDbType.VarChar).Value = cadbn.Regno;

P.S. Have you assigned the query to the command?

If only MySelf.Visible was more than just a getter...

A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting

prasadbuddhika13-Feb-09 1:30

13-Feb-09 1:30

i tried this way too.but failed.
please tell me if passing parameters for sql 2000 and 2005 are same or different.
because these are used for sql 2005 too

musefan13-Feb-09 1:54

13-Feb-09 1:54

well if the exact same code works forr 2005 then there must be a version issue

If only MySelf.Visible was more than just a getter...

A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting

musefan13-Feb-09 2:06

Re: Printing to LPT1 port

13-Feb-09 2:06

http://msdn.microsoft.com/en-us/library/aa226067(SQL.80).aspx[^]

hope that helps...

I assume you will have to add parameters in the correct order now i.e.

Command.parameters.Add(value);

If only MySelf.Visible was more than just a getter...

A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting

Printing to LPT1 port

ArielR12-Feb-09 23:55

ArielR

12-Feb-09 23:55

Does exist in C# a way to open a port ( LPT, COM ) like C++ fopen method?.

f = fOpen( "LPT1", "w")

I tried with... TextWriter tw = new StreamWriter("myFile.txt") but if I change myFile.txt with LPT1 I have this error, "filestream can't open win32 devices, like partitions or tape uniteds" why? thank you very much

musefan13-Feb-09 0:12

Re: Printing to LPT1 port

13-Feb-09 0:12

maybe this will help

http://www.codeproject.com/KB/cs/serialcommunication.aspx[^]

If only MySelf.Visible was more than just a getter...

A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting

Dave Kreskowiak13-Feb-09 3:13

Dave Kreskowiak

13-Feb-09 3:13

You can't do that. This KB article[^] is about as close as you're going to get.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Declaration of list in c#

abbd12-Feb-09 23:27

abbd

12-Feb-09 23:27

Hello,

i would declare a list using C#, i do this :
List<orderdata> _orderDataList;</orderdata>

But there are an error : Error 1 The type or namespace name 'OrderData' could not be found (are you missing a using directive or an assembly reference?) C:\Form1.cs 27 14 WindowsApplication2

Thank you verry mutch.

musefan12-Feb-09 23:33

12-Feb-09 23:33

post come more of your code, esp the part that uses OrderData

If only MySelf.Visible was more than just a getter...

A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting

abbd12-Feb-09 23:38

abbd

12-Feb-09 23:38

I am sorry,

the code is :
List <orderdata> _orderDataList;</orderdata>

Thank you verry mutch

musefan12-Feb-09 23:47

12-Feb-09 23:47

yeah you posted that already...

What i mean is the error is saying you are using a type (OrderData) that cannot be found.

I assume it is compiler error?

If only MySelf.Visible was more than just a getter...

A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting

abbd12-Feb-09 23:57

abbd

12-Feb-09 23:57

there are this error : Error 1 The type or namespace name 'OrderData' could not be found (are you missing a using directive or an assembly reference?) C:\Program.cs 16 14 ConsoleApplication1

Thank you verry mutch.

musefan13-Feb-09 0:02