62,046
社区成员
发帖
与我相关
我的任务
分享
cmd.CommandText = "insert into news(news_title,news_date,news_user,news_contents) values('" + str1 + "'," + now.ToString() + ",'" + users_name + "','" + str2 + "')";
SqlConnection conn = new SqlConnection("***");
conn.Open();
string sql="select users_name from users where users_id = " + Session["Users_id"];
SqlDataAdapter ada=new SqlDataAdapter(String, conn);
SqlCommandBuilder builder = new SqlCommandBuilder(ada);
DataTable dt=new DataSet();
ada.Fill(dts);
DataRow r;
if(dt.Rows.Count==0)
{
r=dt.NewRow();
dt.Rows.Add(r);
}
else
{
r=dt.Rows[0];
}
/*.....修改 r 的值...*/
ada.Update(dt);