Software Developer

No row was updated

2012-01-20T10:49:00.000+03:30

Error:
- A SQL Server Database contains some tables but one of table's rows cannot be updated!!
- How i can update some NULL rows in my table ?
- Can't update rows (...) in Microsoft Visual Studio ...

Error Message:

No row was updated.
The data in row X was not committed.
Error Source: Microsoft.VisualStudio.DataTools.
Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(N rows).
Correct the errors and retry or press ESC to cancel the change(s).

Problem Causes:

This issue occurs if the following conditions are true:
- The table contains one or more columns of the text or ntext data type.
- The value of one of these columns contains the following characters:
- Percent sign (%)
- Underscore (_)
- Left bracket ([)
- The table does not contain a primary key.

Solution:
This is a Microsoft BUG (BUG-925719)
There's not any solution. You need to have a new table with a primary key or correct values and copy data into new table and drop old table, Sorry.

Solution In Microsoft Visual Studio (NEW):
- Goto Server Explorer
- Goto Database > Tables > The Table
- RightClick and Select Edit Table Schema
- ADD a new Column with these options
- Data Type: uniqueidentifier
- Allow Nulls: No
- Unique: Yes
- Primary Key: Yes
- Is RowGuid: True
- Save and Close and open Table and update rows ;-)

REF: http://amastaneh.blogspot.com/2012/01/no-rows-were-deleted.html

No rows were deleted

2012-01-19T10:39:00.001+03:30

Error:
- A SQL Server Database contains some tables but one of table's rows cannot be deleted!!
- How i can delete some NULL rows in my table ?
- Can't delete rows (...) in Microsoft Visual Studio ...

Error Message:

No rows were deleted.
A problem occured attempting to delete row 3.
Error Source: Microsft.VisualStudio.DataTools.
Error Message: The row value(s) updated or deleted either do not make
the row unique or they alter multiple rows (3 rows)
Correct the errors and attempt to delete rows again or press ESC to cancel the change(s)

Problem Causes:
This issue occurs if the following conditions are true:
- The table contains one or more columns of the text or ntext data type.
- The value of one of these columns contains the following characters:
- Percent sign (%)
- Underscore (_)
- Left bracket ([)
- The table does not contain a primary key.

Solution:
This is a Microsoft BUG (BUG-925719)
There's not any solution. You need to have a new table with a primary key or correct values and copy data into new table and drop old table, Sorry.

Solution In Microsoft Visual Studio (NEW):
- Goto Server Explorer
- Goto Database > Tables > The Table
- RightClick and Select Edit Table Schema
- ADD a new Column with these options
- Data Type: uniqueidentifier
- Allow Nulls: No
- Unique: Yes
- Primary Key: Yes
- Is RowGuid: True
- Save and Close and open Table and delete rows ;-)

REF: http://amastaneh.blogspot.com/2012/01/no-row-was-updated.html

Database does not have a valid owner

2012-01-07T09:52:00.000+03:30

Error:
TITLE: Microsoft SQL Server Management Studio
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
BUTTONS:
OK

Solution:
A really short, simple and easy solution is, change the database owner to "sa" like below image

Expand WPF TreeView

2011-12-20T10:46:00.000+03:30

Questions
- How to expand all WPF TreeView nodes?
- Expand all nodes when a WPF TreeView is loaded
- Where is the default ExpandAll solution for WPF TreeView
- Expand all a WPF HierarchicalDataTemplate TreeView

Solution
Add below codes in XAML in TreeView tag.

  <TreeView.ItemContainerStyle>
      <Style>
          <Setter Property="TreeViewItem.IsExpanded" Value="True"/>
      </Style>
  </TreeView.ItemContainerStyle>

4.00 GB (2.99 GB usable)

2011-12-05T14:28:00.001+03:30

Problem
- I am using Windows 7 with 4GB of RAM but system properties says 4GB RAM(2.99GB Usable) ...
- Installed 4GB RAM but the windows 7 says Usable 2.99GB RAM
- Windows 7 shows 4.096 GB(2.96 GB Usable) memory
- Why the Windows 7 memory (RAM) 4 GB (3.25 GB usable) ...

Clean Solution
You need to install Windows 7 - 64 bit

