kingzhexian的专栏

using System;using System.Data;namespace ProductManager{    static class DBTable    {        private static DataSet dataSet;        private static DataTable worker, provider, product, productBuy, pr

 using System.Data;using System.Data.SqlClient;try{    if (SqlConnection.State == ConnectionState.Closed)        SqlConnection.Open();    using (SqlBulkCopy bcp = new SqlBulkCopy(SqlConnection))   

namespace ImageSQL{    partial class FormImageSQL    {        private System.ComponentModel.IContainer components = null;        protected override void Dispose(bool disposing)        {            i

use mastergoif DB_ID(UserImage) is not null   drop database UserImagecreate database UserImagegouse UserImagegocreate table Images( Image_Name nvarchar(255) primary key, Image_Data Image not null)go

using System;using System.Runtime.InteropServices;using System.Threading;using System.Windows.Forms;using Microsoft.Win32;namespace ImageSQL{    static class Program    {        #region DllImportAtt

using System;using System.Data;using System.IO;using System.Text;using System.Windows.Forms;namespace WinFormExcel{    public partial class FormExcel : Form    {        private DataTable table;     

/*use mastergoif DB_ID(UserBase) is not null   drop database UserBasecreate database UserBasegouse UserBasegocreate table UserTable( UserID varchar(10) primary key, UserName nvarchar(20) not null)go

using System;using System.Data;using System.Linq;using System.Windows.Forms;using Excel = Microsoft.Office.Interop.Excel;namespace WinFormExcel{    static class ExtensionMethod    {

using System;using System.Data;using System.Drawing;using System.Globalization;using System.IO;using System.Linq;using System.Windows.Forms;using Excel = Microsoft.Office.Interop.Excel;

 using System.Data;using System.Data.OleDb;Microsoft Excel:OleDbConnectionStringBuilder builder = new OleDbConnectionStringBuilder();builder.Provider = "Microsoft.ACE.OLEDB.12.0"; // "Microsoft.Jet.

/*use mastergoif DB_ID(UserImage) is not null   drop database UserImagecreate database UserImagegouse UserImagegocreate table Images( Image_Name nvarchar(255) primary key, Image_Data Image not null)

 using System.Data;using System.Linq;#regionpublic string GetNewID(this DataView dataView, string letters){    dataView.RowFilter = null; // 清除该筛选器。    dataView.RowStateFilter = DataViewRowState.Cur

获取或设置表达式，用于筛选行、计算列中的值或创建聚合列。 命名空间： System.Data程序集： System.Data（在 System.Data.dll 中）属性值类型：System.String用来计算列的值，或创建聚合列的表达式。表达式的返回类型由列的 DataType 来确定。 异常异常条件ArgumentExc

using System.Windows.Forms;            System.Windows.Forms.ComboBox comboName = new System.Windows.Forms.ComboBox();            this.comboName.DropDownStyle = System.Windows.Forms.ComboBoxStyle.Dro

using System.Data;using System.Data.SqlClient;using System.Linq;绑定 ListControl 的数据源:try{    SqlCommand cmd = new SqlCommand("CommandText", SqlConnection);    cmd.CommandType = CommandType.StoredProc

 using System.Data;using System.Data.SqlClient;public DataView LoadData(){    try    {        using (SqlDataAdapter da = new SqlDataAdapter("select * from Provider", ClassConnection.Connection))    

using System;using System.Data.SqlClient;SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();builder.DataSource = Environment.MachineName;     // builder["server"]builder.InitialCa

using System;using System.Data.SqlClient;using System.ServiceProcess;using System.Windows.Forms;namespace ProductManager{    static class DBConnection    {        private static SqlConnection sql;  

 using System;using System.IO;using System.Linq;using System.Runtime.InteropServices;using System.ServiceProcess;using System.Windows.Forms;using Microsoft.Win32;namespace DIYBackupDB{    public par

using System;using System.Data;using System.Drawing;using System.Globalization;using System.IO;using System.Windows.Forms;using Excel = Microsoft.Office.Interop.Excel;// 添加引用 -> .NET ->