Set Identity From Zero for Existing Table

-
DELETE FROM ProjectMaster;
DBCC CHECKIDENT (ProjectMaster, RESEED, 0)

Comments

Post a Comment

Popular posts from this blog

GridView Design Using CSS

-
Image
 Create Css File in your Project...And Add Reference to Grid View page * {     padding: 0;     margin: 0; } body {     font: 11px Tahoma;     background-color: #F7F7E9; } h1 {     font: bold 32px Times;     color: #666;     text-align: center;     padding: 20px 0;    } #container {     width: 700px;     margin: 10px auto; } .mGrid  {     width: 100%;     background-color: #fff;     margin: 5px 0 10px 0;     border: solid 1px #525252;     border-collapse:collapse; } .mGrid td {    padding: 2px;    border: solid 1px #c1c1c1;    color: #717171; } .mGrid th {     padding: 4px 2px;     color: #fff;     background: #424242 url(grd_head....
Read more

Create and send HTML Formatted Emails in ASP.Net using C#

-
Create File name as Test.htm <html xmlns="http://www.w3.org/1999/xhtml"> <head>     <title></title> </head> <body>     <img src="/Logo.png" /><br />     <br />     <div style="border-top: 3px solid #22BCE5">         &nbsp;</div>     <span style="font-family: Arial; font-size: 10pt">Hello <b>{UserName}</b>,<br />         <br />         A new article has been published on ASPSnippets.<br />         <br />         <a style="color: #22BCE5" href="{Url}">{Title}</a><br />         {Description}         <br />      ...
Read more

Linq Query Using Joins with AsEnumerable()

-
var qu = (from tt in table1.AsEnumerable()           join ss in table2.AsEnumerable() on tt.Field<int>("UniqID")       equals ss.Field<int>(" UniqID ")                                        select new             {               FirstName = tt.Field<string>("ColumnsFName"),               LastName = ss.Field<string>("ColumnsLName"),             }).ToList(); Note:- Using Left join we should check   null rows in the second table. If have null row it`s throw error without ...
Read more