各位大蝦,請指教
操作語言,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數據每欄欄寬.