Click here to Skip to main content
15,895,746 members
Home / Discussions / C#
   

C#

 
GeneralRe: Creating a Pause Button....... Pin
Member 46731984-Oct-08 3:24
Member 46731984-Oct-08 3:24 
AnswerRe: Creating a Pause Button....... Pin
dybs4-Oct-08 12:09
dybs4-Oct-08 12:09 
QuestionHow to access stored procedure Pin
fancyfree833-Oct-08 20:39
fancyfree833-Oct-08 20:39 
AnswerRe: How to access stored procedure Pin
Wendelius3-Oct-08 21:33
mentorWendelius3-Oct-08 21:33 
AnswerRe: How to access stored procedure Pin
TALHAKOSEN4-Oct-08 3:40
TALHAKOSEN4-Oct-08 3:40 
AnswerRe: How to access stored procedure Pin
Nouman Bhatti4-Oct-08 10:08
Nouman Bhatti4-Oct-08 10:08 
AnswerRe: How to access stored procedure Pin
Jaffer Mumtaz4-Oct-08 20:17
Jaffer Mumtaz4-Oct-08 20:17 
AnswerRe: How to access stored procedure Pin
Ashwin. Shetty4-Oct-08 20:48
Ashwin. Shetty4-Oct-08 20:48 
if you r using SQL please check the below code
string strSqlConnectionstring = "sqlserver details with provider";
System.Data.SqlClient.SqlConnection _ObjSQLCon = new System.Data.SqlClient.SqlConnection(strSqlConnectionstring.ToString());
System.Data.SqlClient.SqlCommand _ObjSqlCom = new System.Data.SqlClient.SqlCommand();
try
{
_ObjSQLCon.Open();
_ObjSqlCom.Connection = _ObjSQLCon;
// your store procedure name
_ObjSqlCom.CommandText = "Your Store procedure name";
_ObjSqlCom.CommandType = System.Data.CommandType.StoredProcedure;

// you can add parameter as per your requirement
// parameter name & datatype should be as per you have mentioned in your procedure
// set the direction of your parameter
// you need to add output parameter in the same way but direction out be output
_ObjSqlCom.Parameters.Add("your parameter name", System.Data.SqlDbType.Char, 50).Direction = System.Data.ParameterDirection.Input;
_ObjSqlCom.Parameters.Add("your output parameter name", System.Data.SqlDbType.Char, 50).Direction = System.Data.ParameterDirection.Output;
_ObjSqlCom.Parameters[0].Value = "your parameter value";
_ObjSqlCom.ExecuteNonQuery();
// to get the output value you can use either array location of that parameter or the parameter name
// if you are confused then just right click on _ObjSqlCom and view it in immediate window after you have executed _ObjSqlCom.ExecuteNonQuery();
}
catch
{

}
finally
{
strSqlConnectionstring = string.Empty;
if (_ObjSqlCom != null)
{
_ObjSqlCom.Dispose();
_ObjSqlCom = null;
}
if (_ObjSQLCon != null)
{
if (_ObjSQLCon.State != System.Data.ConnectionState.Closed)
{ _ObjSQLCon.Close(); }
_ObjSQLCon.Dispose();
_ObjSQLCon = null;
}
}
if you further douts feel free to email me at ashwin@omtechsolutions.com Smile | :)

Ashwin Shetty. Mumbai. India

QuestionNot working : Wmv file to Flv file using C# Pin
elango.sham3-Oct-08 20:24
elango.sham3-Oct-08 20:24 
QuestionHow to get mouse pointer of object after using Graphics.ScaleTransform()? Pin
cocoonwls3-Oct-08 18:08
cocoonwls3-Oct-08 18:08 
AnswerRe: How to get mouse pointer of object after using Graphics.ScaleTransform()? Pin
cocoonwls15-Oct-08 0:10
cocoonwls15-Oct-08 0:10 
QuestionWebBrowser Control and Images Pin
#realJSOP3-Oct-08 17:18
mve#realJSOP3-Oct-08 17:18 
AnswerRe: WebBrowser Control and Images Pin
Jaime Olivares3-Oct-08 19:21
Jaime Olivares3-Oct-08 19:21 
GeneralRe: WebBrowser Control and Images [modified] Pin
#realJSOP3-Oct-08 22:48
mve#realJSOP3-Oct-08 22:48 
GeneralRe: WebBrowser Control and Images Pin
Jaime Olivares4-Oct-08 2:16
Jaime Olivares4-Oct-08 2:16 
GeneralRe: WebBrowser Control and Images Pin
#realJSOP4-Oct-08 2:35
mve#realJSOP4-Oct-08 2:35 
GeneralRe: WebBrowser Control and Images Pin
Jaime Olivares4-Oct-08 2:50
Jaime Olivares4-Oct-08 2:50 
GeneralRe: WebBrowser Control and Images Pin
#realJSOP4-Oct-08 3:13
mve#realJSOP4-Oct-08 3:13 
GeneralRe: WebBrowser Control and Images Pin
Wendelius4-Oct-08 7:14
mentorWendelius4-Oct-08 7:14 
GeneralRe: WebBrowser Control and Images Pin
#realJSOP4-Oct-08 8:42
mve#realJSOP4-Oct-08 8:42 
QuestionCannot implicitly convert type 'System.Web.UI.Control' to 'System.IO.MemoryStream' Pin
technette3-Oct-08 13:51
technette3-Oct-08 13:51 
AnswerRe: Cannot implicitly convert type 'System.Web.UI.Control' to 'System.IO.MemoryStream' Pin
Jaime Olivares3-Oct-08 19:33
Jaime Olivares3-Oct-08 19:33 
Questioncompare 2 datetime and get hours Pin
Mohammed Elkholy3-Oct-08 9:36
Mohammed Elkholy3-Oct-08 9:36 
AnswerRe: compare 2 datetime and get hours Pin
J4amieC3-Oct-08 9:56
J4amieC3-Oct-08 9:56 
AnswerRe: compare 2 datetime and get hours Pin
J$3-Oct-08 9:59
J$3-Oct-08 9:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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