用户反馈信息textbox填充数据表，页面使用gridview显示反馈意见

来源：互联网发布：淘宝网账号登录历史编辑：程序博客网时间：2024/04/30 14:16

1.用户反馈信息textbox填充数据表

用户通过radiobuttonlist和textbox输入信息，后台代码将该信息导入数据库中。

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Windows.Forms;using System.Windows.Forms.DataVisualization.Charting;using System.Data;using System.Data.SqlClient;namespace WebApplication1{    public partial class WebForm9 : System.Web.UI.Page    {        protected void Page_Load(object sender, EventArgs e)        {            //数据库连接            SqlConnection conn = new SqlConnection("Data Source=PC-PC;Initial Catalog=TunnelMonitor;Integrated Security=True");            string sql = "insert into UserAdvice (UserName,Grade,Advice,Time) values ('" + Session["UserName"].ToString() + "','" + RadioButtonList1.SelectedValue + "','" + TextBox1.Text + "','" + DateTime.Now.ToString() + "')";            SqlCommand cmd = new SqlCommand(sql, conn);            conn.Open();            SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);        }        protected void RadioButton1_CheckedChanged(object sender, EventArgs e)        {        }        protected void Button2_Click(object sender, EventArgs e)        {                    }    }}

2.页面使用gridview显示反馈意见

通过gridview新建数据库连接，连接到用户意见数据表，用于显示信息

0 0