日期:2014-05-17 浏览次数:20474 次
//using Microsoft.ApplicationBlocks.Data;
//using System.Data.SqlClient;
//执行存储过程返回执行结果
//SqlParameter[] arParms = new SqlParameter[2];
//arParms[0] = new SqlParameter("@userid", enamestr);
//arParms[0].Direction = ParameterDirection.Input;
//arParms[2] = new SqlParameter("@right", SqlDbType.VarChar, 1);// 返回执行结果
//arParms[2].Direction = ParameterDirection.Output;
//SqlHelper.ExecuteNonQuery
//(
// connectionString,
// CommandType.StoredProcedure,
// "p_uis_save",
// arParms
// );
//string oknot = Convert.ToString(arParms[2].Value);
//执行存储过程返回返回数据表
// DataSet userds = SqlHelper.ExecuteDataset
// (
// connectionString,
// CommandType.StoredProcedure,
// "p_sys_djget",
// arParms
// );
//System.Data.DataTable table = userds.Tables[0];
// System.Data.DataView view = new System.Data.DataView(table);
// if (view.Count > 0)
// {
// .................
//}