Thursday, August 30, 2012

Make a list box search


You need a listbox with items, a textbox and a button.


protected void Button1_Click(object sender, EventArgs e)
    {
        ListBoxPolicies.SelectedIndex = -1;

        for(int i=0; i< ListBox1.Items.Count; i++)
        {
            if (ListBox1.Items[i].ToString().Contains(TextBox1.Text))
            {
                ListBox1.SelectedIndex = i;
            }
        }
    }

Monday, August 27, 2012

"SPLIT(x)" --> get the second part of the string in SQL SERVER

If you need something like Split('ABC - DE ') and would like to get
1) 'ABC'  --> The first part of the string
or
2) 'DE'    --->The second part of the string


2) I will start by the one I created:
Here is how to get the second part of the string:

CREATE FUNCTION [dbo].[GetSecondString] (@text VARCHAR(MAX), @character varchar(64))
RETURNS VARCHAR(MAX)
AS
BEGIN
DECLARE @start int;
DECLARE @result VARCHAR(MAX)
SELECT @start =  CHARINDEX(@character,@text) --Get the starting character
---Substring(text, start right after the character, length of text (second string))
SELECT @result = LTRIM(RTRIM(substring(@text, @Start +1, LEN(@text)-@start)))
return @result
END


--------------------
Executing the function


SELECT dbo.GetSecondString ('abcdef1234- What a great result','-') AS myResult;


will produce -->"What a great result"

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


1) To get the first part -obtained from the SQl Authority 

CREATE FUNCTION [dbo].[GetFirst] (@StringVar VARCHAR(MAX))
RETURNS VARCHAR(MAX)
AS
BEGIN
DECLARE @rtStringVar VARCHAR(MAX)
SELECT @rtStringVar = CASE CHARINDEX('-', LTRIM(@StringVar), 1)
WHEN 0 THEN LTRIM(@StringVar)
ELSE SUBSTRING(LTRIM(@StringVar), 1, CHARINDEX('-',LTRIM(@StringVar), 1) - 1)
END
RETURN @rtStringVar
END


---------------------
Executing the function

-Usage of FunctionSELECT dbo.GetFirstWord (''AS FirstWordofSentence;SELECT dbo.GetFirstWord (' Space Before'AS FirstWordofSentence;SELECT dbo.GetFirstWord ('Long Statement'AS FirstWordofSentence;SELECT dbo.GetFirstWord ('SingleWord'AS FirstWordofSentence;