For those of you stalwart followers who like me here, I am splitting out the SQL Server posts to a new blog.
Find it here.
Posts that apply to both Visual Studio development AND SQL Server will probably be posted on both sites.
...
There is a long explanation about SQL server caching values for autoincrement columns, and losing them when the server is restarted, but the fix is this:
This does incur a performance hit, so if you're inserting 20 billion records a day, be warned. But for a normal web or app database, this will make it more likely that your autoincrement values will step up the way you had intended.
...
Last night we had a power outage, so I left my PC off all night. When I rebooted, guess what happened?
Slack - a program I had very clearly configured to run-on-demand suddenly decided it needed to launch on startup. I don't now and never have used Slack as a primary means of communication, and the thought that they would take ownership of my PC because they think they know what's good for me is - well it's unforgivable.
Uninstalled.
When you write code, I know it's easier to think your customers, pirates, and family members love your software so much that they want it front and center 100% of the time, but mostly, they don't. In fact, my computer boots so slowly that I purposely turn off all those autoupdaters that run on startup.
Google Updater, Adobe Updater, Java Updater, Daz, Unity, Apple (for iTunes, another program I rarely use), Avast, Malware Bytes, Carbonite. All of these updaters are disabled, because when I reboot, it takes my hard drive 15 minutes to fully boot. The mouse and icons are there early, but if I try to launch anything it takes 300x as long and it's just not worth it.
Every time I have to disable these malware bots, I have to search startup, the task scheduler, and 4 other places to make sure they haven't found some new, hidden way to infiltrate my system. It wouldn't be so bad if there was a task in the scheduler that would launch the updater, say at 3:46AM and check for a patch, then CLOSE THE UPDATER, but no, the updater must remain running for the rest of time. Some software companies even have a second program that makes sure the first program is never stopped.
Programmers: These practices will get you into the Special Hell. The one reserved for child molesters and people who talk in the theater.
...
Unlike Git or Subversion, when you move your projects to a new path, say to organize your hard drive, you'll see this warning when you open your project.
---------------------------
Microsoft Visual Studio
---------------------------
Team Foundation Server Version Control
The solution you are opening is bound to source control on the following Azure DevOps Server: http://...collection. Would you like to contact this server to try to enable source control integration?
---------------------------
Yes No Help
---------------------------
Pressing Yes is useless. Right clicking your project gives you the option of adding it, not reconnecting it.
Here's the procedure to fix this issue.
Using this 5 step process you can add a client-side JQuery filter to your MVC Index pages.
In your Views/Shared/_Layout page, there is a block of code at the end that looks like this:
@Scripts.Render("~/bundles/jquery")
@Scripts.Render("~/bundles/bootstrap")
@RenderSection("scripts", required: false) Move these to the line just after
@Scripts.Render("~/bundles/modernizr") ...at around line 8. The JQuery library needs to be loaded before the @RenderBody line. This step only needs to happen once for your whole app, unless you're using multiple layout pages.
Next we'll need a filter bar to the index page.
Let's say we want to filter by three fields:
I put this just before the <table>.
<div class="icon-bar">
<span style="font-weight:bold;">Filters</span>
State: <input name="State" id="state" type="text" style="width:35px;" maxlength="2" class="filter" />
County: <input name="County" id="county" type="text" style="width:90px;" class="filter" />
Town: <input name="Town" id="town" type="text" style="width:90px;" class="filter" />
<span id="recordCount" style="font-weight:bold;">@Model.Count().ToString() records.</span>
</div>
class="icon-bar": use this class to style the bar how you like it: I used this in my style sheet, but you do as you like:
div.icon-bar{
background:linear-gradient(#44f, #88F, #44F, #008, #000);
padding:5px;
margin-bottom:12px;
border:1px solid black;
border-radius:15px;
color:white;
} This makes the text in the input boxes white on white, so I added this:
input.filter{
background-color:white;
color:black;
} The first row in your table is the headers and we DON'T want to ever filter that row out. So add a <thead> tag around the first <tr>
Now add a <tbody id="fbody"> around your data loop.
I use the id tag to find the tbody and access its rows in the jQuery.
Rather than use some wizardry to find what's in the <td> cells, I add custom tags to the <tr>s to help me hide/show them as a group.
@foreach (var item in Model){<tr data-state="@item.state" data-county="@item.county" data-town="@item.town"> This adds tags for all the fields I want to filter for.
This is easy enough. Add a keyup function to all 3 filter fields.
<script type="text/javascript">
$(".filter").keyup(function () { //this matches the class=filter on all 3 input boxes.//hide all trs in the tbody
var rows = $("#fbody").find("tr").hide(); //this hides every row in the table body var workingList = rows; //makes a list of all the table rows to work on //grab the text from the search box var state = $("#state").val().toLowerCase(); var county = $("#county").val().toLowerCase(); var town = $("#town").val().toLowerCase();
//now show the ones where all values match
if (state.length > 0) { //if there is any text in the first filter...
//filter just returns a filtered list
workingList = workingList.filter(function () { //spawns a tiny inline function to test each row//return true if data-state starts with var state
if ($(this).data("state").toLowerCase().indexOf(state) == 0) {return true;
}
else {return false;
}
})
}
if (county.length > 0) { workingList = workingList.filter(function () {//return true if data-state starts with var state
if ($(this).data("county").toLowerCase().indexOf(county) == 0) {return true;
}
else {return false;
}
})
}
if (town.length > 0) { workingList = workingList.filter(function () {//return true if data-state starts with var state
if ($(this).data("town").toLowerCase().indexOf(town) == 0) {return true;
}
else {return false;
}
})
}
$(workingList).show(); //show the rows remaining in the working list. $("#recordCount").text(workingList.length+" records.") //update the record count in the filter bar.});
</script>
Also, you C# programmers like me: Don't freak out that there are returns in the middle of the function. Those returns are in the middle of a small inline function, and return to the main function, not from it.
I chose a "startsWith" match, that's why my functions have a .indexof(state)==0. Here's some different ways to match.
if ($(this).data("town").toLowerCase() == town) { if ($(this).data("town").toLowerCase().indexOf(town) >= 0) { This should be a good start to filtering for any ASP.NET MVC index page using jQuery. sqlcmd -S ".\SQLEXPRESS" -U myUserName -P myPassword -i %1 -d DBName >result.txt
start Notepad.exe result.txt
<roleManager enabled="true" cacheRolesInCookie="false" />Once I got rid of that, the error blessedly poofed into a memory.
Multiplicity conflicts with the referential constraint in Role 'blah blah thing that doesn't exist by that name anywhere in the project' in relationship 'blah blah'. Because all of the properties in the Dependent Role are non-nullable, multiplicity of the Principal Role must be '1'.errors.
| id | ParentCategory | Name |
|---|---|---|
| 1 | NULL | Household |
| 2 | 1 | Furniture |
| 3 | 1 | Appliances |
| 4 | 2 | Chair |
| 5 | 2 | Couch |
| 6 | 2 | Bed |
| 7 | 3 | Refridgerator |
| 8 | 3 | Counter |
| 10 | 3 | Bathroom |
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: bryanv
-- Create date: 11/28/2018
-- Description: gets the whole list from here down
-- =============================================
CREATE FUNCTION dbo.CategoryFullName
(
@CategoryID int
)
RETURNS nvarchar(200)
AS
BEGIN
-- Declare the return variable here
DECLARE @ans nvarchar(200)
declare @parent int
-- Add the T-SQL statements to compute the return value here
select @ans=name, @parent=ParentCategory from Categories where id=@CategoryID
if @parent is not null
BEGIN
set @ans=dbo.CategoryFullName(@parent)+' - '+@ans
END
-- Return the result of the function
RETURN @ans
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: bryan valencia
-- Create date: 11/20/2018
-- Description: returns the dates between start and end (inclusive).
-- =============================================
CREATE FUNCTION DaysBetween(@startdate DATE, @enddate DATE)
RETURNS @calendar TABLE
(
calendarday DATE PRIMARY KEY
)
AS
BEGIN
-- Fill the table variable with the rows for your result set
WITH calendar AS
(
SELECT CAST(@startdate AS DATETIME) DateValue
UNION ALL
SELECT DateValue + 1
FROM calendar
WHERE DateValue + 1 <= @enddate
)
insert into @calendar(calendarday)
(
SELECT cast(DateValue as Date) calendarday
FROM calendar
)
OPTION (MAXRECURSION 0)
RETURN
END
GO
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="Generator" content="EditPlus®">
<meta name="Author" content="Bryan Valencia">
<meta name="Keywords" content="Tab, bar, demo, css, html5">
<meta name="Description" content="A quick tab bar demo showing how to make an entire div clickable instead of just the text.">
<title>Tab Bar Demo by Bryan Valencia</title>
<style>
.tab{
width:200px;
height: 20px;
margin: 0px;
padding:10px;
text-align: center;
vertical-align: middle;
display: inline-block;
color: black;
background-color: white;
color: black;
background-color: aliceblue;
border: 1px solid silver;
border-top-right-radius: 10px;
border-top-left-radius: 10px;
border-bottom-right-radius: 0px;
border-bottom-left-radius: 0px; }
.tab:hover{
color: yellow;
background-color: green;
}
a.clickable-tab{
color: black;
display:inline-block;
width:100%; height: 100%;
vertical-align:bottom;
font-family:Arial, helvetica;
text-decoration:none;
}
.tab-bar{
display: block;
border-bottom: 1px solid silver;
padding:0px;
margin:0px;
background-color: gray;
}
</style>
</head>
<body>
<div class="tab-bar">
<h1>Tab Bar Demo</h1>
<div class="tab">
<a href="#" class="clickable-tab">Home</a>
</div><div class="tab"> <!-- the divs are wrapped funny here to prevent space between the tabs. -->
<a href="#" class="clickable-tab">About</a>
</div><div class="tab">
<a href="#" class="clickable-tab">Contact Us</a>
</div>
</div>
</body>
</html>
@echo off
REM MakeChangeLog.bat
REM You Should place this batch file in the folder you want to create the file in.
REM You must run this batch as an administrator!
REM Note that you must have the disk space to initially create the file before it gets compressed.
fsutil file createnew changelog.txt 1000000000
fsutil sparse setflag changelog.txt
compact /c changelog.txt
pause
This resulted in a 4096 byte file on my Windows Server 2012, and a 0 byte file on my Win 10 machine. This file STILL downloads as a 1 gig file. You can check the file size by right-clicking CHANGELOG.TXT and selecting Properties.
InnerException:
ErrorCode=-2147467259
HResult=-2147467259
Message=A public action method ... was not found on controller '...Controller'.
Source=System.Web.Mvc
WebEventCode=0
//Get: ProductPartial Blocks
[HttpGet]
[AllowAnonymous]
public ActionResult ProductBlockPartial(int? ID)
{
if (ID.HasValue)
{
Product model = db.Products.Find(ID);
return PartialView(model);
}
else
{ return null; }
}
If you have any issue with your purchase or related to the configuration of [the software], please post your request in the [user] forums, in the Troubleshooting section.So, you fling out software, charge money, and then leave it to other users to figure out the problems by themselves?
.nav-tabs { border-bottom: 2px solid #DDD; }
.nav-tabs > li > a {
border: none;
color: #666;
}
.nav-tabs > li.nav-item > a,
.nav-tabs > li.nav-item > a:hover {
border: none;
color: #4285F4 !important;
background: transparent;
position: relative;
}
.nav-tabs > li.nav-item > a::after {
content: "";
background: #4285F4;
height: 2px;
position: absolute;
width: 100%;
left: 0px;
bottom: -1px;
transition: all 250ms ease 0s;
transform: scale(0);
}
.nav-tabs > li.nav-item > a.active::after,
.nav-tabs > li.nav-item:hover > a::after {
transform: scale(1);
}
.card {
box-shadow: 0px 1px 3px rgba(0, 0, 0, 0.3);
}
@{
ViewBag.Title = "Index";
Layout = "~/Views/Shared/_Layout.cshtml";
}
<h2>Index</h2>
<h2>Tabsperimentation</h2>
<div class="nav navbar-default">
<ul class="nav nav-tabs">
<li class="nav-item"><a class="active show" data-toggle="tab" href="#TabA">GO TO TAB A</a></li>
<li class="nav-item"><a data-toggle="tab" href="#TabB">GO TO TAB B</a></li>
<li class="nav-item"><a data-toggle="tab" href="#TabC">GO TO TAB C</a></li>
</ul>
</div>
<div class="tab-content">
<div id="TabA" class="tab-pane fade in active">
THIS IS TAB A
</div>
<div id="TabB" class="tab-pane fade in">
THIS IS TAB B
</div>
<div id="TabC" class="tab-pane fade in">
THIS IS TAB C
</div>
</div>
@echo off
cls
set Address=google.com
set ThisDate=%date%A
echo %ThisDate%
:Loop
timeout /t 60
if "%date%" NEQ "%ThisDate%" (
echo %date% >>logfile.log
set ThisDate=%date%
echo %ThisDate%
)
echo %time% >>logfile.log
echo Pinging %Address%
%SystemRoot%\system32\ping.exe -n 1 %Address% | %SystemRoot%\system32\find.exe "TTL=" > NUL >> logfile.log
if %ERRORLEVEL% EQU 0 goto :Loop
echo Error Detected! >>logfile.log
echo Error Detected!
echo Trace route %Address% at %date% %time% >> logfile.log
tracert %Address% >> logfile.log
echo .
echo . >> logfile.log
goto Loop
pause Somehow, I got out of the loop
Thu 09/21/2017
15:55:28.70
Error Detected!
Trace route google.com at Thu 09/21/2017 15:55:40.74
Unable to resolve target system name google.com.
.
15:56:10.16
Error Detected!
Trace route google.com at Thu 09/21/2017 15:56:22.19
Unable to resolve target system name google.com.
.
15:56:52.15
Reply from 172.217.4.142: bytes=32 time=18ms TTL=54
15:57:22.17
Reply from 172.217.4.142: bytes=32 time=18ms TTL=54
15:57:52.13
Reply from 172.217.4.142: bytes=32 time=18ms TTL=54
15:58:22.11
Reply from 172.217.4.142: bytes=32 time=17ms TTL=54
15:58:52.18
Reply from 172.217.4.142: bytes=32 time=18ms TTL=54