private void btnProcess_Click(object sender, EventArgs e)
{
Bitmap p1 = (Bitmap)pictureBox1.Image;
int[,] r = new int[p1.Height, p1.Width];
int[,] g = new int[p1.Height, p1.Width];
int[,] b = new int[p1.Height, p1.Width];
for (int i = 0; i < p1.Height; i++)
{
for (int j = 0; j < p1.Width; j++)
{
r[i, j] = p1.GetPixel(j, i).R;
g[i, j] = p1.GetPixel(j, i).G;
b[i, j] = p1.GetPixel(j, i).B;
}
}
Bitmap p2 = new Bitmap(p1.Height,p1.Width);
for (int i = 0; i < p1.Height; i++)
{
for (int j = 0; j < p1.Width; j++)
{
p2.SetPixel(j,i,Color.FromArgb(r[i,j],g[i,j],b[i,j]));
}
}
pictureBox2.Image = p2;
}
private void btnGray_Click(object sender, EventArgs e)
{
try
{
Bitmap bm1 = (Bitmap)pictureBox1.Image;
Bitmap bm2 = bm1;
int w1 = pictureBox1.Image.Width;
int h1 = pictureBox1.Image.Width;
int x;
int y;
for (y = 0; y <= h1 - 1; y++)
{
for (x = 0; x <= w1 - 1; x++)
{
Color c1 = bm1.GetPixel(x, y);
int r1 = c1.R;
int g1 = c1.G;
int b1 = c1.B;
int avg1 = (r1 + g1 + b1) / 3;
bm2.SetPixel(x, y, Color.FromArgb(avg1, avg1, avg1));
}
}
pictureBox2.Image = bm2;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnProcess_Click(object sender, EventArgs e)
{
Bitmap p1 = (Bitmap)pictureBox1.Image;
Bitmap p2 = new Bitmap(p1.Height, p1.Width);
int avg;
for (int i = 0; i < p1.Height; i++)
{
for (int j = 0; j < p1.Width; j++)
{
avg = (p1.GetPixel(i,j).R + p1.GetPixel(i,j).G + p1.GetPixel(i,j).B)/3;
p2.SetPixel(i, j, Color.FromArgb(avg, avg, avg));
}
}
pictureBox2.Image = p2;
}
using MySql.Data.MySqlClient;
//...
//略
//...
//連接按鈕
private void connectBtn_Click(object sender, System.EventArgs e)
{
if (conn != null)
conn.Close();
//連接字串
string connStr = String.Format("server=localhost;user id=root; password=123456; database=addressbook; pooling=false");
try
{
conn = new MySqlConnection( connStr );
conn.Open();
//取得資料表
GetTable();
}
catch (MySqlException ex)
{
MessageBox.Show( "連接失敗：" + ex.Message );
}
}
//取得資料表
private void GetTable()
{
try
{
data = new DataTable();
//顯示好友名單資料表
da = new MySqlDataAdapter("SELECT * FROM friend" , conn);
cb = new MySqlCommandBuilder(da);
da.Fill(data);
//放到DataGrid顯示
dataGrid.DataSource = data;
}
catch (MySqlException ex)
{
MessageBox.Show("資料表顯示異常：" + ex.Message);
}
}
//更新按鈕
private void updateBtn_Click(object sender, System.EventArgs e)
{
DataTable changes = data.GetChanges();
da.Update( changes );
data.AcceptChanges();
}
Imports MySql.Data.MySqlClient
Public Class Form1
Dim conn As MySqlConnection
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connStr As String
connStr = String.Format("server=localhost;user id=root; password=123456; database=test; pooling=false")
Try
conn = New MySqlConnection(connStr)
conn.Open()
If conn.State = ConnectionState.Open Then
MessageBox.Show("資料庫連結成功")
End If
Catch ex As MySqlException
MessageBox.Show(ex.Message)
End Try
End Sub
End Class
