/// <summary>
/// 获取group2字符串
/// </summary>
/// <param name="axVSFlexGrid1"></param>
/// <param name="strSQL"></param>
/// <param name="Connstr"></param>
public void ExecuteSQL_group2(string result_group0, string result_group1,string sql_group2, string sql_group3, string Connstr, AxVSFlex8.AxVSFlexGrid axVSFlexGrid1)
{ SqlConnection Sqlconnect = new SqlConnection(Connstr);
try
{
Sqlconnect.Open();
SqlCommand cmd = new SqlCommand(sql_group2, Sqlconnect);//传送SQL语句及SqlConnection对象
SqlDataReader myReader = cmd.ExecuteReader();//返回查询的结果集
while (myReader.Read())
{
ExecuteSQL_group3(result_group0, result_group1, myReader[0].ToString(),sql_group3, Connstr, axVSFlexGrid1);
}
myReader.Close();
}
catch
{
Sqlconnect.Close();
}
finally
{
Sqlconnect.Close();
}
}
sql_group2:长度为7000多,报错是:长度不能超过128。
我应该怎么办?
/// 获取group2字符串
/// </summary>
/// <param name="axVSFlexGrid1"></param>
/// <param name="strSQL"></param>
/// <param name="Connstr"></param>
public void ExecuteSQL_group2(string result_group0, string result_group1,string sql_group2, string sql_group3, string Connstr, AxVSFlex8.AxVSFlexGrid axVSFlexGrid1)
{ SqlConnection Sqlconnect = new SqlConnection(Connstr);
try
{
Sqlconnect.Open();
SqlCommand cmd = new SqlCommand(sql_group2, Sqlconnect);//传送SQL语句及SqlConnection对象
SqlDataReader myReader = cmd.ExecuteReader();//返回查询的结果集
while (myReader.Read())
{
ExecuteSQL_group3(result_group0, result_group1, myReader[0].ToString(),sql_group3, Connstr, axVSFlexGrid1);
}
myReader.Close();
}
catch
{
Sqlconnect.Close();
}
finally
{
Sqlconnect.Close();
}
}
sql_group2:长度为7000多,报错是:长度不能超过128。
我应该怎么办?
@input varchar(max)