brian0031的专栏

DataTable dtb2 = new DataTable();string[] m_list = new string[dtb2.Rows.Count];for (int i = 0; i {    m_list[i] = dtb2.Rows[i][0].

导入excel文件到datagridviewprivate DataSet ImportExcel(string filename, string sheet) //自定义函数{    DataSet ds = new DataSet();    using (OleDbConnection conn = new OleDbConnection("Provider=Microsof

combox绑定datatable数据源string _str2 = string.Empty;_str1 = string.Format("select distinct p_o, p_id from [QC_Angel] where Product='{0}' ",textBox1.Text.Trim());comboBox1.DataSource = _dt;comboBox

代码中输入dataGridView1.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing;dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.DisplayedCells;dataGridView1.AutoSi

DataTable dt = new DataTable();dt.Columns.Remove("p_o");

DataTable中手动调整列的顺序(列序,reorder,Rearrange)DataTable dt = new DataTable();dt.Columns("ColumnName").SetOrdinal(4) //将栏位顺序调到第4列

DataView可以帮我们直接获取Distinct数据DataTable dataTable;DataView dataView = dataTable.DefaultView;DataTable dataTableDistinct = dataView.ToTable(true,"FieldName1","FieldName2","...");//注：其中ToTable()的第一个参

DataTable dt = new DataTable();for (int i = dt.Rows.Count; i {    DataRow dr = dt.NewRow();    for (int j = 0; j     {        dr[dataGridView1.Columns[j].Name] = dataGridView1.Rows[i].Cell

DataTable不要导入重复项, 在datagridview中设定DataTable dt = new DataTable();dt.PrimaryKey = new DataColumn[] { dt.Columns["产品编号"], dt.Columns["号头"] };//产品编号,号头设置为"联合主键"，不要重复导入信息(重复信息)

方法一：(拷贝直接可以使用，适合大批量资料, 上万笔)Microsoft.Office.Interop.Excel.Application appexcel = new Microsoft.Office.Interop.Excel.Application();SaveFileDialog savefiledialog = new SaveFileDialog();System.Refl

DataTable dt1 = new DataTable();DataTable calcdt = new DataTable();//dt1只是获取表结构,无数据;//calcdt 有表结构,有数据原方法foreach (DataRow dr in

DataTable dt1 = new DataTable();DataTable calcdt = new DataTable();calcdt = SQL.command(calc).Tables[0];DataRow drcalc;foreach (Data

DataTable dt = new DataTable();int col = dt.Columns.Count;string[,] array = new string[dt.Rows.Count,col];for (int i = 0; i {    f

DataTable dt = new DataTable();int col = dt.Columns.Count;string[,] array = new string[dt.Rows.Count,col];for (int i = 0; i {    f

DataTable dt1 = new DataTable();DataTable frm = new DataTable();foreach (DataRow dr in dt1.Rows){    frm.ImportRow(dr);}dataGridView1.DataSo

DataTable dtsve = new DataTable();private void toolStripButton6_Click(object sender, EventArgs e) //保存{    if (dataGridView1.Rows.Count > 0)

自定义类中使用DataTableusing System.Data;public DataTable dt;