?? form1.cs
字號:
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)
{
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -