Grideview控件绑定数据

最新推荐文章于 2020-01-05 18:19:31 发布

Jasonliuxuefeng

最新推荐文章于 2020-01-05 18:19:31 发布

阅读量619

点赞数

分类专栏： web控件文章标签：控件 web

本文链接：https://blog.csdn.net/Jasonliuxuefeng/article/details/52511026

版权

web控件专栏收录该内容

1 篇文章 0 订阅

订阅专栏

web中Grideview控件绑定

tb_lesson表

tb_Teacher表

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;


namespace 试题插入模块
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            //if (Session["admin"] == null)//判断是否为主页面，是否登录
            //{
            //    Response.Redirect("");
            //}
            if (!IsPostBack)
            {
                string strsql = "select * from tb_Teacher order by ID ";
                BindDG(GridView1, "ID", strsql, "teacher");
            }
        }
        #region 数据库方法
        public static SqlConnection DBCon()
        {
            return new SqlConnection("server=.;database=db_ExamOnline;uid=sa;pwd=123");//数据库连接字符串
        }
        //建立绑定Grideview控件的方法
        public static void BindDG(GridView dg, string id, string strSql, string Tname)
        {
            SqlConnection conn = DBCon();
            SqlDataAdapter sda = new SqlDataAdapter(strSql, conn);
            DataSet ds = new DataSet();
            sda.Fill(ds, Tname);
            dg.DataSource = ds.Tables[Tname];  //设置绑定数据源
            dg.DataKeyNames = new string[] { id }; //根据ID绑定控件
            dg.DataBind();                          //绑定控件
        }
       //删除数据中的一条，
        public static void OperateData(string strsql)
        {
            SqlConnection conn = DBCon();
            conn.Open();
            SqlCommand cmd = new SqlCommand(strsql, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
        }
        #endregion
      
        public string GetKmName(int num )
        {
            SqlConnection con = DBCon();
            con.Open();
            SqlCommand cmd = new SqlCommand("select LessonName from tb_Lesson where ID =" + num, con);
            string kname = cmd.ExecuteScalar().ToString();
            Label1.Text = kname;
            return kname;
        }

        protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
             GridView1.PageIndex = e.NewPageIndex;
            string strsql = "select * from tb_Teacher order by ID ";
            BindDG(GridView1, "ID", strsql, "teacher");
        }

        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            int id = (int)GridView1.DataKeys[e.RowIndex].Value; //获取选中行的ID
            string str = "delete from tb_Teacher where ID=" + id; //执行的SQL语句
            OperateData(str);//删除选中行
            //刷新Grideview
            string strsql = "select * from tb_Teacher order by ID asc";
            BindDG(GridView1, "ID", strsql, "teacher");
        }
    }
} 教师基本信息 
        
  
  
   
   
            

            
    
    
                
     
     
                    
      
      
                    
       
       
                    
      
      
                    
      
      
                    
       
       
                    
      
      
                    
      
      
                    
       
       
                    
      
      
                    
      
      
                        
       
       
                        
                         
       
       
         <%#GetKmName(Convert.ToInt32(Eval("TeacherCourse")))%>

在表中数据库操作可以写成存储过程来操作，使用SQLHelper，和app.config文件来登录数据库和操作数据为好，便于维护，