报错:
Server user 'angel' is not a valid user in database 'HR'.存储过程代码:
CREATE PROCEDURE p_xz_sggbr
@gh char(5)
AS
begin
select ygh as user_id,xname user_n,ename as user_e,bm,zw,gs,dq from askhr where ygh=@gh
end
GO页面代码
protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
//建立查询命令调用存储过程名
SqlCommand cmd = new SqlCommand("p_xz_sggbr",con);
cmd.CommandType = CommandType.StoredProcedure;
//设置存储过程的参数值,其中@id 为存储过程的参数
SqlParameter para = new SqlParameter("@gh", SqlDbType.Char, 5);
para.Value = this.txtbox_ygh.Text;
para.Direction = ParameterDirection.Input; cmd.Parameters.Add(para); SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
//this.txt_name.Text = ds.Tables[0].Rows[0]["xname"].ToString();
//this.txt_ename.Text = ds.Tables[0].Rows[0]["ename"].ToString();
this.txt_bm.Text = ds.Tables[0].Rows[0]["bm"].ToString();
this.txt_zw.Text = ds.Tables[0].Rows[0]["zw"].ToString();
this.txt_gs.Text = ds.Tables[0].Rows[0]["gs"].ToString();
this.txt_dq.Text = ds.Tables[0].Rows[0]["dq"].ToString();
}
else
{
Response.Write("<script>alert('输入错误!查无此人!')</script>");
}
con.Close();
}
Server user 'angel' is not a valid user in database 'HR'.存储过程代码:
CREATE PROCEDURE p_xz_sggbr
@gh char(5)
AS
begin
select ygh as user_id,xname user_n,ename as user_e,bm,zw,gs,dq from askhr where ygh=@gh
end
GO页面代码
protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
//建立查询命令调用存储过程名
SqlCommand cmd = new SqlCommand("p_xz_sggbr",con);
cmd.CommandType = CommandType.StoredProcedure;
//设置存储过程的参数值,其中@id 为存储过程的参数
SqlParameter para = new SqlParameter("@gh", SqlDbType.Char, 5);
para.Value = this.txtbox_ygh.Text;
para.Direction = ParameterDirection.Input; cmd.Parameters.Add(para); SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
//this.txt_name.Text = ds.Tables[0].Rows[0]["xname"].ToString();
//this.txt_ename.Text = ds.Tables[0].Rows[0]["ename"].ToString();
this.txt_bm.Text = ds.Tables[0].Rows[0]["bm"].ToString();
this.txt_zw.Text = ds.Tables[0].Rows[0]["zw"].ToString();
this.txt_gs.Text = ds.Tables[0].Rows[0]["gs"].ToString();
this.txt_dq.Text = ds.Tables[0].Rows[0]["dq"].ToString();
}
else
{
Response.Write("<script>alert('输入错误!查无此人!')</script>");
}
con.Close();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货