用VS2005保存不了数据到Sql Server2005(在线等!)
小弟刚学VB.Net照着书上编程,利用NewRow新增一条记录,最后程序也没有报错,但数据库中也无任何记录,先各位兄弟们指点一番
LocalConn.Open()
strSQL = "Select * from Table"
Dim SqlRead As SqlDataAdapter = New SqlDataAdapter(strSQL, LocalConn)
Dim SqlData As DataSet = New DataSet
SqlRead.Fill(SqlData, "Table1")
Dim SqlDataRow As DataRow = SqlData.Tables("Table1").NewRow()
SqlDataRow("Name") = Trim(TextBox1.Text)
SqlDataRow("Date") = Trim(TextBox2.Text)
SqlDataRow("Sex") = Trim(TextBox3.Text)
SqlData.Tables("Table1").Rows.Add(SqlDataRow)