数据集中的数据保留但无法绑定数据 [英] Data hold in data set but could not bind data
本文介绍了数据集中的数据保留但无法绑定数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
con = new SqlConnection(conn);
con.Open();
DataSet ds = new DataSet();
// DataTable dt = new DataTable();
da = new SqlDataAdapter("SELECT cc.courseCATId ,cm.CourseName,cc.CourseCatName ,cc.CourseDur,cc.CourseFee FROM CourseCat cc INNER JOIN courseMaster cm ON cc.courseId =cm.courseId ORDER BY cc.courseId", con);
da.Fill(ds);
//MessageBox.Show(ds.Tables[0].Rows.Count.ToString() );
// dataGridView2.DataSource = null;
dataGridView2.AutoGenerateColumns = false;
dataGridView2.ColumnCount = 5;
dataGridView2.Columns[0].Name = "Course catID";
dataGridView2.Columns[0].HeaderText = "Category ID";
dataGridView2.Columns[0].DataPropertyName = "cc.courseCATId";
dataGridView2.Columns[1].Name = "Course Name";
dataGridView2.Columns[1].HeaderText = "Course Name";
dataGridView2.Columns[1].DataPropertyName = "cm.CourseName";
dataGridView2.Columns[2].Name = "Course cat Name";
dataGridView2.Columns[2].HeaderText = "Category Name";
dataGridView2.Columns[2].DataPropertyName = "cc.CourseCatName";
dataGridView2.Columns[3].Name = "Course Duration";
dataGridView2.Columns[3].HeaderText = "Course Duration";
dataGridView2.Columns[3].DataPropertyName = "cc.CourseDur";
dataGridView2.Columns[4].Name = "Course Fee";
dataGridView2.Columns[4].HeaderText = "Course Fee";
dataGridView2.Columns[4].DataPropertyName = "cc.CourseFee";
dataGridView2.DataSource = ds;
con.Close();
我尝试过:
What I have tried:
data hold in data set but could not bind data
推荐答案
删除所有cc。
,cm。
> DataPropertyName
remove the "cc.
", "cm.
" in all theDataPropertyName
dataGridView2.Columns[0].DataPropertyName = "cc.courseCATId";
更正:
correction:
dataGridView2.Columns[0].DataPropertyName = "courseCATId";
hi,
你应该使用
you should use
dataGridView1.DataSource = ds.Tables[0];
不仅仅是这里的ds。
这篇关于数据集中的数据保留但无法绑定数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文