请问一个问题sql查询后如何赋值

[ssiyyy]

string sql = " select top 1 id from [Lib_User] order by id desc ";
怎样将查询出来的值赋给变量id

虽然大虾们觉得可能比较菜，但是~~~~

[yangqidong]

这个说来话长。。。

[gdjlc]

我写的例子：


Web.Config:

<appSettings>
<add key="conStr" value="Server=J-7494F2E50BAD4\LICHUAN;database=TIS;Uid=sa;Pwd="/>
</appSettings>

------------------------------------------------------------------
Test.aspx.cs:

string strID=""; //变量
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
con.Open();

string sqlstr = "select top 1 id from [Lib_User] order by id desc ";
SqlCommand cmd = new SqlCommand(sqlstr, con);

SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
strID = dr[id].ToString();
}
dr.Close();

[teerhu]

string sql = " select top 1 id from [Lib_User] order by id desc ";
DataTable dt=GetMyTable(sql,strconnection)

string id="";
if(dt!=null && dt.Rows.Count>0)
{
id=dt.Rows[0]["id"].ToString();
}

public DataTable GetMyTable(string strCmd, string strConnection)
{

SqlDataAdapter da = new SqlDataAdapter(strCmd, strConnection);
da.SelectCommand.CommandTimeout = 240;
DataSet ds = new DataSet();
da.Fill(ds);
da.Dispose();
return ds.Tables[0];
}

[Sysping1]

IList<Lib_User> user = this.SessionUnique(" select thisTbl from [Lib_User] thisTbl order by ID");
object id = user.ID;

[ssiyyy]

[Quote=引用 2 楼 gdjlc 的回复:]
我写的例子：


Web.Config:

<appSettings>
<add key="conStr" value="Server=J-7494F2E50BAD4\LICHUAN;database=TIS;Uid=sa;Pwd="/>
</appSettings>

------------------------------------------------------------------
Test.aspx.cs:

string strID=""; //变量
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
con.Open();

…
[/Quote]

喜欢这个,其他的也都不错,可惜看不明白,不过也给分