Пример #1
0
        //查询全表并绑定在datatable中
        public static DataTable datatable(string selectStr)
        {
            con.Close();
            con.Open();
            MySqlCommand command = new MySqlCommand(selectStr, con);

            MySqlDataAdapter adapter   = new MySqlDataAdapter(selectStr, Connectionsql.ConnectStr());
            DataTable        dataTable = new DataTable();

            adapter.Fill(dataTable);

            con.Close();
            return(dataTable);
        }
Пример #2
0
        //查询表中新添加的数据
        public static DataTable selectnew(string selectStr)
        {
            con.Close();
            con.Open();
            MySqlCommand command = new MySqlCommand(selectStr, con);

            command.ExecuteNonQuery();
            DataSet          dataSet = new DataSet();
            MySqlDataAdapter adapter = new MySqlDataAdapter(selectStr, Connectionsql.ConnectStr());

            adapter.SelectCommand = command;
            adapter.Fill(dataSet);
            DataTable data = dataSet.Tables[0];

            con.Close();
            return(data);
        }