DHCP reservation on Server 2003

13-Feb-1212 Leave a comment

 

Start > Administrative Tools > DHCP

If the server is not connected then DHCP > Right-click > Add Server

Server name > Scope > Reservations > Add need MAC address from PC that you want to fix IP. To get this do an ipconfig /all on that pc

 

Filed under Servers Tagged with

Windows Forms DataBinding displays ‘System.Data.DataRowView’ in text boxes and other controls

09-Feb-1212 Leave a comment

ERROR

Windows Forms DataBinding displays ‘System.Data.DataRowView’ in text boxes and other controls

SOLVED

Was a ComboBox databinding pointing at a field no longer in the dataset.

Filed under ADO.Net, Errors, Troubleshooting, Windows Forms Tagged with

Entity Framework EntityState context.Entry().State

08-Feb-1212 Leave a comment

Entity Framework EntityState

context.Entry(<object>).State

http://blogs.msdn.com/b/adonet/archive/2011/01/29/using-dbcontext-in-ef-feature-ctp5-part-4-add-attach-and-entity-states.aspx

http://msdn.microsoft.com/en-us/library/system.data.entity.infrastructure.dbentityentry(v=vs.103).aspx

Filed under Entity Framework

Problem: Dataset with code behind repeatedly needs Run Custom Tool to compile

08-Feb-1212 Leave a comment

Maybe source code control put the vb code in the wrong place. The .vb code should be underneath the dataset in show all files, not alongside it.
Backup the current .vb code, then copy it to clipboard and delete it. Then go into the dataset and right-click > view code > then paste the code in there. The newly created .vb code file will now be behind and everything should work from now on.

Filed under ADO.Net, Troubleshooting Tagged with

Problem: Dataset does not generate Insert command

08-Feb-1212 Leave a comment

SOLVED today by:

Changing the select statement to SELECT * FROM then pull the fields in again.

Filed under ADO.Net, Errors, Troubleshooting Tagged with

WPF Filter

01-Feb-1212 Leave a comment

Terrible trouble. Predicate confusion. Following works

Method 1 : Entity Framework

See http://wp.me/p17IS4-mX

Method 2

CType(BookViewSource.View, BindingListCollectionView).CustomFilter = String.Concat(“Title LIKE ‘%”, FilterTextBox.Text, “%'”)

Method 3

Dim view As New System.Data.DataView(Me.dsBook1.Books)
view.RowFilter = String.Format(“Title LIKE ‘%{0}%'”, FilterTextBox.Text)
MainGrid.DataContext = view

then possibly with Try-Catch

Private Sub ClearFilter()
MainGrid.DataContext = BookViewSource
CType(BookViewSource.View, BindingListCollectionView).CustomFilter = Nothing
End Sub

Filed under WPF

Newer posts →