form1.cs

c#sql server数据库的简单操作

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)
        {

        }
    }
}