Show Total in GridView Footer

 Given Example shows you how to calculate total of particular cells value and show at the footer of Gridview.
At first define footer template in template field for which you want to calculate total.

<asp:TemplateField HeaderText="Total Pcs">

 <ItemTemplate>

          <asp:Label ID="lbltotpcs" runat="server"  Text='<%# Bind("totpcs") %>'></asp:Label>

 </ItemTemplate>

 <FooterTemplate>

        Total : <asp:Label ID="lbltotqty" runat="server" Text="Label"></asp:Label>

</FooterTemplate>

</asp:TemplateField>

Populate the RowDataBound event of Gridview where you have to do the main calculation.

int totqty=0;

protected void gvCrate_RowDataBound(object sender, GridViewRowEventArgs e)

    {

        if (e.Row.RowType == DataControlRowType.DataRow)

        {

            Label totpcs = (Label)e.Row.FindControl("lbltotpcs");

            totqty = totqty + (Convert.ToInt32(totpcs.Text));

        }

        if (e.Row.RowType == DataControlRowType.Footer)

        {

            ((Label)e.Row.FindControl("lbltotqty")).Text = totqty.ToString();

            TxtTotalpcs.Value = totqty.ToString();

        }

    }

Enable  "ShowFooter" as True in Gridview's property.

Menu Control Not Working Properly On Every Browser

Browser Compatibility Code 
Paste below code in your page_load event of page or master page and then test it on mac safari. Its working fine
if (Request.UserAgent.IndexOf("AppleWebKit") > 0)
  {
            Request.Browser.Adapters.Clear();
  }

ISNULL() -Returns Desired Value If The Field Vlue Is Null

This example shows the use of ISNULL() method.It returns the given value if the field value is NULL.This method takes two arguments first one is desired field and 2nd one is the value you want return if field has value NULL.

ISNULL( check_expression , replacement_value)

select  ISNULL(Name,'xyz') as Name from Stud_Master

Temporary Table -SQL Server

This example Shows you how to create temporary table in SqlServer, Insert values in them, Check their existence and finally Drop them.

Create Temp Table

This one is declared as Global Temporary Table

create table ##YourTempTable (YourTableField1 bigint,YourTableField2 varchar(50))

This one is declared as Local Temporary Table

create table #YourTempTable (YourTableField1 bigint,YourTableField2 varchar(50))

Insert Values in Your Temporary Table 

 

insert into ##YourTempTable

SELECT * FROM  YourDesiredTable

Check Existence of Temporary table

if exists(select * from tempdb.dbo.sysobjects where ID=object_ID(N'tempdb..##YourTempTable '))

Check Existence n Then Drop Temporary Table

if exists(select * from tempdb.dbo.sysobjects where ID=object_ID(N'tempdb..##YourTempTable '))

BEGIN

DROP TABLE ##YourTempTable

END

string.format for datetime

