DAL
SqlParameter[] sqlParameter =
{
new SqlParameter("@name",name),
new SqlParameter("@phone",phone)
};
dbhelper
```csharp
public static DataTable Select(string sql,params SqlParameter[] sqlParameters)
{
using(SqlDataAdapter adapter = new SqlDataAdapter(sql, connstr))
{
if(sqlParameters !=null && sqlParameters.Count() > 0)
adapter.SelectCommand.Parameters.AddRange(sqlParameters);
using(DataTable table = new DataTable())
{
adapter.Fill(table);
return table;
}
}
}