Generate MS SQL DataBase Script with Data in Sql Server 2008 and Visual Studio 2010


Generate MS SQL  Data Base Script with Data in Sql Server 2008 and Visual Studio 2010
1     1. Open Visual Studio 2010
2        2. Go to Tools->Connect to Data Base
3        3. Open Server Explorer right click on Data Base and select Publish to provider

Click Next and Chose the type of data publish

Click next and finish

Comments

Post a Comment

Popular posts from this blog

Display multiple marker point on Google Map with same location or same Longitude,Latitude

 Display multiple marker point on Google Map with same location or same Longitude, Latitude <!DOCTYPE html> <html> <head>     <title>Google Map</title> <!-- For Google Map Style Sheet--> <style type="text/css">     #map_canvas     {         height: 450px;         width: 980px;     }     .infowindow     {         font-size: 12px;         width: 200px !important;         font-family: verdana;     }     @media print     {         #map_canvas         {             height: 950px;         }     } </style> <!-- For Google Map--> <script src="http://maps.google.com/maps/api/js?v=3.7&amp;sensor=false" type="text/javascript"></script> <!--downlaod the oms.min.js javascript file from https://github.com/jawj/OverlappingMarkerSpiderfier --> <script src="JS/oms.min.js" type="text/javascript"></script> <script type="text/java
Read more

Implementing Zoom functionality in asp.net

Zoom functionality in asp.net 1. Write the Below code in the  <head> Tag  <script type="text/javascript">         function BrowserZoomPluse() {            nzoom = parseInt(divTest.style.zoom) + 30 + '%';             divTest.style.zoom = nzoom ;         }         function BrowserZoomMinuse() {             nzoom = parseInt(divTest.style.zoom) - 10 + '%';             divTest.style.zoom = nzoom ;         }         function ResetZoom() {             nzoom = parseInt(divTest.value);             divTest.style.zoom = '100%';         }     </script> 2. Add the below Code inside the <body> tag <div id="divTest" style="zoom: 100%">         <div class="textsize">          <a  href="javascript:void(0);" onclick="BrowserZoomPluse();">                 Zoom + </a>                  <a  href="javascript:void(0);" onclick="BrowserZoom
Read more

Check Session Timeot for Whole Application

1. Create a BasePage.cs in App_Code  and write the following code         protected void Page_Init(object sender, EventArgs e)         {             if (Context.Session != null)             {                 if (Session.IsNewSession)                 {                     HttpCookie newSessionIdCookie = Request.Cookies["ASP.NET_SessionId"];                     if (newSessionIdCookie != null)                     {                         string newSessionIdCookieValue = newSessionIdCookie.Value;                         if (newSessionIdCookieValue != string.Empty)                         {                             //This means Session was timed Out and New Session was started                             Response.Redirect("Home.aspx");                         }                     }                 }             }         } 2. Inherit this basepage on all the aspx pages such as using System; using System.Collections.Generic; using System.Col
Read more