Date , day , month year in Sql-server and asp.net c#

Date , day , month year in Sql-server and asp.net c#

sql-server

select DATEPART(yyyy, getdate())

select DATEPART(dd, getdate())

select DATEPART(mm, getdate())

select convert(varchar,getdate(),101)

asp.net c#

int streventday = DateTime.Now.Day;

int streventmnt = DateTime.Now.Month;

int streventyear = DateTime.Now.Year;

string strdate DateTime.Now.ToString("MM/dd/yyyy");

HyperLinkField Multiple parameter

<asp:HyperLinkField DataNavigateUrlFields="Type, MyParam2, MyParam3"DataNavigateUrlFormatString="Order_Details.aspx?MyParameter={0}&param2={1}&param3={2}"

HeaderText="Details" Text="Details" />

Disable Form Submit on Enter Key Press

How To: Disable Form Submit on Enter Key Press

Set Focus on Control C#

Button1.Focus();

 

Send emails in ASP.NET using Gmail credential

CodeProject: Send emails in ASP.NET using Gmail credentials. Free source code and programming help

As ASP.NET web developers, we often have to include an email sending module in our websites. When I was completing my third year project in the university, I had the same requirement in my web project. I had to go through so many web sites and blogs to find a solution. Using the class file included with this article, you can send emails by entering your Gmail account credentials.

Windows Desktop Sharing with RDP in Vista

CodeProject: Windows Desktop Sharing with RDP in Vista: Add a Professional Interactive Help System to your Applications. Free source code and programming help: "Windows Desktop Sharing with RDP in Vista: Add a Professional Interactive Help System to your Applications"

Windows Vista introduced a powerful Remote Desktop Management API which is relatively unknown. This article will present an easy way to use it, in order to provide professional level help in your Vista applications.

Fully Editable GridView in ASP.NET 2 using C#

Fully Editable GridView in ASP.NET 2 using C#


This article describes how I made a fully editable gridview in C# using ASP.NET 2. The idea is that the GridView looks and works like an Excel spreadsheet. You see all the cells in the table, and you can edit any of the cells you like, and they are automatically updated (i.e. saved to the database). This is very often how people expect data tables to work in web pages, and I've often seen people clicking in vain on un-editable gridview cells, somehow expecting to edit them, and not understanding that they need to click an Edit button at the end of the row.

note:"Tested code"

Dynamic Sql-server Table name as a variable

Create procedure s_ProcTable

@TableName varchar(128)

as

declare @sql varchar(4000)

select @sql = 'select * from [' + @TableName + ']'

exec (@sql)

go

s_ProcTable 'Your Proc Name'

Insert Add Dynamically Menu Items C# asp.net

MenuItemCollection.AddAt Method (System.Web.UI.WebControls)

Inserts the specified MenuItem object in the current MenuItemCollection object at the specified index location.

Deploying ASP.NET Applications

Deploying ASP.NET Applications: "Deploying ASP.NET Applications"
After creating and testing your ASP.NET application, the next step is to deploy the application. Deployment is the process of distributing the finished application to be installed on other computer. We can use the built-in deployment feature that comes with Visual studio .NET to create a Windows Installer file - a .msi file for the purpose of deploying applications.

CodeProject: ColorPicker - ColorPicker with a compact footprint (VB.NET). Free source code and programming help

CodeProject: ColorPicker - ColorPicker with a compact footprint (VB.NET). Free source code and programming help
color picker... isn't there a bunch of those out there already? Yeah, but not really what I needed. There are some cool ones out there, but they were either too big, or too limited. Besides, I enjoy the challenge. What I wanted was to be able to easily select a color from a color gradient bar and adjust the brightness and saturation (HSB).

Maximum numbers of rows in MS access

Maximum numbers of rows in MS access

---It's not the number of rows (records) that matter, it's the amount of torage capacity. Database (.mdb) file size 1 gigabyte.
However, because your database can include linked tables in other files, its total size is limited only by available storage capacity

----Database (.mdb) file size 1 gigabyte.
However, because your database can include linked tables in other files, its total size is limited only by available storage capacity.

Web Slices

Web Slices

This section offers conceptual overview material for Web Slices, introduced with Windows Internet Explorer 8. A Web Slice uses simple HTML markup to represent a clipping of a Web page, enabling users to subscribe to content directly within a Web page.

Subscribing to Content with Web Slices

Today, many Web sites provide content updates through Really Simple Syndication (RSS) news feeds. This requires a Web site to duplicate some content as a special XML file, called a feed, that a news reader application can download and check for updates. In contrast, a Web Slice enables users to subscribe to content directly within a Web page; a separate feed file is not required. Users monitor content changes and view the updated portion of the Web page directly from the Favorites bar (the improved Links toolbar) of Internet Explorer.

Web Slice Format Specification - Version 0.9

A Web Slice allows users to subscribe to a portion of a Web page. The Web Slice format consists of the minimum HTML annotations necessary to enable the publication and consumption of a mutable item on a Web page. Web publishers can use this format in conjunction with properties from hAtom Microformat  to make portions of a Web page subscribe-able.

http://msdn.microsoft.com/en-us/library/cc956158(VS.85).aspx

 

SQL Server Locks

 
Use sp_who and sp_who2  to identify which processes may be blocking other processes.
 
 
You can override how SQL Server performs locking on a table by using the SP_INDEXOPTION command. Below is an example of code you can run to tell SQL Server to use page locking, not row locks, for a specific table:
 
SP_INDEXOPTION 'table_name', 'AllowRowLocks', FALSE
GO
SP_INDEXOPTION 'table_name', 'AllowPageLocks', FALSE
GO

---

See how Windows Mobile brings your life together—at home, work, or on the go. See Now

Insert Blank Value in Access Database sample c#

Date

if

(txtpayDate.Text.Length == 0){cmd.Parameters["@ENTDATE"].Value = DBNull.Value;}

text

if

(txtCaseNO.Text.Length == 0){cmd.Parameters["@CASEID"].Value = DBNull.Value;}