各位大蝦,請指教

操作語言,vb.net 2003 問題主要控件不會使用
Public Strds_report As String = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=ds_report;Data Source=dscac;Use Procedure for Prepare=1;Auto Translate=False;Packet Size=4096;Use Encryption for Data=False;Tag with column collation when possible=False" ‘連接SQL字符串變量

Dim rst1 As New ADODB.Recordset()
Dim MyDataSet As New DataSet
Dim MyAdpater As New OleDb.OleDbDataAdapter

Conds_report.open(strds_report) ‘連接sql數據庫
rst1.ActiveConnection = Conds_report
rst1.Open("SELECT * FROM product_days ") ‘sql語句,結果賦給rst1記錄集

MyAdpater.Fill(MyDataSet, rst1, "PROD_EDIT") ‘建立dataset
Me.DataGrid1.DataSource = MyDataSet.Tables("PROD_EDIT") “賦值給DATAGRID控件

問題1:我如何將datagrid的修改結果傳回到sql數據庫中?
問題2:我將程序打包后在客戶端不能正常使用,客戶端已安裝了dotnetframework及mdac27sp1.
問題3:如何設定datagrid1數據每欄欄寬.

謝謝版主，
1.我試過myadpater.upate(),但不成功。可否詳細點。
2.我再看看，謝謝先。

請指教，下面是更新代碼。請告哪里有問題?
Private Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click

MyAdpater.Update(MyDataSet.GetChanges)
MyDataSet.AcceptChanges()

End Sub