DateTime Format in GridView ItemTemplate In Asp.net C#

DateTime Format in GridView ItemTemplate In Asp.net C#

To format DateTime in GridView In ItemTemplate we have to pass format in eval or bind . There are many format available for the
DateTime .In this article i have given some example that how to format datetime and at end i have listed the datetime format
used in gridview .

Following are  the examples of ItemTemplate where format used for datetime .

<asp:TemplateField>
    <ItemTemplate>
        <asp:Label ID="lblDate" runat="server" Text='<%# Eval("Date", "{0:dd/MM/yyyy}")%>' ></asp:Label>
    </ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
    <ItemTemplate>
        <asp:Label ID="lblDat1" runat="server" Text='<%# Eval("Date", "{0:D}")%>' ></asp:Label>
    </ItemTemplate>
</asp:TemplateField>

Following are  the examples of BoundFieldwhere format used for datetime .

<asp:boundfield datafield="DOB" dataformatstring="{0:d}" headertext="Date Of Birth" readonly="True"> </asp:boundfield>

The following table shows some date format strings that can be used to format date in GridView columns,

Format Pattern	Name	Example
d	Short date	11/8/2008
D	Long date	Sunday, August 11, 2008
t	Short time	3:32 PM
T	Long time	3:32:00 PM
f	Full date/time (short time)	Sunday, August 11, 2008 3:32 PM
F	Full date/time (long time)	Sunday, August 11, 2008 3:32:00 PM
g	General date/time (short time)	8/11/2008 3:32 PM
G	General date/time (long time)	8/11/2008 3:32:00 PM
m or M	Month day	August 11
r or R	RFC 1123	Sun, 11 Aug 2008 8:32:00 GMT
s	Sortable date/time	2008-08-11T15:32:00
u	Universable sortable date/time	2008-08-11 15:32:00z
U	Universable sortable date/time	Sunday, August 11, 2008 11:32:00 PM
y or Y	Year month	August, 2008

Related Other posts

Html Code in blog Radiobuttonlist Example Image In Datalist Merge docs files in c#

Database backup in sql Server CheckboxList example Datetime format in gridview Send mail in asp.net c#

Highest second record in sql Nested gridview Checkboxs in gridview Validation using jquery in asp.net page

Find all references Of Object Table , Stored Procedures, Scalar function In sql Server

Find all references Of Object Table , Stored Procedures, Scalar function In sql Server

Following is the query by which you can get all references of object  Like Table , Stored procedures ,Scalar function ..etc In Scalar function ,Trigger ,View ,stored procedure ..etc.

Many times we require that find all stored procedures that reference a given table .

By Following to search all objects in a database containing a certain string .

SELECT DISTINCT o.name AS ObjectName,
CASE o.xtype
WHEN 'C' THEN 'CHECK constraint'
WHEN 'D' THEN 'Default or DEFAULT constraint'
WHEN 'F' THEN 'FOREIGN KEY constraint'
WHEN 'FN' THEN 'Scalar function'
WHEN 'IF' THEN 'In-lined table-function'
WHEN 'K' THEN 'PRIMARY KEY or UNIQUE constraint'
WHEN 'L' THEN 'Log'
WHEN 'P' THEN 'Stored procedure'
WHEN 'R' THEN 'Rule'
WHEN 'RF' THEN 'Replication filter stored procedure'
WHEN 'S' THEN 'System table'
WHEN 'TF' THEN 'Table function'
WHEN 'TR' THEN 'Trigger'
WHEN 'U' THEN 'User table'
WHEN 'V' THEN 'View'
WHEN 'X' THEN 'Extended stored procedure'
ELSE o.xtype
END AS ObjectType,
ISNULL( p.Name, '[db]') AS Location
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
LEFT JOIN sysobjects p ON o.Parent_obj=p.id
WHERE c.text LIKE '%any text to search for%'
ORDER BY Location, ObjectName

If pass table object name then it show all references table in Stored procedures ,Scalar function ..etc .

If pass Stored procedure object name then it show all references Stored procedures in Stored Procedures ..etc .

Related Other posts

Html Code in Blodspot Radiobuttonlist Example Image In Datalist

Database backup in sql Server CheckboxList example Datetime format in gridview

Highest second record in sql Nested gridview Checkboxs in gridview

String was not recognized as a valid Boolean In C#

String was not recognized as a valid Boolean In C# .

Introduction : In this article i will show how to resolve the error string was not recognized as a valid Boolean in . Its very easy to resolve .just you need to create one method .Pass the string to method then it will return Boolean .

Method for valid Boolean :

    private static bool GetBoolean(string strValue)
    {
        if (strValue=="1")
            return true;
        else
            return false;
    }

Call the function :

 GetBoolean(stringValue) ;

Related Other posts

Html Code in Blodspot Radiobuttonlist Example Image In Datalist

Database backup in sql Server CheckboxList example Datetime format in gridview

Highest second record in sql Nested gridview Checkboxs in gridview

Free Open Source Rich-text editors List

Free Open Source Rich-text editors List

Rich-text editors are web components that allow users to edit and enter text within a web browser.
Its allows you to format the text .Following are the list of open source html editors .

Tinymce

Its a Javascript WYSIWYG Editor and Open Source under LGPL by Moxiecode Systems AB.It is a easy to integrate , custimizable and lightweight .


Following is the example of the tinymce editor :-

Example :-

Download
Demo



FCK Editor

FCKeditor has been around for more than six years. Since 2003 it has built a strong user community becoming the most used editor in the market, accumulating more than 3,5 million downloads.
In 2009, it renamed to the editor CKEditor, bringing to light the next generation of our software: CKEditor 3.0.

