datagridview db핸들링관련질문드립니다.

Question

namespace JHW_TEST1 { public partial class JHW_Community : Form { public static string uid &#61; public static string password &#61; public static string database &#61; public static string sever &#61; DataSet ds &#61; new DataSet(); private void serch() { string connStr &#61; &#34;SERVER&#61;&#34; &#43; sever &#43; &#34;;DATABASE&#61;&#34; &#43; database &#43; &#34;;UID&#61;&#34; &#43; uid &#43; &#34;;PASSWORD&#61;&#34; &#43; password &#43; &#34;;&#34;; StringBuilder sb &#61; new StringBuilder(); SqlConnection conn &#61; new SqlConnection(connStr); SqlCommand cmd &#61; new SqlCommand(); conn.Open(); cmd.Connection &#61; conn; cmd.CommandText &#61; &#34;SELECT SEQ,Title FROM JHW_Community&#34;; SqlDataAdapter da &#61; new SqlDataAdapter(cmd); DataSet ds &#61; new DataSet(); da.Fill(ds, &#34;SEQ&#34;); da.Fill(ds, &#34;Title&#34;); dataGridView1.DataSource &#61; ds; dataGridView1.DataMember &#61; &#34;SEQ&#34;; dataGridView1.DataMember &#61; &#34;TITLE&#34;; } public void test1(string seq) { } public JHW_Community() { InitializeComponent(); } private void BT_Create_Click(object sender, EventArgs e) { JHW_Create Form2 &#61; new JHW_Create(); Form2.ShowDialog(); serch(); } private void BT_Serch_Click(object sender, EventArgs e) { serch(); } private void BT_Delete_Click(object sender, EventArgs e) { int index &#61; dataGridView1.CurrentCell.RowIndex; var row &#61;this.ds.Tables[0].Rows[index]; row[&#34;seq&#34;]; MessageBox.Show(row.ToString()); } } } 현재 이런식으로 작성이되어있는데 ROW [SEQ]이부분을 어떻게 처리해야될지 구글링을 해도 잘 모르겠습니다. private void BT_Serch_Click 클릭시 datagridview에 연동되어있는 db가 출력되고 datagridview에 출력되어있는 db를 선택하여 private void BT_Delete_Click 클릭시 선택한 컬럼에 값을 메세지 박스에 띄우고 싶은데 어떻게 해야될지 잘모르겠습니다.

datagridview db핸들링관련질문드립니다.

0개의 답변

Q&A 목록