private void SelectParts(string machineMaintId)
{
try
{
using (var sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.OpenAsync();
var dynamicParameters = new DynamicParameters();
dynamicParameters.Add("machine_maint_id", machineMaintId, DbType.String, ParameterDirection.Input);
IEnumerable <ScannerData> result = sqlConnection.Query <ScannerData>(
"sp_machine_maint_parts_select",
dynamicParameters,
commandType: CommandType.StoredProcedure);
GridViewMachineMaintParts.DataSource = result;
GridViewMachineMaintParts.DataBind();
}
}
catch (Exception e)
{
SetErrorMessage("Error: " + e.Message);
}
}
private void ClearParts()
{
GridViewMachineMaintParts.DataSource = null;
GridViewMachineMaintParts.DataBind();
ClearErrorMessage();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GridViewMachineMaint.DataSource = null;
GridViewMachineMaint.DataBind();
GridViewMachineMaintParts.DataSource = null;
GridViewMachineMaintParts.DataBind();
return;
}
;
}
