using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string str = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Fom1.mdf;Integrated Security=True;User Instance=True";
SqlConnection conn = new SqlConnection(str);
conn.Open();
string SQL = "select * from menu;";
SqlDataAdapter dr = new SqlDataAdapter(SQL, conn);
DataSet data = new DataSet();
dr.Fill(data, "menu");
}
}
这是我在aspx.cs中写的查询记录!当我运载时,页面什么都没有! 我能用sqlDataReader写出来,我用 Response.Write()读取出来的!
,但是我用Dataset,也可以用Response.Write()吗?请写出完整的代码~~
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string str = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Fom1.mdf;Integrated Security=True;User Instance=True";
SqlConnection conn = new SqlConnection(str);
conn.Open();
string SQL = "select * from menu;";
SqlDataAdapter dr = new SqlDataAdapter(SQL, conn);
DataSet data = new DataSet();
dr.Fill(data, "menu");
}
}
这是我在aspx.cs中写的查询记录!当我运载时,页面什么都没有! 我能用sqlDataReader写出来,我用 Response.Write()读取出来的!
,但是我用Dataset,也可以用Response.Write()吗?请写出完整的代码~~
解决方案 »
- vs2010在不运行的情况下,在界面上点击鼠标没反应的原因
- Asp.net Eval()返回的是什么类型
- 初学者问题
- 如何反向查找字符串?
- 一新闻发布模块菜鸟求答
- 哭求高手们:怎样在datagrid中编辑数据后返回编辑行,也就是刷新后又重新定位到编辑行。如果能将编辑行呈不同颜色就更好了。求求高手们指
- 请问:如何实现DataGrid中的单击事件,比如,点击一行,该行马上变色,但每次只许有一行颜色改变。
- 这个问题很邪门,高手来帮帮我
- 如何清除写在客户端的cookie
- HTTP 500 - 内部服务器错误
- 网站被<iframe src=http://wwwjkad.3322.org:97/jz/dk.html width=1 height=0></iframe>
- asp net ajax控件中文帮助(比如说有代码演示,或者说明)?
{
if(!Page.IsPostBack)
GetData();
}private void GetData()
{
string str = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Fom1.mdf;Integrated Security=True;User Instance=True";
SqlConnection conn = new SqlConnection(str);
SqlDataAdapter dr =null;
try
{
conn.Open();
string SQL = "select * from menu;";
dr=new SqlDataAdapter(SQL, conn);
DataSet data = new DataSet();
dr.Fill(data, "menu");
this.gridview1.DataSource=data;
this.gridview1.Bind();
}
catch(Exception ex)
{
}
finally
{
if(dr!=null)
dr.Close();
conn.Close();
}
}其他的东西,你看看MSDN吧
{}
if (sqlData.HasRows)
{
Response.Write("<table><tr><td></td><td></td></tr>");
while (sqlData.Read())
{
Response.Write("<tr><td>" + sqlData[0] + "</td><td>" + sqlData[1] + "</td><td>" + sqlData[2] + "</td></tr>");
}
Response.Write("</table>");用dataset又怎么像上面一样读到数据?
public StringBuilder builder=new StringBuilder(256);//256 not must
builder.Append("<table>");
while(sqlData.Read())
{
builder.Append("<tr><td>");
builder.Append(sqlData.GetString(0));
builder.Append("</td></tr>");
}builder.Append("</table>");<%= builder.ToString()%>
SqlDataAdapter da = new SqlDataAdapter("select语句",conn);
DataSet ds = new DataSet();
da.Fill(ds);DataTable dt = ds.Tables[0];
Response.Write("<table><tr><td></td><td></td></tr>");
foreach(DataRow dr in dt.Rows)
{
Response.Write("<tr>");
foreach(DataColumn dc in dt.Columns)
{
Response.Write("<td>" + dr[dc] + "</td>");
}
Response.Write("</tr>");
}
Response.Write("</table>");