Using javascript for checkall in gridview

script language="javascript" type="text/javascript"
function selectall(status)
{
var gridview=document.getElementById("gridview1");
for(var i=1;i
Columns>


asp:TemplateField>
HeaderTemplate>
asp:CheckBox runat="Server" ID="chkall" onclick="javascript:selectall(this.checked);" />
/HeaderTemplate>
ItemTemplate>
asp:CheckBox runat="server" ID="chk1" />
/ItemTemplate>
/asp:TemplateField>
asp:BoundField DataField="ename" HeaderText="empname" ReadOnly="true" />
/Columns>
/asp:GridView>

Retrieve two tables of data at the same time by using data reader

Include 2 select statements either in a stored procedure or in a select command and call the ExecuteReader() method on the command object. This will automatically fill the DataReader with 2 Tables of data.

The datareader will always return the data from first table only. If you want to get the second table then you need to use ReaderObject.NextResult() method. The NextResult() method will return true if there is another table.

Example:


SqlConnection con = new SqlConnection("trusted_connection=yes;database=northwind;server=localhost");
SqlCommand cmd = new SqlCommand("select * from categories;select * from products", con);
con.Open();

SqlDataReader dr=cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();


while (dr.NextResult())
{
GridView2.DataSource = dr;
GridView2.DataBind();

}

Open a web page in a new window

The following HTML code will enable you to open a web page in a new window:

A HREF="http://www.yourdomain.com" TARGET="_blank"

If you're linking to a lot of other web sites within your web page and would like to open all of your links in a new window, this HTML code is for you.

The following HTML code will enable you to open all of your links in a new window. Place this code between your HEAD tag within your HTML:

base target="main"

Image Enlarge

http://www.dotnetspider.com/resources/28977-Image-Enlarge.aspx

Difference among Int32.Parse(), Convert.ToInt32(), and Int32.TryParse()

Int32.parse(string)
-------------------------
Int32.Parse (string s) method converts the string representation of a number to its 32-bit signed integer equivalent.
When s is null reference, it will throw ArgumentNullException.
If s is other than integer value, it will throw FormatException.
When s represents a number less than MinValue or greater than MaxValue, it will throw OverflowException.

Example:
------------------
string s1 = "1234";
string s2 = "1234.65";
string s3 = null;
string s4 = "123456789123456789123456789123456789123456789";

int result;
bool success;

result = Int32.Parse(s1); //-- 1234
result = Int32.Parse(s2); //-- FormatException
result = Int32.Parse(s3); //-- ArgumentNullException
result = Int32.Parse(s4); //-- OverflowException


Convert.ToInt32(string)
----------------------------------
Convert.ToInt32(string s) method converts the specified the string representation of 32-bit signed integer equivalent. This calls in turn Int32.Parse () method.
When s is null reference, it will return 0 rather than throw ArgumentNullException
If s is other than integer value, it will throw FormatException.
When s represents a number less than MinValue or greater than MaxValue, it will throw OverflowException

Example:
result = Convert.ToInt32(s1); //-- 1234
result = Convert.ToInt32(s2); //-- FormatException
result = Convert.ToInt32(s3); //-- 0
result = Convert.ToInt32(s4); //-- OverflowException


Int32.TryParse(string, out int)
---------------------------------------------
Int32.Parse(string, out int) method converts the specified the string representation of 32-bit signed integer equivalent to out variable, and returns true if it parsed successfully, false otherwise. This method is available in C# 2.0
When s is null reference, it will return 0 rather than throw ArgumentNullException.
If s is other than integer value, the out variable will have 0 rather than FormatException.
When s represents a number less than MinValue or greater than MaxValue, the out variable will have 0 rather than OverflowException.

Example:-
-------------
success = Int32.TryParse(s1, out result); //-- success => true; result => 1234
success = Int32.TryParse(s2, out result); //-- success => false; result => 0
success = Int32.TryParse(s3, out result); //-- success => false; result => 0
success = Int32.TryParse(s4, out result); //-- success => false; result => 0

Convert.ToInt32 is better than Int32.Parse, since it return 0 rather than exception. But, again according to the requirement this can be used. TryParse will be best since it handles exception itself always.