Gridview 이용하여 화면 뿌리기

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.OracleClient; using System.Data; namespace WebApplication3 { public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { OracleConnection conn = new OracleConnection(); conn.ConnectionString = "Data Source=xxx;User ID=xxx;Password=xxx;Unicode=True"; conn.Open(); string strsql = "SELECT * FROM TEST10G"; DataSet ds = new DataSet(); OracleDataAdapter oda = new OracleDataAdapter(strsql, conn); oda.Fill(ds); DataTable dt = new DataTable(); dt = ds.Tables[0]; DataRow dr = dt.Rows[1]; GridView1.DataSource = ds; GridView1.DataBind(); //TextBox1.Text = dr["SUBJECT"].ToString(); Text1.Value = dr["SUBJECT"].ToString(); conn.Close(); conn.Dispose(); } } }

gridview

- 조회성, 리스트를 보여줄때

- 속성값을 지정해줘야 한다 (열편집, boundfield, datafield, headertext)

- ex)grd_list (ID 맞춰주기)

* AutoGenerate Columns=false 원하는값만 찾아주는 명령어