Technical Answer
A 32bit desktop windows 7 can just address 4GB of memory addresses.
This memory is include RAM + other hardware memory like Graphic Card,
Then if you have
4GB RAM + 1GB Graphic Card Memory = ~3.0 GB RAM available
4GB RAM + 512MB Graphic Card Memory = ~3.5 GB RAM available
and etc...

Physical Memory Limits: Windows 7

The following table specifies the limits on physical memory for Windows 7 [link]

Version	Limit on X86	Limit on X64
Windows 7 Ultimate	4 GB	192 GB
Windows 7 Enterprise	4 GB	192 GB
Windows 7 Professional	4 GB	192 GB
Windows 7 Home Premium	4 GB	16 GB
Windows 7 Home Basic	4 GB	8 GB
Windows 7 Starter	2 GB

Fix wrong character keyboard typing

2011-12-01T15:41:00.001+03:30

Problem
How to fix wrong character display on notebook keyboard ...
Your keyboard wrong character typing in windows vista ...
How to fix wrong character display on U, I, O, J, K, L ...
How to fix numeral character instead of normal character

Solution
Press NumLk (ScrLk) + PrtSc (SysRq) and enjoy

Windows Mobile - Change Caller ID Matching

2011-09-27T12:33:00.003+03:30

Error:
- How can i change my phone number matching caller id ...
- Where can i find a setting for change matching algorithm for find contact of each called number
- Where's WINMO 6.x Setting for change caller id default setting for matching number and find contact

Solution:
In first step you need to have a registry editor software and install it on your windows mobile like below

1- Download and Install Windows Mobile Registry Editor v0.9 [here] and then go to

HKEY_CURRENT_USER/ControlPanel/Phone/CallIDMatch
This value is number of last character from incoming call or SMS for matching process and finding in contact list. You can change it from 8 or 9 to your favor and reboot it and enjoy ;-)

References:
- http://forum.xda-developers.com

WPF Application is not closed after shutdown

2011-09-17T12:37:00.002+04:30

Problem:
- WPF application is not closing correctly ...
- The users close application but the application is not closing.
- My application staying in background processes after closing.
- How to exit a WPF app correctly or programmatically?
- WPF (Avalon) application not closing correctly!
- The application not shuts down correctly!

Solution:
Add Closed Event to main window like below:

    private void DXRibbonWindow_Closed(object sender, EventArgs e)
    {
        //Environment.Exit(0);
        Application.Current.Shutdown();
    }

References:
LINK1: http://stackoverflow.com/questions/810531/wpf-application-is-not-closing-correctly
LINK2: http://stackoverflow.com/questions/3543704/wpf-application-still-runs-in-background-after-closing

This system does not support fullscreen mode

2011-09-13T12:26:00.000+04:30

Errors:
- Full screen mode for DOS programs in Windows 7
- No full screen mode for DOS programs?
- This system does not support fullscreen mode. Error in windows 7.
- I am supposed to run an old DOS program on my Windows 7 OS But ...
- There is no FullScreen DOS in Windows 7
- Full-screen problem in CMD.EXE and COMMAND.EXE

Solution 1:
You can use of DOSBOX which is an open source DOS emulator.

Solution 2:
You can disable your Display Adapter from Device Manager.

Solution 3:
You can disable your Display Adapter with DEVCON command-line utility in batch file or likes.
DEVCON help: link
DEVCON download: link
DEVCON sample: link

Windows Explorer has stopped working

2011-08-25T10:45:00.000+04:30

Problems:
- Windows Explorer has stopped working in windows 7
- Windows Explorer has stopped working in windows 7 starter
- Windows Explorer has stopped working in windows 7 64 bit
- Windows Explorer has stopped working fix
- When I try to open my personal folders and other WINDOWS related folders ...
- When copying files in Explorer, I started getting a "Windows Explorer has ...

Solution:
This ERROR comes from a specific problem. Your problem could be from your computer hardware, software or etc... BTW, simplest and original solution is
- Press CTRL+SHIFT+ESC keys for open Windows Task Manager
- Go to File > New Task (Run...) and Type "C:\" and press OK and then wait a little for open a windows explorer
- Go to Control Panel (from little arrow in left of title bar and select Control Panel or like)
- Go to Administrative Tools > View event logs (or Event Viewer)
- Go to Administrative Events and find the last and top error.
- Read the last error message. Your problem is there. If your problem is not solved you can copy & paste the last message in Google and find a solution.

