SQL Database Connection in RAZOR View Engine/HTML

 


System.Data.SqlClient.SqlConnection conn1 = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DBContext"].ToString());
                    string query1 = string.Format(
                        @"SELECT DISTINCT HEADNM
FROM TABLE_ONE A INNER JOIN TABLE_TWO B ON A.COMPID = B.COMPID AND A.CHARGEID = B.HEADID AND B.HEADTP = 'ABC'");
                    System.Data.SqlClient.SqlCommand cmd1 = new System.Data.SqlClient.SqlCommand(query1, conn1);
                    conn1.Open();
                    SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
                    DataTable ds1 = new DataTable();
                    da1.Fill(ds1);


  foreach (DataRow parentRow in ds1.Rows)
{
.......
.......
.......
.......

}

Helpful page or site

This is a very helpful page. Traverse this page, I think you will surely like this page.

 SS TECHNOLOGY

Thanks for visiting my blog.

INNER JOIN IN SQL

Select Distinct HeadName by INNER JOIN query:

SELECT DISTINCT HEADNM
FROM HMS_PCHGOTC A INNER JOIN HMS_HEADIO B ON A.COMPID = B.COMPID AND A.CHARGEID = B.HEADID AND B.HEADTP = 'IPD'

ALLAH is Almighty

If ALLAH can turn night into day, then surely ALLAH can turn the darkness of your life into happiness and prosperity. Trust in ALLAH. 

Comma in amount by ASP.NET MVC

In the view page I have used this :

                         if (item.CREDITAMT < 0)//Determine negative number
                        {
                            item.CREDITAMT = item.CREDITAMT * (-1);// make that positive
                            ccheck = 1;// Flag for negative check
                            string convertcredit = Convert.ToString(item.CREDITAMT);

                            creditamt = CommainAmount.AmountwithComma(convertcredit);// This link up                                 //with DataAccess Folder
                        }
                        else
                        {
                            ccheck = 0;//flag for positive check
                            string convertcredit = Convert.ToString(item.CREDITAMT);

                            creditamt = CommainAmount.AmountwithComma(convertcredit);// This link up                                 //with DataAccess Folder
                        }


In the DataAccess Folder there are ComminAmount Class and AmountwithComma method:

   public static string AmountwithComma(string CVal)
        {

            string value = "", gotpoint = "", commainvalue = "", firstpart = "", secondpart = "", thirdpart = "", fourthpart = "", finalvalue = "";
            int lengthdebit = CVal.Length;
         

         
         
            for (int i = 0; i < lengthdebit; i++)
            {
                if (CVal[i] == '.')
                {
                    value = CVal.Substring(0, i);
                    commainvalue = CVal.Substring(i, (lengthdebit - i));
                    gotpoint = "y";
                    break;
                }
            }
            if (gotpoint == "y")
            {
                int valuelength = value.Length;
                if (valuelength > 3 && valuelength > 5 && valuelength > 7)
                {
                    value = new string(value.ToCharArray().Reverse().ToArray());
                    firstpart = value.Substring(0, 3);
                    secondpart = value.Substring(3, 2);
                    thirdpart = value.Substring(5, 2);
                    fourthpart = value.Substring(7, valuelength - 7);
                    finalvalue = firstpart + "," + secondpart + "," + thirdpart + "," + fourthpart;
                    finalvalue = new string(finalvalue.ToCharArray().Reverse().ToArray());
                    finalvalue = finalvalue + commainvalue;
                }
                else if (valuelength > 3 && valuelength > 5)
                {
                    value = new string(value.ToCharArray().Reverse().ToArray());
                    firstpart = value.Substring(0, 3);
                    secondpart = value.Substring(3, 2);

                    thirdpart = value.Substring(5, valuelength - 5);
                    finalvalue = firstpart + "," + secondpart + "," + thirdpart;
                    finalvalue = new string(finalvalue.ToCharArray().Reverse().ToArray());
                    finalvalue = finalvalue + commainvalue;
                }
                else if (valuelength > 3)
                {
                    value = new string(value.ToCharArray().Reverse().ToArray());
                    firstpart = value.Substring(0, 3);


                    secondpart = value.Substring(3, valuelength - 3);
                    finalvalue = firstpart + "," + secondpart;
                    finalvalue = new string(finalvalue.ToCharArray().Reverse().ToArray());
                    finalvalue = finalvalue + commainvalue;
                }
                else
                {
                    finalvalue = value;
                    finalvalue = finalvalue + commainvalue;
                }
            }
            else
            {
                finalvalue = CVal;
            }


            return finalvalue;

        }
    }


That's it. Enjoy your code. Thank you.

DropdownList load by change effect with ASP.NET MVC and Javascript

I am loading branch by selecting company. Here is my branch label and dropdownlist for branch.
  <div class="row">
                <div class="col-md-3">
                    @Html.Label("name", "Branch Name")
                </div>
                <div class="col-md-8">
                    @Html.DropDownListFor(model => model.BRANCHID, new SelectList(string.Empty, "Value", "Text"), "--Select--", new { id = "txtBranchID", @class = "form-control", @required = "required" })
                </div>
            </div>


Javascript code:
 $('#txtcompid').change(function () {
                var changedtxt = $('#txtcompid').val();
                $.getJSON(
                  "/AslUserCO/BranchLoad", { "Changedtxt": changedtxt},
                  function (myData) {


                      $("#txtBranchID").empty();
                 


                      $.each(myData.branch, function (i, memo) {

                          $("#txtBranchID").append('<option value="'
                              + memo.Value + '">'
                              + memo.Text + '</option>');

                      });


                  });

            });


Here is my method in AslUserCO controller:

        [AcceptVerbs(HttpVerbs.Get)]
        public JsonResult BranchLoad(Int64 changedtxt)
        {
            var selectdata = from n in db.Asl_BranchDbSet where n.COMPID == changedtxt select new {              n.BRANCHID, n.BRANCHNM};
         

           List<SelectListItem> branchlist = new List<SelectListItem>();

            foreach (var x in selectdata)
                {
                    branchlist.Add(new SelectListItem { Text = x.BRANCHNM, Value =                      Convert.ToString(x.BRANCHID) });
                }




            var result = new { branch = branchlist };

            return Json(result, JsonRequestBehavior.AllowGet);

        }