'Programming/C#'에 해당되는 글 7건

DataTable table = new DataTable("Customers"); 

table.Rows[0].Delete();

table.AcceptChanges();

DataTable workTable = new DataTable("Customers");


DataRow workRow = workTable.NewRow();

workRow["CustLName"] = "Smith";

workRow[1] = "Smith";

workTable.Rows.Add(workRow);


workTable.AcceptChanges(); 

        SQLiteConnection cn = new SQLiteConnection(Form1.dbQuery); 

        cn.Open();

        string SQL;

        SQL = "SELECT users_id, name, username, place FROM users";

        SQLiteCommand cmd = new SQLiteCommand(SQL, cn);

        SQLiteDataAdapter da = new SQLiteDataAdapter(cmd);

        DataSet ds = new DataSet();

        da.Fill(ds);

        DataTable dt = ds.Tables[0];

        this.grid_userlist.DataSource = dt;

        cn.Close(); 

void dataGridView1_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e)

        {

            if (e.Button == MouseButtons.Right)

            {

                DataGridView grid = sender as DataGridView;

                ContextMenuStrip menu = new ContextMenuStrip();

                menu.Items.Add("Task1", null, new EventHandler(Task1_Click));

                menu.Items.Add("Task2", null, new EventHandler(Task2_Click));

                Point pt = grid.PointToClient(Control.MousePosition);

                menu.Show(dataGridView1, pt.X, pt.Y);

            }

        }