调用存储过程

[cowboytan]

请问各位，，如何在WINFROM中调用SQLSERVER的存储过程呀！

[cowboytan]

怎么没人回答我的问题呢，是不是分太少了呀

[riffleliu]

winform和web form有区别吗？
不都一样？
conn = new SqlConnection(strConn);
SqlCommand cmd = conn.CreateCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("paraName",100))
cmd.ExecuteNonQuery();

[lyvvvv]

private DataSet GetDataSetFromStoreProcedureInSqlServer(string sStoreProcedureName,string sTableName,string[] sParameterName,string[] sParameterValue,ref string sMsg)
{
sMsg="";

try
{
if(m_SqlConnection.State ==System.Data.ConnectionState.Closed)m_SqlConnection.Open();

SqlCommand cmd=new SqlCommand(sStoreProcedureName,m_SqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
if(sParameterName != null)
{
for(int i=0;i<sParameterName.Length;i++)
{
cmd.Parameters.Add("@"+sParameterName[i],sParameterValue[i]);
}
}
SqlDataAdapter adp=new SqlDataAdapter(cmd);
DataSet ds=new DataSet();
adp.Fill(ds,sTableName);
sMsg="";
return(ds);
}
catch(SqlException e)
{
sMsg="错误描述："+e.Message+"\n当前的存储过程："+sStoreProcedureName;
return(null);
}
finally
{
}
}

[cowboytan]

SqlConnection thisConnection=new SqlConnection("server="+comm.sqlserver+";uid=dbo;pwd=dbo;database="+comm.sqldata+";");

thisConnection.Open();
SqlCommand thisCommand=new SqlCommand("pro_databackup",thisConnection);
thisCommand.CommandType=CommandType.StoredProcedure;
thisCommand.Parameters.Add("@pathname",SqlDbType.VarChar,100,txtpath.Text.ToString().Trim());

int rows=thisCommand.ExecuteNonQuery();
我这样写错在哪呀，，执行int rows=thisCommand.ExecuteNonQuery();出错

[cowboytan]

OleDbCommand insertCommand=new OleDbCommand("InsertUserData",dsConnection);
insertCommand.CommandType=CommandType.StoredProcedure;
insertCommand.Parameters.Add("@UserName",OleDbType.VarWChar,50,"UserName");
insertCommand.Parameters.Add("@UserInfo", OleDbType.VarWChar,4000,"UserInfo");
dsCommand.InsertCommand=insertCommand;
try
{
dsCommand.InsertCommand=this.GetInsertCommand();
dsCommand.Update(userData,"UserDataStore");
userData.AcceptChanges();
return (true);
}
catch(Exception e)
{
throw e;
}
大家看一下，，这句 dsCommand.InsertCommand=insertCommand;是个什么意思呀，