taskkill /pid /F
Force to kill aspwp.exe and then delete all C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files
Then rebuild .NET solution all will look a lot clearner.
This blog shares my journey as a software engineer, along with personal reviews and life experiences I’ve gained along the way. “I have not failed. I've just found 10,000 ways that won't work.” — Thomas Edison. If you enjoy my content, please support it by clicking on ads (free for you, big help for me!) or by buying me a coffee on Ko-fi. Thank you!
Friday, April 26, 2013
When you work in distributed environment you probably use remote desktop session as you primary method of sql server machines administration. When critical windows updates are installed or when you install system or sql server service pack installation wizard promts you to restart the box in order to complete the installation. And it happens from time to time that this machine hangs on reboot process for some reason and you can no longer connect it via remote desktop. If it was you local computer you could enter into your server room and press the reset button but if it stand thousands miles away from you it becomes a real problem.How to restart or shutdown remote machine
If you can ping this machine from other computer and you have administrators rights on that machine you may use windows utility.
On a computer that has connection to the server which needs to be restarted or shutdown go to Start -> Run and type shutdown -i
This window will show up. Press Add and type either IP or DNS of remote server.
Select shutdown or restart and press OK. That 's it. For your convenience you may run from command line constanct ping (ping servername -t) when the server actually stopped to respond to pings and when it started again.
Alternatively you can go to command prompt (start -> run -> cmd) on your workstation and Type
shutdown -r -m \\x.x.x.x
Replace x.x.x.x with the IP address or computer name of the remote machine. -r option is for restart, don't use -r if want to just shut down the system.
If you can ping this machine from other computer and you have administrators rights on that machine you may use windows utility.
On a computer that has connection to the server which needs to be restarted or shutdown go to Start -> Run and type shutdown -i
This window will show up. Press Add and type either IP or DNS of remote server.
Select shutdown or restart and press OK. That 's it. For your convenience you may run from command line constanct ping (ping servername -t) when the server actually stopped to respond to pings and when it started again.
Alternatively you can go to command prompt (start -> run -> cmd) on your workstation and Type
shutdown -r -m \\x.x.x.x
Replace x.x.x.x with the IP address or computer name of the remote machine. -r option is for restart, don't use -r if want to just shut down the system.
Demystify SQL Debugging with with Visual Studio
Here is what I did to fix this issue "FINALLY"
http://www.asp.net/data-access/tutorials/debugging-stored-procedures-vb
#1 Connect using Windows Authentication as the same account on the local machine that must have sysadmin rights in the Instance of SQL Server.
#2 They use Server Explorer and connect with that same account and then once connect right click on the DB and check "Application Debuggin. I am posting this to my blog.
Great posts. By the way I feel the pain of remote individuals, my answer tell your management that if you want fast, rapid code to fork up the dough for SQL Developer Edition and do all you coding locally with a quality source control.
Robert.
http://www.asp.net/data-access/tutorials/debugging-stored-procedures-vb
#1 Connect using Windows Authentication as the same account on the local machine that must have sysadmin rights in the Instance of SQL Server.
#2 They use Server Explorer and connect with that same account and then once connect right click on the DB and check "Application Debuggin. I am posting this to my blog.
Great posts. By the way I feel the pain of remote individuals, my answer tell your management that if you want fast, rapid code to fork up the dough for SQL Developer Edition and do all you coding locally with a quality source control.
Robert.
Wednesday, April 24, 2013
Try Catch VB.NET and C#
Try + Enter blows out exception method for vb.net
Try tab tab tab C# for Exception method
Provided by Daniel Bivens
Try tab tab tab C# for Exception method
Provided by Daniel Bivens
Opacity on Images for Web Development
CSS Style --
input[type="image"].disabled { /* Required for IE 5, 6, 7 */ /* ...or something to trigger hasLayout, like zoom: 1; */ /*/width: 100%; */ /* Theoretically for IE 8 & 9 (more valid) */ /* ...but not required as filter works too */ /* should come BEFORE filter */ -ms-filter:"progid:DXImageTransform.Microsoft.Alpha(Opacity=50)"; /* This works in IE 8 & 9 too */ /* ... but also 5, 6, 7 */ filter: alpha(opacity=35); /* Older than Firefox 0.9 */ -moz-opacity:0.35; /* Safari 1.x (pre WebKit!) */ -khtml-opacity: 0.35; /* Modern! /* Firefox 0.9+, Safari 2?, Chrome any? /* Opera 9+, IE 9+ */ opacity: 0.35; cursor:default; }
function enableElement(element) { $(element).removeClass('disabled').prop('disabled', false); }
function disableElement(element) { var obj = $(element); obj.prop('disabled', true); if (obj.prop('tagName') === 'INPUT' && obj.prop('type') === 'image') { obj.addClass('disabled'); } }
Thanks Josh Horton... Web Developer GURU....
Thursday, April 11, 2013
Code Academy - Good Stuff
HTTP Status Codes
A successful request to the server results in a response, which is the message the server sends back to you, the client.
The response from the server will contain a three-digit status code. These codes can start with a 1, 2, 3, 4, or 5, and each set of codes means something different. (You can read the full list here). They work like this:
1xx: You won't see these a lot. The server is saying, "Got it! I'm working on your request."
2xx: These mean "okay!" The server sends these when it's successfully responding to your request. (Remember when you got a "200" back from Codecademy?)
3xx: These mean "I can do what you want, but I have to do something else first." You might see this if a website has changed addresses and you're using the old one; the server might have to reroute the request before it can get you the resource you asked for.
4xx: These mean you probably made a mistake. The most famous is "404," meaning "file not found": you asked for a resource or web page that doesn't exist.
5xx: These mean the server goofed up and can't successfully respond to your request.
Wednesday, April 10, 2013
Keyboard shortcuts
Instructions
- Select one word by placing your cursor at one end of the word. Hold down the "Ctrl" key and the "Shift" key. Press the right arrow key to select the word to the right, or press the left arrow key to select the word to the left.
- Select one character at a time by holding down the "Shift" key and and using either arrow key (right or left). Select an entire line of text by holding down the "Shift" key and pressing "End", if you are at the beginning of the line, or "Home" if you are at the end of the line.
- Select an entire paragraph by placing your cursor at either the beginning or the end of that paragraph. Hold down the "Shift" key and press the up arrow, if you are at the end of the paragraph, or the down arrow, if you are at the beginning. If you are in any other section of the paragraph, this shortcut will allow you to select the remainder of the paragraph from your cursor to the end or beginning.
- Select the text from wherever your cursor is placed to one screen up, or one screen down by holding down the "Shift" key and pressing the "Page Up" button (to move up) or the "Page Down" button (to move down). These buttons may say "Pg Up" and "Pg Dn" on your keyboard.
- Select all of the text in your document or on your screen by holding down the "Ctrl" key and pressing the letter "A".
Read more: How to Select Text Using Keyboard Shortcuts | eHow.com http://www.ehow.com/how_4493907_select-text-using-keyboard-shortcuts.html#ixzz2Q54uO1Dt
Wednesday, April 03, 2013
Walt's Words of Wisdom - "Entity Framework"
To know:
If you ware working with Entity Framework be sure to know the following... Thank you Sir Walt.
1. If you are developing for 4.0 ensure all your projects in your solution are set to the same Framework
2. Install by right clicking the project and Manager NuGet Packages and install Entity Framework (Yes Nuget is smart enough to put the correct version, but to verify do the following. Do this for all projects in yoru solution (It will prevent headaches later).
Look at your App.config or Web.config and look for
.NET 4.0 = EntityFramework, Version=4.4.0.0
.NET 4.5 = EntityFramework, Version=5.0.0.0
If you ware working with Entity Framework be sure to know the following... Thank you Sir Walt.
1. If you are developing for 4.0 ensure all your projects in your solution are set to the same Framework
2. Install by right clicking the project and Manager NuGet Packages and install Entity Framework (Yes Nuget is smart enough to put the correct version, but to verify do the following. Do this for all projects in yoru solution (It will prevent headaches later).
Look at your App.config or Web.config and look for
.NET 4.0 = EntityFramework, Version=4.4.0.0
.NET 4.5 = EntityFramework, Version=5.0.0.0
Tuesday, March 26, 2013
Youtube good to know yellow line
When the red line reaches the yellow line, it means you can press the play button and continue your video without any pauses for buffering.
Friday, March 22, 2013
Tuesday, March 19, 2013
Using Statement to get 1 Scalar Value back from SQL
Public Function AddProductCategory( _ ByVal newName As String, ByVal connString As String) As Integer Dim newProdID As Int32 = 0 Dim sql As String = _ "INSERT INTO Production.ProductCategory (Name) VALUES (@Name); " _ & "SELECT CAST(scope_identity() AS int);" Using conn As New SqlConnection(connString) Dim cmd As New SqlCommand(sql, conn) cmd.Parameters.Add("@Name", SqlDbType.VarChar) cmd.Parameters("@Name").Value = newName Try conn.Open() newProdID = Convert.ToInt32(cmd.ExecuteScalar()) Catch ex As Exception Console.WriteLine(ex.Message) End Try End Using Return newProdID End Function
Monday, March 18, 2013
Working with Toolbox DataSources
Current contract I am working a lot with legacy code and find myself going over a pattern to ensure the additions I add remain in-line with the legacy code. Note the entire application is going to be re-written in about six months, so in order to save type by re-factoring I am simply following existing patterns.
Here is the key.
If a developer uses a Object or SQL Datasource you need to follow form the following:
1. ASP.NET (aka .aspx page control)
2. Next to the SQL or Object Data Source ensure the call to the SQL or OBJECT includes the data you need for step 1.
3. If you are performing OBJECT you need to expect the OBJECT that is being called to ensure the SQL or StoreProc is included for the data you need.
4. If SQL you need to ensure inline SQL is in place (Prevent Cross Site Scripting)
5. Then ensure the return to the control on the .aspx page.
6. Ensure all parameters in the INSERT, UPDATE, etc. Match the Controls #Bind("Naming_Structure") and to the object to the db, to keep things simple.
Follow the code from input to output....
Here is the key.
If a developer uses a Object or SQL Datasource you need to follow form the following:
1. ASP.NET (aka .aspx page control)
2. Next to the SQL or Object Data Source ensure the call to the SQL or OBJECT includes the data you need for step 1.
3. If you are performing OBJECT you need to expect the OBJECT that is being called to ensure the SQL or StoreProc is included for the data you need.
4. If SQL you need to ensure inline SQL is in place (Prevent Cross Site Scripting)
5. Then ensure the return to the control on the .aspx page.
6. Ensure all parameters in the INSERT, UPDATE, etc. Match the Controls #Bind("Naming_Structure") and to the object to the db, to keep things simple.
Follow the code from input to output....
Friday, March 15, 2013
SQLDataSource or ObjectDataSource
My experience with the DataSource Toolbox items (I try to stay away from them), but as a developer you always have to maintain another developer's code. Be sure to name your parameters and pass the same exact number of parameters to the calling INSERT, UPDATE, SELECT methods, it will save time and headaches.
You will have issues... More to come.
You will have issues... More to come.
Wednesday, March 13, 2013
SQL Server sp_who2 how to order
--sp_who2
DROP TABLE #sp_who2
CREATE TABLE #sp_who2
(SPID INT,
Status VARCHAR(1000) NULL,
Login SYSNAME NULL,
HostName SYSNAME NULL,
BlkBy SYSNAME NULL,
DBName SYSNAME NULL,
Command VARCHAR(1000) NULL,
CPUTime INT NULL,
DiskIO INT NULL,
LastBatch VARCHAR(1000) NULL,
ProgramName VARCHAR(1000) NULL,
SPID2 INT,
REQUESTID INT)
GO
INSERT INTO #sp_who2
EXEC sp_who2
SELECT * FROM #sp_who2 ORDER BY DiskIO DESC
ADO.NET Get Data to populate DataTable
#Region "Select Concern Status Values"
Public Function SelectProvConcernStatus() As DataTable
Dim dt As New DataTable
Try
Using conn As New SqlConnection(ConfigurationManager.ConnectionStrings("conn_string").ConnectionString)
conn.Open()
Using cmd As New SqlCommand("SELECT concern_status_id, concern_status FROM tbl_provider_concern_status", conn)
cmd.CommandType = CommandType.Text
Dim sda As SqlDataAdapter = New SqlDataAdapter(cmd)
sda.Fill(dt)
End Using
End Using
Return dt
Catch ex As Exception
Throw
End Try
End Function
#End Region
Tuesday, March 12, 2013
T-SQL Library - Check if Column Exists Alter Table
Composing T-SQL to run over and over to check into source control for column change....
IF NOT EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'tbl_Provider_Concerns'
AND COLUMN_NAME = 'concern_status_id')
BEGIN
ALTER TABLE tbl_Provider_Concerns
ADD concern_status_id INT
END
ALTER TABLE tbl_Provider_Concerns
ADD CONSTRAINT FK_Status
FOREIGN KEY(concern_status_id)
REFERENCES tbl_Provider_Concern_Status(concern_status_id)
Friday, March 08, 2013
TFS 2010 Build Automation - Issue with Solution with external project in another Source Control Folder
Backgroud on TFS Structure:
>***** Top level project (***** for security purpose)
--- Development
---XX
---XXirect* (This is what I am attempting to build, more details below)
--- QA
--- Root
Actual solution through Solution Explorer
XXirect-2.5.6.sln (Includes the following projects)
--XXirect (In the XXirect Folder)
--XX_CommonMethods (In the XX Folder aka referenced project)
Under the build definition if have the following:
Status
|
Source Control Folder
|
Build Agent Folder
|
Active
|
$/*****/Development/XX/XX_CommonMethods
|
$(SourceDir)\XX\XX_CommonMethods
|
Active
|
$/*****/Development/XXirect
|
$(SourceDir)
|
When I build I get the following error:
$/*****/Development/XXirect/XXirect-2.5.6.sln - 1 error(s), 103 warning(s), View Log File
C:\Builds\4\*****\XX_DEV - Draft\Sources\XXirect-2.5.6.sln.metaproj: The project file "C:\Builds\4\*****\XX_DEV - Draft\Sources\..\XX\XX_CommonMethods\XX_CommonMethods.csproj" was not found.
I have another build that I copied this template for that works fine. It actual builds to the build server (both containing the controller (m) and agent (007). Actually those are their names, just thought it was great how you explained that in the training.
The build actually builds then copies _Published folder to another server, which works fine. Again the issue I believe lies in the Mapping…
Any help would be great.
FIX
FIX
Try the following
Status
|
Source Control Folder
|
Build Agent Folder
|
Active
|
$/*****/Development/XX/XX_CommonMethods
|
$(SourceDir)\XX\XX_CommonMethods
|
Active
|
$/*****/Development/XXirect
|
$(SourceDir)\XXirect
|
Ahmed is an independent consultant in Ottawa, Canada specialized in .NET, Biztalk, WCF, WPF, TFS and other Microsoft technologies.
Blog: http://lajak.wordpress.com
Twitter: ahmedalasaad
Ahmed Al-Asaad - 5 STARS... You are the man. You suggested fixed the issue. Thank you so much.
I am writing the following for the MSDN community to help them as well.
Yesterday, I tried building individual projects instead of the .sln
In the Build Definition the two sections that are critical to this.
Workspace
tatus
|
Source Control Folder
|
Build Agent Folder
|
Active
|
$/*****/Development/XX/XX_CommonMethods
|
$(SourceDir)\XX\XX_CommonMethods
|
Active
|
$/*****/Development/XXirect/XXirect
(Had added to go directly after the .proj file instead of the .SLN
|
$(SourceDir) (NOTE THE XXIRECT WAS NOT ADDED)
|
Process
- Items to Build
- Here I switched to point directly to the XXirect *.*proj (Note - this was the attempt to fix it do not follow this)
- Also another gotcha is Configurations to Build -AnyCPU|Dev (Note the AnyCPU sometimes has a spaceAny CPU, note the space) which can causes an issue. GOTCHA look out for that.
Thankfully, I checked my email and Ahmed posted on MSDN the following change to the Workspace, which fixed the entire problem.
Status
|
Source Control Folder
|
Build Agent Folder
|
Active
|
$/*****/Development/XX/XX_CommonMethods
|
$(SourceDir)\XX\XX_CommonMethods
|
Active
|
$/*****/Development/XXirect
|
$(SourceDir)\XXirect
|
This also required swtiching the XXIRECT in the Source Control Folder to point to the *.sln and not the *.*proj file as well as switching back the Process to point to the *.sln successfully ran the build.
KUDOS KUDOS to Ahmed.
I searched all overt the Web for 8 hours looking and working on this yesterday. Ahmed and MSDN you really came through. Thanks also for David Star on Plural Sight for an awesome tutorial.
Tuesday, March 05, 2013
Programming as a career
Quoting my old mentor... You must be able to learn, unlearn and relearn to survive in the World of Software Development (Web Development) ever changing. Thank you Doug Cain.
Friday, March 01, 2013
Subscribe to:
Posts (Atom)