学习目的
   Â
我们学得好快,今天做一个简易的新闻发布网页,可以说是个演示型的,只是让大家能理插入数据的最主要步骤。掌握今天的内容,我们就有基础可以做一个稍有实用的新闻程序了。
为了不使注意力分散,程序没有加入输入的验证,很快我会接下去写一个验证输入的方法。
图片如下:
仍用昨天的方法新建一数据表,SQL语句如下:
CREATE TABLE [dbo].[NewsArticle] (
    [NewsArticleID] [int] IDENTITY (1, 1) NOT NULL ,
    [Title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [SubTitle] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [Content] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [Writer] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [PubTime] [datetime] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
ALTER TABLE [dbo].[NewsArticle] WITH NOCHECK ADD
    CONSTRAINT [DF_NewsArticle_PubTime] DEFAULT (getdate()) FOR [PubTime],
    CONSTRAINT [PK_NewsArticle] PRIMARY KEY CLUSTERED
    (
        [NewsArticleID]
    ) ON [PRIMARY]
GO
按昨天的方法加入头部的语句,在提交按钮中建立以下事件:
        private void btnPublish_ServerClick( object sender, System.EventArgs e)
        {
            string strConnection = ConfigurationSettings.AppSettings["SqlDatabase1"];
            // 连接SqlServer数据库
            SqlConnection conn = new SqlConnection(strConnection);
            // 建立SqlCommand
            SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = "INSERT INTO NewsArticle (Title, SubTitle, Writer, Content) valueS ("
                + "'" + txtTitle.Text + "',"
                + "'" + txtSubTitle.Text + "',"
                + "'" + txtWriter.Text + "',"
                + "'" + txtContent.Text + "')";
            conn.Open();
            //Response.Write (cmd.CommandText);
            // 插入记录
            try
            {
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Response.Write("<script language=javascript>alert('输入错误,数据库不能更新。')</script>");
            }
            finally
            {
                conn.Close();
            }
        }
注意Command对象的ExecuteNonQuery()方法使用,该方法可以用于插入、更新、删除等操作,是Command对象的重要方法。今天介绍了Command语句的最基本用法,下次还将介绍占位符的用法。好了,各位先消化一下,明后天将做实用的东东了。
本文转自左洸博客园博客,原文链接:http://www.cnblogs.com/myqiao/articles/233177.html,如需转载请自行联系原作者