public DataTable RUN_PARAMETER_QUERY(IConnectToDB _Connect, Parameter_Run ParamCall) { DataTable dt = new DataTable("ReturnData"); DataColumn column; DataRow row; switch (_Connect.Platform) { case "Microsoft": case "MICROSOFT": using (SqlConnection connection = new SqlConnection(_Connect.DBConnString)) { try { connection.Open(); SqlCommand sqlplus = connection.CreateCommand(); sqlplus.CommandText = ParamCall.sqlIn; foreach (var item in ParamCall._dbParameters) { sqlplus.Parameters.AddWithValue("@" + item.ParamName, item.ParamValue); } SqlDataReader dr = sqlplus.ExecuteReader(); dt.Load(dr); } catch (SqlException ex) { //Return Oracle Error. //return ex.ToString(); // Create first column and add to the DataTable. column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "ChildID"; column.AutoIncrement = true; column.AutoIncrementSeed = 0; column.AutoIncrementStep = 1; column.Caption = "ID"; column.ReadOnly = true; column.Unique = true; dt.Columns.Add(column); // Create second column and add to the DataTable. column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "ChildType"; column.AutoIncrement = false; column.Caption = "ChildType"; column.ReadOnly = false; column.Unique = false; dt.Columns.Add(column); // Create third column and add to the DataTable. column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "ChildItem"; column.AutoIncrement = false; column.Caption = "ChildItem"; column.ReadOnly = false; column.Unique = false; dt.Columns.Add(column); // Create fourth column and add to the DataTable. column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "ChildValue"; column.AutoIncrement = false; column.Caption = "ChildValue"; column.ReadOnly = false; column.Unique = false; dt.Columns.Add(column); row = dt.NewRow(); row["ChildType"] = "RETURN"; row["ChildItem"] = "ERROR"; row["ChildValue"] = DB_ERROR_FORMATTER(_Connect, ex); dt.Rows.Add(row); } finally { connection.Close(); connection.Dispose(); } return(dt); } default: return(dt); } }
public static DataTable _RUN_PARAMETER_QUERY(IConnectToDB _Connect, Parameter_Run ParamCall) { ER_Query eq = new ER_Query(); return(eq.RUN_PARAMETER_QUERY(_Connect, ParamCall)); }