sqlserever 在大二的时候学过,当时可以说是学的还不错,但是随着时间的推移,许久不用竟然都已忘记,好吧,一点一点的拾起来吧!!!
SQLiteHelper lite = new SQLiteHelper();
DataTable table = new DataTable();
table = lite.ExecuteQuery("select * from MessageRecord where friendid='" + this.chatListBox_list.SelectSubItem.ID.ToString() + "'");
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
string data = row["messAddDate"].ToString();
string direction = row["direction"].ToString();
string friendid = row["friendid"].ToString();
string body = row["messBody"].ToString();
string read = row["read"].ToString();
string useid = row["userid"].ToString();
string friendName = row["friendName"].ToString();
string useName = row["userName"].ToString();
}
如果有表情的话则
if (Ismoti(body))
{