String Format for DateTime [C#]

This example shows how to format DateTime using String.Format method. All formatting can be done also using DateTime.ToString method.
Custom DateTime Formatting

There are following custom format specifiers :
y (year),

M (month),

d (day),

h (hour 12), 

H (hour 24),

m (minute),

s (second),

f (second fraction), 

F (second fraction, trailing zeroes are trimmed),

t (P.M or A.M) and

z (time zone).

Following examples demonstrate how are the format specifiers rewritten to the output.

// create date time 2008-03-09 16:05:07.123

DateTime dt = new DateTime(2008, 3, 9, 16, 5, 7, 123);

String.Format("{0:y yy yyy yyyy}", dt); // "8 08 008 2008" year

String.Format("{0:M MM MMM MMMM}", dt); // "3 03 Mar March" month

String.Format("{0:d dd ddd dddd}", dt); // "9 09 Sun Sunday" day

String.Format("{0:h hh H HH}", dt); // "4 04 16 16" hour 12/24

String.Format("{0:m mm}", dt); // "5 05" minute

String.Format("{0:s ss}", dt); // "7 07" second

String.Format("{0:f ff fff ffff}", dt); // "1 12 123 1230" sec.fraction

String.Format("{0:F FF FFF FFFF}", dt); // "1 12 123 123" without zeroes

String.Format("{0:t tt}", dt); // "P PM" A.M. or P.M.

String.Format("{0:z zz zzz}", dt); // "-6 -06 -06:00" time zone

You can use also date separator / (slash) and time sepatator : (colon). These characters will be rewritten to characters defined in the current DateTimeForma­tInfo.DateSepa­rator and DateTimeForma­tInfo.TimeSepa­rator.

// date separator in german culture is "." (so "/" changes to ".")

String.Format("{0:d/M/yyyy HH:mm:ss}", dt); // "9/3/2008 16:05:07" - english (en-US)

String.Format("{0:d/M/yyyy HH:mm:ss}", dt); // "9.3.2008 16:05:07" - german (de-DE)

Here are some examples of custom date and time formatting:

// month/day numbers without/with leading zeroes

String.Format("{0:M/d/yyyy}", dt); // "3/9/2008"

String.Format("{0:MM/dd/yyyy}", dt); // "03/09/2008"

// day/month names

String.Format("{0:ddd, MMM d, yyyy}", dt); // "Sun, Mar 9, 2008"

String.Format("{0:dddd, MMMM d, yyyy}", dt); // "Sunday, March 9, 2008"

// two/four digit year

String.Format("{0:MM/dd/yy}", dt); // "03/09/08"

String.Format("{0:MM/dd/yyyy}", dt); // "03/09/2008"

Standard DateTime Formatting

In DateTimeForma­tInfo there are defined standard patterns for the current culture. For example property ShortTimePattern is string that contains value h:mm tt for en-US culture and value HH:mm for de-DE culture.

Following table shows patterns defined in DateTimeForma­tInfo and their values for en-US culture. First column contains format specifiers for the String.Format method.

Specifier DateTimeFormatInfo property Pattern value (for en-US culture)

t ShortTimePattern h:mm tt

d ShortDatePattern M/d/yyyy

T LongTimePattern h:mm:ss tt

D LongDatePattern dddd, MMMM dd, yyyy

f (combination of D and t) dddd, MMMM dd, yyyy h:mm tt

F FullDateTimePattern dddd, MMMM dd, yyyy h:mm:ss tt

g (combination of d and t) M/d/yyyy h:mm tt

G (combination of d and T) M/d/yyyy h:mm:ss tt

m, M MonthDayPattern MMMM dd

y, Y YearMonthPattern MMMM, yyyy

r, R RFC1123Pattern ddd, dd MMM yyyy HH':'mm':'ss 'GMT' (*)

s SortableDateTi­mePattern yyyy'-'MM'-'dd'T'HH':'mm':'ss (*)

u UniversalSorta­bleDateTimePat­tern yyyy'-'MM'-'dd HH':'mm':'ss'Z' (*)

(*) = culture independent

Following examples show usage of standard format specifiers in String.Format method and the resulting output.

String.Format("{0:t}", dt); // "4:05 PM" ShortTime

String.Format("{0:d}", dt); // "3/9/2008" ShortDate

String.Format("{0:T}", dt); // "4:05:07 PM" LongTime

String.Format("{0:D}", dt); // "Sunday, March 09, 2008" LongDate

String.Format("{0:f}", dt); // "Sunday, March 09, 2008 4:05 PM" LongDate+ShortTime

String.Format("{0:F}", dt); // "Sunday, March 09, 2008 4:05:07 PM" FullDateTime

String.Format("{0:g}", dt); // "3/9/2008 4:05 PM" ShortDate+ShortTime

String.Format("{0:G}", dt); // "3/9/2008 4:05:07 PM" ShortDate+LongTime

String.Format("{0:m}", dt); // "March 09" MonthDay

String.Format("{0:y}", dt); // "March, 2008" YearMonth

String.Format("{0:r}", dt); // "Sun, 09 Mar 2008 16:05:07 GMT" RFC1123

String.Format("{0:s}", dt); // "2008-03-09T16:05:07" SortableDateTime

String.Format("{0:u}", dt); // "2008-03-09 16:05:07Z" UniversalSortableDateTime