datagridview 新增行

问题描述

各位大哥大姐，小弟我有个问题想请教，问题是这样的：我现在布局一个datagridview两个textbox，分别为textbox1，textbox2，还有一个按钮。我想通过按钮单击之后，包textbox1，textbox2中的数据添加到datagridview，之前的datagridview数据不变。请高手帮帮忙！没有插入到数据库中，到最后一起插入数据库的

解决方案

解决方案二：
编号：textbox1，名称：textbox２，提交：button1，还要设立密码作为window验证，如UserID=aa;Password=111用C#写的，用vs2005开发的。我也是初学者，所以代码不够完善，多多见谅，谢谢！usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;publicpartialclass_WebForm1:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack)//定义开始显示的查询页面数据{sql="select编号,名称　from表";}show(sql);}protectedvoidButton1_Click(objectsender,EventArgse){sql1="select*from表　where编号='"+TextBox1.Text+"'and名称='"+TextBox2.Text+"'";Stringsqlconn="DataSource=localhost;InitialCatalog=数据库;UserID=aa;Password=111";SqlConnectionmyConnection=newSqlConnection(sqlconn);myConnection.Open();SqlCommandmyCommand=newSqlCommand(sql1,myConnection);myCommand.ExecuteNonQuery();TextBox1.Text="";TextBox2.Text="";show(sql);}protectedvoidshow(stringstr){SqlConnectionconn=newSqlConnection(connstr);SqlDataAdapteradapter=newSqlDataAdapter(str,conn);DataSetmyset=newDataSet();adapter.Fill(myset,"表");datagridview1.DataSource=myset.Tables["表"].DefaultView;datagridview1.DataBind();}protectedvoidButton2_Click(objectsender,EventArgse){sql1="insertinto表values('"+TextBox1.Text+"','"+TextBox2.Text+"')";Stringsqlconn="DataSource=localhost;InitialCatalog=数据库;UserID=aa;Password=111";SqlConnectionmyConnection=newSqlConnection(sqlconn);myConnection.Open();SqlCommandmyCommand=newSqlCommand(sql1,myConnection);myCommand.ExecuteNonQuery();TextBox1.Text="";TextBox2.Text="";show(sql);}}