public Int32 Execute_SqlParameter2(int commandType, string Sqlstr, DataSet DsDbParameter, string dataAccessName) { DataAccessCollections dac = new DataAccessCollections(); MyNet.Common.Data.DataAccess dAccess = dac.GetDataAccess(dataAccessName); DataTable dt = DsDbParameter.Tables[0]; DbParameter[] DbParameter = new DbParameter[dt.Rows.Count]; for (int i = 0; i < DsDbParameter.Tables[0].Rows.Count; i++) { DbParameter[i] = new MySql.Data.MySqlClient.MySqlParameter(dt.Rows[i]["name"].ToString(), dt.Rows[i]["value"]); try { if (dt.Rows[i]["type"] != null) { DbParameter[i].DbType = (DbType)int.Parse(dt.Rows[i]["type"].ToString()); } } catch { } } System.Data.CommandType ComType = (System.Data.CommandType)commandType; return(dAccess.Execute_Procedure(ComType, Sqlstr, DbParameter)); }
public Int32 Execute_Procedure(string ProcedureName, DataSet DsDbParameter) { DataTable dt = DsDbParameter.Tables[0]; DbParameter[] DbParameter = new DbParameter[dt.Rows.Count]; for (int i = 0; i < DsDbParameter.Tables[0].Rows.Count; i++) { DbParameter[i] = new MySql.Data.MySqlClient.MySqlParameter(dt.Rows[i]["name"].ToString(), dt.Rows[i]["value"]); try { if (dt.Rows[i]["type"] != null) { DbParameter[i].DbType = (DbType)int.Parse(dt.Rows[i]["type"].ToString()); } } catch { } } return(dataAccess.Execute_Procedure(ProcedureName, DbParameter)); }