Comments by envprogrammer (Top 16 by date)

Reason for my vote of 5
Automatic vote of 5 for accepting answer.

In the form designer:
//
// resultdataGridView1
//
this.resultdataGridView1.AutoGenerateColumns = false;
this.resultdataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.resultdataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.chemical_name,
this.casrnDataGridViewTextBoxColumn,
this.resulttextDataGridViewTextBoxColumn,
this.interpreted_qualifiers,
this.remark,
this.validatorqualifiersDataGridViewTextBoxColumn,
this.methoddetectionlimitDataGridViewTextBoxColumn,
this.reportingdetectionlimitDataGridViewTextBoxColumn,
this.detectflagDataGridViewTextBoxColumn,
this.reportableresultDataGridViewTextBoxColumn,
this.quantitationlimitDataGridViewTextBoxColumn,
this.resultunitDataGridViewTextBoxColumn});
this.resultdataGridView1.DataSource = this.dt_resultBindingSource;
this.resultdataGridView1.Location = new System.Drawing.Point(39, 523);
this.resultdataGridView1.Name = "resultdataGridView1";
this.resultdataGridView1.Size = new System.Drawing.Size(951, 150);
this.resultdataGridView1.TabIndex = 19;
this.resultdataGridView1.RowLeave += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridView1_RowLeave);
//


In DataSet Designer:
<dbsource connectionref="SpectraConnectionString (Settings)" dbobjecttype="Unknown" fillmethodmodifier="Public" fillmethodname="FillByTestandFacID" generatemethods="Both" generateshortcommands="true" generatorgetmethodname="GetDataBy2TestID" generatorsourcename="FillByTestandFacID" getmethodmodifier="Public" getmethodname="GetDataBy2TestID" querytype="Rowset" scalarcallretval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" useoptimisticconcurrency="true" usergetmethodname="GetDataBy2TestID" usersourcename="FillByTestandFacID">
<selectcommand>
<dbcommand commandtype="Text" modifiedbyuser="true">
<commandtext>SELECT rt_analyte.chemical_name, dt_result.cas_rn, dt_result.result_text, dt_result.interpreted_qualifiers, dt_result.remark, dt_result.validator_qualifiers,
dt_result.method_detection_limit, dt_result.reporting_detection_limit, dt_result.detect_flag, dt_result.reportable_result, dt_result.quantitation_limit,
dt_result.result_unit
FROM dt_result INNER JOIN
rt_analyte ON dt_result.cas_rn =rt_analyte.cas_rn
WHERE (dt_result.test_id = @test_id) AND (dt_result.facility_id = @facility_id)
<parameters>
<parameter allowdbnull="false" autogeneratedname="test_id" columnname="test_id" datasourcename="Spectra.dbo.dt_result" datatypeserver="int" dbtype="Int32" direction="Input" parametername="@test_id" precision="0" providertype="Int" scale="0" size="4" sourcecolumn="test_id" sourcecolumnnullmapping="false" sourceversion="Current">
<parameter allowdbnull="false" autogeneratedname="facility_id" columnname="facility_id" datasourcename="Spectra.dbo.dt_result" datatypeserver="int" dbtype="Int32" direction="Input" parametername="@facility_id" precision="0" providertype="Int" scale="0" size="4" sourcecolumn="facility_id" sourcecolumnnullmapping="false" sourceversion="Current">

Thank you for your reply. I changed the names of the columns and deleted some variables--so i don't think the datagridview should be autogenerated. Does anyone know if that could create an error?

Reason for my vote of 5
Automatic vote of 5 for accepting answer.