全部代码如下:
using System;
using System.Data;
using System.Web.Configuration;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
SqlHelper data = new SqlHelper();
Alert alert = new Alert();
protected void Page_Load(object sender, EventArgs e)
{
}
private void CreateCommand(string queryString, string connectionString)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandTimeout = 60;//单位为秒
command.CommandType = CommandType.Text;
command.CommandText = queryString;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
string str2 = "";
while (reader.Read())
{
str2 = string.Format("{0}{1:C2}", reader[0], reader[0]);
this.ListBox1.Items.Add(str2);
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string queryString = "select sound from Void ";
string connectionString = WebConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
CreateCommand(queryString, connectionString);
}
}
我一运行 显示了全部的数据库表里内容,我想要的是逐条读取内容,而且只有一列数据即可,现在是两列,如图:
还有就是我多点下按钮,理应不会加上去(即只有数据库里的内容),现在确变成2份了,如图:
大致问题就这2个:1,如何逐条读取数据,且只要1列即可(且只显示1行,直到读取到数据库最后一行数据);
2,数据内容只要1份就行,即便多点了几次按钮,也显示1条数据,也是递增读取。
如若还没了解我的问题,可以加企鹅 514314112,进行详谈。
求各位大神指教了!!小弟在此谢过了。