Login Autherntication using LDAP in asp.net

protected void btnSubmit_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            string path = ConfigurationSettings.AppSettings["ldap"].ToString();
            DirectoryEntry objEntry = new DirectoryEntry(path, txtUserName.Text.Trim(), txtPassword.Text.Trim());
            DirectorySearcher search = new DirectorySearcher(objEntry);
            search.Filter = "(&(objectCategory=person)(SAMAccountName=" + txtUserName.Text.Trim() + "))";
            //search.Filter = "(&(objectCategory=person)(SAMAccountName=AjayK))";
            SearchResult result = search.FindOne();
            if (result != null)
            {
                DirectoryEntry de = result.GetDirectoryEntry();
                PropertyValueCollection groups = de.Properties["memberOf"];

                foreach (string s in groups)
                {
                    //Response.Write(s + "<br/>");
                    if (s.Contains("Managers ABC"))
                        Session["isMgr"] = true;
                }
                Session["name"] = txtUserName.Text.Trim();
                //Session["name"] = "rupeshm";
                Response.Redirect("Index.aspx");
            }
        }
        catch (DirectoryServicesCOMException)
        {
            {
               
              lblMsg.Text = "Invalid User Name or Password!!";
           
            }
        }
    }

How to add double quotes in URL in c#

I have URL

http://abc.io/v3/companies?filters={"info":"ddil"}&api_key=tk5qgu

and i Changes and handle double quotes like below

var url = "http://abc.io/v3/companies?filters={\"info\":\"ddil\"}&api_key=tk5qgu";

how to get first value in string using sql substring function

SUBSTRING(transaction_claimant_Firstname,1,(CHARINDEX('|',transaction_claimant_Firstname + '|')-1))

Calculate mid string in sql

create function dbo.MidString(@string varchar(100))
RETURNS varchar(100)
as
begin
Declare @strtloc int
Declare @endloc int
declare @result varchar(50)
set @strtloc = charindex('|',@string)+1
set @endloc = charindex('|',substring(@string,@strtloc,len(@string)))-1
if @endloc = -1  
begin
set @endloc=len(@string)  
end  
set @result=substring(@string,@strtloc,@endloc)
return @result
end

How to find first name,Middle name,last name in sql

SELECT
LEFT(transaction_claimant_Firstname,CHARINDEX('|',transaction_claimant_Firstname + '|')-1) AS FirstName,
CASE WHEN LEN(transaction_claimant_Firstname) - LEN(REPLACE(transaction_claimant_Firstname,'|','')) > 1  THEN PARSENAME(REPLACE(transaction_claimant_Firstname,'|','.'),2) ELSE NULL END AS MiddleName,
CASE WHEN LEN(transaction_claimant_Firstname) - LEN(REPLACE(transaction_claimant_Firstname,'|','')) > 0 THEN PARSENAME(REPLACE(transaction_claimant_Firstname,'|','.'),1) ELSE NULL END AS LastName
FROM tablename