winfrom如何使用数据库，求完整代码

Question

我想在窗体中调用数据库，可我忘记代码了，百度也没找到合适的，所以我想求完整代码。不要求三层架构
如何在winfrom里调用sql server数据库，求完整代码

Answer 1

MySQLConnection conn = null;
conn = new MySQLConnection(new MySQLConnectionString("58.96.191.232", db_name, "test", "1234", 3306).AsString);
conn.Open();
MySQLCommand commn = new MySQLCommand("set names gb2312", conn);
commn.ExecuteNonQuery();
string sql = "select uname as 用户名,FROM_UNIXTIME(sh_user_cash.create_time,'%Y-%m-%d %h:%i:%s') as 申请入金时间,amount as 申请入金金额 from sh_user_cash,sh_user where sh_user_cash.cash_type=0 and sh_user_cash.create_time >= (FLOOR((unix_timestamp(now()))/86400)*86400-28800 )AND sh_user_cash.user_id=sh_user.id;"; //当日入金申请查询语句
MySQLDataAdapter mda = new MySQLDataAdapter(sql, conn);
DataSet ds = new DataSet();
mda.Fill(ds, "table1");
this.dataGridView1.DataSource = ds.Tables["table1"];
this.tabPage1.Controls.Add(this.dataGridView1);
conn.Close();

仅供参考