|
Richard, I think your idea of using a Placeholder control to wrap around the div tags, and setting the visibility of this control based on the record count of the repeater control is really nice. Unfortunately, I haven't got it to work yet.
First, I got an error trying to set an "OnDataBound" method for the repeater control. After some investigation, I tried using "OnItemDataBound."
Later, I get this compilation error: "Images_DataBound' is not a member of 'ASP.folder_page_aspx'. (The web page is under this directory structure: folder\page.aspx ). I have experimented with using your C# Images_Databound procedure, as well as using what I believe is an ASP.NET equivalent. I don't understand the error message "is not a member of 'ASP.folder_page.aspx'. I have looked through the project and don't see a web page with that name. I think the compilation error is using the folder I am under ("folder") adding an underscore and reporting there is a problem with ASP.folder_page.aspx.
I still like the placeholder control and setting the visible tag for the div tags beneath it to false. I also like trying to set those visible tags to true with a procedure that follows the closing repeater tag. I plan to keep on tinkering with this. Thanks again for your ideas. 
|
|
|
|
|
Richard, after tinkering further I finally got it to work! Thanks so much for your idea about using a placeholder to encapsulate the outer div tags.
First, the method is OnItemDataBound:
<asp: Repeater ... OnItemDataBind="Images_LeftRightControls">
If anyone is wondering how I get the record count of the Repeater control, in the code behind file (i.e., myFile.aspx.vb):
Sub Images_LeftRightControls(sender As Object, e As EventArgs)
Dim myCount As Integer
Dim myDataSource As System.Data.DataSet
Dim myTables As System.Data.DataTableCollection
Dim myList As System.Collections.ArrayList
myDataSource = sender.DataSource
myTables = myDataSource.Tables
myCount = myTables(0).Rows.Count
imageControls.Visible = myCount > [One--why can't I put a 1 here?]
End Sub
Thanks again, Richard!
|
|
|
|
|
Sorry, I thought the repeater fired an event when it had finished binding to the data, but it looks like it doesn't.
The ItemDataBound event will fire for every item in the source data, which might cause problems.
You might want to consider using the ListView[^] instead. It's a lot more powerful than the Repeater, and it does have a DataBound event.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
|
|
|
I have two tabs:Customer and Contract. When I land on the page I want to show the Customer tab info but with my current code I'm unable to get it to work.
aspx
<nav id="spy">
<ul class="sidebar-nav nav">
<li><a href="javascript:void(0)" class="tablinks" onclick="openCity(event, 'Customer')">Customer</a></li>
<li><a href="javascript:void(0)" class="tablinks" onclick="openCity(event, 'Contract')">Contract</a></li>
</ul>
</nav>
<div class="col-sm-8" style="margin-left: 0px; width: 711px;">
<div class="row">
<div class="col-md-12 well tabcontent" id="Customer" style="width:546px">
<legend >Customer Selection</legend>
<div class="row">
<div class="col-md-5 spacing">Customer Source Code:</div>
<%----%>
<div class="col-md-4"">832 - NASA</div>
</div>
<div class="row">
<div class="col-md-5 spacing">Customer Code:</div>
<%----%>
<div class="col-md-4">555</div>
</div>
<div class="row">
<div class="col-md-5 spacing">Name:</div>
<%----%>
<div class="col-md-4">Aeronautics Lab</div>
</div>
<div class="row">
<div class="col-md-5 spacing">City:</div>
<%----%>
<div class="col-md-4">Houston</div>
</div>
<div class="row">
<div class="col-md-5 spacing">State:</div>
<%----%>
<div class="col-md-4">Texas</div>
</div>
<div class="row">
<div class="col-md-5 spacing">Zip:</div>
<%----%>
<div class="col-md-4">10001</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12 well hi tabcontent" style="width:546px;" id="Contract">
<legend >Contract Information</legend>
<div class="row">
<div class="col-md-5 spacing">Nasa Control Number:</div>
<div class="col-md-4">4416367</div>
</div>
<div class="row">
<div class="col-md-5 spacing">Prime Contact Number<span style="color:red">*</span>:</div>
<div class="col-md-4">4416367</div>
</div>
<div class="row">
<div class="col-md-5 spacing">Contract Start Date:</div>
<div class="col-md-4">10/30/2016</div>
</div>
<div class="row">
<div class="col-md-5 spacing">Face Value of Contact<span style="color:red">*</span>:</div>
<div class="col-md-4">10/30/2016</div>
</div>
<div class="row">
<div class="col-md-5 spacing">Contract End Item or Service:</div>
<div class="col-md-4">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</div>
</div>
<div class="row">
<div class="col-md-5 spacing">Authorize Redelegation<span style="color:red">*</span>:</div>
<div class="col-md-4">YES</div>
</div>
<div class="row">
<div class="col-md-5 spacing">Estimated LOD Completion Date<span style="color:red">*</span>:</div>
<div class="col-md-4">10/30/2016</div>
</div>
<div class="row">
<div class="col-md-5 spacing">Is your LOD ONLY for one specific Purchase Order or Delivery Order:</div>
<div class="col-md-4">No</div>
</div>
<div class="row">
<div class="col-md-5 spacing">Contracting Officer:</div>
<div class="col-md-4">John G. Doe</div>
</div>
<div class="row">
<div class="col-md-5 spacing">Date LOD Signed by Customer/Contracting Officer<span style="color:red">*</span>:</div>
<div class="col-md-4">08/11/2016</div>
</div>
</div>
</div>
js
$(document).ready(function(){
$(".custinfo").toggleClass("active");
$("#custinfo").show();
$("#continfo").hide();
$("#prime").hide();
var setHeight = $("#custinfo").outerHeight();
$("#spy").css('height', setHeight);
$(".sidebar-nav").css('height', setHeight);
$('#popover-button').popover({
html: true,
trigger: "hover",
content: function(){
return $('#popover-content').html();
}
});
$('#popover-button').click(function () {
$('.modal').modal('show');
$('#popover-content').popover('hide');
});
$("#menu-toggle").click(function(e) {
e.preventDefault();
$("#wrapper").toggleClass("active");
});
$(".custinfo").click(function(e) {
e.preventDefault();
$("#custinfo").show();
$("#continfo").hide();
$("#prime").hide();
var setHeight = $("#custinfo").outerHeight();
$("#spy").css('height', setHeight);
$(".sidebar-nav").css('height', setHeight);
});
$(".continfo").click(function(e) {
e.preventDefault();
$("#custinfo").hide();
$(".custinfo").removeClass("active");
$("#continfo").show();
$("#prime").hide();
var setHeight = $("#continfo").outerHeight();
$("#spy").css('height', setHeight);
$(".sidebar-nav").css('height', setHeight);
});
$('body').scrollspy({ target: '#spy', offset:80});
$('a[href*=#]:not([href=#])').click(function() {
if (location.pathname.replace(/^\
var target = $(this.hash);
target = target.length ? target : $('[name=' + this.hash.slice(1) + ']');
if (target.length) {
$('html,body').animate({
scrollTop: target.offset().top
}, 1000);
return false;
}
}
});
});
$(window).bind('resize', function(){
});
|
|
|
|
|
I am dynamically creating a PDf in memory and sending a PDF attachment via email.
This works fine.
What I am having problem with is presenting the data in the format management wants.
For instance, they would want the layout in following format:
John Doe 12345
Employee Name Employee ID
john doe
Signature
11/04/2016
Date
How do I fix the code below to accomplish this?
Thanks in advance
I have modified my request and narrowed the help I need to one specific issue.
I need to lay out the results to look similar to this sample below:
<pre><pre lang="PHP"> John Doe 12345
Employee Name Employee ID
john doe
Signature
11/04/2016
Date
So far, everything is wrapping to one column.
I am using stringbuilder.
How do I fix this?
Private Sub SendPDFEmail(dtb As DataTable)
Using sw As New StringWriter()
Using hw As New HtmlTextWriter(sw)
Dim FullName As String = txtFullName.Text
Dim user As String = txtUserName.Text
Dim signedName As String = txtSignature.Text
Dim lDate As String = txtDate.Text
Dim sb As New StringBuilder()
sb.Append("<table border = '0'>")
sb.Append("<tr>")
For Each column As DataColumn In dtb.Columns
sb.Append("<th style = 'background-color: #ffffff;color:#000000'>")
sb.Append(column.ColumnName)
sb.Append("</th>")
Next
sb.Append("</tr>")
For Each row As DataRow In dtb.Rows
sb.Append("<tr>")
For Each column As DataColumn In dtb.Columns
sb.Append("<td>")
sb.Append(row(column))
sb.Append("</td>")
Next
sb.Append("</tr>")
Next
sb.Append("</table>")
sb.Append("<table width='100%' cellspacing='0' cellpadding='2'>")
sb.Append("<tr><td align='center' style='background-color: #ffffff' colspan = '1'></td></tr>")
sb.Append("<tr><td colspan = '3'>")
sb.Append("" & FullName & "</td><td>" & user & "</td></tr>")
sb.Append("<tr><td>Employee ID: </td><td>Employee Signature: ")
sb.Append("</td></tr><tr><td colspan = '3'>")
sb.Append("" & signedName & "")
sb.Append("</td><td> </td></tr><tr><td>Employee Signature")
sb.Append("</td><td> </td></tr>")
sb.Append("<tr><td colspan = '2'>" & lDate & "</td><td> </td></tr>")
sb.Append("<tr><td colspan = '2'>Date :</td><td> </td>")
sb.Append("</tr>")
sb.Append("</table>")
sb.Append("<br />")
modified 5-Nov-16 8:25am.
|
|
|
|
|
That looks like you are just creating one long string. Where is the code that generates a PDF file?
|
|
|
|
|
UDPATE::
This issue has now been resolved.
modified 5-Nov-16 14:39pm.
|
|
|
|
|
how to dynamically generate a SQL server query based on the application server received input from the user
|
|
|
|
|
Probably by writing some code.
|
|
|
|
|
Hello
I am getting the following error:
System.Data.OleDb.OleDbException: Operation must use an updateable query.
when I type in a valid user's email (he exists in the Access mdb) on this page:
forgotten password[^]
I have read a couple of articles on this question, including this one:
Solve Operation Must Use an Updateable Query Error in Access[^]
and have set my permissions accordingly. The folder that houses my Access database, App_Data, has the following permissions: SYSTEM, Steve, and Administrators have full permissions, and Home Users have all permissions apart from Full Control.
[^]
After compiling my project, that folder is now on the server of my Web hosting service and these are the file permissions of App_Data on the server:
[^]
However, I am still getting the same error. Do I need to do anything in the Control Panel of the server, too (I have a Web hosting service) or is what I have already enough>
Thank you.
|
|
|
|
|
When you use an Access database, the code needs to be able to create, modify and delete files in the directory containing the .mdb file.
In ASP.NET, the server-side code does not run as a normal user. Depending on the settings for your AppPool, it will either run as a specific user for that pool, or as the Network Service account.
On your local machine, you need to give the IIS_IUSRS group "modify" access to the folder. This group contains all of the AppPool-specific users created by IIS.
You'll need to contact your hosting company to find out what permissions you need to apply there.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I want to implement Crud operation with generic repository ,unit of work, repository and service layer. I did all the layers but i don't know how to implement it in the controller.Please Help!!
|
|
|
|
|
This reads like the start of a bad joke.
Seriously, though, show us what your issue is (such as how you have your UoW/Repository defined) or you'll never get help with it.
And if I might humbly suggest: if you're not prepared to do query your DAL from your business layer, please don't over-reach on your architectural concerns. Reel it back until it clicks.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
You wrote a layered generic repo that supports UoW...but you don't know how to call your code from a controller? I don't understand how you can develop such a thing yet don't know how to call one class from another?
|
|
|
|
|
Hi guys, I´m new to ASP.NET Core and EF Core and I have the following problem:
I have two related objects, Goals and Months, Goals got the foreign key of Months, and when I try to save the data of goals I got a foreign key error because the value of MonthId is 0, but when I create the select in the HTML I got correct code value.
Description of the error:
SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint FK_Goals_MonthId;. The conflict occurred in database Portal_RNT, table dbo.Months , column MonthId;.
The statement has been terminated.
Here is the code:
HTML
@model ProjectName.Models.Goals
<div>
<form asp-controller="Goals" asp-action="Create">
Other form elements
<select name="months" asp-for="MonthId" class="form-control" asp-items="ViewBag.Months">
</select>
<input type="submit" value="Save" class="btn btn-primary" />
</form>
</div>
Goals Model
public class Goals
{
[Display(Name = "Code")]
public Int32 GoalId { get; set; }
public String GoalName{ get; set; }
public Months Month{ get; set; }
public Int32 MonthId{ get; set; }
....
Other properties
}
Month Model
public class Months
{
[Key]
[Display(Name = "Code")]
public Int32 MonthId { get; set; }
[Display(Name = "Designation")]
public String Designation{ get; set; }
}
Goals Controller
public IActionResult Create(Goals goal)
{
if (ModelState.IsValid)
{
_context.Goals.Add(goal);
_context.SaveChanges();
}
return View("~/../Create.cshtml");
}
Best Regards
|
|
|
|
|
Hi all,
I'm working on reducing the amount of calls to the DB in the applications at our company. One issue that I'm seeing is that the same data is being used by the MVC Controller and the AngularJS controller and an individual call is being made to the DB for each.
I'd like to find a clean way to pass a model into the AngularJS controller when it loads. What suggestions would you have as far as setting this up?
Thanks!
|
|
|
|
|
The best way I've found to conceptualize a SPA is that it's 2 completely separate applications: one for UX/business and the other for data access/projections.
From that standpoint, the optimal backend is a service, which in the .NET world usually means WebAPI for data projected through HTML templates as managed by Angular. You shouldn't use your MVC controllers for any populated views; just get your templates with it (if you absolutely have to have the MVC controllers at all) and JsonResult responses for data access.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
So that is actually how it is currently set up. In this specific case though, I have a page that generates and displays a chart using a .NET tool called SpreadsheetGear. The appearance of the chart is dependent on settings the user has submitted (which we store in the DB). So the Action that generates this chart obviously needs access to that data. However, this page has a modal window that you can open that has an interface where the user can change the settings (AngularJS). We need to prepopulate this with the current settings, so the Javascript needs the same set of data as the Action that generated the chart.
Hopefully I did a good enough job describing the setup. This seems like a decent candidate for a case where an Action and the JS need access to the same data. How would you recommend dealing with this? I'm hoping to not have to execute the same query on the DB twice.
|
|
|
|
|
No, that makes perfect sense.
From my standpoint, I'd usually try and do that job on the JS side because I strictly try and keep UX on the JS side.
There is another option, you could pipeline your responses so that you have a standard response object that is parsed out by Angular. This is not fundamentally dissimilar to how I usually structure services that are meant for consumption by Angular, here's a sloppy example:
public class UXResponse
{
public Dictionary<string,string> Templates{ get; set; }
public object[] Models { get; set; }
}
public ActionResult Chart(int stuff)
{
var queriedItems = context.Stuff.Where(x => x.thing == stuff).ToArray();
var chart = ChartProvider.DoSomethingToGenerate(queriedItems);
...
var response = new UXResponse();
response.Templates.Add("controls", chart.ToHTMLResponseOrWhatever());
response.Models = queriedItems;
return response;
}
Then on the Angular side you make a symmetrical interpreter as a service and run your queries through it:
myApp.service('$getStuff',['$http',function($http){
this.query = function(url, data,callback){
$http.post(url, data).then(
function(result)
{
for(var key in data.Views)
{
document.getElementById(key).innerHTML(data.Views[key]);
}
callback(result.Model)
}
}
}]);
Super rough, but that's the idea.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
Hi All,
I have to have date ranges selected multiple times in HTML5, Like for example if we have Start Date and End Date, like this, there should be multiple Start and End Dates Selected, if one Start and End Date is Selected, then the drop down (or that element) should allow me to select another one as long as I want one.
Any help would be appreciated thanks in advance my friends.
Here is my code to display one set of Date pickers for start and end:
var template;
if (paramType === 'Date Range') {
var multiple = "multiple='multiple'";
template =
'<div id="Param_' + Id + '">' +
'<div class="parameterHeader ui-widget-header ui-corner-top">' + paramDisplayName + '</div>' +
'<div class="parameterItem ui-widget-content ui-corner-bottom" ' + multiple + '>' +
'<div class="parameterFieldResize parameterField">' +
'<input class="parameterDateRangePicker clearable" placeholder="Start" type="text" name="' + paramName + '_1_Start" id="' + paramName + '_1_Start" />' +
'<input class="parameterDateRangePicker clearable" placeholder="End" type="text" name="' + paramName + '_1_End" id="' + paramName + '_1_End" />' +
'</div>' +<br />
'</div>' +
'</div>';
<pre>
this.JQElem = $(template);
initialParent.append(this.JQElem);
$('#' + paramName + '_1_Start').datepicker({
onSelect: function (dateText) {
$(this).trigger("input");
if (typeof me.values[this.id.split('_')[1]] === 'undefined')
me.values[this.id.split('_')[1]] = {};
me.values[this.id.split('_')[1]]['Start'] = dateText;
}
});
$('#' + paramName + '_1_End').datepicker({
onSelect: function (dateText) {
$(this).trigger("input");
if (typeof me.values[this.id.split('_')[1]] === 'undefined')
me.values[this.id.split('_')[1]] = {};
me.values[this.id.split('_')[1]]['End'] = dateText;
}
});
$("#" + paramName + '_1_Start').change(function (event) {
var dateString = this.value;
if (/^\d{1,2}\/\d{1,2}\/\d{2}$/.test(dateString)) {
dateString = dateString.substring(0, dateString.length - 2) + '20' + dateString.substring(dateString.length - 2, dateString.length);
this.value = dateString;
}
if (isValidDate(dateString)) {
if (typeof me.values[paramName + '_1'] === 'undefined')
me.values[this.id.split('_')[1]] = {};
me.values[this.id.split('_')[1]]['Start'] = dateString;
} else if (typeof me.values[this.id.split('_')[1]] !== 'undefined' && typeof me.values[this.id.split('_')[1]]['Start'] !== 'undefined') {
if (typeof me.values[this.id.split('_')[1]]['End'] !== 'undefined')
delete me.values[this.id.split('_')[1]];
else
delete me.values[this.id.split('_')[1]];
}
});
$("#" + paramName + '_1_End').change(function (event) {
var dateString = this.value;
if (/^\d{1,2}\/\d{1,2}\/\d{2}$/.test(dateString)) {
dateString = dateString.substring(0, dateString.length - 2) + '20' + dateString.substring(dateString.length - 2, dateString.length);
this.value = dateString;
}
if (isValidDate(dateString)) {
if (typeof me.values[this.id.split('_')[1]] === 'undefined')
me.values[this.id.split('_')[1]] = {};
me.values[this.id.split('_')[1]]['End'] = dateString;
} else if (typeof me.values[this.id.split('_')[1]] !== 'undefined' && typeof me.values[this.id.split('_')[1]]['End'] !== 'undefined')
if (typeof me.values[this.id.split('_')[1]]['End'] !== 'undefined')
delete me.values[this.id.split('_')[1]];
else
delete me.values[this.id.split('_')[1]];
});
The same thing was possible for Multi select Dropdown, here is the code for that, but when I am trying to do the same on the Date pickers its not working, any Idea is going to be greatly helpful, a code snippet, a link or even suggestion is going to be very helpful thanks in advance my friends.
var template;
if (paramType === 'Date Range') {
var multiple = "multiple='multiple'";
template =
'' +
'' +
' ' +
' ' +
'<input class="parameterDateRangePicker clearable" placeholder="Start" type="text" name="' + paramName + '_1_Start" id="' + paramName + '_1_Start" />' +
'<input class="parameterDateRangePicker clearable" placeholder="End" type="text" name="' + paramName + '_1_End" id="' + paramName + '_1_End" />' +
' ' +
' ' +
'
//Insert HTML
this.JQElem = $(template);
initialParent.append(this.JQElem);
$('#' + paramName + '_1_Start').datepicker({
onSelect: function (dateText) {
$(this).trigger("input");
if (typeof me.values[this.id.split('_')[1]] === 'undefined')
me.values[this.id.split('_')[1]] = {};
me.values[this.id.split('_')[1]]['Start'] = dateText;
}
});
$('#' + paramName + '_1_End').datepicker({
onSelect: function (dateText) {
$(this).trigger("input");
if (typeof me.values[this.id.split('_')[1]] === 'undefined')
me.values[this.id.split('_')[1]] = {};
me.values[this.id.split('_')[1]]['End'] = dateText;
}
});
$("#" + paramName + '_1_Start').change(function (event) {
//convert to 4 digit year (always will be in the 20's)
var dateString = this.value;
if (/^\d{1,2}\/\d{1,2}\/\d{2}$/.test(dateString)) {
dateString = dateString.substring(0, dateString.length - 2) + '20' + dateString.substring(dateString.length - 2, dateString.length);
this.value = dateString;
}
if (isValidDate(dateString)) {
if (typeof me.values[paramName + '_1'] === 'undefined')
me.values[this.id.split('_')[1]] = {};
me.values[this.id.split('_')[1]]['Start'] = dateString;
} else if (typeof me.values[this.id.split('_')[1]] !== 'undefined' && typeof me.values[this.id.split('_')[1]]['Start'] !== 'undefined') {
if (typeof me.values[this.id.split('_')[1]]['End'] !== 'undefined')
delete me.values[this.id.split('_')[1]];
else
delete me.values[this.id.split('_')[1]];
}
});
$("#" + paramName + '_1_End').change(function (event) {
//convert to 4 digit year (always will be in the 20's)
var dateString = this.value;
if (/^\d{1,2}\/\d{1,2}\/\d{2}$/.test(dateString)) {
dateString = dateString.substring(0, dateString.length - 2) + '20' + dateString.substring(dateString.length - 2, dateString.length);
this.value = dateString;
}
if (isValidDate(dateString)) {
if (typeof me.values[this.id.split('_')[1]] === 'undefined')
me.values[this.id.split('_')[1]] = {};
me.values[this.id.split('_')[1]]['End'] = dateString;
} else if (typeof me.values[this.id.split('_')[1]] !== 'undefined' && typeof me.values[this.id.split('_')[1]]['End'] !== 'undefined')
if (typeof me.values[this.id.split('_')[1]]['End'] !== 'undefined')
delete me.values[this.id.split('_')[1]];
else
delete me.values[this.id.split('_')[1]];
});
Thanks,
Abdul Aleem
"There is already enough hatred in the world lets spread love, compassion and affection."
modified 31-Oct-16 16:02pm.
|
|
|
|
|
I want to create a single page on which i can perform full crud operation using dropdownlist, radiobuttonlist, checkbox ,checkbox inside dropdown in a gridview.
and at the left side of each row in gridview should be insert, delete and update.
and should be a button on which click we can see the deleted rows.
please send the code with database script file.
|
|
|
|
|
Member 12736856 wrote: please send the code with database script file.
Sorry this is not a "code to order" forum.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
