Posted on 17 Jun 2015
Requirement Year Qtr.1 Q1IntProc Q1IntProj
CMMICAMSG1 2015 7 4 1
Q1ExtBSI Q1ExtCMMI
0 2
I am trying to sum several fields into one.
This code is giving me the I am getting the Object reference not set to an instance of an object error here:
int lblQtr1 = int.Parse(Q1IntProc.Text) + int.Parse(Q1IntProj.Text) + int.Parse(Q1ExtBSI.Text) + int.Parse(Q1ExtCMMI.Text);
protected void gvInternalAudit_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label Qtr1 = (Label)e.Row.FindControl("lblQtr1");
Label Q1IntProc = (Label)e.Row.FindControl("lblQ1IntProc");
Label Q1IntProj = (Label)e.Row.FindControl("lblQ1IntProj");
Label Q1ExtBSI = (Label)e.Row.FindControl("lblQ1ExtBSI");
Label Q1ExtCMMI = (Label)e.Row.FindControl("lblQ1ExtCMMI");
int lblQtr1 = int.Parse(Q1IntProc.Text) + int.Parse(Q1IntProj.Text) + int.Parse(Q1ExtBSI.Text) + int.Parse(Q1ExtCMMI.Text);
Qtr1.Text = lblQtr1.ToString();
}
}
Here is all of my code:
using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Drawing;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.UI.WebControls.WebParts;
namespace HIMSLA.InternalAudit
{
public partial class InternalAuditUserControl : UserControl
{
public SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLMedTestConnHIM"].ConnectionString);
SqlCommand cmd = new SqlCommand();
protected void Page_Load(object sender, EventArgs e)
{
lblMsg.Text = "";
if (!Page.IsPostBack)
{
BindSubjectData();
}
}
protected void BindSubjectData()
{
using (SqlConnection sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLMedTestConnHIM"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "SELECT * FROM InternalAudit order by Requirement";
cmd.Connection = sqlCon;
sqlCon.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
gvInternalAudit.DataSource = dt;
gvInternalAudit.DataBind();
}
else
{
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
gvInternalAudit.DataSource = dt;
gvInternalAudit.DataBind();
gvInternalAudit.Rows[0].Visible = false;
}
sqlCon.Close();
}
}
}
protected void gvInternalAudit_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label Qtr1 = (Label)e.Row.FindControl("lblQtr1");
Label Q1IntProc = (Label)e.Row.FindControl("lblQ1IntProc");
Label Q1IntProj = (Label)e.Row.FindControl("lblQ1IntProj");
Label Q1ExtBSI = (Label)e.Row.FindControl("lblQ1ExtBSI");
Label Q1ExtCMMI = (Label)e.Row.FindControl("lblQ1ExtCMMI");
int lblQtr1 = int.Parse(Q1IntProc.Text) + int.Parse(Q1IntProj.Text) + int.Parse(Q1ExtBSI.Text) + int.Parse(Q1ExtCMMI.Text);
Qtr1.Text = lblQtr1.ToString();
}
}
protected void gvInternalAudit_RowEditing(object sender, GridViewEditEventArgs e)
{
gvInternalAudit.EditIndex = e.NewEditIndex;
BindSubjectData();
}
protected void gvInternalAudit_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
gvInternalAudit.EditIndex = -1;
BindSubjectData();
}
protected void gvInternalAudit_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Add")
{
bool IsAdded = false;
TextBox newRequirement =
(TextBox)gvInternalAudit.FooterRow.FindControl("newRequirement");
TextBox newYear = (TextBox)gvInternalAudit.FooterRow.FindControl("newYear");
TextBox newQtr1 = (TextBox)gvInternalAudit.FooterRow.FindControl("newQtr1");
TextBox newQ1IntProc = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ1IntProc");
TextBox newQ1IntProj = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ1IntProj");
TextBox newQ1ExtBSI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ1ExtBSI");
TextBox newQ1ExtCMMI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ1ExtCMMI");
TextBox newQtr2 = (TextBox)gvInternalAudit.FooterRow.FindControl("newQtr2");
TextBox newQ2IntProc = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ2IntProc");
TextBox newQ2IntProj = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ2IntProj");
TextBox newQ2ExtBSI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ2ExtBSI");
TextBox newQ2ExtCMMI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ2ExtCMMI");
TextBox newQtr3 = (TextBox)gvInternalAudit.FooterRow.FindControl("newQtr3");
TextBox newQ3IntProc = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ3IntProc");
TextBox newQ3IntProj = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ3IntProj");
TextBox newQ3ExtBSI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ3ExtBSI");
TextBox newQ3ExtCMMI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ3ExtCMMI");
TextBox newQtr4 = (TextBox)gvInternalAudit.FooterRow.FindControl("newQtr4");
TextBox newQ4IntProc = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ4IntProc");
TextBox newQ4IntProj = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ4IntProj");
TextBox newQ4ExtBSI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ4ExtBSI");
TextBox newQ4ExtCMMI = (TextBox)gvInternalAudit.FooterRow.FindControl("newQ4ExtCMMI");
TextBox newYearTotals = (TextBox)gvInternalAudit.FooterRow.FindControl("newYearTotals");
using (SqlConnection sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLMedTestConnHIM"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = @"INSERT INTO InternalAudit(Requirement, Year, Qtr1, Q1IntProc, Q1IntProj,Q1ExtBSI,Q1ExtCMMI,Qtr2,Q2IntProc,Q2IntProj,Q2ExtBSI,Q2ExtCMMI, Qtr3, Q3IntProc, Q3IntProj,Q3ExtBSI,Q3ExtCMMI,Qtr4, Q4IntProc, Q4IntProj,Q4ExtBSI,Q4ExtCMMI,YearTotals)
VALUES(@Requirement,@Year,@Qtr1,@Q1IntProc,@Q1IntProj,@Q1ExtBSI,@Q1ExtCMMI,@Qtr2,@Q2IntProc,@Q2IntProj,@Q2ExtBSI,@Q2ExtCMMI,@Qtr3,@Q3IntProc,@Q3IntProj,@Q3ExtBSI,@Q3ExtCMMI,@Qtr4,@Q4IntProc,@Q4IntProj,@Q4ExtBSI,@Q4ExtCMMI,@YearTotals)";
cmd.Parameters.AddWithValue("@Requirement", newRequirement.Text);
cmd.Parameters.AddWithValue("@Year", newYear.Text);
cmd.Parameters.AddWithValue("@Qtr1", newQtr1.Text);
cmd.Parameters.AddWithValue("@Q1IntProc", newQ1IntProc.Text);
cmd.Parameters.AddWithValue("@Q1IntProj", newQ1IntProj.Text);
cmd.Parameters.AddWithValue("@Q1ExtBSI", newQ1ExtBSI.Text);
cmd.Parameters.AddWithValue("@Q1ExtCMMI", newQ1ExtCMMI.Text);
cmd.Parameters.AddWithValue("@Qtr2", newQtr2.Text);
cmd.Parameters.AddWithValue("@Q2IntProc", newQ2IntProc.Text);
cmd.Parameters.AddWithValue("@Q2IntProj", newQ2IntProj.Text);
cmd.Parameters.AddWithValue("@Q2ExtBSI", newQ2ExtBSI.Text);
cmd.Parameters.AddWithValue("@Q2ExtCMMI", newQ2ExtCMMI.Text);
cmd.Parameters.AddWithValue("@Qtr3", newQtr3.Text);
cmd.Parameters.AddWithValue("@Q3IntProc", newQ3IntProc.Text);
cmd.Parameters.AddWithValue("@Q3IntProj", newQ3IntProj.Text);
cmd.Parameters.AddWithValue("@Q3ExtBSI", newQ3ExtBSI.Text);
cmd.Parameters.AddWithValue("@Q3ExtCMMI", newQ3ExtCMMI.Text);
cmd.Parameters.AddWithValue("@Qtr4", newQtr4.Text);
cmd.Parameters.AddWithValue("@Q4IntProc", newQ4IntProc.Text);
cmd.Parameters.AddWithValue("@Q4IntProj", newQ4IntProj.Text);
cmd.Parameters.AddWithValue("@Q4ExtBSI", newQ4ExtBSI.Text);
cmd.Parameters.AddWithValue("@Q4ExtCMMI", newQ4ExtCMMI.Text);
cmd.Parameters.AddWithValue("@YearTotals", newYearTotals.Text);
cmd.Connection = sqlCon;
sqlCon.Open();
IsAdded = cmd.ExecuteNonQuery() > 0;
sqlCon.Close();
}
}
if (IsAdded)
{
lblMsg.Text = "'" + newRequirement.Text + "' InternalAudit added successfully!";
lblMsg.ForeColor = System.Drawing.Color.Green;
BindSubjectData();
}
else
{
lblMsg.Text = "Error while adding '" + newRequirement.Text + "' subject details";
lblMsg.ForeColor = System.Drawing.Color.Red;
}
}
}
protected void gvInternalAudit_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
bool IsUpdated = false;
int ID =
Convert.ToInt32(gvInternalAudit.DataKeys[e.RowIndex].Value.ToString());
TextBox Requirement =
(TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtRequirement");
TextBox Year = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtYear");
TextBox Qtr1 = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQtr1");
TextBox Q1IntProc = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ1IntProc");
TextBox Q1IntProj = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ1IntProj");
TextBox Q1ExtBSI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ1ExtBSI");
TextBox Q1ExtCMMI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ1ExtCMMI");
TextBox Qtr2 = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQtr2");
TextBox Q2IntProc = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ2IntProc");
TextBox Q2IntProj = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ2IntProj");
TextBox Q2ExtBSI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ2ExtBSI");
TextBox Q2ExtCMMI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ2ExtCMMI");
TextBox Qtr3 = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQtr3");
TextBox Q3IntProc = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ3IntProc");
TextBox Q3IntProj = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ3IntProj");
TextBox Q3ExtBSI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ3ExtBSI");
TextBox Q3ExtCMMI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ3ExtCMMI");
TextBox Qtr4 = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQtr4");
TextBox Q4IntProc = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ4IntProc");
TextBox Q4IntProj = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ4IntProj");
TextBox Q4ExtBSI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ4ExtBSI");
TextBox Q4ExtCMMI = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtQ4ExtCMMI");
TextBox YearTotals = (TextBox)gvInternalAudit.Rows[e.RowIndex].FindControl("txtYearTotals");
using (SqlConnection sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLMedTestConnHIM"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = @"UPDATE InternalAudit SET Requirement=@Requirement,Year=@Year,Qtr1=@Qtr1,Q1IntProc=@Q1IntProc,Q1IntProj=@Q1IntProj,Q1ExtBSI=@Q1ExtBSI,Q1ExtCMMI=@Q1ExtCMMI, Qtr2=@Qtr2, Q2IntProc=@Q2IntProc, Q2IntProj=@Q2IntProj,Q2ExtBSI=@Q2ExtBSI, Q2ExtCMMI=@Q2ExtCMMI, Qtr3=@Qtr3, Q3IntProc=@Q3IntProc, Q3IntProj=@Q3IntProj,Q3ExtBSI=@Q3ExtBSI, Q3ExtCMMI=@Q3ExtCMMI,Qtr4=@Qtr4, Q4IntProc=@Q4IntProc, Q4IntProj=@Q4IntProj,Q4ExtBSI=@Q4ExtBSI, Q4ExtCMMI=@Q4ExtCMMI WHERE ID=@Id";
cmd.Parameters.AddWithValue("@Id", ID);
cmd.Parameters.AddWithValue("@Requirement", Requirement.Text);
cmd.Parameters.AddWithValue("@Year", Year.Text);
cmd.Parameters.AddWithValue("@Qtr1", Qtr1.Text);
cmd.Parameters.AddWithValue("@Q1IntProc", Q1IntProc.Text);
cmd.Parameters.AddWithValue("@Q1IntProj", Q1IntProj.Text);
cmd.Parameters.AddWithValue("@Q1ExtBSI", Q1ExtBSI.Text);
cmd.Parameters.AddWithValue("@Q1ExtCMMI", Q1ExtCMMI.Text);
cmd.Parameters.AddWithValue("@Qtr2", Qtr2.Text);
cmd.Parameters.AddWithValue("@Q2IntProc", Q2IntProc.Text);
cmd.Parameters.AddWithValue("@Q2IntProj", Q2IntProj.Text);
cmd.Parameters.AddWithValue("@Q2ExtBSI", Q2ExtBSI.Text);
cmd.Parameters.AddWithValue("@Q2ExtCMMI", Q2ExtCMMI.Text);
cmd.Parameters.AddWithValue("@Qtr3", Qtr3.Text);
cmd.Parameters.AddWithValue("@Q3IntProc", Q3IntProc.Text);
cmd.Parameters.AddWithValue("@Q3IntProj", Q3IntProj.Text);
cmd.Parameters.AddWithValue("@Q3ExtBSI", Q3ExtBSI.Text);
cmd.Parameters.AddWithValue("@Q3ExtCMMI", Q3ExtCMMI.Text);
cmd.Parameters.AddWithValue("@Qtr4", Qtr4.Text);
cmd.Parameters.AddWithValue("@Q4IntProc", Q4IntProc.Text);
cmd.Parameters.AddWithValue("@Q4IntProj", Q4IntProj.Text);
cmd.Parameters.AddWithValue("@Q4ExtBSI", Q4ExtBSI.Text);
cmd.Parameters.AddWithValue("@Q4ExtCMMI", Q4ExtCMMI.Text);
cmd.Parameters.AddWithValue("@YearTotals", YearTotals.Text);
cmd.Connection = sqlCon;
sqlCon.Open();
IsUpdated = cmd.ExecuteNonQuery() > 0;
sqlCon.Close();
}
}
if (IsUpdated)
{
lblMsg.Text = "'" + Requirement.Text + "' InternalAudit updated successfully!";
lblMsg.ForeColor = System.Drawing.Color.Green;
}
else
{
lblMsg.Text = "Error while updating '" + Requirement.Text + "' subject details";
lblMsg.ForeColor = System.Drawing.Color.Red;
}
gvInternalAudit.EditIndex = -1;
BindSubjectData();
}
protected void gvInternalAudit_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
bool IsDeleted = false;
int ID = Convert.ToInt32(gvInternalAudit.DataKeys[e.RowIndex].Value.ToString());
Label Requirement = (Label)gvInternalAudit.Rows[e.RowIndex].FindControl("lblRequirement");
using (SqlConnection sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLMedTestConnHIM"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "DELETE FROM InternalAudit WHERE Id=@ID";
cmd.Parameters.AddWithValue("@ID", ID);
cmd.Connection = sqlCon;
sqlCon.Open();
IsDeleted = cmd.ExecuteNonQuery() > 0;
sqlCon.Close();
}
}
if (IsDeleted)
{
lblMsg.Text = "'" + Requirement.Text + "' InternalAudit has been deleted successfully!";
lblMsg.ForeColor = System.Drawing.Color.Green;
BindSubjectData();
}
else
{
lblMsg.Text = "Error while deleting '" + Requirement.Text + "' subject details";
lblMsg.ForeColor = System.Drawing.Color.Red;
}
}
}
}
modified 19-Jun-15 1:56am.
|