Get Multi row in Single Coloum using SQL Query & Check 2 value in same colume

Get Multi Row Seat Name in single colum:

(select (select TD.V_SeatName as col1 FROM Transaction T where TD.N_TransactionID=T.N_TransactionID
for xml raw, elements, type).query('for $col1 in (row/col1) return concat($col1, ",")')) as SeatName


Check 2 value in same colume:(Get Status for (1 or 4))

select * from testtable where N_Status in(1,4)

Negative to Postive Value

converting Negative Value to Pstive value in C#:
string s = "-123.45";
s = Math.Abs(Convert.ToDouble(s)).ToString();
//Output=123.45

Date Time Format

Convert Date Time:
string=strStartDate;
strStartDate = Convert.ToDateTime(strStartDate).ToString("yyyy/MM/dd");

.Net Short Cut Keys

Ctrl + KC - Commanted
Ctrl + KU - UnCommanted
Ctrl + KD - Allignment
Ctrl + G - Go To Line

Find Browser Using Java Script

Find Current Browser Using Java Script.........

<script type="text/javascript">

var browser=navigator.appName;
if(browser=="Microsoft Internet Explorer")
{

}
else if(browser=="Netscape")
{

}

</script>

Find IP Address in ASP.NET

string strIPAddress = "";

if (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != "" && Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != null)

strIPAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];

else if (Request.ServerVariables["REMOTE_ADDR"] != "" && Request.ServerVariables["REMOTE_ADDR"] != null)

strIPAddress = Request.ServerVariables["REMOTE_ADDR"];

Response.Write("Your IP " + strIPAddress);

Serial number column in a Gridview at runtime

It will give you serial number Automatic increment at Run time

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" >
<Columns>
<asp:TemplateField HeaderText="S.No">
<ItemTemplate>
<%# Container.DataItemIndex + 1 %>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>