有SqlDataAdapter的很容易

给你一个添加插入数据库代码:

string yzConn="server=WUMS200;user id=sa;password=wums200;database=StuInformManager";
                    SqlConnection yzCon=new SqlConnection(yzConn);
                    yzCon.Open();//打开数据库连接
                    SqlTransaction myTrans=yzCon.BeginTransaction();//触发数据库事务
                    //重新初始化执行命令对象
                    SqlCommand yzCom=new SqlCommand("",yzCon);
                    yzCom.Transaction=myTrans;
                    //为SqlCommand对象的CommandText属性定义SQL插入语句
                    yzCom.CommandText="Insert into stutable(学号,姓名,性别,年龄,班级,籍贯,电话)"+"VALUES('"+stuid+"','"+stuname+"','"+stusex+"','"+stuages+"','"+stuclass+"','"+stuaddr+"','"+stutel+"')";
                    yzCom.ExecuteNonQuery();//执行SQL插入语句
                    myTrans.Commit();//提交事务
                    yzCon.Close();//关闭数据库连接
                    System.Windows.Forms.MessageBox.Show("你成功的添加了该记录");