新手求大师帮忙
我刚学ASP.NET我们老师让我用后台代码 连接SQL SERVER 数据库读取里面的信息 求帮忙 QQ136944646 --------------------编程问答-------------------- 简单增删改查 --------------------编程问答-------------------- 楼主找点ADO.NET的资料看看 --------------------编程问答-------------------- 上课不好好听讲 --------------------编程问答-------------------- 呵呵呵 就不告诉你 自己查资料 --------------------编程问答-------------------- --------------------编程问答-------------------- 给个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;
}
} --------------------编程问答-------------------- 51aspx.com上面下载项目去
--------------------编程问答-------------------- 百度 谷歌 MSDN dotnet --------------------编程问答-------------------- 好好学习啊,想当年我也是这样 --------------------编程问答-------------------- 去下载一些简单的实例看看
--------------------编程问答-------------------- 这个好像没什么难的啊
给个代码你参考一下好了
--------------------编程问答-------------------- 上课不听课,自己做也行的!自学嘛
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();
}
补充:.NET技术 , ASP.NET