Example:
public static DataTable GetEmployee(string employeeName)
{
try {
Database db = DatabaseFactory.CreateDatabase("DataBase ConnectionString");
SqlCommand sqlCommand = new SqlCommand("select * from employee where name like @name");
db.AddInParameter(sqlCommand, "name", DbType.String, employeeName);
return db.ExecuteDataSet(sqlCommand.Tables(0));
}
catch (Exception ex) {
throw;
}
}