问题描述
在我解释我的问题时,请多多包涵.我认为这会更有意义.谢谢:
我在SQL Server 2005中有一个表,该表具有三列CustomerID(整数,身份),Name(varchar(50)和Address(varchar(50)).我为该表创建了四个存储过程(CustomerSelect,CustomerInsert,CustomerDelete和CustomerUpdate).
在VS 2008中,我使用Settings.settings创建了到表的连接字符串.然后,我使用以下代码创建了一个数据访问类,以使我能够销售并查看数据库中的客户:
Please bear with me while i explain my question. I think it will make more sense. Thank you:
I have a table in SQL server 2005 with three columns CustomerID (integer, identity), Name(varchar(50) and Address(varchar(50). I created four stored procedures for the table (CustomerSelect, CustomerInsert, CustomerDelete and CustomerUpdate).
In VS 2008, i created a connection string to the table using Settings.settings. I then created a Data Access Class with the following code to enable me sellect and view a customer in the database:
public class CustomerDAL
{
private string connectionString = Properties.Settings.Default.BranchAppConnString;
public Branch SelectCustomer(int ID)
{
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("CustomerSelect", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CustomerID", ID);
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
Customer customer = new Customer((string)reader["customerName"], (string)reader["address"]);
return (customer);
}
else
{
return null;
}
}
finally
{
conn.Close();
}
}
现在,我使用客户实体的属性创建了数据类.我还使用部分类向应用程序公开了CustomerDAL类.现在,这很好用.我可以在文本框中插入一个客户ID,然后单击一个botton以查看该客户.
我的问题是:如何通过相同的存储过程使用相同的模式来插入,删除和更新客户表?
请帮我解决一下这个.谢谢
Now i created Data Class with the properties for the Customer Entity. I also exposed the CustomerDAL class to the application using a partial class. Now this works just fine. I can insert a Customer ID in a text box and click a botton to view the customer.
My question is: How can i use the same pattern to insert, delete and update the customer table via the corresponding stored procedures?
Please help me with this. Thanks
推荐答案
这篇关于如何通过WPF中的存储过程更新SQL数据库?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!