how to get sql variable Value in my stored procedure from C# application??

Question

hi all  i have create stored procedure  this procedure contain variable will hold important value  i want to get variable value into C#  how?? like this DECLARE @NUMBER INT SET @NUMBER = 1

Master Billa · Answer

Hi You can select @NUmber end of the Stored procedure if your Sp returning only one value you can write code like this way Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:Table Normal; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:Calibrisans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Times New Roman; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;} Private object GetData() { using ( SqlConnection con = new SqlConnection ( Con )) { if (con . State != System . Data . ConnectionState . Open) { con . Open(); } using ( SqlCommand cmd = con . CreateCommand()) { cmd . CommandText = SPName ; cmd . CommandType = System . Data . CommandType . StoredProcedure; object data = cmd . ExecuteScalar(); if (data != null ) { return data; } } } } Note:If you have more than one column we need use the SqlDataReader to access. thank you

abas shahen · Answer

hi  thank u man but i dont need sql query returned value  i have variable in my stored procedure and i want to get variable Value not stored procedure query value. can u help me?

Dan · Answer

Hi Assuming you're using a SQLCommand object called com you add parameters like this: com.Parameters.AddWithValue( @MYPARAM  Test Value);

how to get sql variable Value in my stored procedure , from C# application??