如何使用sqlhelper [英] how to use sqlhelper

问题描述

这是业务逻辑中的代码可以告诉你如何编写sqlhelper

this is the code in business logic can you tell how to write sqlhelper

public class BusinessLogic
    {
       string name, gender, city;
       public string Name
       {
           get { return name; }
           set { name = value; }
       }
       public string Gender
       {
           get { return gender; }
           set { gender = value; }
       }
       public string City
       {
           get { return city; }
           set { city = value; }
       }
       int id;
       public int Id
       {
           get { return id; }
           set { value = id; }
       }
       public void AddEmployee()
       {
           SqlParameter[] p=new SqlParameter[4];
           p[0] = new SqlParameter("@EmployeeId", this.id);
           p[0].DbType = DbType.String;
           p[1] = new SqlParameter("@Name",this.name);
           p[1].DbType = DbType.String;
           p[2] = new SqlParameter("@Gender",this.gender);
           p[2].DbType = DbType.String;
           p[3] = new SqlParameter("@City",this.city);
       }

推荐答案

取决于SQLHelper的实现方式。

通过使用命令参数，你似乎走在了正确的轨道上。

Depends on how SQLHelper has been implemented.
By using command parameters, you seem to be on the right track.

这篇关于如何使用sqlhelper的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！