为什么GridView显示不出来?求指导
public partial class friendlist : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!CheckUser())
Response.Redirect("Login.aspx");
if (!this.IsPostBack)
InitData();
}
private bool CheckUser()
{
if (Session["login_name"] == null)
{
Response.Write("<Script Language=JavaScript>alert('请登录!');</Script>");
return false;
}
return true;
}
private void InitData()
{
System.Data.SqlClient.SqlConnection conn = new SqlConnection();
conn.ConnectionString =
ConfigurationManager.ConnectionStrings["MyBBSConnectionString"].ConnectionString;
SqlCommand cmd1 = new SqlCommand();
cmd1.Connection = conn;
cmd1.CommandText = "SELECT* FROM[Friend] where UserName=@UserName";
cmd1.CommandType = CommandType.Text;
SqlParameter para0 = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
para0.Value = Session["login_name"].ToString();
cmd1.Parameters.Add(para0);
conn.Open();
cmd1.ExecuteNonQuery();
SqlDataReader dr1 = cmd1.ExecuteReader();
GV.DataSource = dr1;
GV.DataBind();
LabelPages.Text = "查询结果(第" + (GV.PageIndex + 1).ToString() + "页 共" + GV.PageCount.ToString() + "页)";
System.Data.SqlClient.SqlConnection conn1 = new SqlConnection();
conn1.ConnectionString =
ConfigurationManager.ConnectionStrings["MyBBSConnectionString"].ConnectionString;
SqlDataReader dr;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn1;
cmd.CommandText = "SELECT* FROM [Friend] where FriendName=@FriendName";
cmd.CommandType = CommandType.Text;
SqlParameter para = new SqlParameter("@FriendName", SqlDbType.VarChar, 50);
para.Value = Session["login_name"].ToString();
cmd.Parameters.Add(para);
try
{
conn1.Open();
dr = cmd.ExecuteReader();
if (dr.Read())
{
if (dr.GetString(3) != "无 ")
LabelMsg.Text = dr.GetString(0) + "给你发了一条消息";
}
dr.Close();
}
catch (SqlException sqlException)
{
Response.Write(sqlException.Message);
}
finally
{
if (conn1.State == ConnectionState.Open)
conn1.Close();
}
}
protected void GV_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GV.PageIndex = e.NewPageIndex;
InitData();
}
protected void Btnjj_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection conn = new SqlConnection();
conn.ConnectionString =
ConfigurationManager.ConnectionStrings["MyBBSConnectionString"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "Update [Friend] Set[state]=@state where [UserName]=@UserName and [FriendName]=@FriendName";
cmd.CommandType = CommandType.Text;
SqlParameter para0 = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
para0.Value = Session["login_name"].ToString();
cmd.Parameters.Add(para0);
SqlParameter para1 = new SqlParameter("@FriendName", SqlDbType.VarChar, 50);
para1.Value = TxtFriend.Text;
cmd.Parameters.Add(para1);
SqlParameter para2 = new SqlParameter("@state", SqlDbType.VarChar, 50);
para2.Value = "添加失败";
cmd.Parameters.Add(para2);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException sqlException)
{
Response.Write(sqlException.Message);
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
}
//string username = Convert.ToString(Request.QueryString["user_name"]);
System.Data.SqlClient.SqlConnection conn1 = new SqlConnection();
conn1.ConnectionString =
ConfigurationManager.ConnectionStrings["MyBBSConnectionString"].ConnectionString;
SqlCommand cmd1 = new SqlCommand();
cmd1.Connection = conn1;
cmd1.CommandText = "Update [Friend] Set[state]=@state where [UserName]=@UserName and [FriendName]=@FriendName";
cmd1.CommandType = CommandType.Text;
SqlParameter para3 = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
para3.Value = TxtFriend.Text;
cmd1.Parameters.Add(para3);
SqlParameter para4 = new SqlParameter("@FriendName", SqlDbType.VarChar, 50);
para4.Value = Session["login_name"].ToString();
cmd1.Parameters.Add(para4);
SqlParameter para5 = new SqlParameter("@state", SqlDbType.VarChar, 50);
para5.Value = "添加失败";
cmd1.Parameters.Add(para5);
try
{
conn1.Open();
cmd1.ExecuteNonQuery();
}
catch (SqlException sqlException)
{
Response.Write(sqlException.Message);
}
finally
{
if (conn1.State == ConnectionState.Open)
conn1.Close();
}
}
protected void GV_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void BtnBack_Click1(object sender, EventArgs e)
{
Response.Redirect("TopicList.aspx");
}
protected void Btnckxx_Click1(object sender, EventArgs e)
{
Response.Redirect("Message.aspx");
}
protected void ButtonMsg_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection conn = new SqlConnection();
conn.ConnectionString =
ConfigurationManager.ConnectionStrings["MyBBSConnectionString"].ConnectionString;
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;
cmd.Connection = conn;
cmd.CommandText = "SELECT* FROM[Friend] where [UserName]=@UserName and [FriendName]=@FriendName";
cmd.CommandType = CommandType.Text;
SqlParameter para0 = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
para0.Value = Session["login_name"].ToString();
cmd.Parameters.Add(para0);
SqlParameter para1 = new SqlParameter("@FriendName", SqlDbType.VarChar, 50);
para1.Value = Txtmsg.Text;
cmd.Parameters.Add(para1);
try
{
conn.Open();
dr = cmd.ExecuteReader();
if (dr.Read())
{
if (dr.GetString(2) == "添加成功")
Response.Redirect("SendMsg.aspx");
else
Response.Write("<Script Language=JavaScript>alert('该用户并非您的好友,您不能给他发送信息!');</Script>");
}
dr.Close();
}
catch (SqlException sqlException)
{
Response.Write(sqlException.Message);
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
}
}
protected void Btnjs_Click1(object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection conn = new SqlConnection();
conn.ConnectionString =
ConfigurationManager.ConnectionStrings["MyBBSConnectionString"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "Update [Friend] Set[state]=@state where [UserName]=@UserName and [FriendName]=@FriendName";
cmd.CommandType = CommandType.Text;
SqlParameter para0 = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
para0.Value = Session["login_name"].ToString();
cmd.Parameters.Add(para0);
SqlParameter para1 = new SqlParameter("@FriendName", SqlDbType.VarChar, 50);
para1.Value = TxtFriend.Text;
cmd.Parameters.Add(para1);
SqlParameter para2 = new SqlParameter("@state", SqlDbType.VarChar, 50);
para2.Value = "添加成功";
cmd.Parameters.Add(para2);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException sqlException)
{
Response.Write(sqlException.Message);
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
}
//string username = Convert.ToString(Request.QueryString["user_name"]);
System.Data.SqlClient.SqlConnection conn1 = new SqlConnection();
conn1.ConnectionString = ConfigurationManager.ConnectionStrings["MyBBS_DataConnectionString"].ConnectionString;
SqlCommand cmd1 = new SqlCommand();
cmd1.Connection = conn1;
cmd1.CommandText = "Update [Friend] Set[state]=@state where [UserName]=@UserName and [FriendName]=@FriendName";
cmd1.CommandType = CommandType.Text;
SqlParameter para3 = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
para3.Value = TxtFriend.Text;
cmd1.Parameters.Add(para3);
SqlParameter para4 = new SqlParameter("@FriendName", SqlDbType.VarChar, 50);
para4.Value = Session["login_name"].ToString();
cmd1.Parameters.Add(para4);
SqlParameter para5 = new SqlParameter("@state", SqlDbType.VarChar, 50);
para5.Value = "添加成功";
cmd1.Parameters.Add(para5);
try
{
conn1.Open();
cmd1.ExecuteNonQuery();
}
catch (SqlException sqlException)
{
Response.Write(sqlException.Message);
}
finally
{
if (conn1.State == ConnectionState.Open)
conn1.Close();
}
}
}
[解决办法]
调试一下