数据集中的数据保留但无法绑定数据 [英] 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 the DataPropertyName

dataGridView2.Columns[0].DataPropertyName = "cc.courseCATId";

更正：

correction:

dataGridView2.Columns[0].DataPropertyName = "courseCATId";

hi，



你应该使用

you should use

dataGridView1.DataSource = ds.Tables[0];

不仅仅是这里的ds。

这篇关于数据集中的数据保留但无法绑定数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！