Replace in sql

REPLACE ( string_expression , string_pattern , string_replacement )

Charindex in sql

SET @FullName = 'www.java2s.com'
SET @SpaceIndex = CHARINDEX('java', @FullName)
SELECT LEFT(@FullName, @SpaceIndex - 1)

Substring in sql

SELECT x = SUBSTRING('abcdef', 2, 3)

Learning asp.net 4.5

Radio button with gridview asp.net

Hi Ther,

We are facing many problems with including radio button with grid
one of them is all are selected because they are generating different name in html
to overcome we have to do the following then its easy.

in html code we have to assign its checked chang event and in code back we have to write the code like this

     foreach (GridViewRow row in gridViewProducts.Rows)
   {
    ((RadioButton)row.FindControl("radioButtonToSelectTheProductResult")).Checked = false;
   }
   var radioButton = (RadioButton)sender;
   radioButton.Checked = true;

then what we are doing here is setting first all check box to false and then the one who is sender to true.

by default with radio we are giving customer to select one, we are not allowing to deselect all.
so one who is clicked is already selected in grid.

It is working correctly there.

Engjoy radiobutton with gridview

Thanks & Regards
Nipam Budhabhatti

Modal popup-;extender control with asp. net

Normal ajax popup extender control is using the client side calls.

so from backside if we want to starts the modal control from code
then first we have to give the faxe control for target control id

then from code we can show extender.Show(); method

then we can choosse the update panel to open it also at the time of update panel.


Thanks & Regards
Nipam Budhabhatti

Javascript with Scriptmanager

ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "xxx", "alert('Hello World!');", true);