Get All Table and Row count in SQL Server

SELECT sc.name +'.'+ ta.name TableName

,SUM(pa.rows) RowCnt

FROM sys.tables ta

INNER JOIN sys.partitions pa

ON pa.OBJECT_ID = ta.OBJECT_ID

INNER JOIN sys.schemas sc

ON ta.schema_id = sc.schema_id

WHERE ta.is_ms_shipped = 0 AND pa.index_id IN (1,0)

GROUP BY sc.name,ta.name

ORDER BY SUM(pa.rows) DESC

High quality to low quality compress file, Reduce image size in kb with c#

var image = new Bitmap(FileUpload1.FileContent);
     
var jpegCodec = ImageCodecInfo.GetImageEncoders().First(enc => enc.FormatID == ImageFormat.Jpeg.Guid);
       
 var jpegParams = new EncoderParameters(1);
  jpegParams.Param = new[] { new EncoderParameter(Encoder.Quality, 50L) };
  image.Save(@"E:\images\" + FileUpload1.FileName, jpegCodec, jpegParams);

Read Json in diffrent methods c#

 ------------------------------------------1st Methods-----------------------------------------------------------------
File Name: json.txt
{"processing_result":"1","error_message_string":"{\r\n  \"dob\": \"02/04/1999\",\r\n  \"mobile\": \"9788888888\",\r\n  \"City\": \"Mumbai\",
\r\n  \"company\": \"KOTAK MAHINDRA BANK LIMITED\",\r\n  \"company_category\": \"OTHER SUPER CAT A\",\r\n  \"official_email_id\": \"sdfsdfs@asdas.com\",
\r\n  \"salary\": \"74000\",\r\n  \"lead_id\": \"1073227\",\r\n  \"oppo_id\": \"153471\",\r\n  \"loan_application_id\": \"042420171535_4215\",
\r\n  \"loan_amount\": \"244000\",\r\n  \"customer_status\": \"FINALSUBMITDONE\",\r\n  \"cibil_score\": \"-1\",\r\n  \"applied_date\": \"24/04/2017\",
\r\n  \"lead_source\": \"test\",\r\n  \"product\": \"Personal Loans\",\r\n  \"previous_month_salary\": \"74000\",\r\n  \"salaried_sep_senp\": \"0\",
\r\n  \"total_employment\": \"0\",\r\n  \"tenure\": \"32\",\r\n  \"processing_fee\": \"999\",\r\n  \"roi\": \"11.99\",\r\n  \"emi_options\": \"STD\"\r\n}",
"timestamp":"2017-04-24 03.41 PM"}

string  result= File.ReadAllText(Server.MapPath("json\\json.txt"));
        JObject joResponse = JObject.Parse(result);
string Status= joResponse["result"].ToString();

       JObject error_message_string = JObject.Parse(joResponse["result"].ToString());

string    RejectionReason = Convert.ToString(error_message_string["innerresult"].ToString());


-----------------------------------------2nd Methods-----------------------------------------------------------------
File Name:   djson.txt file
{"ExtDResponse":{"API":{"Status":"SUCCESS","Remarks":"","LogTxnId":299018},"FanNo":"279PZ0000084",
"ExtDApplicants":{"ExtDApplicant":{"ExtDAppDetails":{"ApplicantReferenceId":"PL_021320171916_6683","ApplicantType":"P"},
"ExtDDetails":{"DReferenceId":10284,"TypeOfMatch":"","OverallResult":"004"},
"ExtDMatches":{"ExtDMatch":{"ChasisNo":"","DD":"","BookedDate":"","IdDrivingLic":"",
"ReportDate":"","OdcSett":"","IdPanCard":"","Reason":"","ApplFlag":"","MatchDesc":"","RcNo":"",
"ContractNo":"","PhoneNo":"","EngineNo":"","Status":"","MobileNo":"","IdPassport":"","FirstName":"",
"PinCodeNo":"","ContractId":"","City":"","ValWaiver":"","MiddleName":"","IdElectionCard":"","AddressLine3":"",
"AddressLine2":"","AddressLine1":"","DealerCode":"","Model":"","LastName":"","BranchCode":"","BirthDate":""}}}}}}


string result = File.ReadAllText(Server.MapPath("\\test\\json\\Dsjson.txt"));
        var parsed = JObject.Parse(result);
        string Status = parsed.SelectToken("ExtDResponse.API.Status").Value<string>();
        string FanNo = parsed.SelectToken("ExtDResponse.FanNo").Value<string>();
        string OverallResult = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDDetails.OverallResult").Value<string>();
        string DDDReferenceId = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDDetails.DReferenceId").Value<string>();
        string ApplicantReferenceId = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDAppDetails.ApplicantReferenceId").Value<string>();
        string ContractId = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.ContractId").Value<string>();
        string PinCodeNo = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.PinCodeNo").Value<string>();
        string MatchDesc = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.MatchDesc").Value<string>();
        string Model = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.Model").Value<string>();
        string RcNo = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.RcNo").Value<string>();
        string ApplFlag = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.ApplFlag").Value<string>();
        string BranchCode = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.BranchCode").Value<string>();
        string IdPanCard = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.IdPanCard").Value<string>();
        string OdcSett = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.OdcSett").Value<string>();
        string LastName = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.LastName").Value<string>();
        string MobileNo = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.MobileNo").Value<string>();
        string BookedDate = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.BookedDate").Value<string>();
        string ReportDate = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.ReportDate").Value<string>();
        string DD = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.DD").Value<string>();
        string FirstName = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.FirstName").Value<string>();
        string Reason = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.Reason").Value<string>();
        string IdElectionCard = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.IdElectionCard").Value<string>();
        string DealerCode = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.DealerCode").Value<string>();
        string BirthDate = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.BirthDate").Value<string>();
        string City = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.City").Value<string>();
        string inStatus = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.Status").Value<string>();
        string MiddleName = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.MiddleName").Value<string>();
        string ValWaiver = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.ValWaiver").Value<string>();
        string AddressLine1 = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.AddressLine1").Value<string>();
        string AddressLine2 = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.AddressLine2").Value<string>();
        string AddressLine3 = parsed.SelectToken("ExtDResponse.ExtDApplicants.ExtDApplicant.ExtDMatches.ExtDMatch.AddressLine3").Value<string>();

Remove the newline and enter data \n and select SQL Query

REPLACE(REPLACE(cast(BRANCHNAME as nvarchar(max)), CHAR(13), ''), CHAR(10), '')

XML Convert into SQL table

DECLARE @XMLData XML

SET @XMLData ='

<STUDENTS>

  <STUDENT>

    <StudentID>1</StudentID>

    <Name>John Smith</Name>

    <Marks>200</Marks>

  </STUDENT>

  <STUDENT>

    <StudentID>2</StudentID>

    <Name>Mark Johnson</Name>

    <Marks>300</Marks>

  </STUDENT>

<STUDENT>

    <StudentID>3</StudentID>

    <Name>Nitin Tyagi</Name>

    <Marks>400</Marks>

  </STUDENT>

</STUDENTS>'

SELECT StudentID = Node.Data.value('(StudentID)[1]', 'INT')

        , [Name] = Node.Data.value('(Name)[1]', 'VARCHAR(MAX)')

        , [Marks] = Node.Data.value('(Marks)[1]', 'INT')

FROM    @XMLData.nodes('/STUDENTS/STUDENT') Node(Data)

Arry Data DataTable Data Xml data insert into Database

 DataTable _dt = new DataTable();
                    DataColumn col1 = new DataColumn("fkEmployeeid");
                    col1.DataType = System.Type.GetType("System.String");
                    _dt.Columns.Add(col1);

 if (sel_list.Items.Count > 0)
                    {
                        for (int i = 1; i < sel_list.Items.Count; i++)
                        {
                            _dt.Rows.Add(sel_list.Items[i].Value);

                        }
                    }

 public static string GetXMLOfDataTable(DataTable dtToProcess)
    {
        string strOutput = "";
        try
        {
            dtToProcess.TableName = "Table";
            StringWriter sw = new StringWriter();
            dtToProcess.WriteXml(sw);
            strOutput = sw.ToString();
        }
        catch (Exception ex)
        {
        }
        return strOutput;
    }
ED.strxmlData1 = GetXMLOfDataTable(_dt);

@xmlLanguage2 xml,

  IF (@xmlLanguage2 IS NOT NULL)
begin    
SELECT ISNULL(cast(Colx.query('data(fkEmployeeid)') as varchar(max)),'0') as fkEmployeeid
INTO #TMPLanguage1 FROM @xmlLanguage2.nodes('DocumentElement/Table') AS Tabx(Colx)
insert into tb_tab_OthereEmployeeInvoled(
Employeeid,
EmployeeReportId
)
select fkEmployeeid,@RID from #TMPLanguage1
 end

DDL Drropdown DDLDay DDLMonth DDlYear

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="testc.aspx.cs" Inherits="testc" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<script type="text/javascript">
    function ValidateDate(sender, args) {
        var dateString = document.getElementById("ddlday").value + "/" + document.getElementById("ddlmonth").value +
            "/" + document.getElementById("ddlyear").value ;
        alert(dateString)
        var regex = /(((0|1)[0-9]|2[0-9]|3[0-1])\/(0[1-9]|1[0-2])\/((19|20)\d\d))$/;
        if (regex.test(dateString)) {
            var parts = dateString.split("/");
            var dt = new Date(parts[1] + "/" + parts[0] + "/" + parts[2]);
            args.IsValid = (dt.getDate() == parts[0] && dt.getMonth() + 1 == parts[1] && dt.getFullYear() == parts[2]);
        } else {
            args.IsValid = false;
        }
    }
</script>
</head>
<body>
    <form id="form1" runat="server">
    <div class="selectWrapper">
                            <label>Date of registration</label>
                            <div class="selectContainer">
                                <div class="innerContainer">
                                    <div class="selectText" id="selectday" runat="server" >Day</div>
                                   <asp:DropDownList ID="ddlday" runat="server">
                                       <asp:ListItem>Day</asp:ListItem>
                                   </asp:DropDownList>
                                 
                                </div>
                            </div>
                            <div class="selectContainer">
                                <div class="innerContainer">
                                    <div class="selectText">Month</div>
                                    <asp:DropDownList ID="ddlmonth" runat="server">
                                       <asp:ListItem>Month</asp:ListItem>
                                   </asp:DropDownList>
                                </div>
                            </div>
                            <div class="selectContainer">
                                <div class="innerContainer">
                                    <div class="selectText">Year</div>
                                      <asp:DropDownList ID="ddlyear" runat="server">
                                       <asp:ListItem>Year</asp:ListItem>
                                   </asp:DropDownList>
                                </div>
                            </div>
                        </div>
        <asp:CustomValidator runat="server" ClientValidationFunction="ValidateDate"
    ErrorMessage="Invalid Date." OnServerValidate="ValidateDate" ValidationGroup="Group2" />
        <asp:Button ID="Button1" runat="server" Text="Button" ValidationGroup="Group2" />
    </form>
</body>
</html>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Text.RegularExpressions;

using System.Globalization;

public partial class testc : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            bindddlDayMonthYear();

        }

    }

    protected void ValidateDate(object sender, ServerValidateEventArgs e)

    {

        string txtDate3 = ddlday.SelectedValue + "/" + ddlmonth.SelectedValue + "/" + ddlyear;

        if (Regex.IsMatch(txtDate3, "(((0|1)[0-9]|2[0-9]|3[0-1])\\/(0[1-9]|1[0-2])\\/((19|20)\\d\\d))$"))

        {

            DateTime dt;

            e.IsValid = DateTime.TryParseExact(e.Value, "dd/MM/yyyy", new CultureInfo("en-GB"), DateTimeStyles.None, out dt);

            if (e.IsValid)

            {

                ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Valid Date.');", true);

            }

        }

        else

        {

            e.IsValid = false;

        }

    }

    protected void bindddlDayMonthYear()

    {

        ddlday.Items.Clear();

        for (int i = 1; i <= 31; i++)

        {

            if (i < 10)

            { ddlday.Items.Add(new ListItem("0" + i.ToString())); }

            else

            { ddlday.Items.Add(new ListItem(i.ToString())); }

        }

        ddlday.Items.Insert(0, "Day");

        ddlmonth.Items.Clear();

        for (int i = 1; i <= 12; i++)

        {

            if (i < 10)

            { ddlmonth.Items.Add(new ListItem("0" + i.ToString())); }

            else

            {

                ddlmonth.Items.Add(new ListItem(i.ToString()));

            }

        }

        ddlmonth.Items.Insert(0, "Month");

        ddlyear.Items.Clear();

        for (int i = 1980; i <= DateTime.Now.Year; i++)

        {

            ddlyear.Items.Add(new ListItem(i.ToString()));

        }

        ddlyear.Items.Insert(0, "Year");

    }

}