Hancem.sarang.net

단일 테이블 연결
SqlDataAdapter myadapter=new SqlDataAdapter("select * from address", 
                                                                "server=(local);Trusted_connection=yes;database=ado");
DataSet mydataset=new DataSet();
myadapter.Fill(mydataset, "address");
dataGrid1.DataSource=mydataset.Tables["address"].DefaultView;


행의 추가
SqlDataAdapter myadapter=new SqlDataAdapter("select * from address", 
                                                                "server=(local);Trusted_connection=yes;database=ado");
SqlCommandBuilder mycommandbuilder=new SqlCommandBuilder(myadapter);
DataSet mydataset=new DataSet();
myadapter.Fill(mydataset, "address");
DataRow myrow=mydataset.Tables["address"].NewRow();
myrow["name"]=textBox1.Text;
myrow["phone"]=textBox2.Text;
myrow["email"]=textBox3.Text;
mydataset.Tables["address"].Rows.Add(myrow);
myadapter.Update(mydataset, "address");
dataGrid1.DataSource=mydataset.Tables["address"].DefaultView;



행의 삭제
SqlDataAdapter myadapter=new SqlDataAdapter("select * from address", 
                                                            "server=(local);Trusted_connection=yes;database=ado");
SqlCommandBuilder mycommandbuilder=new SqlCommandBuilder(myadapter);
DataSet mydataset=new DataSet();
myadapter.Fill(mydataset, "address");
curRow=dataGrid1.CurrentRowIndex;
if (curRow >-1)
       mydataset.Tables["address"].Rows[curRow].Delete();
myadapter.Update(mydataset.GetChanges(DataRowState.Deleted), "address");
dataGrid1.DataSource=mydataset.Tables["address"].DefaultView;	



행의 수정
SqlDataAdapter myadapter=new SqlDataAdapter("select * from address", 
                                                              "server=(local);Trusted_connection=yes;database=ado");
SqlCommandBuilder mycommandbuilder=new SqlCommandBuilder(myadapter);
DataSet mydataset=new DataSet();
myadapter.Fill(mydataset, "address");
curRow=dataGrid1.CurrentRowIndex;
mydataset.Tables["address"].Rows[curRow].BeginEdit();
mydataset.Tables["address"].Rows[curRow]["name"]=textBox1.Text;
mydataset.Tables["address"].Rows[curRow]["phone"]=textBox2.Text;
mydataset.Tables["address"].Rows[curRow]["email"]=textBox3.Text;			
mydataset.Tables["address"].Rows[curRow].EndEdit();
myadapter.Update(mydataset, "address");
dataGrid1.DataSource=mydataset.Tables["address"].DefaultView;

위를 보시면 대충 연결에 대해 이해가 가실꺼고..

대충 요런식으로 리스트 뷰에 데이타를 집어 넣으시면 되겠네요.ㅎㅎ

public void GetPatientList(ListView list)
  {
   
   list.Items.Clear();
   ListViewItem item;
   foreach(DataRow r in dSet.Tables["patient"].Rows)
   {
    item=new ListViewItem(r["name"].ToString());
    item.SubItems.Add(r["jumin"].ToString());
    item.SubItems.Add(r["id"].ToString());
    list.Items.Add(item);
   }
  }