62,046
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 从指定表中读取数据,读取的数据放到datatable中
/// </summary>
/// <param name="table">表名</param>
/// <param name="cmdText">命令(为select语句)</param>
/// <param name="dt">存储读取到得数据</param>
/// <returns>返回是否读取成功</returns>
public static bool Read(string table, string cmdText, DataTable dt)
{
conn = new OleDbConnection(connectionString);
conn.Open();
OleDbCommand cmd = new OleDbCommand(cmdText, conn);//创建command
OleDbDataAdapter oda = new OleDbDataAdapter(cmd);
try
{
oda.Fill(dt);//填充数据
oda.Update(dt);
return true;//返回读取成功
}
catch (OleDbException ode)
{
return false;
throw new Exception(ode.Message);
}
finally
{
oda.Dispose();
conn.Close();
}
}
<asp:GridView ID="gv_News" runat="server" CellPadding="4" EnableModelValidation="True"
ForeColor="#333333" GridLines="None" AllowPaging="True" AutoGenerateColumns="false"
OnPageIndexChanging="gv_News_PageIndexChanging" PageSize="15"
OnRowCommand="gv_News_RowCommand" DataKeyNames="news_id"
onrowdeleting="gv_News_RowDeleting">
<Columns>
<asp:BoundField HeaderText="新闻标题" DataField="news_title" />
<asp:BoundField HeaderText="发布时间" DataField="news_time" />
<asp:BoundField HeaderText="阅读次数" DataField="news_readtimes" />
<asp:TemplateField HeaderText="操作">
<ItemTemplate>
<a href="javascript:;" onclick="newsEdit(<%#Eval("news_id") %>)">编辑</a>| <a href="javascript:;"
onclick="newsDel(<%#Eval("news_id") %>)">删除</a>|
<asp:LinkButton runat="server" Text="删除" CommandArgument='<%#Eval("news_id") %>'
CommandName="Del"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField HeaderText="自带的删除" ShowDeleteButton="True" ButtonType="Button" />
</Columns>
<AlternatingRowStyle BackColor="White" />
<EditRowStyle BackColor="#2461BF" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
</asp:GridView>
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
gv_NewsInit();//初始化新闻
}
}
protected void gv_NewsInit()
{
string cmdText = "select * from tb_news order by news_id desc";
DataTable dt = new DataTable();
dt.Clear();
if (DbHelper.Read("tb_news", cmdText, dt))
{
if (dt != null)
{
gv_News.DataSource = null;
gv_News.DataSource = dt;
gv_News.DataBind();
}
}
}
//新增新闻
protected void bt_sumbitNews_Click(object sender, EventArgs e)
{
string news_title = mcmNewsTitle.Value.ToString();//新闻标题
string news_content = mcmNewsContent.Value.ToString();//新闻内容
DateTime news_time=DateTime.Now;//发表新闻的时间
//做些服务器端的检查
string cmdText = "insert into tb_news (news_title, news_content, news_time,news_readtimes) values('" + news_title + "','" + news_content + "','" + news_time + "',0)";
if (DbHelper.RunSql(cmdText))
{
Response.Write("<script>alert('添加成功!')</script>");
}
gv_NewsInit();
}
gv_News.DataSource = null;
gv_News.DataSource = dt;