说明:
页面在框架中右下侧
程序是一个datagird,从表中显示数据
运行正常
后想增加查询功能,增加了textbox,button,
想用户点击button后,根据textbox中的内容,
重新刷新datagrid,但点击button后,出现
“无法显示页面”的错误。
在其他叶面不会出现这种情况
页面在框架中右下侧
程序是一个datagird,从表中显示数据
运行正常
后想增加查询功能,增加了textbox,button,
想用户点击button后,根据textbox中的内容,
重新刷新datagrid,但点击button后,出现
“无法显示页面”的错误。
在其他叶面不会出现这种情况
解决方案 »
- 怎么让JS中的 数字 1和 1px相加?
- 向前台div层中动态添加多个图片
- TextBox失去焦点后ListBox得到Textbox的value怎么做
- 在 ajax中 会出现什么原因,让ajax请求失败???
- 08r2系统安装角色服务(asp.net)以及.net扩展性需要重启么?
- .NET 自定义404错误页面
- asp.net中内容页后台如何调用母版页前台js方法
- 域用户验证问题
- 如何按指定的格式返回时间字符串
- 迫切需要解决的一个问题,希望高手进来看一看!
- 请问,怎样在插入数据库一条信息的同时又可以得到这条信息在数据的id值呢
- redirect为什么没有target属性。有什么办法只在Server端中实现这种功能?
cs文件using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient; namespace bjhgfx
{
/// <summary>
/// ShowComp 的摘要说明。
/// </summary>
public class ShowComp : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.HtmlControls.HtmlForm Form1;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Button BtnQuery;
protected System.Web.UI.WebControls.TextBox TxtCompCode;
string connString="server=GI-037ED4B9D0;database=bjhg;uid=sa;pwd=12345678";
string strW="";
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if((Session["UserName"]==null)||(Session["UserName"].ToString()==""))Response.Redirect("login.aspx") ;
else
{
string userName=Session["UserName"].ToString();
string UserInfo=GetUserInfo(userName,"1");
if (UserInfo!="F")Response.Redirect("error.aspx") ;
//if(!IsPostBack)BindShow("");
BindShow(strW);
}
}
/// <summary>
/// 返回用户信息
/// </summary>
/// <param name="userNo"> </param>
/// <param name="strType">1 返回所在科室,2 返回用户等级 </param>
/// <returns></returns>
private string GetUserInfo(string userNo,string strType)
{
string strSql = "";
string strVar="";
strSql="select * from T_user where username='"+userNo +"'";
SqlConnection conn=new SqlConnection(connString);
SqlCommand cmd=new SqlCommand(strSql,conn);
conn.Open();
SqlDataReader dr=cmd.ExecuteReader();
while(dr.Read())
{
if (strType=="1")strVar=dr["office"].ToString();
if (strType=="2")strVar=dr["Headship"].ToString();
}
dr.Close();
conn.Close();
return strVar;
}
public void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
string showStr="风险要素说明:";
Label1.Text =showStr;
showStr="";
e.Item.Cells[0].ToolTip ="查看企业基本资料";
e.Item.Cells[2].ToolTip =showStr;
e.Item.Cells[4].ToolTip ="查看企业稽核纪录";
e.Item.Cells[5].ToolTip ="制发风险作业指令";
} /// <summary>
/// 对下拉框绑定
/// </summary>
private void BindShow(string strWhere)
{
//string strSql = "select a.*,b.CheckNumber from T_RiskComp a LEFT OUTER JOIN VIEW_CheckNumber b on a.compcode=b.compcode order by len(RiskItems) desc";
string strSql = "SELECT e.compcode, e.compname, e.riskitems, e.noticecode, e.checknumber, e.cfxz + ' ' + e.trust_class as fxck ";
strSql+=" FROM (SELECT d .compcode, d .compname, d .riskitems, d .noticecode, d .checknumber, cfxz = CASE d .cfxz WHEN '2' THEN '厂房' ELSE '' END, TRUST_CLASS = CASE d .TRUST_CLASS WHEN '低级' THEN '低' ELSE '' END ";
strSql+=" FROM (SELECT TOP 5000 a.CompCode, a.CompName, a.RiskItems, a.Noticecode, b.checknumber, c.cfxz AS cfxz, c.TRUST_CLASS AS trust_class ";
strSql+=" FROM T_RiskComp a LEFT OUTER JOIN VIEW_CheckNumber b ON a.CompCode = b.CompCode LEFT OUTER JOIN jbxx c ON a.CompCode = c.qybh ORDER BY LEN(a.RiskItems) DESC) AS d) AS e ";
strSql+=strWhere;
SqlConnection conn=new SqlConnection(connString);
SqlDataAdapter da=new SqlDataAdapter(strSql,conn);
DataSet ds= new DataSet();
da.Fill(ds,"T_RiskList");
DataView dv=ds.Tables["T_RiskList"].DefaultView;
DataGrid1.DataSource =dv;
DataGrid1.DataBind();
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.BtnQuery.Click += new System.EventHandler(this.BtnQuery_Click);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion
private void BtnQuery_Click(object sender, System.EventArgs e)
{
}
}
}
<%@ Page language="c#" Codebehind="ShowComp.aspx.cs" AutoEventWireup="false" Inherits="bjhgfx.ShowComp" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>ShowComp</title>
<meta content="Microsoft FrontPage 4.0" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
<style type="text/css">A:link { COLOR: #00ff00; TEXT-DECORATION: none }
A:hover { COLOR: #666666 }
A:visited { COLOR: #00ff00; TEXT-DECORATION: none }
</style>
<script language="javascript">
var IsShow=false;
var IsScroll=true;;
function ChangeScroll()
{
if (!IsScroll)
{
IsScroll=true;
ShowCompData.scrollDelay=200;
}
else
{
IsScroll=false;
ShowCompData.scrollDelay=10000000000000;
}
}
function ChangeDown()
{
var radioD=document.getElementById("radioDown");
var radioU=document.getElementById ("radioUp");
radioD.checked=true;
radioU.checked =false;
IsScroll=true;
ShowCompData.scrollDelay=200;
ShowCompData.direction ="down";
}
function ChangeUp()
{
var radioD=document.getElementById ("radioDown");
var radioU=document.getElementById ("radioUp");
radioD.checked=false;
radioU.checked =true;
IsScroll=true;
ShowCompData.scrollDelay=200;
ShowCompData.direction ="up";
}
function ShowMsg()
{
var btnM=document.getElementById("btnMsg");
if(IsShow)
{
showMsg.style.display ="none";
IsShow=false;
btnM.value="显示";
}
else
{
showMsg.style.display ="";
IsShow=true;
btnM.value="隐藏";
}
}
</script>
<body text="#00ff00" bgColor="white" MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server" >
<TABLE borderColor="#3300ff" height="357" cellSpacing="0" cellPadding="0" rules="none"
width="784" align="center" bgColor="#333300" border="1">
<TBODY>
<TR>
<TD style="HEIGHT: 52px" width="779" bgColor="#799ae1" height="52">
<P style="FONT-WEIGHT: bold; COLOR: #000000" align="center"><FONT color="#ffffff" size="5">
企业显示</FONT></P>
</TD>
</TR>
<TR>
<TD style="HEIGHT: 20px" width="779" bgColor="#799ae1" height="25">
<table id="table1" style="WIDTH: 800px; HEIGHT: 38px" cellSpacing="1" cellPadding="0" width="100%"
border="0">
<tr>
<td width="12%">
<p align="left"><font color="#ffffff">编码</font></p>
</td>
<td width="36%"><font color="#ffffff">名称</font></td>
<td width="20%"><font color="#ffffff">要素</font></td>
<td width="13%"><font color="#ffffff">参考</font></td>
<td width="9%"><font color="#ffffff">纪录</font></td>
<td width="10%"><font color="#ffffff">指令</font></td>
</tr>
</table>
</TD>
</TR>
<TR>
<TD width="779" height="387" style="HEIGHT: 387px">
<p align="center">
<MARQUEE id="ShowCompData" ondblclick="ChangeScroll();" style="WIDTH: 802px; HEIGHT: 386px"
scrollDelay="200" direction="up" bgColor="#000000"><asp:datagrid id="DataGrid1" runat="server" OnItemDataBound="DataGrid1_ItemDataBound" AutoGenerateColumns="False"
Width="100%">
<Columns>
<asp:HyperLinkColumn DataNavigateUrlField="CompCode" DataNavigateUrlFormatString="javascript:window.showModalDialog('CompDetail.aspx?CompCode={0}','数据查看','dialogHeight: 700px; dialogWidth: 800px; dialogTop: 100px; dialogLeft: 100px; center: no; help: no'); "
DataTextField="CompCode">
<HeaderStyle ForeColor="#FFCC33" Width="12%"></HeaderStyle>
<ItemStyle Width="12%"></ItemStyle>
</asp:HyperLinkColumn>
<asp:BoundColumn DataField="CompName">
<HeaderStyle ForeColor="#FFCC33" Width="36%"></HeaderStyle>
</asp:BoundColumn>
<asp:HyperLinkColumn DataNavigateUrlField="CompCode" DataNavigateUrlFormatString="javascript:window.showModalDialog('Showall.aspx?CompCode={0}','数据查看','dialogHeight: 600px; dialogWidth: 700px; dialogTop: 100px; dialogLeft: 100px; center: no; help: no'); "
DataTextField="RiskItems">
<HeaderStyle ForeColor="#FFCC33" Width="20%"></HeaderStyle>
</asp:HyperLinkColumn>
<asp:HyperLinkColumn DataNavigateUrlField="fxck" DataTextField="fxck" DataNavigateUrlFormatString="#">
<HeaderStyle ForeColor="#FFFFFF" Width="13%"></HeaderStyle>
</asp:HyperLinkColumn>
<asp:HyperLinkColumn DataNavigateUrlField="CompCode" DataTextField="CheckNumber" DataNavigateUrlFormatString="javascript:window.showModalDialog('ShowCheck.aspx?CompCode={0}','数据查看','dialogHeight: 700px; dialogWidth: 900px; dialogTop: 100px; dialogLeft: 100px; center: no; help: no'); ">
<HeaderStyle ForeColor="#FFFFFF" Width="9%"></HeaderStyle>
</asp:HyperLinkColumn>
<asp:HyperLinkColumn Text="制发指令" DataNavigateUrlField="CompCode" DataNavigateUrlFormatString="javascript:window.showModalDialog('CollectInfo.aspx?Mode=ZZFX&CompCode={0}','数据查看','dialogHeight: 700px; dialogWidth: 900px; dialogTop: 100px; dialogLeft: 100px; center: no; help: no'); ">
<HeaderStyle ForeColor="#33CCFF" Width="10%"></HeaderStyle>
</asp:HyperLinkColumn>
</Columns>
</asp:datagrid></MARQUEE>
</p>
</TD>
</TR>
<TR>
<TD style="HEIGHT: 20px" width="779" bgColor="#799ae1" height="25">
<table id="table1" style="WIDTH: 727px; HEIGHT: 20px" cellSpacing="1" cellPadding="0" width="727"
border="0">
<tr>
<td width="426" style="WIDTH: 426px">
<p align="left"><font color="#ffffff">双击鼠标开始/停止滚动屏幕</font></p>
</td>
<td width="63" style="WIDTH: 63px"><font color="#ffffff"><INPUT type="radio" name="radioDown" id="radioDown" onclick="ChangeDown();">向下</font></td>
<td width="57" style="WIDTH: 57px"><font color="#ffffff"><INPUT type="radio" name="radioUp" id="radioUp" onclick="ChangeUp();">向上</font></td>
<td width="10%"><FONT color="#ffffff"></FONT></td>
</tr>
</table>
</TD>
</TR>
<TR>
<TD width="779" bgColor="#799ae1" height="28">
<asp:Label id="Label2" runat="server" ForeColor="White">请输入企业编码</asp:Label>
<asp:TextBox id="TxtCompCode" runat="server"></asp:TextBox>
<asp:Button id="BtnQuery" runat="server" Width="56px" Text="查询"></asp:Button> <INPUT type="button" id="btnMsg" value="显示" onclick="ShowMsg();">
<div id="showMsg" style="DISPLAY:none">
<asp:Label id="Label1" runat="server" Width="720px" ForeColor="White" Font-Size="Smaller"></asp:Label>
</div>
</TD>
</TR>
</TBODY>
</TABLE>
</form>
</body>
</HTML>
<%@ Page language="c#" Codebehind="ShowComp.aspx.cs" AutoEventWireup="false" Inherits="bjhgfx.ShowComp" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>ShowComp</title>
<meta content="Microsoft FrontPage 4.0" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
<script language="javascript">
var IsShow=false;
var IsScroll=true;;
function ChangeScroll()
{
if (!IsScroll)
{
IsScroll=true;
ShowCompData.scrollDelay=200;
}
else
{
IsScroll=false;
ShowCompData.scrollDelay=10000000000000;
}
}
function ChangeDown()
{
var radioD=document.getElementById("radioDown");
var radioU=document.getElementById ("radioUp");
radioD.checked=true;
radioU.checked =false;
IsScroll=true;
ShowCompData.scrollDelay=200;
ShowCompData.direction ="down";
}
function ChangeUp()
{
var radioD=document.getElementById ("radioDown");
var radioU=document.getElementById ("radioUp");
radioD.checked=false;
radioU.checked =true;
IsScroll=true;
ShowCompData.scrollDelay=200;
ShowCompData.direction ="up";
}
function ShowMsg()
{
var btnM=document.getElementById("btnMsg");
if(IsShow)
{
showMsg.style.display ="none";
IsShow=false;
btnM.value="显示";
} 2
else
{
showMsg.style.display ="";
IsShow=true;
btnM.value="隐藏";
}
}
</script>
</HEAD>
<body text="#00ff00" bgColor="white" MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server" >
<TABLE borderColor="#3300ff" height="357" cellSpacing="0" cellPadding="0" rules="none" width="784" align="center" bgColor="#333300" border="1">
<TBODY>
<TR>
<TD style="HEIGHT: 52px" width="779" bgColor="#799ae1" height="52">
<P style="FONT-WEIGHT: bold; COLOR: #000000" align="center"><FONT color="#ffffff" size="5">企业显示</FONT></P>
</TD>
</TR>
<TR>
<TD style="HEIGHT: 20px" width="779" bgColor="#799ae1" height="25">
<table id="table1" style="WIDTH: 800px; HEIGHT: 38px" cellSpacing="1" cellPadding="0" width="100%" border="0">
<tr>
<td width="12%">
<p align="left"><font color="#ffffff">编码 </font></p>
</td>
<td width="36%"><font color="#ffffff">名称 </font></td>
<td width="20%"><font color="#ffffff">要素 </font></td>
<td width="13%"><font color="#ffffff">参考 </font></td>
<td width="9%"><font color="#ffffff">纪录</font></td>
<td width="10%"><font color="#ffffff">指令</font></td>
</tr>
</table>
</TD>
</TR>
<TR>
<TD width="779" height="387" style="HEIGHT: 387px">
<p align="center">
<MARQUEE id="ShowCompData" ondblclick="ChangeScroll();" style="WIDTH: 802px; HEIGHT: 386px" scrollDelay="200" direction="up" bgColor="#000000"><asp:datagrid id="DataGrid1" runat="server" OnItemDataBound="DataGrid1_ItemDataBound" AutoGenerateColumns="False" Width="100%">
<Columns>
<asp:HyperLinkColumn DataNavigateUrlField="CompCode" DataNavigateUrlFormatString="javascript:window.showModalDialog('CompDetail.aspx?CompCode={0}','数据查看','dialogHeight: 700px; dialogWidth: 800px; dialogTop: 100px; dialogLeft: 100px; center: no; help: no'); " DataTextField="CompCode">
<HeaderStyle ForeColor="#FFCC33" Width="12%"></HeaderStyle>
<ItemStyle Width="12%"></ItemStyle>
</asp:HyperLinkColumn>
<asp:BoundColumn DataField="CompName">
<HeaderStyle ForeColor="#FFCC33" Width="36%"></HeaderStyle>
</asp:BoundColumn>
<asp:HyperLinkColumn DataNavigateUrlField="CompCode" DataNavigateUrlFormatString="javascript:window.showModalDialog('Showall.aspx?CompCode={0}',' 数据查看','dialogHeight: 600px; dialogWidth: 700px; dialogTop: 100px; dialogLeft: 100px; center: no; help: no'); " DataTextField="RiskItems">
<HeaderStyle ForeColor="#FFCC33" Width="20%"></HeaderStyle>
</asp:HyperLinkColumn>
<asp:HyperLinkColumn DataNavigateUrlField="fxck" DataTextField="fxck" DataNavigateUrlFormatString="#">
<HeaderStyle ForeColor="#FFFFFF" Width="13%"></HeaderStyle>
</asp:HyperLinkColumn>
<asp:HyperLinkColumn DataNavigateUrlField="CompCode" DataTextField="CheckNumber" DataNavigateUrlFormatString="javascript:window.showModalDialog('ShowCheck.aspx?CompCode={0}','数据查看','dialogHeight: 700px; dialogWidth: 900px; dialogTop: 100px; dialogLeft: 100px; center: no; help: no'); ">
<HeaderStyle ForeColor="#FFFFFF" Width="9%"></HeaderStyle>
</asp:HyperLinkColumn>
<asp:HyperLinkColumn Text="制发指令" DataNavigateUrlField="CompCode" DataNavigateUrlFormatString="javascript:window.showModalDialog('CollectInfo.aspx?Mode=ZZFX&CompCode={0}','数据查看','dialogHeight: 700px; dialogWidth: 900px; dialogTop: 100px; dialogLeft: 100px; center: no; help: no'); ">
<HeaderStyle ForeColor="#33CCFF" Width="10%"></HeaderStyle>
</asp:HyperLinkColumn>
</Columns>
</asp:datagrid></MARQUEE>
</p>
</TD>
</TR>
<TR>
<TD style="HEIGHT: 20px" width="779" bgColor="#799ae1" height="25">
<table id="table1" style="WIDTH: 727px; HEIGHT: 20px" cellSpacing="1" cellPadding="0" width="727" border="0">
<tr>
<td width="426" style="WIDTH: 426px">
<p align="left"><font color="#ffffff">双击鼠标开始/停止滚动屏幕</font></p>
</td>
<td width="63" style="WIDTH: 63px"><font color="#ffffff"><INPUT type="radio" name="radioDown" id="radioDown" onclick="ChangeDown();">向下</font></td>
<td width="57" style="WIDTH: 57px"><font color="#ffffff"><INPUT type="radio" name="radioUp" id="radioUp" onclick="ChangeUp();">向上</font></td>
<td width="10%"><FONT color="#ffffff"></FONT></td>
</tr>
</table>
</TD>
</TR>
<TR>
<TD width="779" bgColor="#799ae1" height="28">
<asp:Label id="Label2" runat="server" ForeColor="White">请输入企业编码 </asp:Label>
<asp:TextBox id="TxtCompCode" runat="server"></asp:TextBox>
<asp:Button id="BtnQuery" runat="server" Width="56px" Text="查询"></asp:Button>
<INPUT type="button" id="btnMsg" value="显示" onclick="ShowMsg();">
<div id="showMsg" style="DISPLAY:none">
<asp:Label id="Label1" runat="server" Width="720px" ForeColor="White" Font-Size="Smaller"></asp:Label>
</div>
</TD>
</TR>
</TBODY>
</TABLE>
</form>
</body>
</HTML>
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient; namespace bjhgfx
{
/// <summary>
/// ShowComp 的摘要说明。
/// </summary>
public class ShowComp : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.HtmlControls.HtmlForm Form1;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Button BtnQuery;
protected System.Web.UI.WebControls.TextBox TxtCompCode;
string connString="server=GI-037ED4B9D0;database=bjhg;uid=sa;pwd=12345678";
string strW="";
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if((Session["UserName"]==null)||(Session["UserName"].ToString()==""))Response.Redirect("login.aspx") ;
else
{
string userName=Session["UserName"].ToString();
string UserInfo=GetUserInfo(userName,"1");
if (UserInfo!="F")Response.Redirect("error.aspx") ;
//if(!IsPostBack)BindShow("");
BindShow(strW);
}
}
/// <summary>
/// 返回用户信息
/// </summary>
/// <param name="userNo"> </param>
/// <param name="strType">1 返回所在科室,2 返回用户等级 </param>
/// <returns></returns>
private string GetUserInfo(string userNo,string strType)
{
string strSql = "";
string strVar="";
strSql="select * from T_user where username='"+userNo +"'";
SqlConnection conn=new SqlConnection(connString);
SqlCommand cmd=new SqlCommand(strSql,conn);
conn.Open();
SqlDataReader dr=cmd.ExecuteReader();
while(dr.Read())
{
if (strType=="1")strVar=dr["office"].ToString();
if (strType=="2")strVar=dr["Headship"].ToString();
}
dr.Close();
conn.Close();
return strVar;
}
public void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
string showStr="说明:";
Label1.Text =showStr;
showStr="";
e.Item.Cells[0].ToolTip ="查看资料";
e.Item.Cells[2].ToolTip =showStr;
e.Item.Cells[4].ToolTip ="查看纪录";
e.Item.Cells[5].ToolTip ="制发指令";
} /// <summary>
///
/// </summary>
private void BindShow(string strWhere)
{
string strSql = "SELECT e.compcode, e.compname, e.riskitems, e.noticecode, e.checknumber, e.cfxz + ' ' + e.trust_class as fxck ";
strSql+=" FROM (SELECT d .compcode, d .compname, d .riskitems, d .noticecode, d .checknumber, cfxz = CASE d .cfxz WHEN '2' THEN '厂房' ELSE '' END, TRUST_CLASS = CASE d .TRUST_CLASS WHEN '低级' THEN '低' ELSE '' END ";
strSql+=" FROM (SELECT TOP 5000 a.CompCode, a.CompName, a.RiskItems, a.Noticecode, b.checknumber, c.cfxz AS cfxz, c.TRUST_CLASS AS trust_class ";
strSql+=" FROM T_RiskComp a LEFT OUTER JOIN VIEW_CheckNumber b ON a.CompCode = b.CompCode LEFT OUTER JOIN jbxx c ON a.CompCode = c.qybh ORDER BY LEN(a.RiskItems) DESC) AS d) AS e ";
strSql+=strWhere;
SqlConnection conn=new SqlConnection(connString);
SqlDataAdapter da=new SqlDataAdapter(strSql,conn);
DataSet ds= new DataSet();
da.Fill(ds,"T_RiskList");
DataView dv=ds.Tables["T_RiskList"].DefaultView;
DataGrid1.DataSource =dv;
DataGrid1.DataBind();
} private void BtnQuery_Click(object sender, System.EventArgs e)
{
}
}
}
用Datagrid1显示表T_RiskComp 的内容,Sql语句比较复杂,join 和嵌套都有,语句是正确的
通过录入编码,点击按扭,更新Datagrid1问题是:我在pageload 绑定Datagrid1 BindShow()
再提交就会出现这个错,
但pageload 不绑定Datagrid1
就不会出错!
但没有反应