string cnstring="DATABASE = aa; SERVER = tt; UID = sa; PWD=;";
SqlConnection conn = new SqlConnection(cnstring);
conn.Open();
SqlDataAdapter mycommand=new SqlDataAdapter("select * from ss", conn);
SqlCommandBuilder mycb= new SqlCommandBuilder(mycommand);
DataSet mydataset= new DataSet();
mycommand.Fill(mydataset, "ss");
DataTable mytable=mydataset.Tables["ss"];
DataRow mydatarow;
mydatarow = mytable.NewRow();
mydatarow[1] = bname.Text.Trim();
mydatarow[2] = bsex.SelectedItem.Value.Trim();
mydatarow[3] = bnation.Text.Trim();
mytable.Rows.Add(mydatarow);
mycommand.Update(mydataset, "ss");
SqlConnection conn = new SqlConnection(cnstring);
conn.Open();
SqlDataAdapter mycommand=new SqlDataAdapter("select * from ss", conn);
SqlCommandBuilder mycb= new SqlCommandBuilder(mycommand);
DataSet mydataset= new DataSet();
mycommand.Fill(mydataset, "ss");
DataTable mytable=mydataset.Tables["ss"];
DataRow mydatarow;
mydatarow = mytable.NewRow();
mydatarow[1] = bname.Text.Trim();
mydatarow[2] = bsex.SelectedItem.Value.Trim();
mydatarow[3] = bnation.Text.Trim();
mytable.Rows.Add(mydatarow);
mycommand.Update(mydataset, "ss");
解决方案 »
- TFS 2010 Standard安装问题
- 调试超卡,非调试一点都不卡~!怎么办?
- 初学.net
- 基础问题,一个类的调用问题。含代码,初学者~~~~
- 我用svg加javascript加iis做了一个网上围棋,怎么部署到因特网上给大家用
- itemTemplate中数据绑定的问题
- TreeView 怎么触发(+/-)号的事件?
- ??????如何在.net下实现无服务器刷新的表单连动?在先等 100分!
- 如何在asp.net中使用<%#myvar%>?
- 在ASP。NET中怎么播放audio和vidio flash?
- 【问】网站能否删除源文件?
- 求助:在visual studio .net中无法建立项目.
SqlConnection conn = new SqlConnection(cnstring);
conn.Open();
SqlDataAdapter mycommand = new SqlDataAdapter("select * from ss", conn);
SqlCommandBuilder mycb = new SqlCommandBuilder(mycommand);
DataSet mydataset = new DataSet();
mycommand.Fill(mydataset, "ss");
DataTable mytable = mydataset.Tables("ss");
DataRow mydatarow = mytable.NewRow();
mydatarow[1] = bname.Text.Trim();
mydatarow[2] = bsex.SelectedItem.Value.Trim();
mydatarow[3] = bnation.Text.Trim();
mytable.Rows.Add(mydatarow);
mycommand.Update(mydataset, "ss");
比如:vb.net to c#.net或c#.net to vb.net
楼主可以从http://aspxcn.com下载