getuserpwd.cs

学术会议在线投稿系统 fghgfhgfhgfhfgh

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.Collections.Generic;
using System.Text;
using System.Data.SqlClient;

/// <summary>
/// Summary description for GetUserPwd
/// </summary>
public class GetUserPwd:DataAccess 
{
    public String pwd;
    public String GetUserPwd_ChangePwd(String Email)
    {
         SqlCommand comm = new SqlCommand();
        conn.Open();
        comm.CommandType = CommandType.StoredProcedure;
        comm.CommandText = "User_SelectUserPasswordByEmial";
        comm.Connection = conn;
        comm.Parameters.Add("@Email", SqlDbType.NVarChar).Value = Email;
        SqlDataAdapter sda = new SqlDataAdapter(comm);
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        try
        {    
            sda.Fill(ds, "UserPwd_ChangePwd");
            dt = ds.Tables["UserPwd_ChangePwd"];
            foreach (DataRow dr in dt.Rows)
            {   
                TableRow tr = new TableRow();
                for (int j = 0; j <=dt.Columns.Count; j++)
                     pwd=dr[0].ToString();

            }
        }
        catch (SqlException e)
        {
            String error_string = e.ToString();
            conn.Close();
            return "";
        }
        conn.Close();
        return pwd;
    }

}