读书人

在SQL查询后获取某个字段的值,该如何

发布时间: 2012-01-15 22:57:48 作者: rapoo

在SQL查询后,获取某个字段的值
我代码是这么写的:
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection Myconnection;
SqlCommand Mycommend;
SqlDataReader Myreader;
SqlParameter userParam;

Myconnection = new SqlConnection();
Myconnection.ConnectionString = ConfigurationManager.ConnectionStrings[ "jwglConn "].ConnectionString;
Mycommend = new SqlCommand();
Mycommend.CommandText = "select * from user_tabl where UserName = @usr ";
Mycommend.CommandType = CommandType.Text;
Mycommend.Connection = Myconnection;

userParam = new SqlParameter();
userParam.ParameterName = "@usr ";
userParam.Value = TextBox1.Text.Trim();

Mycommend.Parameters.Add(userParam);

Mycommend.Connection.Open();
Myreader = Mycommend.ExecuteReader();
if (!Myreader.Read()) return;
TextBox2.Text = Myreader[ "Psw "].ToString;//这儿有问题,提示:无法将方法组“tostring "转换为非委托类型 "sting "
Myreader = Mycommend.ExecuteReader(CommandBehavior.CloseConnection);
Mycommend.Dispose();
Myconnection.Dispose();
}
}
我想通过字段名称来获取字段值,问题在那,该怎么写,请各位帮忙,谢谢了

[解决办法]
TextBox2.Text = Myreader[ "Psw "].ToString();

读书人网 >asp.net

热点推荐