死办法的sql语句怎么写? select top 1 CardID from tb_Card order by CardID desc;对吗? 怎么在.cs文件中调用这个sql语句? 我写cardidn = "select top 1 CardID from tb_Card order by CardID desc";在前台就直接显示这句话了,怎么执行啊?
你要把数据取出来绑定到页面上。。 public static DataTable ReturnDataTable(string cmdtext, CommandType ct, SqlParameter[] para) { DataTable dt = new DataTable(); cmd = new SqlCommand(cmdtext, GetConn()); cmd.CommandType = ct; cmd.Parameters.AddRange(para); SqlDataReader dr = null; using (dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { dt.Load(dr); } return dt; } 执行你的SQL 获取DataTABLE
在程序里想得到ID可以insert后 加一句 select scope_identity()就可以得到
insert ...
SELECT @@IDENTITY
死办法的sql语句怎么写?
select top 1 CardID from tb_Card order by CardID desc;对吗?
怎么在.cs文件中调用这个sql语句?
我写cardidn = "select top 1 CardID from tb_Card order by CardID desc";在前台就直接显示这句话了,怎么执行啊?
{
DataTable dt = new DataTable();
cmd = new SqlCommand(cmdtext, GetConn());
cmd.CommandType = ct;
cmd.Parameters.AddRange(para);
SqlDataReader dr = null;
using (dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
dt.Load(dr);
}
return dt;
}
执行你的SQL 获取DataTABLE
我的本意是:
我现在想做的是添加图片,且在图片表里面加入主贴编号,这样下一步就可以根据帖子编号显示图片了吗。
但是,问题是如何在下面代码中,把主贴编号找出来,然后放入图片表中?
(小弟.net底子薄,确实不明白),肯请指教啊!protected void UploadPic_OnClick(object sender, EventArgs e) {
string strName = "";
string cardidn = ""; cardidn = "select top 1 CardID from tb_Card order by CardID desc"; 这两个肯定有些问题,但是我也确实不知道应该怎么绑定数据啊
try
{
strName = Session["Name"].ToString();
string filePath = picUpload.PostedFile.FileName;
string filename = filePath.Substring(filePath.LastIndexOf("\\") + 1);
string fileEx = filePath.Substring(filePath.LastIndexOf(".") + 1);
string serverpath = Server.MapPath(@"..\Pic\") + filename;
string relativepath = @"..\Pic\" + filename; picUpload.PostedFile.SaveAs(serverpath);
picmanage.Piclink = relativepath;
picmanage.PicuploadName = strName;
picmanage.AddPic(picmanage);
labpiclink.Text = cardidn;有问题! Response.Write("<script language=javascript>alert('图片上传成功!')</script>");
}
catch { Response.Write("<script language=javascript>alert('错误!')</script>"); }
}
insert into table(name,age) values(@name,@age);select @@identityExecuteScalar获取
我需要查询出最近的帖子编号,这样也可以吗?