C# Discussion Boards - CodeProject

Re: Using a Stored Procedure in C#

Vimalsoft(Pty) Ltd3-Mar-08 1:19

Vimalsoft(Pty) Ltd

3-Mar-08 1:19

hi Thanks for your Reply

like this

<br />
         cmdselect.CommandText = "get_me";<br />
 <br />
         cmdselect.CommandType = CommandType = StoredProcedure;<br />

"get_me" is the name of the Procedure.
and this is how i wrote my code, what is Wrong ?

Thanks

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Re: Using a Stored Procedure in C#

Colin Angus Mackay3-Mar-08 3:06

Colin Angus Mackay

3-Mar-08 3:06

Vuyiswa wrote:
and this is how i wrote my code, what is Wrong ?

Since this code would generate a compiler error, surely the error message would be able to pinpoint where the error is.

Try:
cmdselect.CommandType = CommandType.StoredProcedure;

Note the dot instead of the second equals sign.

Upcoming FREE developer events:
* Developer Day Scotland

Recent blog posts:
* Mixins in C#3.0

My website | Blog

Re: Using a Stored Procedure in C#

Vimalsoft(Pty) Ltd3-Mar-08 19:14

Vimalsoft(Pty) Ltd

3-Mar-08 19:14

Thanks it worked

Re: Using a Stored Procedure in C#

mav.northwind3-Mar-08 1:12

mav.northwind

3-Mar-08 1:12

Hi!
The first place to look for parameters should be the documentation - MSDN still is the authority to ask.
Try explaining what your cmdselect.CommandType... line does (not what you want it to do, but what the meaning of the statements you've written is!).
You'll see that the two assignments you're performing are nonsense.
StoredProcedure is an enum value and you have to tell which enum it's a part of.
Btw., you don't get an Exception but a syntax error during compilation - that's a huge difference!

Regards,
mav

--
Black holes are the places where God divided by 0...

Re: Using a Stored Procedure in C#

Vimalsoft(Pty) Ltd3-Mar-08 1:54

Vimalsoft(Pty) Ltd

3-Mar-08 1:54

Thanks man i saw the Problem

Thanks

Re: Using a Stored Procedure in C#

Walaza3-Mar-08 1:23

Walaza

3-Mar-08 1:23

//Try the ff:
cmdselect.CommandType = System.Data.CommandType.StoredProcedure;
cmdselect.CommandText = "Name_Of_StoredProcedure";

Mvelo Walaza
Developer
Telkom SA

Re: Using a Stored Procedure in C#

Vimalsoft(Pty) Ltd3-Mar-08 1:56

Vimalsoft(Pty) Ltd

3-Mar-08 1:56

Thanks man it Worked

Thanks

Re: Using a Stored Procedure in C#

Walaza3-Mar-08 1:59

Walaza

3-Mar-08 1:59

Glad to know Wink | ;)

Mvelo Walaza
Developer
Telkom SA

Re: Using a Stored Procedure in C#

Vimalsoft(Pty) Ltd3-Mar-08 19:15

Vimalsoft(Pty) Ltd

3-Mar-08 19:15

Thanks Bro

Re: Using a Stored Procedure in C#

baala.m3-Mar-08 2:28

baala.m

3-Mar-08 2:28

this is my suggestion check it out. the line should be
cmd.CommandType = CommandType.StoredProcedure;

Re: Using a Stored Procedure in C#

Vimalsoft(Pty) Ltd3-Mar-08 19:18

Vimalsoft(Pty) Ltd

3-Mar-08 19:18

Thanks i get your point

transaction

SVb.net3-Mar-08 0:54

SVb.net

3-Mar-08 0:54

i'm using C#2005
i need to doing my two sqldatadpaters or more then in one transaction , and when happend error rollback all operation .

123

Re: transaction

Xmen Real 3-Mar-08 4:36

Xmen Real

3-Mar-08 4:36

use

Try...Catch..Finally

google it for more info

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can

Word 2002 cast COM object error

mpavas3-Mar-08 0:47

mpavas

3-Mar-08 0:47

After doing a the following

gacutil -i Microsoft.Office.Interop.Word.dll and
regedit /s Microsoft.Office.Interop.Word.dll.reg

I get the following error:

Unable to cast COM object of type 'Word.ApplicationClass' to interface type 'Word._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{00020970-0000-0000-C000-000000000046}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)).

C# Code:

Word.Application oWord;
oWord = new Word.Application();
oWord.Visible = true; // This line is generating error

Regards,
Pavas

Rename object using DirectoryServices.AccountManagement

vrocks12893-Mar-08 0:25

vrocks1289

3-Mar-08 0:25

Hello there!

Can anyone tell me how to Rename an active directory object using DirectoryServices.AccountManagement

Thanks in advance!

control usb

SVb.net3-Mar-08 0:12

SVb.net

3-Mar-08 0:12

i need to control read from usb host?

123

video player from direct X

jimmy2shoes2-Mar-08 22:58

jimmy2shoes

2-Mar-08 22:58

i guys was wondering if someobdy could help me out please

i am using the video player that direct x provides and playing it through a panal.

i can get the panal to play when i select the name of the file from the openfile dialog

if (openFileDialog1.ShowDialog() == DialogResult.OK)

movie = new Video(openFileDialog1.FileName);

but instead of me putting openFileDialog1.FileName in above i would like to specify the file name like c:/"""/""".mpeg for instance but it will not play. i get the following error

Error in the application.-2147220970 (VFW_E_NOT_FOUND)
at Microsoft.DirectX.AudioVideoPlayback.Video.Open(String fileName, Boolean autoRun)
at Microsoft.DirectX.AudioVideoPlayback.Video..ctor(String fileName, Boolean autoRun)

any ideas?]

j2s

Re: video player from direct X

Simon P Stevens2-Mar-08 23:21

Simon P Stevens

2-Mar-08 23:21

I don't use DirectX, but in c#, the backslash character is an escape character, so in path strings it can mess up the string. Try either using double backslashes to get what you want. e.g

String fileName = "C:\\myfolder\\myfile.mpg";

or you can use the @ character to make c# ignore all escape characters in the string.

String filename = @"C:\myfolder\myfile.mpg";

Simon

Re: video player from direct X

jimmy2shoes2-Mar-08 23:34

jimmy2shoes

2-Mar-08 23:34

forgot to say that i am using double black slashes friend

i will try the @ symbol to see what happens

thanks

Re: video player from direct X

Simon P Stevens2-Mar-08 23:38

Simon P Stevens

2-Mar-08 23:38

Sorry, then. I don't know anything about DirectX, so that was my only Idea.

Simon

Re: video player from direct X

jimmy2shoes2-Mar-08 23:39

jimmy2shoes

2-Mar-08 23:39

got it working friend

i has the wrong extension in, i had mpeg instead of mpg, only put that in at it says below movie MPEG MOVIE

thanks for your time and help

j2s

Re: video player from direct X

Simon P Stevens3-Mar-08 0:30

Simon P Stevens

3-Mar-08 0:30

No prob, although looks like you solved it yourself really.

Simon

Byte and bitArray

half-life2-Mar-08 22:20

half-life

2-Mar-08 22:20

Hi,
i'd like to know how to iterate bit's in a Byte or BitArray

THANKS Smile | :)