SqlConnection1.Open()
SqlDataAdapter1.InsertCommand.CommandText = "INSERT INTO BGDS " & _
"( BGENO)" & _
" VALUES " & _
"( @BGENO)"
SqlDataAdapter1.InsertCommand.Parameters.Clear()
SqlDataAdapter1.InsertCommand.Parameters.Add("@BGENO", TextBox1.Text)
SqlDataAdapter1.InsertCommand.ExecuteNonQuery()
SqlDataAdapter1.Update(DataSet11, "BGDS")
SqlDataAdapter1.Fill(DataSet11, "BGDS")
SqlConnection1.Close()