git rebase command - baseed on master branch to our branch

Get the latest changes from master branch to our branch

below is the command to do rebase on top branch

git pull --rebase origin master

radial gradient - multipule color css

                                                

 <h2 class="text-center" style="margin-top: 0; padding-top: 30px; padding-bottom: 30px; background: radial-gradient(farthest-side circle at 100px 35px, #f6d0ea, #d8f7f8 86%);">Azure SignalR Group Chat</h2>

    <div class="container" style="height: calc(100% - 110px);"><div>

background: radial-gradient(farthest-side circle at 100px 35px, #f6d0ea, #d8f7f8 86%);

CROSS APPLY and get inner json node details

 SELECT s.StudentId,

s.StudentName,

s.[Message],

[m].MessageType,

[m].[Subject],

[m].[MessageBody]

FROM Student s 

CROSS APPLY OPENJSON([Message], '$.Messages') sm

CROSS APPLY OPENJSON(sm.value)

WITH

(

MessageType NVARCHAR(50),

[Subject] NVARCHAR(50),

[MessageBody] NVARCHAR(50)

) AS [m]

--Insert into Student values(1,'TestStudent','{"Messages": [{"MessageType": "Email","Subject": "Payment","MessageBody":"Kindly pay your school bill amount {amount}"},{"MessageType": "Sms","Subject": "Payment","MessageBody":"Kindly pay your school bill amount {amount}"}]}')

How to get Xml Inner node value using c#

How to get Xml Inner node value using c#

<?xml version="1.0"?>

<Document xmlns="urn:hl7-org:v3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sdtc="urn:hl7-org:sdtc">

   <docTime value="19981001064138-0400"/> 

</Document>

Name space: xmlns="urn:hl7-org:v3"

Node: DocTime

C# code:

XDocument doc = XDocument.Parse(xmlData);

var docTime = doc.Descendants(XName.Get("{urn:hl7-org:v3}docTime")).FirstOrDefault().FirstAttribute.Value;

result of docTime: 19981001064138-0400

Dynamic Linq query in Core

Dynamic Linq:

namespace System.Linq.Dynamic.Core

https://dynamic-linq.net/

Example in Fiddler:

https://dotnetfiddle.net/GdxsMG

var context = new EntityContext();

// Example 1: Strongly styped = normal LINQ

var example1 = context.Customers

.OrderBy(c => c.City).ThenBy(c => c.CompanyName)

.ToList();

FiddleHelper.WriteTable(example1);

// Example 2: Dynamic

var example2 = context.Customers

.OrderBy("City, CompanyName")

.ToList();

FiddleHelper.WriteTable(example2);

// Example 3: Dynamic

var example3 = context.Customers

.OrderBy("City").ThenBy("CompanyName desc")

.ToList();

FiddleHelper.WriteTable(example3);

// Example 4: Dynamic

var example4 = context.Customers

.OrderBy("City, CompanyName desc")

.ToList();

FiddleHelper.WriteTable(example4);

String Split and get nth values in Sql (or) nth highest salary in sql and alternative of string_split

 DECLARE @ AS VARCHAR(MAX) = 'param0,param1,param3,param4'

SELECT VALUE FROM

(

    SELECT VALUE , ROW_NUMBER() OVER (ORDER BY (SELECT null)) rn FROM STRING_SPLIT(@, ',')

)x where rn = 3

GO

OR

DECLARE @str VARCHAR(100) = 'param0,param1,param3,param4';

SELECT *

FROM OPENJSON('["' +  REPLACE(@str,',','","') + '"]')

-----------

Get value By position in the string:

DECLARE @str VARCHAR(100) = 'param0,param1,param3,param4';

SELECT *

FROM OPENJSON('["' +  REPLACE(@str,',','","') + '"]')

WHERE [key]=2;

--------------------------

String_split altenative for string split with position: 

DECLARE @dlmt NVARCHAR(10)=N',';

DECLARE @pos INT = 2;

declare @input varchar(max)= 'a,b,c';

SELECT CAST(N'<x>' + REPLACE(@input,@dlmt,N'</x><x>') + N'</x>' AS XML).value('/x[sql:variable("@pos")][1]','nvarchar(max)')

xls file data import to database using c#

 xls ( Excel sheet ) file data import to database using c#

string path = string.Concat(Server.MapPath("~/UploadFileFolder/" + FileUpload1.FileName));  

                    FileUpload1.SaveAs(path);  

                    string excel = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=Excel 8.0", path);  

                    using (OleDbConnection con = new OleDbConnection(excel))  

                    {  

                        OleDbCommand cmd = new OleDbCommand("select * from [Sheet1$]", con);  

                        con.Open();  

                        OleDbDataAdapter da = new OleDbDataAdapter(cmd);

                        DataSet ds = new DataSet();

                        da.Fill(ds);

                    }