using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;

namespace SQLserver
{
    public partial class Form1 : Form
    {      
        SqlCeConnection conn = null;
        SqlCeCommand cmd;
        int M_nCount = 0;
        public Form1()
        {
            InitializeComponent();
            try
            {
                conn = new SqlCeConnection("Data Source =\\Program Files\\SQLserver\\MyDatabase#1.sdf; Password =''");
                conn.Open();

                cmd = conn.CreateCommand();
                cmd.CommandText = "INSERT INTO Customers ([Customer ID], [Company Name]) Values('NWIND', 'Northwind Traders')";

                M_nCount = cmd.ExecuteNonQuery();
            }
            finally
            {
                conn.Close();
            }
            string str = "";
            string[] str1 ={ "Name", "Age", "NO" };
            str = OrganiseItem(str1,3,3);
            listBox1.Items.Add(str);
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //string queryText = "SELECT * FROM Categories ORDER BY [Category ID]";
            //SqlCeCommand cmd = new SqlCeCommand(queryText);
            //獲取SQL語句
            cmd.CommandText = SQLtextBox.Text;
            cmd.Connection = conn;
            //執行SQL語句
            cmd.CommandType = CommandType.Text;
            cmd.UpdatedRowSource = UpdateRowSource.Both;


        }
        //編輯listbox中項
        public string  OrganiseItem(string []str,int nCount,int nCol)
        {
            int n = listBox1.Width;
            //計算每一字符串可供顯示的寬度
            int nLength = n / nCol;
            //得到每一個字符的寬度
            int m = (int)this.Font.Size;
            //計算出每一字符串最多能顯示的字符數
            int nCountCanShow = nLength / m;
            string strShow = "";
            //將要顯示的字符串連起來，每一個字符串之間用空格顯示
            for (int j = 0; j < nCount; j++)
            {
                string strTemp = "", strTab = "";
                //如果字符串長度超過能顯示的字符數截取規定的字符數顯示
                if (str[j].Length > nCountCanShow)
                {
                    for (int i = 0; i < nCountCanShow; i++)
                    {
                        strTemp += str[j][i];
                    }
                }
                else
                {
                    int nLeng = (nCountCanShow - str[j].Length);
                    for (int i = 0; i <= (nLeng + 1) * 2; i++)
                    {
                        strTab += " ";
                    }
                    strTemp = str[j] + strTab;
                }
                strShow += strTemp;
            }
            return(strShow);
        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private void bindingSource1_CurrentChanged(object sender, EventArgs e)
        {

        }
    }
}