public static DataSet GetSplitFieldDs(string strBidID,string strFieldID)
{
string strSQL="Select * from p_Sield where BigID=" + strBidID + " and FieldID=" + strFieldID + "";
return Class.DB.ExecuteStatementDs(strSQL);
}
上面是其中的sQL
private void txtFDataGrid_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
TableCell Stable=e.Item.Cells[1];
string strSdgDataList=Stable.Text;
strSdgDataList +=",";
Response.Write(strSdgDataList);
string [] split = strSdgDataList.Split("|".ToCharArray());
foreach (string classid1 in split)
{
//string clssids = strSdgDataList.Split(0); Response.Write(classid1+"<br>");
System.Data.DataSet dd=new DataSet();
dd=Class.AdminProduct.GetSmallFieldDs(this.txtBig.SelectedItem.Value,classid1);
if(dd.Tables[0].Rows.Count>0)
{
this.txtSfiel.Visible=true;
this.txtSfiel.DataSource=dd.Tables[0].DefaultView;
this.txtSfiel.DataBind();
for(int c=0;c<dd.Tables[0].Rows.Count;c++)
{
TextBox myText =new TextBox();
myText.ID=this.txtSfiel.Items[c].Cells[2].Text;
myText.Controls.Add(myText);
}
}
else
{
this.txtSfiel.Visible=false;
this.txtSfiel.DataSource="";
this.txtSfiel.DataBind();
}
}
{
string strSQL="Select * from p_Sield where BigID=" + strBidID + " and FieldID=" + strFieldID + "";
return Class.DB.ExecuteStatementDs(strSQL);
}
上面是其中的sQL
private void txtFDataGrid_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
TableCell Stable=e.Item.Cells[1];
string strSdgDataList=Stable.Text;
strSdgDataList +=",";
Response.Write(strSdgDataList);
string [] split = strSdgDataList.Split("|".ToCharArray());
foreach (string classid1 in split)
{
//string clssids = strSdgDataList.Split(0); Response.Write(classid1+"<br>");
System.Data.DataSet dd=new DataSet();
dd=Class.AdminProduct.GetSmallFieldDs(this.txtBig.SelectedItem.Value,classid1);
if(dd.Tables[0].Rows.Count>0)
{
this.txtSfiel.Visible=true;
this.txtSfiel.DataSource=dd.Tables[0].DefaultView;
this.txtSfiel.DataBind();
for(int c=0;c<dd.Tables[0].Rows.Count;c++)
{
TextBox myText =new TextBox();
myText.ID=this.txtSfiel.Items[c].Cells[2].Text;
myText.Controls.Add(myText);
}
}
else
{
this.txtSfiel.Visible=false;
this.txtSfiel.DataSource="";
this.txtSfiel.DataBind();
}
}
解决方案 »
- 注册 HTTP 处理程序
- 兄弟们 请问怎么禁用FF 的后退功能(转到上一页)
- asp.net困惑我已久的问题,能耐心回答的进
- 如何消除gridview的边框???
- 有人用listview做一个所有单元格都是编辑状态的在线编辑表格吗?
- 是这个Page.IsPostBack 属性 到底什么时候用到!举个简单的例子
- 怎么添加一个Null到数据库里面??
- VS2005发布网站到server2003上遇到的问题
- 如何用JAVASCRIPT客户端脚本设置页面上某一个表的某一行的背景图片?
- 高分请教(在线等候)!
- 存储过程在写入纪录的时候怎样将该条记录的主键的值取出
- 防盗链:如何页面实现跳转,又要能把音乐地址传给另一页
是不是这里 string strSQL="Select * from p_Sield where BigID=" + strBidID + " and FieldID=" + strFieldID + "";
报错
这里错了如何解决呢?
string strSQL="Select * from p_Sield where BigID='" + strBidID + "' and FieldID='" + strFieldID + "'";
将 varchar 值 '37,' 转换为数据类型为 int 的列时发生语法错误。