Example:
- I had a problem with divxmfsource.dll and i fix it after install K-Lite Codec
- I had a problem with SnagIt Printer and i remove it and problem goes to hell ;-))

Edit a bundle in Google Reader

2011-08-20T09:56:00.000+04:30

Problem:
- How to edit a Bundle in Google Reader
- I can't find a EDIT link for a bundle in google reader
- Where's edit link for created bundles

Solution:
A carzy developer put it in behind ;-)
1- Go to Google Reader
2- Go to Browse for stuff
3- Find the blue link with "View your bundles »" text and click on it
4- You can find the "Edit" link in here :-D

CSR Bluetooth Problem

2011-08-15T07:02:00.002+04:30

Error:
- How to fix BlueSoleil USB Bluetooth® Dongle on Windows 7 ...
- I have a bluetooth device and it's not activated ...
- I can't turn on my CSR Bluetooth Device
- I am using Window 7 with CSR Bluetooth Device Dongle, guide me on how to connect

Solution:
- Check the USER and you must be a administrator. (this command helps you on this >whoami)
- Disable Anti-Virus software
- Disable Anti-Spyware software
- Disable Firewall software
- Uninstall Any Soleil software
- Uninstall Sony Bluespace software
- Uninstall XTNDConnect Blue Manager software
- Uninstall Microsoft Patch Q323183 (on WINDOWS XP)
- Uninstall Any drivers that were supplied with your existing Bluetooth device.
- Uninstall Microsoft IntelliType and IntelliPoint software for Bluetooth Mouse and Keyboards
- Plug-Out the bluetooth device now.
- Check the Control Panel\System and Security\Administrative Tools\Services\Bluetooth Support Service and start it
- Check the nxj.cache file and delete it (this command helps you on this >dir /a/s nxj.cache)
- Restart Windows
- Install Latest WIDCOMM Bluetooth Drivers or (http://download.lenovo.com/ibmdl/pub/pc/pccbbs/mobiles/7zbv19ww.exe)
- Goto Safe Mode
- Install Widcomm_patcher_v2 for overwrite on these files (wbtapi.dll, BTNeighborhood.dll, BTStackServer.exe, BTTray.exe)
- Restart Windows
- Plug the bluetooth device now and enjoy

Instructions for using the patch:
1) Uninstall ALL your previous Widcomm Bluetooth drivers
2) Switch off your PC
3) Remove your Bluetooth dongle from PC
4) Start your PC
5) Install the new drivers
6) Restart your PC in safe mode
7) Run the patch
8) Restart your PC
9) Plug in your Bluetooth dongle
10) Now everything should work properly

DevExpress ASPxHttpHandlerModule and DXR.axd problem

2011-08-10T23:47:00.003+04:30

Error
- when i deploy then the report tool bar icons just show "missing image" and log shows 404 for a bunch of calls to DXR.axd ...
- DevExpress and Image not Loading ...
- i have recently added Devexpress Charts to my reports. and i get the following errror message
- after upgrade version from v9 to v10 or v11 the some images can't loaded from DXR.axd ...

Solution
This problem is usually comes from the missing
- DevExpress.Web.ASPxThemes.v10.1.dll
- DevExpress.Web.ASPxThemes.v11.1.dll
or any in your application's Bin folder.

Cannot apply indexing with [] to an expression of type System.Collections.Generic.IEnumerable

2011-06-30T18:23:00.003+04:30

Error:
Cannot apply indexing with [] to an expression of type 'System.Collections.Generic.IEnumerable<ANY_TYPE>

Solution:
If used of IEnumerable SampleArray then you can access to elements like:
- SampleArray[index] WRONG
- SampleArray.ElementAt(index) RIGHT
Because the IEnumerable interface dose not support of [] for indexing :-))

Server-generated keys and server-generated values are not supported by SQL Server Compact

2011-06-15T15:54:00.005+04:30

Errors:
{"Server-generated keys and server-generated values are not supported by SQL Server Compact."}
{"An error occurred while updating the entries. See the inner exception for details."}

