Hi,
I am using this code to populate data into datagridview and i want to add a simple checkbox column which is not related to any field in the database but it will be used for the staffto select the visit and make the payments for the selected visits only.
how can i do that
public void get_visits()
{
this.Cursor = Cursors.WaitCursor;
data_table = new DataTable();
// sql_connection = new SqlConnection("Data Source=.\\SQLEXPRESS;initial catalog=shefa;integrated security=true");
sql_connection = new SqlConnection(public_var.sql_connection);
sql_command = new SqlCommand("sp_get_patient_visits", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;
sql_command.Parameters.Add("@file_no", SqlDbType.Int).Value = file_no;
sql_adapter = new SqlDataAdapter(sql_command);
sql_adapter.Fill(data_table);
dataVisits.DataSource = data_table;
dataVisits.Columns["visit_id"].HeaderText = "insurance id";
dataVisits.Columns["visit_id"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopRight;
dataVisits.Columns["visit_id"].Visible = false;
dataVisits.Columns["created_date"].HeaderText = "Visit Created";
dataVisits.Columns["created_date"].DefaultCellStyle.Format = "ddd dd MMM yyyy HH:mm";
dataVisits.Columns["created_date"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
dataVisits.Columns["created_date"].Width = 160;
dataVisits.Columns["direct_or_insurance"].HeaderText = "Payment";
dataVisits.Columns["direct_or_insurance"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
dataVisits.Columns["direct_or_insurance"].Width = 120;
dataVisits.Columns["visit_total_amount"].HeaderText = "Total Amount";
dataVisits.Columns["visit_total_amount"].DefaultCellStyle.Format = "BD #,###,0.000";
dataVisits.Columns["visit_total_amount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
dataVisits.Columns["visit_total_amount"].Width = 120;
dataVisits.Columns["visit_closing_paid"].HeaderText = "Paid Amount";
dataVisits.Columns["visit_closing_paid"].DefaultCellStyle.Format = "BD #,###,0.000";
dataVisits.Columns["visit_closing_paid"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
dataVisits.Columns["visit_closing_paid"].Width = 120;
dataVisits.Columns["visit_is_open"].HeaderText = "Open ";
dataVisits.Columns["visit_is_open"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
dataVisits.Columns["visit_is_open"].Width = 120;
// dataVisits.Refresh();
if (file_is_open == "N")
{
toolOpenCloseFile.Visible = true;
toolVitalSigns.Visible = false;
toolPayment.Visible = false;
}
else
{
toolOpenCloseFile.Visible = false;
toolVitalSigns.Visible = true;
toolPayment.Visible = true;
}
}