public int GetRank()
{
int tempRank;
String strConnection1 = ConfigurationSettings.AppSettings["connectionString1"];
String strConnection2 = HttpContext.Current.Server.MapPath("../"+ConfigurationSettings.AppSettings["connectionString2"]);
String strConnection3 = strConnection1+strConnection2; OleDbConnection objConnection = new OleDbConnection(strConnection3);
OleDbCommand myCommand = new OleDbCommand("SELECT rank FROM Agent WHERE aid = @aid)", objConnection); OleDbParameter parameteraid = new OleDbParameter("@aid", OleDbType.Char, 50);
parameteraid.Value = HttpContext.Current.User.Identity.Name;
myCommand.Parameters.Add(parameteraid);
objConnection.Open();
OleDbDataReader myReader;
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
tempRank = Convert.ToInt32(myReader["rank"]);
}
myReader.Close();
objConnection.Close(); Rank = tempRank;
return Rank
}调用时先建立类的实例
类名() 实例1 = new 类名();
int 变量 = 实例1.方法名();
{
int tempRank;
String strConnection1 = ConfigurationSettings.AppSettings["connectionString1"];
String strConnection2 = HttpContext.Current.Server.MapPath("../"+ConfigurationSettings.AppSettings["connectionString2"]);
String strConnection3 = strConnection1+strConnection2; OleDbConnection objConnection = new OleDbConnection(strConnection3);
OleDbCommand myCommand = new OleDbCommand("SELECT rank FROM Agent WHERE aid = @aid)", objConnection); OleDbParameter parameteraid = new OleDbParameter("@aid", OleDbType.Char, 50);
parameteraid.Value = HttpContext.Current.User.Identity.Name;
myCommand.Parameters.Add(parameteraid);
objConnection.Open();
OleDbDataReader myReader;
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
tempRank = Convert.ToInt32(myReader["rank"]);
}
myReader.Close();
objConnection.Close(); Rank = tempRank;
return Rank
}调用时先建立类的实例
类名() 实例1 = new 类名();
int 变量 = 实例1.方法名();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货