本文整理汇总了C#中DataBaseConnection.AuthConn方法的典型用法代码示例。如果您正苦于以下问题：C# DataBaseConnection.AuthConn方法的具体用法？C# DataBaseConnection.AuthConn怎么用？C# DataBaseConnection.AuthConn使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataBaseConnection的用法示例。
在下文中一共展示了DataBaseConnection.AuthConn方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetClientId
public void GetClientId(string UserName)
{
string ClientId = "";
MembershipUser user = Membership.GetUser(UserName);
Guid guid = (Guid)user.ProviderUserKey;
DataBaseConnection dbConn = new DataBaseConnection();
SqlConnection con = dbConn.AuthConn();
SqlCommand cmdI = new SqlCommand("SELECT ClientId FROM Users WHERE UserId='" + guid + "'", con);
cmdI.Connection.Open();
SqlDataReader drI = cmdI.ExecuteReader();
if (drI.HasRows)
{
while (drI.Read())
{
ClientId = drI["ClientId"].ToString();
}
}
drI.Close();
con.Close();
drI.Dispose();
con.Dispose();
HttpContext.Current.Session["ClientId"] = ClientId;
}示例2: GetUsername
public string GetUsername(int id)
{
string ret = "";
DataBaseConnection dbConn = new DataBaseConnection();
SqlConnection con = dbConn.AuthConn();
SqlCommand cmdI = new SqlCommand("SELECT aU.UserName FROM Users U INNER JOIN aspnet_Users aU ON U.UserId = aU.UserId WHERE U.UsersId = " + id, con);
cmdI.Connection.Open();
SqlDataReader drI = cmdI.ExecuteReader();
if (drI.HasRows)
{
while (drI.Read())
{
ret = drI["UserName"].ToString();
}
}
drI.Close();
con.Close();
drI.Dispose();
con.Dispose();
return ret;
}示例3: InsertUserSchool
public string InsertUserSchool(Guid UserId, int ClientId)
{
string strReturn = "";
DataBaseConnection dbConn = new DataBaseConnection();
SqlConnection con = dbConn.AuthConn();
SqlCommand cmdI = new SqlCommand("INSERT INTO Users VALUES ('" + UserId + "'," + ClientId + ")", con);
cmdI.Connection.Open();
cmdI.ExecuteNonQuery();
con.Close();
con.Dispose();
return strReturn;
}