乐视电视怎么看nba直播:ADO.NET中Adapter对象更新数据源的问题

我想要更新数据库中的数据表，用的是SQL Server
我的程序是这样写的：
Dim cmd As New SqlCommand
cmd.CommandText = "UPDATE SempleTable SET Name = @Name, Adress = @Adress WHERE (Name = @O_Name) AND (Adress = @O_Adress)"
cmd.Parameters.Add("Name", SqlDbType.Char, 10, "Name")
cmd.Parameters.Add("O_Name", SqlDbType.Char, 10, "Name")
cmd.Parameters.Add("Adress", SqlDbType.Char, 10, "Adress")
cmd.Parameters.Add("O_Adress", SqlDbType.Char, 10, "Adress")
cmd.Parameters.Item("O_Name").SourceVersion = DataRowVersion.Original
cmd.Parameters.Item("Name").SourceVersion = DataRowVersion.Current
cmd.Parameters.Item("Adress").SourceVersion = DataRowVersion.Current
cmd.Parameters.Item("O_Adress").SourceVersion = DataRowVersion.Original
cmd.Connection = Me.SqlConnection1
Me.SqlDataAdapter1.UpdateCommand = cmd
Dim tmpTable As DataTable
tmpTable = ATable.GetChanges
If tmpTable.Rows.Count > 0 Then
Try
SqlDataAdapter1.Update(tmpTable)
Catch ex As Exception
MsgBox(ex.Message)
End Try

End If
我的数据表只有两个字段：Name、Adress。但是每次运行到SqlAdapter1.Update的时候都捕获到错误“第一行，Name附近有语法错误"
给参数加单引号还是不行，报告一样的错误