C#用datagirdview显示TEXT属性显示不出来
stringsql7="SELECTDISTINCTzt_file.pathname脚本路径,zt_file.title脚本编号,zt_case.title用例标题,zt...
string sql7 = "SELECT DISTINCT zt_file.pathname 脚本路径, zt_file.title 脚本编号,zt_case.title 用例标题,zt_casestep.expect 预期结果,zt_file.extension 文件类型 from zt_case,zt_file,zt_casestep where zt_case.id =" + myid + " and zt_file.objectID=" + myid + " AND zt_casestep.`case`=" + myid + "";
MySQLDataAdapter mda7 = new MySQLDataAdapter(sql7, conn);
DataSet ds7 = new DataSet();
mda7.Fill(ds7, "zt_testtable");
this.dataGridViewyongli.DataSource = ds7.Tables["zt_testtable"];
查询出来预期结果是TEXT属性在控件上显示出错有异常,改为vchar就正常了但是vchar太小了控件不够急!!!!!!!!!!!!!!! 展开
MySQLDataAdapter mda7 = new MySQLDataAdapter(sql7, conn);
DataSet ds7 = new DataSet();
mda7.Fill(ds7, "zt_testtable");
this.dataGridViewyongli.DataSource = ds7.Tables["zt_testtable"];
查询出来预期结果是TEXT属性在控件上显示出错有异常,改为vchar就正常了但是vchar太小了控件不够急!!!!!!!!!!!!!!! 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询