在DataSet的DataTable中,增加一条空白记录,然后绑定到DataGrid上。SqlDataAdapter1.Fill(DataSet1);DataRow row = DataSet1.Tables[0].NewRow();DataSet1.Tables[0].Rows.Add(row);DataGrid1.DataSource = DataSet1.Tables[0];DataGrid1.DataBind();DataGrid1.CurrentPageIndex = DataGrid1.PageCount - 1;DataGrid1.EditItemIndex = DataSet1.Tables[0].Rows.Count % DataGrid1.PageSize;DataGrid1.DataBind();
谢谢你提供的叶面,可是和我得想要求的有点区别,我是想要达到,点击“ADD New"之后,在DateDrid的最下面出现一航可输入的区域,然后输入,插入。
Dim strFirstName As String objConn = New SqlConnection(ConfigurationSettings.AppSettings("connectionString"))
objConn.Open()
strLastName = txtLastName.Text.Trim()
strFirstName = txtFirstName.Text.Trim()
strSql = "INSERT INTO Employees (LastName, FirstName) " _
& "VALUES ('" & strLastName & "', '" & strFirstName & "')"
objCmd = New SqlCommand(strSql, objConn)
objCmd.ExecuteNonQuery()
objConn.Close()
还有谁有好的建议么?
http://aspnet.4guysfromrolla.com/articles/021203-1.aspxenjoy!
里面有一个Editable DataGrid的模版,应该是你想要的。