try{
SqlConnection conn=new SqlConnection("server=localhost;database=insure;uid=sa;pwd=");
string sql="select productname,kindid,companyid,age,paymode,paydeadline,ensdeadline,characteristic,duty from product";
conn.Open();
SqlCommand cmd=new SqlCommand(sql,conn);
SqlDataReader rs=cmd.ExecuteReader();
if (rs.Read()) {
//读取相关信息
lblpname.Text = rs.GetString(0);
lblage.Text=rs.GetString(3);
lblpaymode.Text=rs.GetString(4);
this.lblpaydate.Text=rs.GetString(5);
this.lblensuredate.Text=rs.GetString(6);
this.lblcharicter.Text=rs.GetString(7);
this.lblresponsibility.Text=rs.GetString(8);
int cid=rs.GetInt32(1);
string sqlc="select conanyname from company where cid='"+cid+"'"; SqlCommand cmdc=new SqlCommand(sqlc,conn);
SqlDataReader rsc=cmdc.ExecuteReader();
if(rsc.Read()){
this.lblcompany.Text=rsc.GetString(0);
}
int kid=rs.GetInt32(2);
string sqlk="select productname from insurekinds where id='"+kid+"'"; SqlCommand cmdk=new SqlCommand(sqlk,conn);
SqlDataReader rsk=cmdk.ExecuteReader();
if(rsk.Read()){
this.lblkindname.Text=rsk.GetString(0);
}
rsc.Close();
rsk.Close();
rs.Close();
conn.Close();
}
}catch(Exception ex){
throw ex;
}
finally{
}
这段代码是为页面中的label读取数据的,可总不能显示数据,也不报错,大虾们看下,是不是数据没从数据库中得到,怎么调试,希望指点一下
SqlConnection conn=new SqlConnection("server=localhost;database=insure;uid=sa;pwd=");
string sql="select productname,kindid,companyid,age,paymode,paydeadline,ensdeadline,characteristic,duty from product";
conn.Open();
SqlCommand cmd=new SqlCommand(sql,conn);
SqlDataReader rs=cmd.ExecuteReader();
if (rs.Read()) {
//读取相关信息
lblpname.Text = rs.GetString(0);
lblage.Text=rs.GetString(3);
lblpaymode.Text=rs.GetString(4);
this.lblpaydate.Text=rs.GetString(5);
this.lblensuredate.Text=rs.GetString(6);
this.lblcharicter.Text=rs.GetString(7);
this.lblresponsibility.Text=rs.GetString(8);
int cid=rs.GetInt32(1);
string sqlc="select conanyname from company where cid='"+cid+"'"; SqlCommand cmdc=new SqlCommand(sqlc,conn);
SqlDataReader rsc=cmdc.ExecuteReader();
if(rsc.Read()){
this.lblcompany.Text=rsc.GetString(0);
}
int kid=rs.GetInt32(2);
string sqlk="select productname from insurekinds where id='"+kid+"'"; SqlCommand cmdk=new SqlCommand(sqlk,conn);
SqlDataReader rsk=cmdk.ExecuteReader();
if(rsk.Read()){
this.lblkindname.Text=rsk.GetString(0);
}
rsc.Close();
rsk.Close();
rs.Close();
conn.Close();
}
}catch(Exception ex){
throw ex;
}
finally{
}
这段代码是为页面中的label读取数据的,可总不能显示数据,也不报错,大虾们看下,是不是数据没从数据库中得到,怎么调试,希望指点一下
解决方案 »
- 急求Excel问题
- JS屏蔽html标签的问题
- 页面设计中菜单问题
- PetShop3.0 是什么?
- 包含实时功能的ASP.NET系统结构
- 如何把一段字符串转换成stream数据流?
- 在ASP。NET(C#)中插入当前时间DB2数据的时候我想在月份上加一个月该怎么写?????大家帮帮忙,请指教
- 到底Itemcommand与SelectedIndexChanged事件有什么区别呢,进来你就知道!
- 用Web開發手機短信收發功能,怎樣的方案比較好?
- 怎样实现点击提交按钮后自动跳到指定的aspx页面?我写了一个但不行(附源码)?
- 控制显示字符的长度
- 以前看到过一篇文章,讲如何在vs2005中调试ASP程序,现在找不到了,大家谁知道,100分!
2、设置断点在
int cid=rs.GetInt32(1);位置
察看lable是否得到了值
推荐第一种方法
使用 SqlDataReader 读取数据示例
<% @Import namespace="System.Data" %>
<% @Import Namespace="System.Data.SqlClient" %><html>
<HEAD>
<title>使用 SqlDataReader 读取数据示例</title>
<script language="C#" runat="server">
void Page_Load(object sender, System.EventArgs e)
{
string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"];
string Sql = "SELECT LastName, FirstName FROM Employees";
sqlconnection thisConnection = new SqlConnection(ConnectionString);
SqlCommand thisCommand = new SqlCommand(Sql, thisConnection);
thisCommand.CommandType = CommandType.Text;
try
{
// 打开数据库连接
thisCommand.Connection.Open();
// 执行SQL语句,并返回DataReader对象
SqlDataReader dr = thisCommand.ExecuteReader();
// 以粗体显示标题
myLabel.Text = "<b>LastName FirstName</b><br>";
// 循环读取结果集
while(dr.Read())
{
// 读取两个列值并输出到Label中
myLabel.Text += dr["LastName"] + " " + dr["FirstName"] + "<br>";
}
// 关闭DataReader
dr.Close();
}
catch(SqlException ex)
{
// 异常处理
Response.Write(ex.ToString());
}
finally
{
// 关闭数据库连接
thisCommand.Connection.Close();
}
}
</script>
</HEAD><body>
<form id="Form1" method="post" runat="server">
<h3>使用 SqlDataReader 读取数据示例</h3>
显示内容:<br>
<asp:Label id="myLabel" runat="server"></asp:Label>
</form>
</body>
</HTML>
一个数据库连接只能开一个DataReader好不好
SqlCommand cmdc=new SqlCommand(sqlc,conn);
SqlDataReader rsc=cmdc.ExecuteReader();
前面加个新的连接
SqlConnection conn2=new SqlConnection("server=localhost;database=insure;uid=sa;pwd=");
conn2.Open();
SqlCommand cmdc=new SqlCommand(sqlc,conn2);
SqlDataReader rsc=cmdc.ExecuteReader();