<script language="C#" type="text/C#" runat="server">
private void page_load(object sender, EventArgs e)
{
string Userid = Request.QueryString["userid"];
string ConnSql = System.Configuration.ConfigurationManager.AppSettings["SqlConnection"];
SqlConnection conn = new SqlConnection(ConnSql);
string sql = "select username form sh where userid='" + Userid + "'";
//接下来怎么办?
}
</script>接下来我该怎么写呀?我想取出数据库中的username列,但并不用于显示
private void page_load(object sender, EventArgs e)
{
string Userid = Request.QueryString["userid"];
string ConnSql = System.Configuration.ConfigurationManager.AppSettings["SqlConnection"];
SqlConnection conn = new SqlConnection(ConnSql);
string sql = "select username form sh where userid='" + Userid + "'";
//接下来怎么办?
}
</script>接下来我该怎么写呀?我想取出数据库中的username列,但并不用于显示
解决方案 »
- 数据库遍历
- asp.net 整页转换成静态
- 微软官方VS2008试用版怎么下不下来了
- 请问:就是數據庫中為null時提示出錯,datagrid上什麽也沒有顯示出來.........數據庫中為空時 提示出錯,datagrid上顯示為空。谢谢
- 前辈,虚拟目录路径问题。。
- DataTable作为函数参数的怪问题,请指点!
- DataGrid控件中日期的显示包含了时间,怎么把时间部分去掉(asp.net,c#)
- 关于框架问题求救
- 怎么在datagrid的DeleteCommand事件中得到datagrid的总行数?在线等待
- 我这样调用存储过程有错误吗?大家过来看一下!
- 请问大家是怎么处理DbNull值的?
- 求救,使用cookies记录用户IP,防止重复点击出现问题..
sqldatareader dr = cmd.ExecuteReader();
if(dr.read())
{
dr.getstring(0);
}
SqlDataAdapter myAd=new SqlDataAdapter (myCom);
conn.Open();
DataSet ds=ad.Fill(ds,"");
conn.Close();
大体上是这样的,关键字可能有错误。
public SqlDataReader sdrOpen(string sdrStr)
{
cmd = new SqlCommand(sdrStr, con);
sdr = cmd.ExecuteReader();
return sdr;
con.Close();
sdr.Close();
}aspx:
string sql = "select username form sh where userid='" + Userid + "'";
SqlDataReader usersdr = odb.sdrOpen(sql);
while (usersdr.Read())
{
string str= usersdr.GetString(0);
}
usersdr.Close();
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.SelectCommand = new SqlCommand(sql , conn);
da.Fill(ds);
sqldatareader dr = cmd.ExecuteReader();
if(dr.read())
{
dr["你要的字段名"].ToString();
}如果是单独要用这个字段,可以用上面的;
如果是用来数据绑定或处理等,可以用dataset,方法,楼上已有人回答,我就不引用了!
异常详细信息: System.InvalidOperationException: ExecuteReader 要求已打开且可用的连接。连接的当前状态为已关闭。
SqlDataReader dr = cmd.ExecuteReader();行 12: string sql = "select username form sh where userid='" + Userid + "'";
行 13: SqlCommand cmd = new SqlCommand(sql, conn);
行 14: SqlDataReader dr = cmd.ExecuteReader(); ------------------->出错行!
行 15: if (dr.Read())完整的代码:
<%@ Page Language="C#"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="C#" type="text/C#" runat="server">
private void page_load(object sender, EventArgs e)
{
string Userid = Request.QueryString["userid"];
Response.Write("将" + Userid + "升级为高级会员");
string ConnSql = System.Configuration.ConfigurationManager.AppSettings["SqlConnection"];
SqlConnection conn = new SqlConnection(ConnSql);
string sql = "select username form sh where userid='" + Userid + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
dr["username"].ToString();
} }
</script>
<%@ Page Language="C#"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="C#" type="text/C#" runat="server">
private void page_load(object sender, EventArgs e)
{
string Userid = Request.QueryString["userid"];
Response.Write("将" + Userid + "升级为高级会员");
string ConnSql = System.Configuration.ConfigurationManager.AppSettings["SqlConnection"];
SqlConnection conn = new SqlConnection(ConnSql);
string sql = "select username from sh where userid='" + Userid + "'";
conn.open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
dr["username"].ToString();
} }
</script>
<%@ Page Language="C#"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="C#" type="text/C#" runat="server">
private void page_load(object sender, EventArgs e)
{
string Userid = Request.QueryString["userid"];
Response.Write("将" + Userid + "升级为高级会员");
string ConnSql = System.Configuration.ConfigurationManager.AppSettings["SqlConnection"];
SqlConnection conn = new SqlConnection(ConnSql);
string sql = "select username from sh where userid='" + Userid + "'";
conn.open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
dr["username"].ToString();
}
sqlcon.close();
}
</script>
谢谢各位,zy_1985和BernardSun很细心,呵呵~~谢谢!!