private void BindData() { var sql = $"SELECT Craft FROM PD_ProcCard_UPrice WHERE DeptId='{SqlHelper.DeptId}' ORDER BY ID"; var ds = SqlHelper.ExecuteDataset(SqlHelper.GetConnectionString("dzdj"), CommandType.Text, sql); cbxCraft.DataSource = ds.Tables[0]; cbxCraft.DisplayMember = "Craft"; cbxCraft.ValueMember = "Craft"; sql = "SELECT IDO '流水',iname '工序名称',qtime '时间起',ztime '时间止'," + "jilu '单价基数',jisu '计算折率',beizu '备注' FROM udodt ORDER BY iname , ztime "; ds = SqlHelper.ExecuteDataset(SqlHelper.GetConnection(), CommandType.Text, sql); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].Width = 60; dataGridView1.Columns[1].Width = 80; dataGridView1.Columns[2].Width = 80; dataGridView1.Columns[3].Width = 80; dataGridView1.Columns[4].Width = 80; dataGridView1.Columns[5].Width = 80; dataGridView1.Columns[6].Width = 200; dataGridView1.Sort(dataGridView1.Columns[0], System.ComponentModel.ListSortDirection.Ascending); }