显示代码如下:
sqlDataAdapter1.SelectCommand.Parameters["@classid"].Value=Request.QueryString["classid"];
sqlDataAdapter1.Fill(webnadata1);
DataList1.DataBind();以前是可以显示的,后来不知怎么回事现在调试就不能显示数据了,我的sqlDataAdapter1的数据预览功能正常,classid传递也正常,请把那忙解决
sqlDataAdapter1.SelectCommand.Parameters["@classid"].Value=Request.QueryString["classid"];
sqlDataAdapter1.Fill(webnadata1);
DataList1.DataBind();以前是可以显示的,后来不知怎么回事现在调试就不能显示数据了,我的sqlDataAdapter1的数据预览功能正常,classid传递也正常,请把那忙解决
解决方案 »
- 网页上那种下拉框的智能感应是怎么弄的,就是输入拼音,下拉框下面可以显示以这个拼音打头选项?
- 上網找東西發現轉貼的現象很嚴重.無聊,故來散散分
- 请教:关于负载均衡时,如何将文件上传到固定服务器的问题?
- 关于Assembly.Load(string)问题,急!!helpMe
- 新手求助,连接SQL,怎么使用DataSet???
- ASP.NET Sql数据库访问类(转)
- 网龙(中国)公司-福州招聘c#的B/S开发程序员,哦!!!!!!
- 有人用过IwebOffice这个组件吗?
- 来看看这些
- 如何为页面内插入的用户自定义控制项动态(插入的.ascx文件)的设置参数值?
- Word表格中:合并单元格问题
- 如何在asp.net中使用<%#myvar%>?
sqlDataAdapter1.Fill(webnadata1);
DataList1.DataBind();-----------------------------------
DataList1.DataSource = webnadata1;//我假定你的webnadata1是DataTable
DataList1.DataBind();
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;namespace ohcq
{
/// <summary>
/// websch 的摘要说明。
/// </summary>
public class websch : System.Web.UI.Page
{
protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
protected System.Web.UI.WebControls.DataList DataList1;
protected System.Web.UI.WebControls.PlaceHolder BreadCrumbs;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Data.SqlClient.SqlCommand sqlSelectCommand1;
protected System.Data.SqlClient.SqlCommand sqlInsertCommand1;
protected System.Data.SqlClient.SqlConnection sqlConnection1;
protected ohcq.webnadata webnadata1;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
sqlDataAdapter1.SelectCommand.Parameters["@classid"].Value=Request.QueryString["classid"];
sqlDataAdapter1.Fill(webnadata1);
DataList1.DataBind();
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
this.webnadata1 = new ohcq.webnadata();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
((System.ComponentModel.ISupportInitialize)(this.webnadata1)).BeginInit();
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "readwebna", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("title", "title"),
new System.Data.Common.DataColumnMapping("url", "url"),
new System.Data.Common.DataColumnMapping("id", "id"),
new System.Data.Common.DataColumnMapping("memo", "memo"),
new System.Data.Common.DataColumnMapping("classid", "classid"),
new System.Data.Common.DataColumnMapping("verity", "verity"),
new System.Data.Common.DataColumnMapping("email", "email")})});
//
// webnadata1
//
this.webnadata1.DataSetName = "webnadata";
this.webnadata1.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "[readwebna]";
this.sqlSelectCommand1.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlSelectCommand1.Connection = this.sqlConnection1;
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@classid", System.Data.SqlDbType.Int, 4));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "[NewInsertCommand]";
this.sqlInsertCommand1.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@title", System.Data.SqlDbType.NVarChar, 100, "title"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@url", System.Data.SqlDbType.NVarChar, 200, "url"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@id", System.Data.SqlDbType.Int, 4, "id"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@memo", System.Data.SqlDbType.NVarChar, 50, "memo"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@classid", System.Data.SqlDbType.Int, 4, "classid"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@verity", System.Data.SqlDbType.Int, 4, "verity"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@email", System.Data.SqlDbType.NVarChar, 120, "email"));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=NETPETBOY;packet size=4096;user id=sa;data source=NETPETBOY;persis" +
"t security info=True;initial catalog=wjtx;password=iloveyou";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.webnadata1)).EndInit(); }
#endregion private void DataList1_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
}
}