jingzhe__的博客

private void Form3_Load(object sender, EventArgs e){//为DataGridView动态添加下拉列表DataGridViewComboBoxColumn dgvc = new DataGridViewComboBoxColumn();dgvc.Items.Add(“第一项”);dgvc.Items.Add(“第二项”);dgvc.Ite...

private string MySqlCon = “server=127.0.0.1;user id=root;password=root;database=data”; MySqlCommand cmd; MySqlConnection con; MySqlDataAdapter msda; public MySQLConn() { c...

[//导出Excelprivate void Export(DataSet ds){System.Data.DataTable DT = ds.Tables[0];string exportExcelPath = textBox4.Text + “\” + textBox2.Text.Substring(textBox2.Text.LastIndexOf(’\’) + 1); ...

生成EXCEL文件是经常需要用到的功能，我们利用一些开源库可以很容易实现这个功能。方法一：利用excellibrary，http://code.google.com/p/excellibrary/excellibrary是国人写的开源组件，很容易使用，可惜貌似还不支持.xlsx(Excel 2007)，例子如下：123456789101112131415161...

//创建一个workbook实例Workbook wb = new Workbook();//清除默认的工作表wb.Worksheets.Clear();//添加一个工作表并指定表名Worksheet sheet = wb.Worksheets.Add(“职员表”);//横向合并A1到G1的单元格sheet.Range[“A1:G1”].Merge();//写入数据到A1单元格，设...

private void button5_Click(object sender, EventArgs e){FolderBrowserDialog dilog = new FolderBrowserDialog();dilog.Description = “请选择文件夹”;if (dilog.ShowDialog() == DialogResult.OK || dilog.ShowDia...

//获取private void button3_Click(object sender, EventArgs e){OpenFileDialog dialog = new OpenFileDialog();dialog.Filter = “数据文件(.mdb)|.mdb”;if (dialog.ShowDialog() == DialogResult.OK){textBox1.Te...

string str = fi.FullName.Replace("\", “\\”);text = text.Replace("’", “”).Replace(""", “”).Replace(" “, “”).Replace(”,", “”).Replace("\t", “”).Replace("\r", “”).Replace("\n", “”).Replace("\s", “”);st...