private void ure()
{
SqlConnection cnn = new SqlConnection(LiaoAn);
string sqlUre = "select id as 'No.',PotN as '图号',' ' as '占有百分比' from Procure where id=" + ladygaga + " or BnID=" + ladygaga + " order by BnID";
SqlDataAdapter datUre = new SqlDataAdapter(sqlUre, LiaoAn);
DataTable tabUre = new DataTable();
datUre.Fill(tabUre);
this.dgView.DataSource = tabUre;
dgView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
} private void ces()
{
SqlConnection cnn = new SqlConnection(LiaoAn);
string sqlCes = "select id as 'No.',PrCt as '图号',' ' as '占有百分比' from Proces where id=" + ladygaga + " or BeID=" + ladygaga + " order by BeID";
SqlDataAdapter datCes = new SqlDataAdapter(sqlCes, LiaoAn);
DataTable tabCes = new DataTable();
datCes.Fill(tabCes);
this.dgView.DataSource = tabCes;
dgView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
} private void mod()
{
SqlConnection cnn = new SqlConnection(LiaoAn);
string sqlMod = "select ID as 'No.',PrNb as '图号',' ' as '占有百分比' from Molded where id=" + ladygaga + " or BtID=" + ladygaga + " order by BtID";
SqlDataAdapter datMod = new SqlDataAdapter(sqlMod, LiaoAn);
DataTable table = new DataTable();
datMod.Fill(table);
this.dgView.DataSource = table;
dgView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
} private void ast()
{
SqlConnection cnn = new SqlConnection(LiaoAn);
string sql = "select id as 'No.',Prdu as '图号',' ' as '占有百分比' from plastic where id =" + ladygaga + " or BelongID =" + ladygaga + " order by BelongID";
SqlDataAdapter datAper = new SqlDataAdapter(sql,LiaoAn);
DataTable table = new DataTable();
datAper.Fill(table);
this.dgView.DataSource = table;
dgView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
}
//以上4种情况,3种情况都通过了
//mod()这个方法什么都不显示DataGridView内没有数据
能告诉我到底怎么了?
{
SqlConnection cnn = new SqlConnection(LiaoAn);
string sqlUre = "select id as 'No.',PotN as '图号',' ' as '占有百分比' from Procure where id=" + ladygaga + " or BnID=" + ladygaga + " order by BnID";
SqlDataAdapter datUre = new SqlDataAdapter(sqlUre, LiaoAn);
DataTable tabUre = new DataTable();
datUre.Fill(tabUre);
this.dgView.DataSource = tabUre;
dgView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
} private void ces()
{
SqlConnection cnn = new SqlConnection(LiaoAn);
string sqlCes = "select id as 'No.',PrCt as '图号',' ' as '占有百分比' from Proces where id=" + ladygaga + " or BeID=" + ladygaga + " order by BeID";
SqlDataAdapter datCes = new SqlDataAdapter(sqlCes, LiaoAn);
DataTable tabCes = new DataTable();
datCes.Fill(tabCes);
this.dgView.DataSource = tabCes;
dgView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
} private void mod()
{
SqlConnection cnn = new SqlConnection(LiaoAn);
string sqlMod = "select ID as 'No.',PrNb as '图号',' ' as '占有百分比' from Molded where id=" + ladygaga + " or BtID=" + ladygaga + " order by BtID";
SqlDataAdapter datMod = new SqlDataAdapter(sqlMod, LiaoAn);
DataTable table = new DataTable();
datMod.Fill(table);
this.dgView.DataSource = table;
dgView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
} private void ast()
{
SqlConnection cnn = new SqlConnection(LiaoAn);
string sql = "select id as 'No.',Prdu as '图号',' ' as '占有百分比' from plastic where id =" + ladygaga + " or BelongID =" + ladygaga + " order by BelongID";
SqlDataAdapter datAper = new SqlDataAdapter(sql,LiaoAn);
DataTable table = new DataTable();
datAper.Fill(table);
this.dgView.DataSource = table;
dgView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
}
//以上4种情况,3种情况都通过了
//mod()这个方法什么都不显示DataGridView内没有数据
能告诉我到底怎么了?
你在SqlDataAdapter datMod = new SqlDataAdapter(sqlMod, LiaoAn);打个断点把sql复制出来在sql server里面运行看一下,,看是否有数据,我确定没数据,其他的都一样,就sql不一样
那就是这里有问题啊,,你执行一下sql,