Re: Using a Stored Procedure in C# - C# Discussion Boards

3-Mar-08 1:03

Good Afternoon All

An new in C#, i have been doing Ado.net in vb.net. i want to use a Stored Procedure to do my database work, and i want to tell my command object that we are going to use a StoredProcedure. if i try this

<br />
<br />
 cmdselect.CommandType = CommandType = StoredProcedure;<br />
<br />

I get an Exception that says

The Name StoredProcedure does not Exists in the current context

i have googled and my line looked ok, but i dont know what is wrong with this line

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

Obaid ur Rehman3-Mar-08 1:11

Obaid ur Rehman

3-Mar-08 1:11

When the CommandType property is set to StoredProcedure, the CommandText property should be set to the name of the stored procedure.
http://msdn2.microsoft.com/en-us/library/x8ybe6s2(VS.80).aspx[^]

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

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

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

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

3-Mar-08 19:14

Thanks it worked

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

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

3-Mar-08 1:54

Thanks man i saw the Problem

Thanks

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

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

3-Mar-08 1:56

Thanks man it Worked

Thanks

Walaza3-Mar-08 1:59

Walaza

3-Mar-08 1:59

Glad to know Wink | ;)

Mvelo Walaza
Developer
Telkom SA

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

3-Mar-08 19:15

Thanks Bro

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;

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

Word 2002 cast COM object error

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

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

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

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

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