主题:DataGrid 未能从选定数据源自动生成任何列。
private void Button3_Click(object sender, System.EventArgs e)
{
dataSet211.Clear();
dataSet11.Clear();
DataGrid1.DataSource="";
//string month;
string date;
string year;
//month = dpMonth.SelectedItem.Text;
year=dpYear.SelectedItem.Text;
//date=month + "/01/" + year;
date=year;
sqlConnection1.Open();
//"SELECT FltNo, SUM(Fare) AS Fare FROM dtDepartedFlights WHERE (YEAR(DateOfJourney) = @date) GROUP BY FltNo");
SqlCommand myCommand = new SqlCommand("SELECT FltNo, SUM(Fare) AS Fare FROM dtDepartedFlights WHERE (YEAR(DateOfJourney) = "+ date + ") GROUP BY FltNo",sqlConnection1);
sqlDataAdapter1.SelectCommand = myCommand;
//SelectComand = new SqlCommand("SELECT FltNo, SUM(Fare) AS Fare FROM dtDepartedFlights WHERE (YEAR(DateOfJourney) = @date) GROUP BY FltNo");
//sqlDataAdapter1.SelectCommand.Parameters[0].Value=date;
sqlDataAdapter1.SelectCommand.ExecuteNonQuery();
DataView source = new DataView(dataSet11.Tables["Renvenue"]);
DataGrid1.DataSource=source;
DataGrid1.DataBind();
sqlConnection1.Close();
}
为什么会报错??
ID 为“DataGrid1”的 DataGrid 未能从选定数据源自动生成任何列。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.Web.HttpException: ID 为“DataGrid1”的 DataGrid 未能从选定数据源自动生成任何列。
{
dataSet211.Clear();
dataSet11.Clear();
DataGrid1.DataSource="";
//string month;
string date;
string year;
//month = dpMonth.SelectedItem.Text;
year=dpYear.SelectedItem.Text;
//date=month + "/01/" + year;
date=year;
sqlConnection1.Open();
//"SELECT FltNo, SUM(Fare) AS Fare FROM dtDepartedFlights WHERE (YEAR(DateOfJourney) = @date) GROUP BY FltNo");
SqlCommand myCommand = new SqlCommand("SELECT FltNo, SUM(Fare) AS Fare FROM dtDepartedFlights WHERE (YEAR(DateOfJourney) = "+ date + ") GROUP BY FltNo",sqlConnection1);
sqlDataAdapter1.SelectCommand = myCommand;
//SelectComand = new SqlCommand("SELECT FltNo, SUM(Fare) AS Fare FROM dtDepartedFlights WHERE (YEAR(DateOfJourney) = @date) GROUP BY FltNo");
//sqlDataAdapter1.SelectCommand.Parameters[0].Value=date;
sqlDataAdapter1.SelectCommand.ExecuteNonQuery();
DataView source = new DataView(dataSet11.Tables["Renvenue"]);
DataGrid1.DataSource=source;
DataGrid1.DataBind();
sqlConnection1.Close();
}
为什么会报错??
ID 为“DataGrid1”的 DataGrid 未能从选定数据源自动生成任何列。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.Web.HttpException: ID 为“DataGrid1”的 DataGrid 未能从选定数据源自动生成任何列。