新手求大师帮忙

Question

我刚学ASP.NET我们老师让我用后台代码 连接SQL SERVER 数据库读取里面的信息  求帮忙 QQ136944646  

Answer 1

给个DBhelper的写法  /// <summary>
        /// 获取存储在配置文件里面的数据连接字符串
        /// </summary>
        private static string connString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        /// <summary>
        /// 专门通过SQL文本来执行添加、修改、删除的语句
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="para"></param>
        /// <returns></returns>
        public static bool ExecuteNonQueryBySQL(string sql, OracleParameter[] para)
        {            try
            {
                using (OracleConnection conn = new OracleConnection(connString))
                {
                    OracleCommand cmd = new OracleCommand(sql, conn);
                    if (para != null)
                    {
                        cmd.Parameters.AddRange(para);
                    }
                    if (conn.State == ConnectionState.Closed)
                    {
                        conn.Open();
                    }
                    int i = cmd.ExecuteNonQuery();//在执行这句话之前一定打开连接
                    return i > 0 ? true : false;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }        }
        /// <summary>
        /// 专门通过存储过程来执行添加、修改、删除的语句
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="para"></param>
        /// <returns></returns>
        public static bool ExecuteNonQueryByStoredProcedure(string sql, OracleParameter[] para)
        {            try
            {
                using (OracleConnection conn = new OracleConnection(connString))
                {
                    OracleCommand cmd = new OracleCommand(sql, conn);
                    cmd.CommandType = CommandType.StoredProcedure;//告诉程序你现在执行的是存储过程
                    if (para != null)
                    {
                        cmd.Parameters.AddRange(para);
                    }
                    if (conn.State == ConnectionState.Closed)
                    {
                        conn.Open();
                    }
                    int i = cmd.ExecuteNonQuery();//在执行这句话之前一定打开连接
                    return i > 0 ? true : false;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }        }

Answer 2

百度 谷歌 MSDN dotnet

Answer 3

这个好像没什么难的啊
给个代码你参考一下好了 static string connectionString = ConfigurationManager.ConnectionStrings["GYDConnectionString"].ConnectionString;    public void BindGridView()
    {
        SqlConnection con = new SqlConnection(connectionString);
        SqlCommand cmd = con.CreateCommand();
        cmd.CommandText = "SELECT e.EmpId,e.[EmpName],D.[DepartId],D.[DepartName],w.[BaseID],w.[PaymentBase], w.[PensionBase], w.[FertilityBase], w.[MedicalBase] FROM [Crm_WagePaymentBase] w INNER JOIN [Crm_Employee] e on e.EmpId=w.EmpID INNER JOIN Crm_Depart D ON D.DepartId=e.DepartId order by D.DepartId";        SqlDataAdapter adpt = new SqlDataAdapter();
        adpt.SelectCommand = cmd;        DataSet ds = new DataSet();
        adpt.Fill(ds);        this.gvWageBase.DataSource = ds;
        this.gvWageBase.DataBind();
    }