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.方法名();