自译MSDN文献 《摆脱开发者对 CommandBuilder的依赖》

自译MSDN文献 《摆脱开发者对 CommandBuilder的依赖》(26) 第一步我们要做的是从生成代码中构建我们的SqlDataAdapter . 展开 "Windows Form Designer generated code" 区域 知道你找到SqlSelectCommand1 如清单 4所示.

清单 4. DACW-生成 SelectCommand

'

'SqlSelectCommand1

'

Me.SqlSelectCommand1.CommandText = "SELECT PID, Name, State, _

  TimeStamp FROM DemoTSConcurrency WHERE (State = " & _

  @StateWanted)"

Me.SqlSelectCommand1.Connection = Me.SqlConnection1

Me.SqlSelectCommand1.Parameters.Add(New _

 System.Data.SqlClient.SqlParameter("@StateWanted", _

 System.Data.SqlDbType.VarChar, 2, "State"))

        '