将记录添加到数据表之后GridView只读到其中一个字段的值
将作者、标题、内容三个文本框中的数据写入数据表之后通过GridView重新读取,结果只能读到标题和内容,作者无法读取。求解决方法!保存按钮的代码:
protected void Button2_Click(object sender, EventArgs e)
{
if (TextBox1.Text != "" || TextBox2.Text != "" || TextBox1.Text != null || TextBox2.Text != null)
{
Reader1 r1 = new Reader1();
r1.User = TextBox1.Text;
r1.Title = TextBox2.Text;
r1.Content = TextBox3.Text;
r1.Time = DateTime.Now;
RProvider1 re = new RProvider1();
re.Insert(r1);
Response.Write("User:" + r1.User + "<br/>");
Response.Write("Title:" + r1.Title + "<br/>");
Response.Write("Content:" + r1.Content + "<br/>");
Response.Write("Time:" + r1.Time + "<br/>");
this.Response.Redirect("yggl.aspx");
}
}
Reader1类的代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace RD.Entity
{
public class Reader1 : EntityBase
{
private string user = "";
/// <summary>
/// 获取或设置用户的名称
/// </summary>
public string User
{
get { return user.Trim(); }
set { user = value; }
}
private string title = "";
/// <summary>
/// 获取或设置用户的密码
/// </summary>
public string Title
{
get { return title.Trim(); }
set { title = value; }
}
/// <summary>
/// 获取用户身份
/// </summary>
private string content = "";
public string Content
{
get { return content; }
set { content = value; }
}
private DateTime time = DateTime.MinValue;
public DateTime Time
{
get { return time; }
set { time = value; }
}
}
}
RProvider1的代码
public bool Insert(Reader1 reader1)
{
string sqlText = "INSERT INTO own([user],title,content,dateandtime) VALUES(@user,@Title,@Content,@dateandtime)";
IList<DataParameter> parameters = new List<DataParameter>();
parameters.Add(new DataParameter("@user", DbType.String, reader1.User));
parameters.Add(new DataParameter("@Title", DbType.String, reader1.Title));
parameters.Add(new DataParameter("@Content", DbType.String, reader1.Content));
parameters.Add(new DataParameter("@dateandtime", DbType.DateTime, reader1.Time));
return this.dataHandler.ExecuteCommand(sqlText, parameters);
} --------------------编程问答-------------------- 怎么读取的 --------------------编程问答-------------------- 无法读取什么意思?你这里好像没有读取数据绑定gridview的代码 --------------------编程问答--------------------
作者、标题、内容三个文本框中的数据写入指定数据表中之后,GridView把刚刚添加的数据显示出来!标题和内容的数据都能显示,就是作者这一字段的无法显示!数据是有写入到数据表中!
补充:.NET技术 , ASP.NET