ASP.NET操作数据库经典代码

最新推荐文章于 2021-10-12 23:51:55 发布
最新推荐文章于 2021-10-12 23:51:55 发布
阅读量647 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： ASP.NET(随笔) 文章标签： asp.net 数据库 command insert delete string
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/zz_mm/article/details/6592858
本文介绍了一个用于北风数据库的数据访问层实现，包括客户、订单及其详情的增删改查操作。通过ADO.NET技术实现了对数据库的高效访问。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

 public class DataLayer
    {
        private static OleDbConnection _connection;

        private static OleDbConnection Connection
        {
            get
            {
                if (DataLayer._connection == null)
                {
                    DataLayer._connection = new OleDbConnection();
                    DataLayer._connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["NorthWindConnectionString"].ConnectionString;
                }

                return DataLayer._connection;
            }
        }

        #region Helper

        private static OleDbParameter CreateParameter(string key, object value)
        {
            OleDbParameter parameter = new OleDbParameter();
            parameter.ParameterName = key;
            parameter.Value = value;

            return parameter;
        }

        private static int ExecuteNonQuery(OleDbCommand command)
        {
            int affectedRecords;
            try
            {
                command.Connection.Open();
                affectedRecords = command.ExecuteNonQuery();
            }
            finally
            {
                command.Connection.Close();
            }

            return affectedRecords;
        }

        #endregion

        #region Customers DataLayer

        private static Customer CreateCustomerData(OleDbDataReader dataReader)
        {
            Customer customer = new Customer();
            customer.CustomerID = dataReader.IsDBNull(0) ? string.Empty : dataReader.GetString(0);
            customer.CompanyName = dataReader.IsDBNull(1) ? string.Empty : dataReader.GetString(1);
            customer.ContactName = dataReader.IsDBNull(2) ? string.Empty : dataReader.GetString(2);
            customer.ContactTitle = dataReader.IsDBNull(3) ? string.Empty : dataReader.GetString(3);
            customer.Address = dataReader.IsDBNull(4) ? string.Empty : dataReader.GetString(4);
            customer.City = dataReader.IsDBNull(5) ? string.Empty : dataReader.GetString(5);
            customer.Region = dataReader.IsDBNull(6) ? string.Empty : dataReader.GetString(6);
            customer.PostalCode = dataReader.IsDBNull(7) ? string.Empty : dataReader.GetString(7);
            customer.Country = dataReader.IsDBNull(8) ? string.Empty : dataReader.GetString(8);
            customer.Phone = dataReader.IsDBNull(9) ? string.Empty : dataReader.GetString(9);
            customer.Fax = dataReader.IsDBNull(10) ? string.Empty : dataReader.GetString(10);

            return customer;
        }

        public static CustomerCollection GetCustomers()
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax From Customers";
            command.Connection = DataLayer.Connection;

            CustomerCollection customers = new CustomerCollection();
            try
            {
                command.Connection.Open();

                OleDbDataReader dataReader = command.ExecuteReader();
                while (dataReader.Read())
                {
                    Customer customer = DataLayer.CreateCustomerData(dataReader);
                    customers.Add(customer);
                }
            }
            finally
            {
                command.Connection.Close();
            }

            return customers;
        }

        public static Customer GetCustomer(string customerID)
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax From Customers WHERE CustomerID = ?";
            command.Parameters.Add(DataLayer.CreateParameter("CustomerID", customerID));
            command.Connection = DataLayer.Connection;

            try
            {
                command.Connection.Open();

                OleDbDataReader dataReader = command.ExecuteReader();
                if (dataReader.Read())
                {
                    Customer customer = DataLayer.CreateCustomerData(dataReader);
                    return customer;
                }
            }
            finally
            {
                command.Connection.Close();
            }

            return null;
        }

        public static int InsertCustomer(Customer customer)
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "INSERT INTO Customers (CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax) Values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
            command.Connection = DataLayer.Connection;
            command.Parameters.Add(DataLayer.CreateParameter("CustomerID", customer.CustomerID));
            command.Parameters.Add(DataLayer.CreateParameter("CompanyName", customer.CompanyName));
            command.Parameters.Add(DataLayer.CreateParameter("ContactName", customer.ContactName));
            command.Parameters.Add(DataLayer.CreateParameter("ContactTitle", customer.ContactTitle));
            command.Parameters.Add(DataLayer.CreateParameter("Address", customer.Address));
            command.Parameters.Add(DataLayer.CreateParameter("City", customer.City));
            command.Parameters.Add(DataLayer.CreateParameter("Region", customer.Region));
            command.Parameters.Add(DataLayer.CreateParameter("PostalCode", customer.PostalCode));
            command.Parameters.Add(DataLayer.CreateParameter("Country", customer.Country));
            command.Parameters.Add(DataLayer.CreateParameter("Phone", customer.Phone));
            command.Parameters.Add(DataLayer.CreateParameter("Fax", customer.Fax));

            return DataLayer.ExecuteNonQuery(command);
        }

        public static int UpdateCustomer(Customer customer)
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "UPDATE Customers SET CustomerID = ?, CompanyName = ?, ContactName = ?, ContactTitle = ?, " +
                "Address = ?, City = ?, Region = ?, PostalCode = ?, Country = ?, Phone = ?, Fax = ? WHERE CustomerID = ?";
           
            command.Parameters.Add(DataLayer.CreateParameter("CustomerID", customer.CustomerID));
            command.Parameters.Add(DataLayer.CreateParameter("CompanyName", customer.CompanyName));
            command.Parameters.Add(DataLayer.CreateParameter("ContactName", customer.ContactName));
            command.Parameters.Add(DataLayer.CreateParameter("ContactTitle", customer.ContactTitle));
            command.Parameters.Add(DataLayer.CreateParameter("Address", customer.Address));
            command.Parameters.Add(DataLayer.CreateParameter("City", customer.City));
            command.Parameters.Add(DataLayer.CreateParameter("Region", customer.Region));
            command.Parameters.Add(DataLayer.CreateParameter("PostalCode", customer.PostalCode));
            command.Parameters.Add(DataLayer.CreateParameter("Country", customer.Country));
            command.Parameters.Add(DataLayer.CreateParameter("Phone", customer.Phone));
            command.Parameters.Add(DataLayer.CreateParameter("Fax", customer.Fax));
            command.Parameters.Add(DataLayer.CreateParameter("OriginalCustomerID", customer.CustomerID));
            command.Connection = DataLayer.Connection;

            return DataLayer.ExecuteNonQuery(command);
        }

        public static int DeleteCustomer(Customer customer)
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "DELETE FROM Customers WHERE CustomerID = ?";
            command.Connection = DataLayer.Connection;
            command.Parameters.Add(DataLayer.CreateParameter("OriginalCustomerID", customer.CustomerID));

            return DataLayer.ExecuteNonQuery(command);
        }

        #endregion

        #region Orders DataLayer

        private static Order CreateOrderData(OleDbDataReader dataReader)
        {
            Order order = new Order();
            order.OrderID = dataReader.IsDBNull(0) ? 0 : dataReader.GetInt32(0);
            order.CustomerID = dataReader.IsDBNull(1) ? string.Empty : dataReader.GetString(1);
            order.EmployeeID = dataReader.IsDBNull(2) ? 0 : dataReader.GetInt32(2);
            order.OrderDate = dataReader.IsDBNull(3) ? DateTime.MinValue : dataReader.GetDateTime(3);
            order.RequiredDate = dataReader.IsDBNull(4) ? DateTime.MinValue : dataReader.GetDateTime(4);
            order.ShippedDate = dataReader.IsDBNull(5) ? DateTime.MinValue : dataReader.GetDateTime(5);
            order.ShipVia = dataReader.IsDBNull(6) ? 0 : dataReader.GetInt32(6);
            order.Freight = dataReader.IsDBNull(7) ? 0.0M : dataReader.GetDecimal(7);
            order.ShipName = dataReader.IsDBNull(8) ? string.Empty : dataReader.GetString(8);
            order.ShipAddress = dataReader.IsDBNull(9) ? string.Empty : dataReader.GetString(9);
            order.ShipCity = dataReader.IsDBNull(10) ? string.Empty : dataReader.GetString(10);
            order.ShipRegion = dataReader.IsDBNull(11) ? string.Empty : dataReader.GetString(11);
            order.ShipPostalCode = dataReader.IsDBNull(12) ? string.Empty : dataReader.GetString(12);
            order.ShipCountry = dataReader.IsDBNull(13) ? string.Empty : dataReader.GetString(13);

            return order;
        }

        public static OrderCollection GetOrders()
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "SELECT OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry FROM Orders";
            command.Connection = DataLayer.Connection;

            OrderCollection orders = new OrderCollection();
            try
            {
                command.Connection.Open();

                OleDbDataReader dataReader = command.ExecuteReader();
                while (dataReader.Read())
                {
                    Order order = DataLayer.CreateOrderData(dataReader);
                    orders.Add(order);
                }
            }
            finally
            {
                command.Connection.Close();
            }

            return orders;
        }

        public static OrderCollection GetOrders(string customerID)
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "SELECT OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry FROM Orders WHERE CustomerID = ?";
            command.Parameters.Add(DataLayer.CreateParameter("CustomerID", customerID));
            command.Connection = DataLayer.Connection;

            OrderCollection orders = new OrderCollection();
            try
            {
                command.Connection.Open();

                OleDbDataReader dataReader = command.ExecuteReader();
                while (dataReader.Read())
                {
                    Order order = DataLayer.CreateOrderData(dataReader);
                    orders.Add(order);
                }
            }
            finally
            {
                command.Connection.Close();
            }

            return orders;
        }

        public static OrderCollection GetOrders(int orderID)
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "SELECT OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry FROM Orders WHERE OrderID = ?";
            command.Parameters.Add(DataLayer.CreateParameter("OrderID", orderID));
            command.Connection = DataLayer.Connection;

            OrderCollection orders = new OrderCollection();
            try
            {
                command.Connection.Open();

                OleDbDataReader dataReader = command.ExecuteReader();
                while (dataReader.Read())
                {
                    Order order = DataLayer.CreateOrderData(dataReader);
                    orders.Add(order);
                }
            }
            finally
            {
                command.Connection.Close();
            }

            return orders;
        }

        public static int InsertOrder(Order order)
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "INSERT INTO Orders (CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";                       
            command.Connection = DataLayer.Connection;
            command.Parameters.Add(DataLayer.CreateParameter("CustomerID", order.CustomerID));
            command.Parameters.Add(DataLayer.CreateParameter("EmployeeID", order.EmployeeID));
            command.Parameters.Add(DataLayer.CreateParameter("OrderDate", order.OrderDate));
            command.Parameters.Add(DataLayer.CreateParameter("RequiredDate", order.RequiredDate));
            command.Parameters.Add(DataLayer.CreateParameter("ShippedDate", order.ShippedDate));
            command.Parameters.Add(DataLayer.CreateParameter("ShipVia", order.ShipVia));
            command.Parameters.Add(DataLayer.CreateParameter("Freight", order.Freight));
            command.Parameters.Add(DataLayer.CreateParameter("ShipName", order.ShipName));
            command.Parameters.Add(DataLayer.CreateParameter("ShipAddress", order.ShipAddress));
            command.Parameters.Add(DataLayer.CreateParameter("ShipCity", order.ShipCity));
            command.Parameters.Add(DataLayer.CreateParameter("ShipRegion", order.ShipRegion));
            command.Parameters.Add(DataLayer.CreateParameter("ShipPostalCode", order.ShipPostalCode));
            command.Parameters.Add(DataLayer.CreateParameter("ShipCountry", order.ShipCountry));

            return DataLayer.ExecuteNonQuery(command);
        }

        public static int UpdateOrder(Order order)
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "UPDATE Orders SET CustomerID = ?, EmployeeID = ?, OrderDate = ?, RequiredDate = ?, ShippedDate = ?, " +
                "ShipVia = ?, Freight = ?, ShipName = ?, ShipAddress = ?, ShipCity = ?, ShipRegion = ?, ShipPostalCode = ?, ShipCountry = ? WHERE OrderID = ?";
            command.Connection = DataLayer.Connection;
            command.Parameters.Add(DataLayer.CreateParameter("CustomerID", order.CustomerID));
            command.Parameters.Add(DataLayer.CreateParameter("EmployeeID", order.EmployeeID));
            command.Parameters.Add(DataLayer.CreateParameter("OrderDate", order.OrderDate));
            command.Parameters.Add(DataLayer.CreateParameter("RequiredDate", order.RequiredDate));
            command.Parameters.Add(DataLayer.CreateParameter("ShippedDate", order.ShippedDate));
            command.Parameters.Add(DataLayer.CreateParameter("ShipVia", order.ShipVia));
            command.Parameters.Add(DataLayer.CreateParameter("Freight", order.Freight));
            command.Parameters.Add(DataLayer.CreateParameter("ShipName", order.ShipName));
            command.Parameters.Add(DataLayer.CreateParameter("ShipAddress", order.ShipAddress));
            command.Parameters.Add(DataLayer.CreateParameter("ShipCity", order.ShipCity));
            command.Parameters.Add(DataLayer.CreateParameter("ShipRegion", order.ShipRegion));
            command.Parameters.Add(DataLayer.CreateParameter("ShipPostalCode", order.ShipPostalCode));
            command.Parameters.Add(DataLayer.CreateParameter("ShipCountry", order.ShipCountry));
            command.Parameters.Add(DataLayer.CreateParameter("OriginalOrderID", order.OrderID));

            return DataLayer.ExecuteNonQuery(command);
        }

        public static int DeleteOrder(Order order)
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "DELETE FROM Orders WHERE OrderID = ?";
            command.Connection = DataLayer.Connection;
            command.Parameters.Add(DataLayer.CreateParameter("OriginalOrderID", order.OrderID));

            return DataLayer.ExecuteNonQuery(command);
        }

        #endregion

        #region Order Details DataLayer

        private static OrderDetail CreateOrderDetailData(OleDbDataReader dataReader)
        {
            OrderDetail orderDetail = new OrderDetail();
            orderDetail.OrderID = dataReader.IsDBNull(0) ? 0 : dataReader.GetInt32(0);
            orderDetail.ProductID = dataReader.IsDBNull(1) ? 0 : dataReader.GetInt32(1);
            orderDetail.UnitPrice = dataReader.IsDBNull(2) ? 0.0M : dataReader.GetDecimal(2);
            orderDetail.Quantity = dataReader.IsDBNull(3) ? (short)0 : dataReader.GetInt16(3);
            orderDetail.Discount = dataReader.IsDBNull(4) ? 0 : dataReader.GetFloat(4);

            return orderDetail;
        }

        public static OrderDetailCollection GetOrderDetails()
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "SELECT OrderID, ProductID, UnitPrice, Quantity, Discount FROM [Order Details]";
            command.Connection = DataLayer.Connection;

            OrderDetailCollection orderDetails = new OrderDetailCollection();
            try
            {
                command.Connection.Open();

                OleDbDataReader dataReader = command.ExecuteReader();
                while (dataReader.Read())
                {
                    OrderDetail order = DataLayer.CreateOrderDetailData(dataReader);
                    orderDetails.Add(order);
                }
            }
            finally
            {
                command.Connection.Close();
            }

            return orderDetails;
        }

        public static OrderDetailCollection GetOrderDetails(int orderID, int productID)
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "SELECT OrderID, ProductID, UnitPrice, Quantity, Discount FROM [Order Details] WHERE OrderID = ? AND ProductID = ? ";
            command.Parameters.Add(DataLayer.CreateParameter("OrderID", orderID));
            command.Parameters.Add(DataLayer.CreateParameter("ProductID", productID));
            command.Connection = DataLayer.Connection;

            OrderDetailCollection orderDetails = new OrderDetailCollection();
            try
            {
                command.Connection.Open();

                OleDbDataReader dataReader = command.ExecuteReader();
                while (dataReader.Read())
                {
                    OrderDetail order = DataLayer.CreateOrderDetailData(dataReader);
                    orderDetails.Add(order);
                }
            }
            finally
            {
                command.Connection.Close();
            }

            return orderDetails;
        }

        public static OrderDetailCollection GetOrderDetails(int orderID)
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "SELECT OrderID, ProductID, UnitPrice, Quantity, Discount FROM [Order Details] WHERE OrderID = ?";
            command.Parameters.Add(DataLayer.CreateParameter("OrderID", orderID));
            command.Connection = DataLayer.Connection;

            OrderDetailCollection orderDetails = new OrderDetailCollection();
            try
            {
                command.Connection.Open();

                OleDbDataReader dataReader = command.ExecuteReader();
                while (dataReader.Read())
                {
                    OrderDetail order = DataLayer.CreateOrderDetailData(dataReader);
                    orderDetails.Add(order);
                }
            }
            finally
            {
                command.Connection.Close();
            }

            return orderDetails;
        }

        public static int InsertOrderDetail(OrderDetail orderDetail)
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "INSERT INTO [Order Details] (OrderID, ProductID, UnitPrice, Quantity, Discount) VALUES (?, ?, ?, ?, ?)";
            command.Connection = DataLayer.Connection;
            command.Parameters.Add(DataLayer.CreateParameter("OrderID", orderDetail.OrderID));
            command.Parameters.Add(DataLayer.CreateParameter("ProductID", orderDetail.ProductID));
            command.Parameters.Add(DataLayer.CreateParameter("UnitPrice", orderDetail.UnitPrice));
            command.Parameters.Add(DataLayer.CreateParameter("Quantity", orderDetail.Quantity));
            command.Parameters.Add(DataLayer.CreateParameter("Discount", orderDetail.Discount));

            return DataLayer.ExecuteNonQuery(command);
        }

        public static int UpdateOrderDetail(OrderDetail orderDetail)
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "UPDATE [Order Details] SET ProductID = ?, UnitPrice = ?, Quantity = ?, Discount = ? WHERE OrderID = ?";
            command.Connection = DataLayer.Connection;           
            command.Parameters.Add(DataLayer.CreateParameter("ProductID", orderDetail.ProductID));
            command.Parameters.Add(DataLayer.CreateParameter("UnitPrice", orderDetail.UnitPrice));
            command.Parameters.Add(DataLayer.CreateParameter("Quantity", orderDetail.Quantity));
            command.Parameters.Add(DataLayer.CreateParameter("Discount", orderDetail.Discount));
            command.Parameters.Add(DataLayer.CreateParameter("OrderID", orderDetail.OrderID));

            return DataLayer.ExecuteNonQuery(command);
        }

        public static int DeleteOrderDetail(OrderDetail orderDetail)
        {
            OleDbCommand command = new OleDbCommand();
            command.CommandText = "DELETE FROM [Order Details] WHERE OrderID = ?";
            command.Connection = DataLayer.Connection;
            command.Parameters.Add(DataLayer.CreateParameter("OriginalOrderID", orderDetail.OrderID));

            return DataLayer.ExecuteNonQuery(command);
        }
        #endregion

    }

 

