我写了一个新闻读取的类,但是出现标题所出的问题。
这是我的详细代码:
前台:
<table border="1">
<tr><td style="width: 293px" runat="server" id="tt1"> </td></tr>
</table>
后台
protected void Page_Load(object sender, EventArgs e)
{
string str = "select top 5 * from news where type_ids=51 order by id desc";
access.yj(str,tt1);
}调用的类:
public static string yj(string str,HtmlTableCell tt)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GirlsysConnectionString"].ConnectionString);//连接数据库
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(str, conn);
SqlDataReader dea = cmd.ExecuteReader();
while (dea.Read())
{
tt.InnerText +="<a href=\"news_look.aspx?id=" + dea["id"] + "\" target=_blank>" + access.Substr(dea["title"].ToString(), 0, 11);
return tt.InnerText;
}
}
catch
{
return tt.InnerText;
}
finally
{
conn.Close();
}
}
谢谢各位了
这是我的详细代码:
前台:
<table border="1">
<tr><td style="width: 293px" runat="server" id="tt1"> </td></tr>
</table>
后台
protected void Page_Load(object sender, EventArgs e)
{
string str = "select top 5 * from news where type_ids=51 order by id desc";
access.yj(str,tt1);
}调用的类:
public static string yj(string str,HtmlTableCell tt)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GirlsysConnectionString"].ConnectionString);//连接数据库
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(str, conn);
SqlDataReader dea = cmd.ExecuteReader();
while (dea.Read())
{
tt.InnerText +="<a href=\"news_look.aspx?id=" + dea["id"] + "\" target=_blank>" + access.Substr(dea["title"].ToString(), 0, 11);
return tt.InnerText;
}
}
catch
{
return tt.InnerText;
}
finally
{
conn.Close();
}
}
谢谢各位了
解决方案 »
- 数据库里字段是uniqueidentifier类型的,怎么操作。
- 取出GridView1中LinkButton的行号
- 100分:如何解决2003下IIS的w3wp.exe问题?
- 为什么DrawString时,使用的Font对象字体不起作用?
- 求助!急!
- 请问用户控件怎么继承其它页面
- 是 DataGrid 的显示样式的问题,请大家指教.
- 存储过程的绑定问题
- 关于DataGrid控件绑定数据源的问题(急。。。。。。。。。。。)在线等
- 大家認為這樣刪除能不能是真正的刪除,如果不行該如何改下才好呢?
- 未标记为可序列化 错误,请高手帮助
- Cookie开发后,在本地登陆一切正常,然而传到服务器就出现CookIE对象里的KEY没有建立,连NULL都不是。晕了,有代码!请高手帮忙!
{
tt.InnerText +=" <a href=\"news_look.aspx?id=" + dea["id"] + "\" target=_blank>" + access.Substr(dea["title"].ToString(), 0, 11);
return tt.InnerText;
} 如果while 里面没有执行,又没有出异常,就出问题了!
return tt.InnerText;
public static string yj(string str,HtmlTableCell tt)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GirlsysConnectionString"].ConnectionString);//连接数据库
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(str, conn);
SqlDataReader dea = cmd.ExecuteReader();
while (dea.Read())
{
tt.InnerText +=" <a href=\"news_look.aspx?id=" + dea["id"] + "\" target=_blank>" + access.Substr(dea["title"].ToString(), 0, 11);
return tt.InnerText;
}
}
catch
{
return tt.InnerText;
}
finally
{
conn.Close();
}
} 你最后再返回 return "";可以了,
一般你可以在最外面声明个变量把数据赋给这个变量,最后只返回这个变量就可以了。
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GirlsysConnectionString"].ConnectionString);// 连接数据库
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(str, conn);
SqlDataReader dea = cmd.ExecuteReader();
while (dea.Read())
{
tt.InnerText +=" <a href=\"news_look.aspx?id=" + dea["id"] + "\" target=_blank>" + access.Substr(dea["title"].ToString(), 0, 11);
}
return tt.InnerText;
}
catch
{
return tt.InnerText;
}
finally
{
conn.Close();
}
}
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GirlsysConnectionString"].ConnectionString);//连接数据库
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(str, conn);
SqlDataReader dea = cmd.ExecuteReader();
while (dea.Read())
{
tt.InnerText +=" <a href=\"news_look.aspx?id=" + dea["id"] + "\" target=_blank>" + access.Substr(dea["title"].ToString(), 0, 11);
}
}
catch
{
//return tt.InnerText;
}
finally
{
conn.Close();
}
return tt.InnerText; }
while (dea.Read())
{
tt.InnerText +=" <a href=\"news_look.aspx?id=" + dea["id"] + "\" target=_blank>" +access.Substr(dea["title"].ToString(), 0, 11);
return tt.InnerText;
}
应该是这样的吧:
while (dea.Read())
{
tt.InnerText +=" <a href=\"news_look.aspx?id=" + dea["id"] + "\" target=_blank>" +access.Substr(dea["title"].ToString(), 0, 11);
}
return tt.InnerText;
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GirlsysConnectionString"].ConnectionString);// 连接数据库
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(str, conn);
SqlDataReader dea = cmd.ExecuteReader();
while (dea.Read())
{
tt.InnerText +=" <a href=\"news_look.aspx?id=" + dea["id"] + "\" target=_blank>" + access.Substr(dea["title"].ToString(), 0, 11);
return tt.InnerText;
}
return string.empty;
}
catch
{
return tt.InnerText;
}
finally
{
conn.Close();
}
}
while (dea.Read())
{
tt.InnerText +=" <a href=\"news_look.aspx?id=" + dea["id"] + "\" target=_blank>" + access.Substr(dea["title"].ToString(), 0, 11);
return tt.InnerText;
}
你这个while 中的return造成了这个错误,所以在编译的时候报这个错误。6楼正解。
哎来晚了!!