示例#1
0
        public Form2()
        {
            InitializeComponent();
            table = new DataTable();
            table.Columns.Add(new DataColumn("epc", typeof(string)));
            table.Columns.Add(new DataColumn("time", typeof(string)));
            table.Columns.Add(new DataColumn("ant", typeof(string)));
            dataGridView1.DataSource = table;
            var headers = dataGridView1.Columns.Cast <DataGridViewColumn>();

            sb.AppendLine(string.Join(",", headers.Select(column => "\"" + column.HeaderText + "\"").ToArray()) + ",\"" + "point" + "\"");

            databasecmd = new ConnectDatabase();
        }
示例#2
0
        private bool validate_login(string user, string pass)
        {
            databasecmd = new ConnectDatabase();
            databasecmd.connectDB();
            databasecmd.cmd.CommandText = "Select username , password from login where username=@user and password=@pass";
            databasecmd.cmd.Parameters.AddWithValue("@user", user);
            databasecmd.cmd.Parameters.AddWithValue("@pass", pass);
            databasecmd.cmd.Connection = databasecmd.connection;
            MySqlDataReader login = databasecmd.cmd.ExecuteReader();

            if (login.Read())
            {
                databasecmd.connection.Close();
                return(true);
            }
            else
            {
                databasecmd.connection.Close();
                return(false);
            }
        }
示例#3
0
 public ConnectDatabase()
 {
     Instance    = this;
     _connection = new MySqlConnection(MyConnectionString);
     _cmd        = new MySqlCommand("", connection);
 }