Let’s say you want to retrieve only the first row of each question type from the question type table. The 3rd SQL statement will give you your results, but let’s explain each of 3 SQL statements.
select RowNumber, question_type from…
Author: James
SQL Server Management Studio – Retrieve one child row regardless of number of grand children from another child table with or without filtering
Let’s say you want to report on each child row, but you only want to see one row based on a grand child row with filtering on the grand child row. The following SQL will not work, but instead gets …
SQL Server Management Studio – Retrieve one parent row regardless of number of children when filtering on children
Let’s say you want to report on each parent row, but must join a child row to do filtering on the child row, but you only want to return one row per parent. The following SQL will not work, but …
Windows 10 – Determine Version Build
Click start. Enter winver and select winver.exe in result set.
Visual Studio Community Edition 2017 – Stop debugger when browser windows is closed, close browser when debugging stops
If you want to test threading that will still perform after closing down your browser, you need to still have the debugger running. In order to do that, you need to uncheck the box in the Tools/Options/Web Projects section that states:Stop debugger when browser windows is closed, close browser when debugging stops.
MVC 5 – Third Party Date Picker that works in IE
First, send back the browser type from the controller to the browser.
ViewBag.Browser = Request.Browser.Browser;
Add the following javascript:
…
<script type="text/javascript" src="https://cdn.jsdelivr.net/jquery/latest/jquery.min.js"></script>
<script type="text/javascript" src="https://cdn.jsdelivr.net/momentjs/latest/moment.min.js"></script>
<script type="text/javascript" src="https://cdn.jsdelivr.net/
npm/daterangepicker/daterangepicker.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.
MVC 5 – Refresh Parent Window After Executing Child Window
Close a windows tab upon returning a view:
Do this when a parent window opens a child window.
The child window does the processing, but after the processing, you want the parent window to refresh.
In the SAVE action of …
MVC 5 – How to Close a Browser Tab Using Javascript
Close a windows tab upon returning a view:
@if (ViewBag.CloseWindow == true)
{
<script type="text/javascript">
window.close();
</script>
}
Closing a Windows tab via a button …
MVC 5 – How to Display a PDF in a View
Assuming that you have a PDF in your controller as a byte array, add the following code to convert the data to a base64 string and send to your view.
string imageBase64Data = Convert.ToBase64String(results);…
string imageDataURL = string.Format("data:application/pdf;base64,{0}", imageBase64Data);
ViewBag.ImageData
MVC 5 – Using Javascript to set focus to control, textbox, button, dropdown list upon loading of a Razor View
Let’s say you want to add focus to a button in your view. The first thing you need to do is add the id attribute to your control and give it a name such as id=”RefreshListButton”.
Next, in the jquery …