Remove the "Homegroup" icon from the desktop

Read more »

Remove the "Homegroup" icon from the desktop

1) Drive to "Folder Options"
2) Click "View"
3) Scroll down to "Use Sharing Wizard (Recommended)" it must be checked
4) Un-Check  the Check -box
5) Click "Apply". The Icon will be removed from your desktop
6) Re-Check the Check-box. the icon will not be back

Remove the "Homegroup" icon from the desktop

Posted by : Pooja

Date :Wednesday, May 28, 2014

With 0comments

Update the .edmx file when the database changes

Read more »

To update the .edmx file when the database changes

1. In the Model Browser, right-click the .edmx file and select Update Model from Database.
2. The Update Model Wizard starts. If there is no database connection specified, the Choose Your Database Connection dialog box appears. Otherwise, the Choose Your Database Objects dialog box appears. 
3. If the Choose Your Database Connection dialog box appears, specify a database connection. Otherwise, go to the next step.
4. For details about specifying a connection, see Choose Your Data Connection Dialog Box (Entity Data Model Wizard). When you have specified the connection, click Next to display the Choose Your Database Objects dialog box.
5. Click the Add tab.
   Nodes for tables, views, and stored procedures are displayed. If any objects have been added to the database (or were not included in the previous storage model), you can expand the corresponding node to view the objects that are available to add to the conceptual model.
6.  If an object has been deleted from the conceptual model but has not also been deleted from the storage model, the object will not be available to add to the conceptual model.
7. Expand the Tables, Views, and Stored Procedures nodes, and check the objects you want to add to the .edmx file.
8. Click the Refresh tab.
   Nodes for tables, views, and stored procedures that are included in the existing storage model are displayed. Any changes that have been made to these database objects will be reflected in the updated storage model. Changes to the conceptual model are made when columns are added to a table or view.
9. Click the Delete tab.
   Nodes for tables, views, and stored procedures are displayed. If an object has been deleted from the database and was included in the previous storage model, you can expand the corresponding node. The objects in these nodes will be deleted from the updated model.
   Click Finish to update the .edmx file with the database changes.

Reference - MSDN

Update the .edmx file when the database changes

Posted by : Pooja

Date :Saturday, May 17, 2014

With 0comments

Tag : AJAX, ASP.NET, C#.NET, Database, SQL Server, Web Service, Windows 8

How to apply RowFilter on DataView

Read more »

Following code can be used to apply filter on the DataView

 DataSet ds = new DataSet();  
 ds= GetData();  
 DataView dv = ds.Tables[0].DefaultView;  
 dv.RowFilter = "SrNo='" + txtSNo.Text.Trim() + "'";   

LIKE, AND , OR operators can also be used in the RowFilter of Dataview.

To access the filtered records, each DataRowView of the DataView

 foreach (DataRowView drv in dv)  
       {  
         currentName = Convert.ToString(drv["Name"]);  
       }  

How to apply RowFilter on DataView

Posted by : Pooja

Date :Friday, May 9, 2014

With 0comments

Tag : ASP.NET, C#.NET, Database, Miscellaneous, MS SQL Server, SQL Server