public void OnPostNext() { String Search_User = HttpContext.Session.GetString("Search_User"); String Exception = ""; Boolean CheckConnection = MyOwnMySQLConnectionClass.LoadConnection(ref Exception); MySqlCommand MySQLQuery = new MySqlCommand(); MySqlDataReader RecordReader; String Requestor_1 = ""; String Current_User = HttpContext.Session.GetString("User_Name"); String Chat_OFFSET_String = HttpContext.Session.GetString("Chat_OFFSET"); int Chat_OFFSET = int.Parse(Chat_OFFSET_String); OtherUserList = new List <String> { }; IDList = new List <String> { }; if (Search_User != null) { if (Chat_OFFSET == 0) { Chat_OFFSET += 50; } MySQLQuery.CommandText = "SELECT `Requestor_1`,`ID` FROM `DF_Public_Key` WHERE `Requestor_1`=@Current_User AND `Status`=@Status AND `Requestor_2` LIKE '%@Search_User%' LIMIT 50 OFFSET " + Chat_OFFSET.ToString(); MySQLQuery.Parameters.Add("@Search_User", MySqlDbType.Text).Value = Search_User; MySQLQuery.Parameters.Add("@Current_User", MySqlDbType.Text).Value = Current_User; MySQLQuery.Parameters.Add("@Status", MySqlDbType.Text).Value = "R1 & R2 had established keys respectively"; MySQLQuery.Connection = MyOwnMySQLConnectionClass.MyMySQLConnection; MySQLQuery.Prepare(); RecordReader = MySQLQuery.ExecuteReader(); while (RecordReader.Read()) { Requestor_1 = RecordReader.GetValue(0).ToString(); OtherUserList.Add(Requestor_1); IDList.Add(RecordReader.GetValue(1).ToString()); } MyOwnMySQLConnectionClass.MyMySQLConnection.Close(); CheckConnection = MyOwnMySQLConnectionClass.LoadConnection(ref Exception); MySQLQuery = new MySqlCommand(); MySQLQuery.CommandText = "SELECT `Requestor_2`,`ID` FROM `DF_Public_Key` WHERE `Requestor_2`=@Current_User AND `Status`=@Status AND `Requestor_1` LIKE '%@Search_User%' LIMIT 50 OFFSET " + Chat_OFFSET.ToString(); MySQLQuery.Parameters.Add("@Search_User", MySqlDbType.Text).Value = Search_User; MySQLQuery.Parameters.Add("@Current_User", MySqlDbType.Text).Value = Current_User; MySQLQuery.Parameters.Add("@Status", MySqlDbType.Text).Value = "R1 & R2 had established keys respectively"; MySQLQuery.Connection = MyOwnMySQLConnectionClass.MyMySQLConnection; MySQLQuery.Prepare(); RecordReader = MySQLQuery.ExecuteReader(); while (RecordReader.Read()) { Requestor_1 = RecordReader.GetValue(0).ToString(); OtherUserList.Add(Requestor_1); IDList.Add(RecordReader.GetValue(1).ToString()); } MyOwnMySQLConnectionClass.MyMySQLConnection.Close(); HttpContext.Session.SetString("Chat_OFFSET", (Chat_OFFSET + 50).ToString()); } else { if (Chat_OFFSET == 0) { Chat_OFFSET += 50; } MySQLQuery.CommandText = "SELECT `Requestor_1`,`ID` FROM `DF_Public_Key` WHERE `Requestor_1`=@Current_User AND `Status`=@Status AND LIMIT 50 OFFSET " + Chat_OFFSET.ToString(); MySQLQuery.Parameters.Add("@Current_User", MySqlDbType.Text).Value = Current_User; MySQLQuery.Parameters.Add("@Status", MySqlDbType.Text).Value = "R1 & R2 had established keys respectively"; MySQLQuery.Connection = MyOwnMySQLConnectionClass.MyMySQLConnection; MySQLQuery.Prepare(); RecordReader = MySQLQuery.ExecuteReader(); while (RecordReader.Read()) { Requestor_1 = RecordReader.GetValue(0).ToString(); OtherUserList.Add(Requestor_1); IDList.Add(RecordReader.GetValue(1).ToString()); } MyOwnMySQLConnectionClass.MyMySQLConnection.Close(); CheckConnection = MyOwnMySQLConnectionClass.LoadConnection(ref Exception); MySQLQuery = new MySqlCommand(); MySQLQuery.CommandText = "SELECT `Requestor_2`,`ID` FROM `DF_Public_Key` WHERE `Requestor_2`=@Current_User AND `Status`=@Status LIMIT 50 OFFSET " + Chat_OFFSET.ToString(); MySQLQuery.Parameters.Add("@Current_User", MySqlDbType.Text).Value = Current_User; MySQLQuery.Parameters.Add("@Status", MySqlDbType.Text).Value = "R1 & R2 had established keys respectively"; MySQLQuery.Connection = MyOwnMySQLConnectionClass.MyMySQLConnection; MySQLQuery.Prepare(); RecordReader = MySQLQuery.ExecuteReader(); while (RecordReader.Read()) { Requestor_1 = RecordReader.GetValue(0).ToString(); OtherUserList.Add(Requestor_1); IDList.Add(RecordReader.GetValue(1).ToString()); } MyOwnMySQLConnectionClass.MyMySQLConnection.Close(); HttpContext.Session.SetString("Chat_OFFSET", (Chat_OFFSET + 50).ToString()); } }