C# Discussion Boards - CodeProject

mav.northwind3-Mar-08 1:12

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

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#

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

Have Fun
Never forget it

Re: Byte and bitArray

Xmen Real 2-Mar-08 22:25

Xmen Real

2-Mar-08 22:25

http://www.codeproject.com/KB/cpp/BitArray.aspx

Re: Byte and bitArray

half-life2-Mar-08 23:46

half-life

2-Mar-08 23:46

Thanks i eventually used the
BitArray(byte []) cotr.
and then the Get(index) Method
Thanks anyway Smile | :)

Have Fun
Never forget it

send e-mail

wenshengluo2-Mar-08 22:17

wenshengluo

2-Mar-08 22:17

program:
System.Web.Mail.MailMessage myEmail = new System.Web.Mail.MailMessage();
System.Web.Mail.MailAttachment attach = new System.Web.Mail.MailAttachment(path + ".zip");
// SET MESSAGE PARAMETERS
myEmail.From= "ella@yahoo.com.cn";
myEmail.To = "sellina@yahoo.com.cn";
myEmail.Subject = "Product Availability Notice";
myEmail.BodyFormat = System.Web.Mail.MailFormat.Html;
myEmail.Body = "The sunglasses you expressed interest in are now in stock.";
myEmail.Attachments.Add(attach);
myEmail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "1");
myEmail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", "ella");
myEmail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendpassword", "123456");

//SEND THE MESSAGE
System.Web.Mail.SmtpMail.SmtpServer = "smtp.mail.yahoo.com.cn";
System.Web.Mail.SmtpMail.Send(myEmail);

myEmail = null;
attach = null;
error:
System.Web.HttpException: demand the name of smtp server,but don't find in configure

Re: send e-mail

Christian Graus2-Mar-08 22:35

Christian Graus

2-Mar-08 22:35

You do indeed need to set your SMTP server to be able to send mail. Do you mean you don't know the server to use, or you don't know how to set it in code ?

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: send e-mail

wenshengluo2-Mar-08 22:54

wenshengluo

2-Mar-08 22:54

System.Web.Mail.SmtpMail.SmtpServer = "smtp.mail.yahoo.com.cn";

I want to use the yahoo server,but it failed when trying to link the server

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