ASP 用GridView控件连接SQL Server数据库(4)

        }

        else

        {

            SqlConnection con = new SqlConnection(ConfigurationManager.

                                ConnectionStrings["connection"].ConnectionString);

            string update = "update news set 新闻类别='" + TextBox2.Text + "',

                           新闻题目='" + TextBox3.Text + "',新闻内容='" +

                           TextBox4.Text + "' where 新闻编号='" + TextBox1.Text + "'";

            SqlCommand cmd = new SqlCommand(update, con);

            con.Open();

            cmd.ExecuteNonQuery();

            con.Close();

            GridViewBind();

        }

    }