Because CKEditor is licensed under flexible Open Source and commercial licenses, you'll be able to integrate and use it inside any kind of application.
This is the ideal editor for developers, created to provide easy and powerful solutions to their users.
Editor with all features
- Interface color
- Multi-language interface
- Custom toolbar
- Skins

Example :-

Download
Demo

FreeTextBox HTML Editor

The free version of FreeTextBox enables users to do basic HTML editing in a WYSIWYG environment with a look and feel similar to desktop products.
It is the  popular free ASP.NET WYSIWYG rich HTML editor

Browser Support

    IE 6,7,8,9
    Firefox 1+
    Google Chrome 1+
    Apple Safari 3,4,5
    Opera 7,8,9,10

Example :-

Demo
Download

Related Other posts

Html Code in Blodspot Radiobuttonlist Example Image In Datalist Database backup in sql Server CheckboxList example Datetime format in gridview

Bind Image In Datalist Control In Asp.net c#

Bind Image In Datalist Control In Asp.net c#

Introduction :-
I have used the dataList asp control to display images and images are stored in application directory .
I have written the html code as well as the code behind code to bind the images in datakist control in c# .
The itemTemplate of dataList is used to display images of product .

Display of Images :-

HTML Code of Datalist :-

<asp:DataList ID="dlImages" runat="server" RepeatDirection="Horizontal" RepeatColumns="2" BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px"
CellPadding="4" CellSpacing="2" ForeColor="Black" GridLines="Both">
<FooterStyle BackColor="#CCCCCC" />
<ItemTemplate>
    <table  style="font-family:Courier New;border-style:dotted;border-width:thick" >
        <tr>
            <td align="right">Product Name :-</td>
            <td><asp:Label ID="lblName" Text='<%# Eval("Name") %>' runat="server"></asp:Label></td>
        </tr>
        <tr>
            <td valign="top">Product Image :-</td>
            <td><asp:Image ID="imageProduct" Width="150" Height="150" ImageUrl='<%# Eval("ImagePath") %>' runat="server" /></td>
        </tr>
    </table>
</ItemTemplate>
<ItemStyle BackColor="White" />
<SeparatorStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
    Font-Underline="False" />
<SelectedItemStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
</asp:DataList>

c# Code for Bind Image Datalist :

protected void Page_Load(object sender, EventArgs e) {
         if (!IsPostBack)
        {
            dlImages.DataSource = DataBindInDataLIST();
            dlImages.DataBind();
        }
    }
    public DataTable DataBindInDataLIST()
    {
        //--Decalration Of Data Table ---//
        DataTable Dt = new DataTable();
        //--Decalration Of Data Column-----//
        DataColumn DCID = new DataColumn("Name", typeof(String));
        DataColumn DCName = new DataColumn("ImagePath", typeof(String));
        //-- Add Data Column to DataTable --//
        Dt.Columns.Add(DCID);
        Dt.Columns.Add(DCName);
        //-- Add Data Rows to DataTable --//
        DataRow Dr1 = Dt.NewRow();
        Dr1["ImagePath"] = "~\\ProductImage\\Blue hills.jpg";
        Dr1["Name"] = "Blue hills";

        DataRow Dr2 = Dt.NewRow();
        Dr2["ImagePath"] = "ProductImage\\Sunset.jpg";
        Dr2["Name"] = "Sunset";
        DataRow Dr3 = Dt.NewRow();
        Dr3["ImagePath"] = "ProductImage\\Water lilies.jpg";
        Dr3["Name"] = "Water lilies";
        DataRow Dr4 = Dt.NewRow();
        Dr4["ImagePath"] = "ProductImage\\Winter.jpg";
        Dr4["Name"] = "Winter";   
        Dt.Rows.Add(Dr1);
        Dt.Rows.Add(Dr2);
        Dt.Rows.Add(Dr3);
        Dt.Rows.Add(Dr4);
        return Dt;
    }

I hope this article will help You .

Related Other posts

Sorting, Paging, Add, Update, Delete in GridView Check / Uncheck all checkbox in treeview using jquery Image In Datalist Merge docs files in c#

Bind Treeview in asp.net c# using dataset CheckboxList example Datetime format in gridview Send mail in asp.net c#

Highest second record in sql Nested gridview Checkboxs in gridview Validation using jquery in asp.net page

Fetch Highest second Record In SQL Server

Fetch Highest second Record In SQL Server.

Introduction : In this article i will show you how to fetch second highest salary record in sql server database .Here you can fetch entire second highest row from the table in sql server .To achieve the highest record i have used Row_number().

Example :  Following is example which fetch second highest salary record from the table in sql server .

Select * from ( select  Row_number() over (  order by salary desc ) as Row_INDEX , * From Data ) as Temp where Row_INDEX = 2

Related Other posts

Html Code in blog Radiobuttonlist Example Image In Datalist Merge docs files in c#

Database backup in sql Server CheckboxList example Datetime format in gridview Send mail in asp.net c#

Highest second record in sql Nested gridview Checkboxs in gridview Validation using jquery in asp.net page

To take back up of database In Sql Server

To take back up of database In SQL Server Database .


Follow the steps :

I have explained how to take back up of database using SQL Server Management Studio .

1. Fisrt Connect to the appropriate SQL Server Database Engine .

2. Expand Databases and select the databse which you want to take a back up  .

3. Rigth Click On Database and Go to the Task Option and In task Option Click on the Back Up option .

4.After then One dialog box will open then Add the destination file path where you want to save the back up file .

5.Click on the add button for the destination path .

6.One Dialog Box will open then choose the destination path and give the file name with .bak extension ,Like TestBaup.bak .

7.Finally you need click on OK Button .


8.Once back Up of database complete , One message will prompt that "The backup of database 'DatabaseName' completed successfully .