ALTER PROCEDURE get_user //存储过程
AS
select name1 from T_user
RETURN
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand("get_user",conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
SqlDataReader sdr = cmd.ExecuteReader();
if(sdr.Read())
{ TextBox1.Text = sdr[0].ToString();
}
}
} //我的代码,我的数据库有很多数据,为什么只能读出,第一条数据??求高手,给详细答案
AS
select name1 from T_user
RETURN
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand("get_user",conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
SqlDataReader sdr = cmd.ExecuteReader();
if(sdr.Read())
{ TextBox1.Text = sdr[0].ToString();
}
}
} //我的代码,我的数据库有很多数据,为什么只能读出,第一条数据??求高手,给详细答案
解决方案 »
- 有什么办法能让IE6支持RSS
- 关于树形结构的问题。
- GridView 的GridView1_RowCommand 触发问题
- HttpModule 拦截客户端所请求的事件名称或者控件ID
- 如何把HTML转成WORD??(在线等!)
- 20求!。net怎样更改其实环境配置!在线等
- 制作自定义DataGrid控件时遇到的问题
- 请问,我要在ASP.NET中的树控件中单击的时候执行代码,怎么实现?
- 奇怪asp.net居然可以这样?
- datagrid里面的模板列控件,例如:button,在运行时如何更改其 Enabled属性?
- 我用rational rose2003画类图的时候发现这个图幅太小,类图复杂时画不下,怎么办?
- 求问大家 两个表中的非主键字段 如何关联?
.....
SqlDataReader sdr = cmd.ExecuteReader();
while( sdr.Read())
{
Response.Write(sdr[0].ToString()+"<br />"); }
{
DataTable dt = new DataTable();
cmd = new SqlCommand(cmdtext, GetConn());
cmd.CommandType = CommandType.Text;
SqlDataReader dr = null;
using (dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
dt.Load(dr);
}
return dt;
}调用ReturnDataTable(sql语句或者存储过程Name)
读了一条就over了,用while
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand("get_user",conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
SqlDataReader sdr = cmd.ExecuteReader();
while(sdr.Read())
{
this.TextBox1.Text += sdr["name1"];//得用字符串的相加,防止结果
}
}
}