미련곰 블로그

시작하기

/// 

/// List<object> for container
/// 
private List<object> list;

/// 

/// total count
/// 
public int Count { get { return this.list.Count; } }

/// 

/// indexer
/// 
/// 
/// 
public SqlParameter this[int index] { get { return (SqlParameter)this.list[index]; } }

/// 

/// creator
/// 
public SqlPrmCollection()
{
	list = new List<object>();
}

/// 

/// 개체의 열거자를 반환
/// 
/// IEnumerator
public IEnumerator GetEnumerator()
{
	return this.list.GetEnumerator();
}

/// 

/// List<object> 에 SqlParameter 개체를 추가 한다.
/// 
/// ParameterName
/// Value
public void Add(string name, object value)
{
	SqlParameter prm = new SqlParameter();

	prm.ParameterName = name;
	prm.Value = value;

	this.list.Add(prm);
}

/// 

/// List<object> 에 SqlParameter 개체를 추가 한다.
/// 
/// ParameterName
/// SqlDbType
/// Size
/// Value
public void Add(string name, SqlDbType type, int size, object value)
{
	SqlParameter prm = new SqlParameter();

	prm.ParameterName = name;
	prm.SqlDbType = type;
	prm.Size = size;
	prm.Value = value;

	this.list.Add(prm);
}

/// 

/// List<object> 에 SqlParameter 개체를 추가 한다.
/// 
/// ParameterName
/// SqlDbType
/// Size
/// Direction
public void Add(string name, SqlDbType type, int size, ParameterDirection direction)
{
	SqlParameter prm = new SqlParameter();

	prm.ParameterName = name;
	prm.SqlDbType = type;
	prm.Size = size;
	prm.Direction = direction;

	this.list.Add(prm);
}

/// 

/// List<object> 에 SqlParameter 개체를 추가 한다.
/// 
/// ParameterName
/// SqlDbType
/// Size
/// Direction
/// Value
public void Add(string name, SqlDbType type, int size, ParameterDirection direction, object value)
{
	SqlParameter prm = new SqlParameter();

	prm.ParameterName = name;
	prm.SqlDbType = type;
	prm.Size = size;
	prm.Direction = direction;
	prm.Value = value;

	this.list.Add(prm);
}

/// 

/// Collection 의 내용을 모두 삭제 합니다.
/// 
public void Clear()
{
	this.list.Clear();
} 

시작하기

/// 

/// member connection string
/// 
	
public string connectionstring { get; set; }

/// 

/// member SqlConnection
/// 
private SqlConnection con;

/// 

/// member SqlCommand
/// 
private SqlCommand cmd;

/// 

/// member SqlDataAdapter
/// 
private SqlDataAdapter da;

/// 

/// member DataSet
/// 
private DataSet ds;

public SqlHelper()
{
	this.connectionstring = "server=localhost;database=test;uid=sa;pwd=1234;";
}

public SqlHelper(string connectionString)
{
	this.connectionstring = connectionString;
} 

public void Dispose()
{
	if (con != null) con.Dispose();
	if (cmd != null) cmd.Dispose();
	if (da != null) da.Dispose();
	if (ds != null) ds.Dispose();
}

/// 

/// 셀렉트의 결과 집합을 반환한다.
/// 
/// 
/// 
/// 
/// DataSet
public DataSet ExecuteDataSet(string query, SqlPrmCollection param, CommandType cmdType)
{
	using (con = new SqlConnection(connectionstring))
	{
		cmd = new SqlCommand(query, con);
		cmd.CommandType = cmdType;

		da = new SqlDataAdapter(cmd);
		ds = new DataSet();

		if (param != null && param.Count > 0)
		{
			IEnumerator ie = param.GetEnumerator();
			while (ie.MoveNext()) cmd.Parameters.Add((SqlParameter)ie.Current);
		}

		con.Open();
		da.Fill(ds);
	}

	return ds;
}

/// 

/// 쿼리문 혹은 SP 실행후 반영된 row 수 반환
/// 
/// 
/// 
/// 
/// int
public int ExecuteNonQuery(string query, SqlPrmCollection param, CommandType cmdType)
{
	int iRe = 0;

	using (con = new SqlConnection(connectionstring))
	{
		cmd = new SqlCommand(query, con);
		cmd.CommandType = cmdType;

		if (param != null && param.Count > 0)
		{
			IEnumerator ie = param.GetEnumerator();
			while (ie.MoveNext()) cmd.Parameters.Add((SqlParameter)ie.Current);
		}

		con.Open();
		iRe = cmd.ExecuteNonQuery();
	}

	return iRe;
}

/// 

/// 쿼리문 혹은 SP 실행후 단일값 반환
/// 
/// 
/// 
/// 
/// object
public object ExecuteScalar(string query, SqlPrmCollection param, CommandType cmdType)
{
	object objRe;

	using (con = new SqlConnection(connectionstring))
	{
		cmd = new SqlCommand(query, con);
		cmd.CommandType = cmdType;

		if (param != null && param.Count > 0)
		{
			IEnumerator ie = param.GetEnumerator();
			while (ie.MoveNext()) cmd.Parameters.Add((SqlParameter)ie.Current);
		}

		con.Open();
		objRe = cmd.ExecuteScalar();
	}

	return objRe;
}

삘 받아서쓰는 초간단 강좌..

강좌라 하기도 머하지만요..

이번엔 디버깅하기 편하고..

여러 닷넷 개발자분들도 사용하는 방법으로..

프로세스에 연결해서 하는 디버깅방법을 알아보겠습니다..

그냥 바로 화면으로 ..

System.Diagnostics.Stopwatch watch = new System.Diagnostics.Stopwatch();
watch.Start();

// something doing

watch.Stop();
Response.Write(watch.Elapsed.ToString());

if (this.Form.HasControls())
{
 Response.Write("HasControls ; " + this.Form.Controls.Count + "
");
 Response.Write("
");
 for (int i = 0; i < this.Form.Controls.Count; i++)
 {
  Control ctl = this.Form.Controls[i];

  Response.Write(i.ToString() + " ; " + ctl.GetType() + " -> clientid : " + ctl.ClientID + "
");
 }
}
else
{
 Response.Write("No HasControls");
}