Problem:
The current version of Entity Framework does not support identity keys using SQL Compact ;-(

Solution:
1- Add the Guid.NewGuid() after new row like below here (for uniqueidentifier ID)

BindingListCollectionView CurrentView = categoriesViewSource.View as BindingListCollectionView;
Table tb1 = CurrentView.AddNew() as Table1;
tb1.ID = Guid.NewGuid();
this.CurrentView.CommitNew();

2- Another solution can be find the last and greatest ID and make a new one with ++ to that like here (for int ID)

3- Another solution can be used of DateTime.UtcNow.Ticks (for bigint ID)

PS: There's a little problem with True value for Identity property in SQL CE Table and must be set to False.

Make invisible layer in Flash CS5

2011-06-12T03:31:00.000+04:30

Hide layer (with click on eye icon) for invisible in design time and then right-click on layer and checked the Guide item for invisible in run-time.

Primary side of the relationship error on Entity Framework

2011-06-06T18:36:00.003+04:30

Error:
The relationship 'RELATIONSHIP NAME' has columns that are not part of the key of the table on the primary side of the relationship. The relationship was excluded.

Solution:
Attention to the RELATIONSHIP NAME in your database. The Relationship Name must have a unique name and this error comes from a duplicate relationship name in database. Entity Framework (EF 4.0) generator have problem with duplicate relationship names from databases.

WPF SelectedValue for TreeView

2011-06-01T21:08:00.001+04:30

Questions:
- How to programmatically select an Item in a WPF TreeView
- How to programmatically selecting an Item in a WPF TreeView
- How to SelectedItem in a WPF TreeView
- How to set SelectedItem or SelectedValue in C#/WPF TreeView
- WPF TreeView SelectedItem should have set accessor …
- How to programmatically change the SelectedItem in a WPF TreeView

Solution:
The Solution is simple and quick with just a little method

TreeViewItem matchItam = SelectTreeViewItem(this.treeView1.Items, "sample value");

The code is here

private TreeViewItem SelectTreeViewItem(ItemCollection Collection, String Value)
{
    if (Collection == null) return null;
    foreach(TreeViewItem Item in Collection)
    {
        /// Find in current
        if (Item.Header.Equals(Value))
        {
            Item.IsSelected = true;
            return Item;
        }

        /// Find in Childs
        if (Item.Items != null)
        {
            TreeViewItem childItem = this.SelectTreeViewItem(Item.Items, Value);
            if (childItem != null)
            {
                Item.IsExpanded = true;
                return childItem;
            }
        }
    }
    return null;
}

C# HTML Minification

2011-06-01T06:03:00.001+04:30

Questions:
- Is there any code which input the html source of a page and it will minify the code?
- A solution for Text Compress without used of GZip for...
- Minifies given HTML or XML source by removing extra whitespaces, comments and other unneeded Characters without breaking the content structure
- Minify HTML (or XHTML), and any CSS or JS included in your markup
- Compressing and Minifying HTML Markups

Solution:
I hope this helps.

/// Solution A
html = Regex.Replace(html, @"\n|\t", " ");
html = Regex.Replace(html, @">\s+<", "><").Trim();
html = Regex.Replace(html, @"\s{2,}", " ");

/// Solution B
html = Regex.Replace(html, @"(?<=[^])\t{2,}|(?<=[>])\s{2,}(?=[<])|(?<=[>])\s{2,11}(?=[<])|(?=[\n])\s{2,}", "");
html = Regex.Replace(html, @"[ \f\r\t\v]?([\n\xFE\xFF/{}[\];,<>*%&|^!~?:=])[\f\r\t\v]?", "$1");
html = html.Replace(";\n", ";");

/// Solution C
html = Regex.Replace(html, @"[a-zA-Z]+#", "#");
html = Regex.Replace(html, @"[\n\r]+\s*", string.Empty);
html = Regex.Replace(html, @"\s+", " ");
html = Regex.Replace(html, @"\s?([:,;{}])\s?", "$1");
html = html.Replace(";}", "}");
html = Regex.Replace(html, @"([\s:]0)(px|pt|%|em)", "$1");

/// Remove comments
html = Regex.Replace(html, @"/\*[\d\D]*?\*/", string.Empty);

References:
- Is there a better approach to minify html generated from aspx page
- Efficient stylesheet minification in C#
- Follow up to Additional CSS minifying regex patterns
- Improve ASP.NET Performance - CSSmin

Nullable String

2011-05-29T20:17:00.000+04:30

Error:
The type 'string' must be a non-nullable value type in order to use it as parameter 'T' in the generic type or method 'System.Nullable'

Problem:
- I have a function that I want to pass data that gets data from ...
- What's C# problme with nullable string ...
- Why no support for nullable string in C#
- C# have a problem with passing nullable string ...
- public void test(string? x){} has ERROR
- public void test(Nullable x){} has ERROR

Solution:
:-D System.String is a reference type and it is nullable. :-)

