ASP.NET中SQL数据库如何取新增记录的自动ID,请指教!求代码?
我爱运动 2017-09-25 04:20:17 protected void Button1_Click(object sender, EventArgs e)
{
string connString = System.Configuration.ConfigurationManager.ConnectionStrings["Main_Database"].ConnectionString;
SqlConnection Conn = new SqlConnection(connString);
Conn.Open(); //打开连接
string SelectSql = "select * from News_Center";
SqlDataAdapter da = new SqlDataAdapter(); //创建DataAdapter对象
da.SelectCommand = new SqlCommand(SelectSql, Conn); //取出数据库中需要的数据
DataSet ds = new DataSet(); //创建一个空DataSet对象
SqlCommandBuilder scb = new SqlCommandBuilder(da); //为DataAdapter自动生成更新命令
da.Fill(ds); //填充DataSet对象
DataRow NewRow = ds.Tables[0].NewRow(); //向DataSet第一个表对象中添加一个新行
NewRow["Time"] = DateTime.Now.ToString();
NewRow["Their_Type"] = Request.QueryString["Their_Type"].ToString();
NewRow["Name_Type"] = Name_Type_Disp;
NewRow["English_Type"] = English_Type_Disp;
NewRow["Title"] = Title.Text;
if (LinkImg.Text != "")
{
NewRow["LinkImg"] = LinkImg.Text;
NewRow["Judge_Img"] = true;
}
NewRow["Link"] = "News/index.asp?ID="+ ID; //如何取ID
ds.Tables[0].Rows.Add(NewRow); //将新建行添加到DataSet第1个表对象中
da.Update(ds); //将DataSet中数据变化提交到数据库(更新数据库)
Conn.Close();
}
NewRow["Link"] = "News/index.asp?ID="+ ID; //如何取ID