主要代码是这样的:
private string OutputArticle()
{//Only output one Record of the "AriticID" is 2
string m_strRet = "";
//string str_ID = Request["id"];
string str_ID = Convert.ToString(Request.QueryString["id"]);
SqlConnection mySqlConnection = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["myConnString"]);
mySqlConnection.Open(); SqlCommand mySqlCommand = new SqlCommand("Select ay from xsaj where id ='" + str_ID + "'", mySqlConnection);
mySqlCommand.Connection = mySqlConnection; SqlDataReader dr = mySqlCommand.ExecuteReader();
if (dr.Read())
{
m_strRet = dr["ay"].ToString();
} return m_strRet;
dr.Close(); mySqlConnection.Close(); mySqlConnection.Dispose();
}
private string substr()
{
int id = Convert.ToInt32(Convert.ToString(Request.QueryString["id"]));
int ct = Int32.Parse(page);
if (strl == (strl / pagesize) * pagesize)
{
for (int i = 1; i <= strl / pagesize; i++)
{
this.Literal1.Text += "<a href=detail.aspx?id="+id+"&page=" + i + ">" + (i) + "</" + "a> |";
}
string s = str.Substring(pagesize * ct - pagesize, pagesize);
return s;
}
else if (ct * pagesize > strl)
{
for (int i = 1; i <= (strl / pagesize) + 1; i++)
{
this.Literal1.Text += "<a href=detail.aspx?id=" + id + "&page=" + i + ">" + (i) + "</" + "a> ";
}
string s = str.Substring((ct - 1) * pagesize, strl - (ct - 1) * pagesize);
return s; }
else
{
for (int i = 1; i <= strl / pagesize + 1; i++)
{
this.Literal1.Text += "<a href=detail.aspx?id=" + id + "&page=" + i + ">" + (i)+ "</" + "a> |";
}
string s = str.Substring(pagesize * ct - pagesize, pagesize);
return s;
}
}
private string OutputArticle()
{//Only output one Record of the "AriticID" is 2
string m_strRet = "";
//string str_ID = Request["id"];
string str_ID = Convert.ToString(Request.QueryString["id"]);
SqlConnection mySqlConnection = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["myConnString"]);
mySqlConnection.Open(); SqlCommand mySqlCommand = new SqlCommand("Select ay from xsaj where id ='" + str_ID + "'", mySqlConnection);
mySqlCommand.Connection = mySqlConnection; SqlDataReader dr = mySqlCommand.ExecuteReader();
if (dr.Read())
{
m_strRet = dr["ay"].ToString();
} return m_strRet;
dr.Close(); mySqlConnection.Close(); mySqlConnection.Dispose();
}
private string substr()
{
int id = Convert.ToInt32(Convert.ToString(Request.QueryString["id"]));
int ct = Int32.Parse(page);
if (strl == (strl / pagesize) * pagesize)
{
for (int i = 1; i <= strl / pagesize; i++)
{
this.Literal1.Text += "<a href=detail.aspx?id="+id+"&page=" + i + ">" + (i) + "</" + "a> |";
}
string s = str.Substring(pagesize * ct - pagesize, pagesize);
return s;
}
else if (ct * pagesize > strl)
{
for (int i = 1; i <= (strl / pagesize) + 1; i++)
{
this.Literal1.Text += "<a href=detail.aspx?id=" + id + "&page=" + i + ">" + (i) + "</" + "a> ";
}
string s = str.Substring((ct - 1) * pagesize, strl - (ct - 1) * pagesize);
return s; }
else
{
for (int i = 1; i <= strl / pagesize + 1; i++)
{
this.Literal1.Text += "<a href=detail.aspx?id=" + id + "&page=" + i + ">" + (i)+ "</" + "a> |";
}
string s = str.Substring(pagesize * ct - pagesize, pagesize);
return s;
}
}
解决方案 »
- 如何在asp.net页面中引用sql service2005 analysis services中的分析结果?
- 急啊、、、请教、、、、
- 神啊,快来救救我吧,该死的vs显示问题
- 触发器的问题?
- 用Response.WriteFile进行下载文件老是出现网站无法打开的情况
- 用VS2008编辑FTP网站的问题!
- 做一个网站需要屏蔽所有来自中国的访客?行吗?
- 谁有cookie使用的例子,关于cookie的修改和删除方面的……
- 高手帮忙,方法优化。
- EF的DbContext子类问题
- asp.net 的 asp:button ,用户点击的时候。怎么样能先弹出一个确认框confirm,用户确认后。在执行C#里面的函数。
- 高难度: 如何 修改绑定datalist的DataSource 中的某个字段的值,并且修改后还能绑定?
这样的新闻扫描成PDF速度快的多