名片互赞程序代码分享

数据库连接类：
public bool OpenConnection()
{
conn = new SqlConnection(connStr);
try
{
if (conn.State.ToString() != "Open")
{
conn.Open();
}
return true;
}
catch
{
return false;
}
}

断开数据库连接方法：
public bool CloseConnection()
{
try
{
conn.Close();
return true;
}
catch
{
return false;
}
}

数据库添加一行数据
/// <summary>
/// 添加一行
/// </summary>
/// <param name="qq"></param>
/// <returns></returns>
public bool AddRow(string qq)
{
if (OpenConnection() == true)
{
SqlDataAdapter myDataAdapter = new SqlDataAdapter("select * from QQ", conn);
DataSet myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet, "QQ");
DataTable myTable = myDataSet.Tables["QQ"];
DataRow myRow = myTable.NewRow();
myRow["QQ"] = qq;
myTable.Rows.Add(myRow);
SqlCommandBuilder mySqlCommandBuilder = new SqlCommandBuilder(myDataAdapter);
myDataAdapter.Update(myDataSet, "QQ");
myDataAdapter.Dispose();
myDataSet.Dispose();
return CloseConnection();
}
else
return false;
}

/// <summary>
/// 读取所有数据
/// </summary>
/// <param name="count"></param>
/// <returns></returns>
public List<string> GetAllData(out int count)
{
if (OpenConnection() == true)
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM QQ";
SqlDataReader reader = cmd.ExecuteReader();
count = 0;
List<string> arr = new List<string>();
while (reader.Read())
{
arr.Add(reader.GetString(reader.GetOrdinal("QQ")));
count++;
}
CloseConnection();
return arr;
}
count = 0;
return null;
}

上一楼删除数据需要调用的查找数据的方法
public object seekSql(string QQ)
{
SqlCommand command1 = conn.CreateCommand();
command1.CommandType = CommandType.Text;
command1.CommandText = "Select * from QQ ";
SqlDataReader reader1 = command1.ExecuteReader();
ArrayList list1 = new ArrayList();
while (reader1.Read())
{
if (reader1["QQ"].Equals(QQ))
{
list1.Add(reader1["ID"]);// 打印出每个用户的用户名
}
}
object id = list1.ToArray()[0];
reader1.Close();
return id;
}

至此数据库类完成，接下来窗口自动操作类，需要用到几个API

需要用到的API函数：
[DllImport("user32.dll")]
private static extern int EnumWindows(EnumWindowsProc ewp, int lParam);//EnumWindows函数，EnumWindowsProc 为处理函数
[DllImport("user32.dll")]
private static extern int GetWindowText(int hWnd, StringBuilder title, int size);
[DllImport("user32.dll")]
public static extern IntPtr FindWindow(string lpClassName, string lpWindowName);
[DllImport("User32.dll", EntryPoint = "SendMessage")]
public static extern int SendMessage(IntPtr hWnd, int Msg, IntPtr wParam, IntPtr lParam);
[DllImport("User32.dll ")]
public static extern IntPtr FindWindowEx(IntPtr parent, IntPtr childe, string strclass, string FrmText);
[DllImport("user32.dll", EntryPoint = "PostMessage")]
public static extern bool PostMessage(IntPtr hwnd, int msg, uint wParam, uint lParam);
[DllImport("user32.dll", CharSet = CharSet.Auto)]
public static extern int MoveWindow(IntPtr hWnd, int x, int y, int nWidth, int nHeight, bool BRePaint);
[DllImport("user32.dll")]
private static extern bool IsWindowVisible(int hWnd);
[DllImport("user32.dll", SetLastError = true, CharSet = CharSet.Auto)]
static extern int GetClassName(int hWnd, StringBuilder lpClassName, int nMaxCount);
[DllImport("user32.dll")]
private static extern int GetWindowTextLength(int hWnd);
[DllImport("user32.dll", EntryPoint = "keybd_event")]