string Sql = "";
int i;
int data;
for (i = Convert.ToInt32(tb_year_begin.Text.ToString().Trim()); i <= Convert.ToInt32(tb_year_finality.Text.ToString().Trim()); i++)
{
Sql = "select SUM(ProjectNianBao" + ProjectNianBaoTable.AfterSupportFinance + ")" + " from " + ProjectNianBaoTable.TableName + "where(ProjectNianBao." +
ProjectNianBaoTable.ProjectTime + "='" + i + "-1-1 0:00:00" + "')and(" + ProjectNianBaoTable.ProjectID + "like 'Aa*')";
DataTable dt = SQLHelp.DataBase1.GetDataTable(Sql,false, null, "details");
data+=Convert.ToInt32(dt.Rows[0][0].ToString());
}
TextBox3.Text =data.ToString();
初学,请高手们指教!
int i;
int data;
for (i = Convert.ToInt32(tb_year_begin.Text.ToString().Trim()); i <= Convert.ToInt32(tb_year_finality.Text.ToString().Trim()); i++)
{
Sql = "select SUM(ProjectNianBao" + ProjectNianBaoTable.AfterSupportFinance + ")" + " from " + ProjectNianBaoTable.TableName + "where(ProjectNianBao." +
ProjectNianBaoTable.ProjectTime + "='" + i + "-1-1 0:00:00" + "')and(" + ProjectNianBaoTable.ProjectID + "like 'Aa*')";
DataTable dt = SQLHelp.DataBase1.GetDataTable(Sql,false, null, "details");
data+=Convert.ToInt32(dt.Rows[0][0].ToString());
}
TextBox3.Text =data.ToString();
初学,请高手们指教!
建议这么编码:
Sql=string.Format("select sum('{0}') from {1} where {2}",字段名,表名,查询条件);
// {0},{1},{2} 是占位符,记得如果是字符串的话要加单引号引起来,例如”'{0}'“
你在好好检查一下你的 SQL 语句吧!