Asp.Net 对数据库进行操作
白鹭立雪的博客
03-02 1447
前一段时间用到了 .net core, 并且使用了Entity Framework Core来进行数据库的操作。在此记录一下基本的操作内容，便于以后使用。 创建数据库 首先使用以下sql语句建立一张数据表： CREATE TABLE `account` ( `id` int(11) NOT NULL AUTO_INCREMENT, `userId` varchar(255) DEFAULT...
ASP.NET程序与数据库设计入门及应用实例下载源代码
05-28
ASP.NET程序与数据库设计入门及应用实例下载源代码<br/> 我还没看.不知道怎么样.
asp.net中读取数据库数据代码
08-08 141
SqlConnection conn = BaseClass.DBCon(); conn.Open(); SqlCommand cmd = new SqlCommand("select * from tb_Student where StudentNum='" + Session["ID"].ToString() + "'",...
ASP.NET数据库操作实例
rorelys的专栏
08-30 695
 public static bool insertPerson(Person p)    {                try        {            SqlConnection con = DBCon.createConnection();            con.Open();            SqlCommand cmd 
最简单的ASP.NET数据库操作示例源代码
u011877729的专栏
08-30 614
using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.
asp.net Oracle数据库访问操作类
01-01
代码如下:using System;using System.Collections;using System.Collections.Specialized;using System.Data;using System.Data.OracleClient;using System.Configuration;using System.Data.Common;using System....
ASP.NET 4.5 数据库入门经典 第3版
12-19
《ASP.NET 4.5 数据库入门经典》第三版是一本专为初学者设计的教程，旨在帮助读者快速掌握ASP.NET 4.5框架下的数据库编程技术。这本书以通俗易懂的方式介绍了诸多关键概念和实践技巧，使得读者即使在没有深入接触过...
ASP.NET中数据库操作初步
01-20
ASP.NET 是一种用于构建 Web 应用程序的框架，它提供了丰富的功能来处理数据库操作。在 ASP.NET 中，我们可以使用 ADO.NET 组件与数据库进行交互，如 `OleDbConnection` 和 `OleDbCommand` 对象，它们是 .NET ...
asp.net连接数据库的代码
06-04
你可以下载下来参考学习，理解并实践这些代码，有助于深入掌握ASP.NET中的数据库操作。 总之，ASP.NET提供了强大的工具和类库来处理数据库连接，通过理解和实践，开发者可以轻松地实现与各种数据库（如SQL Server、...
asp.net+sql数据库学生成绩管理系统源码
01-23
【工控老马出品，必属精品，亲测校正，质量保证】 资源名：asp.net+sql数据库学生成绩...源码说明： 基于asp.net编写的学生成绩管理系统 包含完整代码和数据库 很适合借鉴学习 适合人群：新手及有一定经验的开发人员
ASP.NET数据库连接实例
minjie0402的专栏
12-12 527
using System;using System.Collections;using System.ComponentModel;using System.Data;using System.Drawing;using System.Web;using System.Web.SessionState;using System.Web.UI;using System.Web.UI.WebContr
ASP.NET常用代码
南京晓庄学院 吴心亚(Net学生)
06-05 312
ASP.NET的数据查询参数
浓汤拉面的专栏
03-11 852
一、SelectCommand生命周期（生效位置） `pageLoad `控件事件 `AccessDataSource.Selecting事件 也就是说，在按钮事件中改变SelectCommand的值，也会在本次刷新中生效。 而且被保留在AccessDataSource中。 二、SelectParameters(查询参数) Session值 Cookie值 控件值
Asp.net常用的51个代码（值得收藏）
Alex 的程序园地
10-12 1237
1.弹出对话框.点击转向指定页面 Code: Response.Write("<script>window.alert('该会员没有提交申请,请重新提交！')</script>"); Response.Write("<script>window.location ='http://www.msproject.cn/index.asp'</script>"); 2.弹出对话框 Code: Response.Write("<script lan
ASP.NET操作mysql数据库的实例（傻瓜都能看懂，已测试过）
【敦厚的曹操】的专栏
11-29 6372
ASP.NET操作mysql数据库的实例（傻瓜都能看懂，已测试过）
ASP.NET 连接数据库 增删改查简单实例
热门推荐
lqadam的博客
03-12 4万+
本文主要讲解连接ASP.NET 连接数据库最简单的方法和增删改查的小例子，因为只涉及到一个页面，所以没有使用web.config，以及使用DBHelper，旨在让读者们抛开封装好的东西，了解实际代码。
最简单的asp.net 操作 access 数据库方法
阿勇的博客
02-25 1万+
在asp.net中，使用C#操作access的mdb数据库，简单实用，只需要几步就可以实现。 1、新建一个asp.net网站，作为整个程序的表现层，里面的aspx文件可以调用其他层的项目。 2、建立一个数据库操作项目，命名为DBUtility，项目中只包含一个操作access数据库的类文件DbHelperOleDb.cs即可。 3、将网站引用DBUtility项目，这样，网站中的任何aspx
ASP.NET连接数据库代码技巧大集合
由于压缩包文件名中只给出了“C#连接数据库代码 - 51CTO.COM_files”，我们可以推测出代码示例是以C#编写的，这符合ASP.NET常见的开发语言之一。 在接下来的内容中，我将详细介绍ASP.NET环境中数据库连接的知识点，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值