Creating Full Text Catalog and Full Text Search

http://www.codeproject.com/Articles/29237/SQL-SERVER-Creating-Full-Text-Catalog-and-Ful

Clickonce , "Your Web browser settings do not allow you to run unsigned applications.!

1 - Tools->Options->Security tab->Trusted Sites->Sites button->Add->OK 

2 - Tools->Options->Security tab->Trusted Sites->Custom Level->Automatic login with current user and password 

3 - Tools->Options->Advanced->Allow software to run even if the signature is invalid.

CASCADE ex in SQL server!

CREATE TABLE [dbo].[Products](

[ProductID] [int] NOT NULL,

[ProductDesc] [varchar](50) NOT NULL,

CONSTRAINT [PK_Products] PRIMARY KEY CLUSTERED

(

[ProductID] ASC

)) ON [PRIMARY]

CREATE TABLE [dbo].[ProductDetails](

[ProductDetailID] [int] NOT NULL,

[ProductID] [int] NOT NULL,

[Total] [int] NOT NULL,

CONSTRAINT [PK_ProductDetails] PRIMARY KEY CLUSTERED

(

[ProductDetailID] ASC

)) ON [PRIMARY]

GO

ALTER TABLE [dbo].[ProductDetails] WITH CHECK ADD CONSTRAINT

[FK_ProductDetails_Products] FOREIGN KEY([ProductID])

REFERENCES [dbo].[Products] ([ProductID])

ON UPDATE CASCADE

ON DELETE CASCADE

INSERT INTO Products (ProductID, ProductDesc)

SELECT 1, 'Bike'

UNION ALL

SELECT 2, 'Car'

UNION ALL

SELECT 3, 'Books'

INSERT INTO ProductDetails

([ProductDetailID],[ProductID],[Total])

SELECT 1, 1, 200

UNION ALL

SELECT 2, 1, 100

UNION ALL

SELECT 3, 1, 111

UNION ALL

SELECT 4, 2, 200

UNION ALL

SELECT 5, 3, 100

UNION ALL

SELECT 6, 3, 100

UNION ALL

SELECT 7, 3, 200

SELECT *

FROM Products

SELECT *

FROM ProductDetails

DELETE

FROM Products

WHERE ProductID = 1

select * from dbo.ProductDetails

select * from dbo.Products

DROP TABLE ProductDetails

DROP TABLE Products

Error occured while registering with Source control

In Visual studio , Tools - -> Options - -> Source control 
change manager version was selected as the source control plug in. I changed it to None. Then i did not get any error. (error occurred registering this project with source control). 

Error : “Unable to start debugging on the web server…” ASP.NET 4.0

Solution 

cd %windir%\Microsoft.NET\Framework\v4.0.30319

aspnet_regiis.exe -i

Check for duplicate and insert into a data table C#

//preparing the column and values to be searched inside the table.

    string find = "ReferredFieldId = '" + referredControlId + "' AND  FormulaFieldId = '" +          CalculateFormula.ID + "'";

  DataRow[] foundRows = FormulaFieldData.Select(find);

//checking any rows exists or not if not inserting

if (foundRows.Length.Equals(o))

                                    {

DataTable dt = FormulaFieldData;

                                        dt.Rows.Add(referredControlId, referredFieldName, referedFieldIds, CalculateFormula.ID, CalculateFormula.ToolTip);

                                        FormulaFieldData = dt;

}