Database

CREATE TABLE dbo.NumTest (Num int)
INSERT INTO dbo.NumTest VALUES ( '' ) 

static string notdoh = " AND (hospital Not In ('SOUTHERN ISABELA GENERAL HOSPITAL','CAGAYAN VALLEY MEDICAL CENTER','VETERANS REGIONAL HOSPITAL'))";

static string where_pg1 = "WHERE hosp_categ Not In ('S','T') And hosp_class='G' " + notdoh;
static string where_pg2 = " Or hosp_categ=' ' And hosp_class='G' " + notdoh;

static string where_prigov = where_pg1 + where_pg2;

//Claim_Amount
string sel_amt = "SELECT SUM(totalamount)";
string fr_amt_orig = "FROM vw";
string fr_amt = "FROM vw";
string SQLquery_amt = "";

//Claim_Count
string sel_count = "SELECT COUNT(*)";
string fr_count_orig = "FROM vw";
string fr_count = "FROM vw";
string SQLquery_count = "";

string qm = " ";
string var;

SqlCommand cmd = new SqlCommand();
string SQL_cmd = "";

public void amount(int slctdind1_p, int ind1_p, string sub_p)
{
if ((slctdind1_p + 1) < 10)
		var = "0";
	else
		var = "";
	fr_amt += (var + ind1_p + sub_p);
	SQLquery_amt = sel_amt + qm + fr_amt;
	fr_amt = fr_amt_orig;
}

public void count(int slctdind1_p, int ind1_p, string sub_p)
{
	if ((slctdind1_p + 1) < 10)
		var = "0";
	else
		var = "";
	fr_count += (var + ind1_p + sub_p);
	SQLquery_count = sel_count + qm + fr_count;
	fr_count = fr_count_orig;
}


public void btnGenerateGov_Click(object sender, EventArgs e)
{

cnn.ConnectionString = Properties.Settings.Default.DBInfo;
	string year = cbYearGov.Text;
	string sub = year.Substring(2, 2);

	int slctdind1 = cbMonthGov.SelectedIndex;
	int slctdind2 = cbMonth2Gov.SelectedIndex;
	int ind1 = slctdind1 + 1;
	int ind2 = slctdind2 + 1;

	//Claim_Amount_Region_Province
	amount(slctdind1, ind1, sub);

	//Claim_Count_Region_Province
	count(slctdind1, ind1, sub);

	try
	{
	cnn.Open();
      
		#region government
	      //Region_Prim_Gov_Claims
	      SQL_cmd = SQLquery_count + " " + where_prigov;
	      txtPGClaims.Text = claims(cmd, SQL_cmd);
	
	//Region_Prim_Gov_Amt
	      SQL_cmd = SQLquery_amt + " " + where_prigov;
	txtPGAmt.Text = claims(cmd, SQL_cmd);
}

SELECT ROUND(0.833333333333333,2)