110,539
社区成员
发帖
与我相关
我的任务
分享
//查询方法
public static void conn()
{
MySqlConnection mySql = getCom.getMySqlCon();//连接字符串mysql
string sqlSearch = "SELECT * FROM `marketInfo` ";//SQL语句
MySqlCommand mySqlCommand = getCom.getSqlCommand(sqlSearch, mySql);//执行语句
mySql.Open();//打开数据库
getCom.getResultset(mySqlCommand);//操作查询语句
mySql.Close();//关闭数据库
}
//数据库查询
public static void getResultset(MySqlCommand mySqlCommand)
{
MySqlDataReader reader = mySqlCommand.ExecuteReader();
DataGridViewRow row = new DataGridViewRow();
Form1 fm = new Form1();
fm.dgv.RowHeadersWidth = 20;
int index = fm.dgv.Rows.Add(row);
fm.dgv.Rows.Clear();//第一次调用清除
try
{
while (reader.Read())
{
if (reader.HasRows)
{
int a=(reader.GetInt32(0));
string b=(reader.GetString(1));
int c=(reader.GetInt32(2));
int d=(reader.GetInt32(3));
Console.Write(a+"\t");
Console.Write(b+"\t");
Console.Write(c+"\t");
Console.Write(d+"\n");
fm.dgv.Rows[index].Cells[0].Value = 1;
fm.dgv.Rows[index].Cells[1].Value = b;
fm.dgv.Rows[index].Cells[2].Value = c;
fm.dgv.Rows[index].Cells[3].Value = d;
}
}
}
catch (Exception)
{
Console.WriteLine("查询失败");
}
finally
{
reader.Close();
}
}
//调用
private void button1_Click(object sender, EventArgs e)
{
MSQL.conn();
}