ADO.net DB Connect

 

 

ADO.net DB connect

 

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Data; using System.Data.Common; using System.Data.SqlClient; using System.Data.SqlTypes; namespace BIZ.Common.Dac { public class ADOConnect { public DataSet GetDataSet(string database, string storeProcedure, Dictionary<string, object> dicParams ) { string connectingString = "Data Source = 192.168.18.13; Initial Catalog = " + database + "; Persist Security Info=True;User ID = sa; Password=1111" ; var cmd = new SqlCommand(); var ds = new DataSet(); using (var con = new SqlConnection(connectingString)) using (var adp = new SqlDataAdapter(cmd)) { con.Open(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = storeProcedure; SqlParameterCollection parameters = cmd.Parameters; foreach(KeyValuePair<string, object> pair in dicParams) //Type value = ((object)333).GetType(); { switch(pair.Value.GetType().ToString()) { case "System.Int32": parameters.Add(new SqlParameter("@" + pair.Key.ToString(), (int)pair.Value)); break; case "System.String": parameters.Add(new SqlParameter("@" + pair.Key.ToString(), (string)pair.Value)); break; } } adp.Fill(ds); con.Close(); return ds; } } } }

 

 

사용법

Dictionary<string, object> dic = new Dictionary<string, object>(); dic.Add("param1", "111"); DataSet data = (new ADOConnect()).GetDataSet("Kaishaku", "Z_UP_COCKTAIL_MATERIAL_LIST", dic);