-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Iamtheoneurwarnedabout
Message 1 in Discussion
Hi All, I am using stored procedures in my C# application. The Stored procedure is
an parameterized one, also uses joins. It returns an string value. Following is the
code Iam using in my C# application to get an output from stored procedure:
SAMCmd.Parameters.Add("@Profile_Name",SqlDbType.VarChar,50);
SAMCmd.Parameters["@Profile_Name"].Direction = ParameterDirection.Output;
SAMConn.Open();
SAMCmd.ExecuteNonQuery();
string strProfile;
strProfile = Convert.ToString(SAMCmd.Parameters["@Profile_Name"].Value);
MessageBox.Show(strProfile);
But when I run the application, Iam getting empty message box i.e., nothing is
displayed.
But I tested the Stored Procedure in my Query Analyzer, its working fine there, I mean
perfectly displaying the out parameter,
Why it is not showing me anything in the message box.
Can anyone help me in this regard, its bit urgent.
Cheers
GodsThrone
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
