.Net STUFF's - Guide to get it..

Check all,Select all checkbox in gridview asp.net

Header checkbox to select all the check box in the particular grid.

Place the below script inside the head tag

Include the below checkbox in your gridview:

HOW TO TRACK STORED PROCEUDRE, TABLE, FUNCTION ALTERATION IN SQL SERVER ?

CREATE TABLE [dbo].[AdministratorLog](
[databasename] [varchar](256) NULL,
[eventtype] [varchar](50) NULL,
[objectname] [varchar](256) NULL,
[objecttype] [varchar](25) NULL,
[sqlcommand] [varchar](max) NULL,
[loginname] [varchar](256) NULL,
[createdon] [datetime] NULL
)

GO  

CREATE TRIGGER [Admin_Backup_Objects]
ON DATABASE
FOR create_procedure, alter_procedure, drop_procedure,
create_table, alter_table, drop_table,
create_function, alter_function, drop_function
AS
SET NOCOUNT ON
DECLARE @data XML
SET @data = EVENTDATA()

INSERT INTO dbo.AdministratorLog(databasename, eventtype,objectname, objecttype, sqlcommand, loginname,createdon)
VALUES(
@data.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'varchar(256)'),
@data.value('(/EVENT_INSTANCE/EventType)[1]', 'varchar(50)'),  -- value is case-sensitive
@data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'varchar(256)'), 
@data.value('(/EVENT_INSTANCE/ObjectType)[1]', 'varchar(25)'), 
@data.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'varchar(max)'), 
@data.value('(/EVENT_INSTANCE/LoginName)[1]', 'varchar(256)'),GETDATE()
)

GO


Thanks to Deeraj & dotnetfunda

The selected file is a solution file but was created by a newer version of this application and cannot be opened 2012 to 2010

Error when i'm trying to open VS 2012 project in VS 2010


Tried with the below approach, it worked out. But i'm not sure this is a best way to do.Take a risk, do it..

• Just open the solution in a text editor 
• in the second line you can find Microsoft Visual Studio Solution File, 
• Format Version 12.00 
• Try to open the solution and it works.
• change the version to 11.00 and save it.