string appName=ConfigurationSettings.AppSettings["myConn"];
SqlConnection sqlConn=new SqlConnection(appName);
string sqlSelect="select * from BaseProjectInfo where ProjectID='"+strPid+"'";
SqlDataAdapter sqlAdpter=new SqlDataAdapter(sqlSelect,sqlConn);
SqlCommandBuilder cb = new SqlCommandBuilder(sqlAdpter);
DataSet myDs=new DataSet();
try
{
sqlAdpter.Fill(myDs,"BaseProjectInfo");
if(myDs.Tables["BaseProjectInfo"].Rows.Count==1)
{
DataRow myDr=myDs.Tables["BaseProjectInfo"].Rows[0];
myDr["name"]=strName; //strName是参数
myDr["password"]=strPassword; //strPassword是参数
sqlAdpter.Update(myDs,"BaseProjectInfo");
myDs.AcceptChanges();
this is bad, you can just run
update yourtable set name='newname' and password='newpassword' ....
SqlConnection sqlConn=new SqlConnection(appName);
string sqlSelect="select * from BaseProjectInfo where ProjectID='"+strPid+"'";
SqlDataAdapter sqlAdpter=new SqlDataAdapter(sqlSelect,sqlConn);
SqlCommandBuilder cb = new SqlCommandBuilder(sqlAdpter);
DataSet myDs=new DataSet();
try
{
sqlAdpter.Fill(myDs,"BaseProjectInfo");
if(myDs.Tables["BaseProjectInfo"].Rows.Count==1)
{
DataRow myDr=myDs.Tables["BaseProjectInfo"].Rows[0];
myDr["name"]=strName; //strName是参数
myDr["password"]=strPassword; //strPassword是参数
sqlAdpter.Update(myDs,"BaseProjectInfo");
myDs.AcceptChanges();
this is bad, you can just run
update yourtable set name='newname' and password='newpassword' ....
解决方案 »
- linq高手帮帮忙,关于linq多表左连接查询出错!在线等,急急急
- UrlRewriter如何将配置文件放在单独的xml中?
- DataBinder.Eval的简单问题,解决就给分!!!!!!!!!
- IIS匿名登录时怎样用ASP.NET获得用户名和域?
- 关于ActiveXObject,大家进来看看.
- 用javascript传递中文参数,怎么在服务器断得到呀
- .net生成静态HTML页面怎么限制用户访问?
- 哭求 上传文章 排版函数 请高手指教
- ASP.net怎么将网页全屏显示啊?小弟初学ASP.NET好多都不懂。请多多指教。
- 怎么关闭窗口呀?
- 如何正常使用HTML的File Field控件?
- 水晶报表票据打印
id name grade
1 null null
我要的结果是
id name grade
1 xxx xxx
自己瞎改的:)
myCmd.CommandText="insert into BaseProjectInfo(); valuemyCmd.ExecuteNonQuery();
sqlConn.Close();
这样加的不在原来的行上
sqlConn.Open();
cmd.ExecuteNonQuery();
sqlConn.Close();