C#

PARAMETERS comId Guid, subprojId Guid;
SELECT Community.CommunityID, Community.CommunityCode, Subproject.SubprojectID, Subproject.SubprojectCode, IIf(Subproject.SubprojectStatusID In (1,2,4),Subproject.PlannedNSPBudgetAFA,IIf(Subproject.SubprojectStatusID In (3,5,6),Subproject.ActualNSPBudgetAFA,0)) AS TotalSubProjectBudget, zSubprojectStatus.SubprojectStatus, Subproject.SubprojectStatusID, Subproject.PlannedCDCBudgetAFA, Subproject.PlannedStartDate, Subproject.PlannedEndDate, Subproject.DateForm7Filled, Subproject.ActualNSPBudgetAFA, Subproject.ActualCDCBudgetAFA, Subproject.ActualStartDate, Subproject.ActualEndDate, Subproject.PMUSFSRApprovalDate, Subproject.ActualSkilledLabors, Subproject.ActualUnSkilledLabors, Subproject.SubprojectCompletionReason, Community.BGEntitlementAFA, Subproject.PlannedNSPBudgetAFA, vw_getPaidInstallments.PaidActualNSPAmountAFA AS PaidInstallmentAFA, IIf(IsNull([vw_getRemainingCDCBudget].[RBGE]),[BGEntitlementAFA],[vw_getRemainingCDCBudget.RBGE]) AS RemainingBG
FROM (Community INNER JOIN vw_getRemainingCDCBudget ON Community.CommunityID = vw_getRemainingCDCBudget.CommunityID) INNER JOIN ((Subproject INNER JOIN zSubprojectStatus ON Subproject.SubprojectStatusID = zSubprojectStatus.SubprojectStatusID) LEFT JOIN vw_getPaidInstallments ON Subproject.SubprojectID = vw_getPaidInstallments.SubprojectID) ON Community.CommunityID = Subproject.CommunityID
WHERE (((Community.CommunityID)=[comId]) AND ((Subproject.SubprojectID)=[subprojId]) AND ((Subproject.SubprojectStatusID) In (1,2,3,4)));

private void btnOptionSaveChanges_Click(object sender, EventArgs e)
        {
            //http://support.microsoft.com/kb/307587
            //http://bytes.com/topic/c-sharp/answers/251248-reading-dataset
            //http://support.microsoft.com/kb/307587
            SQLObjects MySQLObjects = new SQLObjects();

                if (StandardProcedures.SQL_TestConnection(WhatIsMyConnectionString) == false)
                {
                    MessageBox.Show("There is an issue with the application's connection string or ability to communicate with SQL Server! No Changes will be made.");
                    //Environment.Exit(-1);
                    return;
                }
                if (!StandardProcedures.SQL_CheckToSeeIfTheObjectAlreadyExistsInSQLServer(WhatIsMyConnectionString, MySQLObjects.Table, "tblSoftwareControls"))
                {
                    MessageBox.Show("tblSoftwareControls table does not exist in the Database. No Changes will be made");
                    //Environment.Exit(-1);
                    return;
                }
                //string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
                //string sql = @"select top 1 * from tblSoftwareControls";
                //string sql = @"SELECT CompanyName, CopyRight, ConnectionString, SplashScreenTimer, SplashScreenImage, VersionOverride FROM tblSoftwareControls";
                string sql = @"SELECT * FROM tblSoftwareControls";
                
                SqlConnection conn = new SqlConnection(WhatIsMyConnectionString);

                try
                {
                    conn.Open();
                    SqlDataAdapter da = new SqlDataAdapter(sql, conn);
                    DataSet ds = new DataSet();
                    da.FillSchema(ds, SchemaType.Source, "tblSoftwareControls");
                    da.Fill(ds, "tblSoftwareControls");
                    //**************************************

                    //Update the dataset
                    DataTable dt = ds.Tables["tblSoftwareControls"];
                    DataRow dr;
                    if (dt.Rows.Count > 0)
                    {
                        dr = dt.Rows[0];
                        dr.BeginEdit();
                        dr["ConnectionString"] = txtApplicationConnectionString.Text;
                        dr["SplashScreenTimer"] = txtSplashScreenTimer.Text;
                        dr["VersionOverride"] = ckbxOverrideVersionByPass.Checked;
                        dr.EndEdit();
                        StandardProcedures.DebugLogWriter("Updated the record in tblSoftwareControls!");
                    }
                    else
                    {
                        dr = dt.NewRow();
                        dr["ConnectionString"] = txtApplicationConnectionString.Text;
                        dr["SplashScreenTimer"] = txtSplashScreenTimer.Text;
                        dr["VersionOverride"] = ckbxOverrideVersionByPass.Checked;
                        
                        //Pass the new object into the add method of the datatable
                        dt.Rows.Add(dr);
                        StandardProcedures.DebugLogWriter("Wrote a new record to tblSoftwareControls!");
                    }
                    //**************************************

                    //Update the sql database by sending it the data in the dataset.
                    // BEGIN SEND CHANGES TO SQL SERVER 

                    SqlCommandBuilder objCommandBuilder = new SqlCommandBuilder(da);
                    da.Update(ds, "tblSoftwareControls");
                    StandardProcedures.DebugLogWriter("DataSet modifications or additions or deletions has the modifications applied to the SQL Server Table.");
                    // END SEND CHANGES TO SQL SERVER
                        



                        /*

                    foreach (DataRow dr in dt.Rows)
                    {
                        txtApplicationConnectionString.Text = dr["ConnectionString"].ToString();
                        txtSplashScreenTimer.Text = dr["SplashScreenTimer"].ToString();
                        ckbxOverrideVersionByPass.Checked = StandardProcedures.Convert_TrueFalse(dr["VersionOverride"].ToString());
                    }
                    DataTable dt = ds.Tables["tblSoftwareControls"];
                    txtApplicationConnectionString.Text = dt.Columns["ConnectionString"].;
                    txtSplashScreenTimer.Text = dt.Columns["SplashScreenTimer"].;
                    ckbxOverrideVersionByPass.Checked = StandardProcedures.Convert_TrueFalse(dt.Columns["VersionOverride"]);
                    */
                }
                catch (Exception ex)
                {
                    StandardProcedures.ErrorLogWriter("Trying to populate the Options Tab: " + ex.ToString());    
                }
                finally
                {
                    conn.Close();
                }
        }