History of Adobe Media Player

2011-05-27T00:42:00.000+04:30

Problem:
- How do i delete all my personal videos in Adobe Media player?
- Where is file history in Adobe Media Player?
- How to clear history of Adobe Flash Player?

Solution:
It's so simple. Go to below folder and delete or rename it ... ;-)
C:\Users\{YOUR USER}\AppData\Roaming\Adobe\Adobe Media Player
like
C:\Users\Administrator\AppData\Roaming\Adobe\Adobe Media Player

Modifying a 'method' which contains a query expression will prevent

2011-05-25T04:31:00.000+04:30

Error:
Modifying a 'method' which contains a query expression will prevent the debug session from continuing while Edit and Continue is enabled.

Solution:
If did you add a LINQ code then you have no solution.
I'm serious and you can find the answer of microsoft out here

String was not recognized as a valid DateTime

2011-05-10T18:36:00.000+04:30

Error:
The message of exception is "String was not recognized as a valid DateTime."

Problem:
- I am trying to convert my string formated value to date type with DateTime.ParseExact but ...
- I get the error saying "String was not recognized as a valid DateTime" when I used of ParseExact ...
- ... in some value as "9/7/2008 13:00:00" when im going to set startdate it throw was not recognized as a valid DateTime and ...

Solution:
The DateTime.ParseExact have not any problem and the orginal problem comes from us thus you attention to String of Formatx
EXAMPLE: the string format for "02/Dec/2007:14:15:40 -08:00" is
WRONG: dd/MMM/yyyy:hh:mm:ss zzz
RIGHT: dd/MMM/yyyy:HH:mm:ss zzz

Did you got the problem source! It comes from (hh) and because the hour is greater than 12 need the (HH). Ok, look at again to the StringFormat and debug it again ;-)

Chaneg Googlemail to Gmail

2011-04-30T08:03:00.000+04:30

Questions
- How to migrate from Googlemail to Gmail?
- How to Convert Your @GoogleMail to @Gmail?

Solution
If did you have a google mail account like user@googlemail.com and you wanna change it to @gmail.com , it' easy if you follow me ;-)

1- Go to you Google Mail with user@googlemail.com
2- Go to Mail Setting (If you can't find the Mail Setting you can choose Google Account Setting and after that select the setting link in front of Google Mail)

3- Select Account and Important tab
4- Find the Switch to @gmail.com and click on it

5- Follow links and enjoy :-D

Hang and Freeze on Open/Save dialog in Windows 7

2011-04-26T01:43:00.002+04:30

Problem:
- When i clicked the button which will execute the Open Dialog or Save Dialog then hangs ...
- Whenever I request a "File|Open" or "File|Save" from any application, the Open or Save dialog box that opens freezes and hangs the ...
- IE8 will also hang on open and ...
- Whenever I try to use "Save as" dialog box and select an option, the window simply stops responding and ...
- "Save As" or "Open" dialog box hangs on windows 7
- "File Open" or "Save As" windows dialog boxes take too long to open

Solution:
At this moment I do NOT think that comes from Antivirus or software development companies bug. It's a Aero Problem i think so, but how cares ..., Please follow of following instruction for pass this problem till the Microsoft wake-up for this ;-)

1) You can change the compatibility of each application that you need to solve.
- Right-Click on Application Icon (or EXE file which related to that)
- Select Properties
- Select Compatibility Tab and Change the Compatibility Mode to Widows XP or another one

2) or Disable Aero Theme
- Open Appearance Setting and select a classic or standard theme.

3) or Scan
- Go to RUN (Win-Key + R) and type run the sfc /scannow