protected void BtnSearch_Click(object sender, EventArgs e)
{
var connString = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
using (var conn = new SqlConnection(connString))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand("SearchMemo", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SearchField", CboSearch.SelectedValue); // Name or Title
cmd.Parameters.AddWithValue("@SearchQuery", TxtSearch.Text.Replace("--", ""));
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds, "Memos");
GrvMemoList.DataSource = ds; //.Tables[0].DefaultView;
GrvMemoList.DataBind();
}
}
protected void BtnSearch_Click(object sender, EventArgs e)
{
// '리스트' 버튼을 클릭하면 그리드 뷰를 통해 데이터가 출력
var connString = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
using (var conn = new SqlConnection(connString))
{
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand("SearchMemo", conn); // 저장 프로시저 SearchMemo 를 호출
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SearchField", CboSearch.SelectedValue); // Name, Title 넘어감
cmd.Parameters.AddWithValue("@SearchQuery", TxtSearch.Text.Replace("--", "")); // '--' 라는 Sql쿼리의 주석을 없애겠다는 의미
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds, "Memos");
GrvMemoList.DataSource = ds.Tables[0].DefaultView;
GrvMemoList.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
var connString = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
using (var conn = new SqlConnection(connString))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand("ListMemo", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds, "Memos");
GrvMemoList.DataSource = ds;
GrvMemoList.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
var connString = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
using (var conn = new SqlConnection(connString))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand("ListMemo", conn);
cmd.CommandType = CommandType.StoredProcedure; //ListMemo에 있는 데이터중 종류는 StoredProcedure(저장된 프로시저)꺼 불러오기
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet(); //데이터를 넣을 공간을 만든다
adapter.Fill(ds, "Memos");
GrvMemoList.DataSource = ds; //그리드뷰에서 바인딩 실행하면 표에 위에서 뽑은 값들이 채워진다
GrvMemoList.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
// '리스트' 버튼을 클릭하면 그리드 뷰를 통해 데이터가 출력
var connString = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
using (var conn = new SqlConnection(connString))
{
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand("ListMemo", conn); // 저장 프로시저 ListMemo 를 호출(SELECT 문)
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds, "Memos");
GrvMemoList.DataSource = ds;
GrvMemoList.DataBind();
}
}
