Comments by frostcox (Top 200 by date)

Hey, yeah I went with something similar, all the properties for the areas and plots are more or less the same so I created a generic class that incorporates these properties and populate it from the db. Really appreciate the suggestion, thanks very much.

Thanks mate I will take a look through the Wix toolkit and have a look at what you suggested.

Brilliant thank you very much

Hey, thanks for your reply, yeah I know they are separate but I was just seeing if there were any non entity framework samples out there.

Hey, Thanks very much i will give it a try.

No prob, thanks for your help

By the looks of it no, as if it was it should return true, therefor entering a record in my event log table. see code above.

Hi Thanks for you reply, I looked in to this and I made a few adjustments to the code to try and get to the bottom of this. Unfortunately there are some files still only being copied as apposed to being moved. Just wondering have you any other ideas... im stumped!!

Huh? Your going to have to be a bit more specific here, use labels to display what exactly?

async springs to mind!!!

Sounds perfect for an Admin application, here are plenty of templates where you can buy and customise for your need for as little as 18 dollars for your license!!! http://themeforest.net/category/site-templates/admin-templates

I would use a HttpHandler for this task, you can perform seemless operations with no effort at all, if you need a code sample I am happy to supply.

excellent thanks very much.

sorry if I was unclear with what I was trying to do do here, I tried to be as clear as I could, but the solution by Richard was exactly what I was looking for. Thanks for your help.

I would create a Player class then create a generic List<> of Players. That way you can add and remove from this list as you please. Far simpler that the solution above.

Hey, thanks for the detailed answer, I will look into the Transactional File Manager and see if it fits my needs. I like the idea of logging so i will implement that aswell, thanks again.

Hey thanks for your response, The process will perform the operations in batches of 20, so the clients computer could have 100's of files there already. Is there any FileSystem transactions which you know about?

Ok just place a property in Form2 like List<object> ListOfObjects and make it public, then in Form1 add your datasource to this property and then bind to your grid??

When you say doesn't work what do you mean? Do you get an error or is there no value in that cell?

Hey when I enter text in the numeric field it allows the form to be submitted. Any ideas?

Ok when I removed the controller name it worked, thanks for your help.

excellent thank you!

Ah I see, what was confusing me was my application is a MVC web application but I can modify the logic to suit what I need, thank you so much for your help.

Thanks very much for your solution, only thing which is confusing me is this line where you instanciate MenuControl menu = new MenuControl();. MenuControl being what??. What I originally have is a List of Menuitems which is a list of all the menus in the database regardless of type parent/child, so at that point all the sub menus are null but the ParentMenuItemId is 0(parent) or ParentMenuItemId = MenuItemId for childern. How do I modify the above solution to cater for this scenario. Thanks again for your help.

Thank you sir, I think it was just too long a day, I followed your links and it works like a treat. Thanks again.

Hey thanks for your help, turns out I was adding the jquery js file twice in my code, once I removed one it worked just fine...

The break tags are not in the file thanks

Hey all the files are being loaded correctly, I'm just getting undefined when I try access the #calender div now. The code in the Index.cshtml file is @Scripts.Render("~/Scripts/fullcalendar.js")
<br><br><br>
@Scripts.Render("~/Scripts/Calendar.js")<br>
 <br>
<div id="calendar"></div>

Is this correct or am I doing something wrong?

Hi thanks for your reply I did as you suggested but I now get the error TypeError: $(...).fullCalendar is not a function. I have the exact same code in a web forms project and it works perfectly. Thanks again for your help.

I'm sorry I don't follow, #calendar is declared in the Index.cshtml, I then try access it in the calendar.js file, if you know the correct way I should be declaring it i'm open to suggestions, thanks for your help.

That I do:)

Thank you sir, i will take a look at the options, appreciate the help.

Ok back to the drawing board I guess, thanks

Ok my colsole application will be a windows service, which through signalr will push notifications to the client. I am just having trouble authenticating the service. I have tried loads of different approaches to try an achieve this but no luck, I suppose I am just looking for the correct way to do this. My web application uses Forms Authentication.

I am fully aware that there are no console applications in ASP.NET, i am trying to authenticate a console application through a WCF service hosted in my web application

What are you even talking about here?

Thank you so much my error has stopped. Really appreciate the help.

Thank you so much my error has stopped. Really appreciate the help.

If I'm not being clear all you have to do is ask for more clarity. We're on here to receive help from more experienced developers so for you to just go around down voting questions instead of trying to help is just rude.

Yeah but I want to display the results cross tab in the same result set if that if possible?

Hey thanks for your reply, I have updated my qesstion, you ask what have I tried so far, I have wrote the initial query in the question I just am unsure how to get my expected results. Thanks again

No joy :(, I have replaced the old js code with the edited one in the question above, can you please take a look and let me know where im going wrong. Thanks again.

Hey I tried that but now I can't access any of the this.options?? It says there undefined. Any ideas? Thanks again for your help.

Hey thanks, I will try that. if you look here in the js file $.notification.defaultOptions I add ClientNotificationId then I call base.options.extend to add it, then I pass it in through the json in to the js file.

So the displayMessage is called from the server X amount of times depending on how many notifications there are to display.

Ok I updated the question thanks

I can post the entire js file if that will help.

Ok I have say 3 or 4 separate notifications which each are passed to the js file in the format,
{"ClientNotificationId" : 220,
"text": "You have 1 notifications waiting to be processed. Click to view or X to remove all.",
"url": null,
"theme": "noty_theme_facebook",
"layout": "bottomRight",
"type": "alert",
"speed": 500,
"closeButton": true,
"closeOnSelfClick": true,
"closeOnSelfOver": false,
"modal": false
}
So each notification has its own ClientNotificationId sat 218,219, 220 etc...,
I have put various alerts in the js files to check that this Id is unique across all notifications and they all are. But when I try and capture the ClientNotificationId in the Close event it always returns the notification with 220.

Hey thanks for your reply, the issue is still there. the base.options.ClientNotificationId is always the I'd of the last notification rendered to the screen even after making your change. Any more ideas?

Good answer... but I would recommend the use of using statements around any classes which implement IDisposable like SqlConnection & SqlCommand....

Can you be more specific? What type of database?

Hey there's def no extra "<" in the config file. The application runs like a treat locally its only after deployment I get the issue??

Could you be more specific?

Hey found the issue, it was because when I added the reference I pointed at the bin/debug folder rather than just add a reference to the actual project. Thanks for your help.

Its gives out that it is trying to reference two different versions of the same DLL's bacause studio hasn't automatically changed the path from the Debug folder to the Release folder.

Hi thanks for you reply, I have checked through all the settings and they are all the same, the only thing I noticed is in the References tab when I switch between Debug and Release the patch only change for some DLLs and not others

Hey I added the correct DLL but not the StartUp class never gets called. Any ideas? When I try create the hub proxy I get "undefined"

The thing is when i install SignalR.Core it installs Microsoft.Owin version 2.0.2 but qhen a run the application and it reaches the Maphubs() i get the error.

Yeah I have tried every way known to man and its not liking it for some reason.

Hey, that's actually a really good idea. I'm not 100% sure on the restrictions on the remote server. But if I could have that service watch the main folder and then return me a list of new files in the last X minutes that would solve my issue of having to read the whole file system for each request. Thanks for that...

Hey thank you for your answer, There is just far too much code to post here and I don't think it would help even if I did post it. We basically transfer 100,000 + files a day. Currently we do as you suggest have each individual job pull the files from the remote server but there lies the problem. Say we have 10+ instances of the service running and each service is reading the remote file system which has 300,000+ files we have no control over the amount of files which are on the server and cannot delete them!!, we are just required to take the most recent. I'm thinking of having one service constantly poll the remote file system and then each instance will work off that pool of files instead of having to query the system every time.

Cheers dude.

Max file size is about 20 megabytes. Yeah your right it may be worth me re-thinking how I was processing the file. I will run a few tests and observe the results but your solution is by far the easiest to implement.
Thanks Again

Hey thanks for you answer. If I read the whole file in and store it in memory as a string won't that take up to much memory?

Thank you sir...

Hey I'm using a tool from Red Gate ANTS Memory Profiler. It is using that amount of memory, see a developer that is no longer with the company wrote the code and I have been tasked with stripping it down and finding out why its so memrory intensive...

Fair enough, there's just a lot of code to post here. Thanks anyway

Hey I have a trimmed down version of the project, maybe I could email it on to you and you might throw your eye over it?

Hey I have a trimmed down version of the project, maybe I could email it on to you and you might throw your eye over it?

Hey its a pretty complex process, basically is a binary file with say 100+ records on each line which I need to convert to strings are then write to the database at different stages at its simplest form. There is a lot going on but I will work on putting together a trimmed down version of the code, then maybe you can help. I have been trawling the internet the last few days trying to find a solution but all articles seem to share the same opinion that a lot of strings are a bad idea..... Thanks

Thanks but the way the classes are structured it not going to be a viable option.

You could join the table on to itself and get your result from that

Thank you kind sir, will calling the to list on the IQueryable subscription affect when I call db.GetChangeSet??

improved

Improved :)

Its not a problem as such, the query returns the data as expected, I just want guidence as to how code it better. Like should I use cte's for the sub queries or what is best practice.

Well its not as such, obviously JQuery is going to set it whereever I tell it to but its just working out the best solution is the problem:)

You can just loop through your datagrid like I do above and then display the average in a text box, I just showed you a real world example, need anymore help with anything let me know as I know starting out with programming can be tough!

Hey thanks for your reply, I got it working. I just done a bit of study and learned how it all fits together, thanks again.

Hey your not executing your stored procedure anywhere!

Ok well post your code and I will amend it for you with comments to explain what I did.

How are you binding you data source to your dgv??

Give me your exact requirements and il post the solution for you!

Thank you kind sir.

Ok define, ver hello = function () {
alert('Condition met!');
}

in my plugin I call

this.hello();
error: Object doesnt support method or property 'hello'

Sorry its been a really long day:), I know im probably just calling it wrong in the plugin?

He yes just says hello is underfined or not an object

Hey excuse my ingrorance but I tried calling the this.hello() inside my plugin but I still get an error. Thanks for your help

Hey I found a solution to this in one short query,
;with
cte
as
(
select DestinationId, dbo.fnSplit(DestinationName,'>',1) as Dest from dbo.Destination
WHERE CHARINDEX('>', DestinationName) > 0
)
SELECT DISTINCT cte.Dest , (select cast(c.DestinationId as CHAR(2)) + Char(44) from cte c
where c.Dest = cte.Dest for XML PATH(''))
FROM cte

Thanks again for your help.

Unfortunately splitting it is not an option at the minute, I agree it's terrible design but I'm only following orders:), I was just hoping there was a quick query to return the data, that's fine il do as you suggested thanks very much!

Hey but the name is different in my table so lets say 'Airtel > India' that is the name in the column in the database. Your query only matches exact names where I'm looking for all ids that start with the name left of the greater than sign, sorry for not being clear.

Hey thank you so much for your reply, it still only gives single Id's. The example I have above all the names are individual entries in the same table in the data base. So for instance I need to look for all instances of lets say 'Airtel'. So there are two names which start with Airtel in that table Id's 1,9. Any idea how to display this. Thanks again for your help.

Hey, thanks for your reply, the client is running on my local iis running ie9. The hub class gets called initially when I call the hub.start() method I know this because I set a breakpoint in my hub class and it gets there with no error. My only problem is connecting to my hub class instance through my service which I don't know how to do. If you could help me that would be great. And sorry yeah JavaScript is enabled:)

Hey dude, still doesn't work:(

Thank you very much, exactly it!!!

Cool thanks very much

Hey this look like something I could really use, is the compatible with .Net 3.5 and 4.0?

Hey this will be very hard to prove because he could have created an new project and copied all the files across thus making it impossible to prove if he actually wrote the code. You could question him on parts of his code, what it actually does and im sure it won't be long before he admits he didn't write it.

What have you tried? I am happy to help.

Can you show your aspx code please?

Hey is this your code and its not working or what is the issue?

Hey, ok what I can suggest is that you use alias' in your select query so instead of ("select * from student") you replace with ("select [sro] as [sro], [village] as village, [Taluka] as [Taluka1], [std9ScBoys] as [Boys], etc... From Student)
Hope this helps

Inside SetRandomInfo()
set score = 0 and name = "" at the start

Hi Replace dr = cmd.ExecuteReader with:
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);GridView1.DataSource = dt;
Also you are calling cmd.ExecuteNonQuery() after your closing your reader why?

Great Explination. +5

Hey you need to replace index with your column index I.e 0 etc.........

You need to load your sql data in to a datatable and set the datasource of your gridview to your datatable.

Just inside your main form use, Form2 frmTwo = new Form2();
frmTwo.Show(); or frmTwo.ShowDialog();

Can you be more specific please?

C# or Vb?

Can you please elaborate a bit more as to what your trying to do.

;WITH cte
AS (SELECT A.paymentid,
A.paydate,
A.payfrom,
A.monerismsg,
NULL AS GuardianId,
NULL AS RegId,
NULL AS TransId,
A.amount,
A.paystatus,
A.cardauthorizationcode
FROM dceonlinepaymenttest.dbo.tblpayment A
UNION ALL
SELECT B.paymentid,
B.paydate,
B.payfrom,
B.monerismsg,
B.guardianid,
B.regid,
B.transid,
B.payamount AS Amount,
B.status AS PayStatus,
NULL AS CardAuthorizationCode
FROM lakesidelabsqltest.dbo.tbluserpayment B)
SELECT cte.paymentid,
cte.paydate,
cte.payfrom,
cte.monerismsg,
cte.guardianid,
cte.regid,
cte.transid,
cte.amount,
cte.paystatus,
cte.cardauthorizationcode,
Sum(cte.amount) AS TotalPaidAmount
FROM cte
GROUP BY cte.paymentid,
cte.paydate,
cte.payfrom,
cte.monerismsg,
cte.guardianid,
cte.regid,
cte.transid,
cte.amount,
cte.paystatus,
cte.cardauthorizationcode

your converting C.Paystatus to UPPERCASE and then trying to compare it to Lowercase letters?

Looks like you are trying to sum the wrong thing Replace Sum(C.Amount) as TotalPaidAmount, with (Sum(Amount)) as TotalPaidAmount

Your tables have no relationship, can you please tell me what you are trying to acheive from doing this?

You cannot do a union if the columns are of different datatypes.

Your instanciating your class and then never using your declared reference to your business logic class.

Hey replace BusinessLogicBuyer with oBusinessLogicBuyer and your in business.

Can you post what error you are getting? I wrote this free hand so I might have missed something.

Put if(dt.Rows.Count != 0)
{
Logic here....
}
And you will receive no error, your data table must have no rows so that's why your getting the error

Just loop through the datalist items and append the data on to the query string??

Hey your data table is empty so when you try to read it you get the error

Ha what question:)

Good stuff, glad you got it sorted.

Glad I could help.

HAve you tried enabling the tabpage. Like tabPage3.Enabled = true?

You need to re-create your control on every postback. Dynamic controls added to the page during a previous postback go to the garbage collector.

You need to make the classes public, so Public Class Account etc....

I use MigraDoc for generating PDFs its very easy to work with and creates some very nice documents.

vb version sorry If dataGridView1.Rows.Count > 0 Then
dataGridView1.Rows(index).DefaultCellStyle.Font = New System.Drawing.Font("Arial", 10, FontStyle.Bold)
dataGridView1.DefaultCellStyle.SelectionForeColor = System.Drawing.Color.Black
End If

That is very strange, it looks like you grid is disabled so try setting that to enabled, failing that what I can suggest you do is after you set the datasource in the code behind do something like this if (dataGridView1.Rows.Count > 0)
{
dataGridView1.Rows[index].DefaultCellStyle.Font = new System.Drawing.Font("Arial", 10, FontStyle.Bold);
dataGridView1.DefaultCellStyle.SelectionForeColor = System.Drawing.Color.Black;
}

Hey in design view click on the little triangle at the top right of the datagrid, go to Edit Columns and check that the DataPropertyName is set for each individual column.

Suppose you could check the person table before you preform any inserts of updates for the PersonId?

Hey are you trying to disable the whole form? Where do you want to do this I.e after a button click of form load?

Either way here you won't be able to insert duplicate records in you database with the same ids, can you elaborate a bit more as to what your trying to achieve and post some code so I can take a look for you?

Hey what are you looking for here, an SQL statement to insert the values in to a database or am I miss understanding the question?

Have you got AutogenerateColumns set to true or false?

PayPal?

Cool always nice to get a good bit of advice every now and again, cheers.

The query looks fine can you show us the code from which you call the stored procedure?

Your user_id cannot be 0 as there must be a foreign key constraint between the 2 tables

CHill60 is right, you are always only going to return 1 record with your SQL query, you need to change this and your code will be fine.

Hey very hard to explain, here's a step by step process of setting it up. http://www.axosoft.com/support/quickstartguide/v10/OnTime_Quickstart_Guide.pdf

Hey there is a different one I use for Internet Explorer, will tell you exactly what the error is http://www.fiddler2.com/fiddler2/

Hey yes I use this every day, what do you need to know?

Can you show you code so I can see whats going on

Hey I don't know much about Access but it looks to me that you are closing your connection to the database after the first insert in the loop.

Hey he is simply saying use, PageNumber = (int)e.CommandArgument - 1.
Cheers

Hey have you thought about using jquery to validate these textboxes?

Hey you need to set the DataSource of the GridView to the DataTable you return.

Then in the RowDataBound event of the gridview set the PostBackUrl of the desired column using an anchor tag. If you need any more help i'm happy to help

Hey you need to change the condition in your if statement to If txtClockHour.Text.Trim() <> String.Empty And txtClockHour.Text.Trim() <> String.Empty Then .... If you need any more help I'm happy to help.

Try removing the dll and re-adding it, I had this error a few weeks back with a different dll and that worked for me.

Hey you have a couple of options here. For the overall average in main() under where you get the proAvg declare a double dOverAllAvg =(exAvg + hwAvg + labAvg + parAvg + proAvg) / 5, then just display the message to the user using another console.writeline("message here" + dOverAllAvg.toString()). Hope this helps

Hey thank you for your reply.

Hey thank you so much for your reply.

Thank you my friend!

Hey the query returns about 4000 rows so I don't think its a massive chunk of data. Yeah there is a good bit of aggregation that happens in the report but if I leave out one of the destinationgroups it runs fine?? Any ideas?

Hey could you please include the steps, thank you.

Thank you so much!!

Hey I am using a utility called PDF Sharp it is very usefull and easy to create PDF's. I have been using it to generate bills and statements that look pretty cool too.

Thank you so much sir.

Hey please look at http://stackoverflow.com/questions/8576652/how-to-programmatically-read-over-a-scanned-document-or-image

Hey can you explian more clearly what you are after?, are you looking for popups to be displayed on screen, emails to be sent?

Hey I got it working by enclosing the ('modal').reveal insind a seperate method and calling it onClientClick, but I have another problem, The CommandName="Update" is getting fired before I have time to read the result from the modal. thanks

Hey thanks for your response, I will try and find where the signatures are stored, from there it's pretty straight forward to figure it out, thanks again.

I've have my application sending standard smtp mails but they don't have the signature.

Hey thank you very much, the file must be encrypted as when I use the GEtEncoding it says UTF8 but when I decode it is still un-readable. Thanks for your help.

Hey thank you for your reply, yeas you are right when I set AutoGenerateColumns="false" all the borders show. But that still leaves me with the problem as I don't need to display all the columns as some columns are id's that I need upon saving and drilldown to next screen. thanks

Yeah that makes sense, but surely there is an event on the dropdown that you could call to close it. Maybe im just being silly here, anyway thanks for your help.

When you select the dropdown list it shows say 20 items, I want to close the list once the mouse leaves the list items. Cheers

Hey sorry it took so long to accept your answer, you were right, the wpf was referenced in most of the files so I just deleted all the references and it worked like a treat.

Hey I had a chance to test this out and it is not hiding the dropdown on mouse out, any other ideas?

Yeah cool makes sense, il implement this when I get a chance and accept your solution, thanks for your help.

Hey sorry for not accepting your solution sooner, you were right, it turns out that one of our developers had hardcoded the image tag values so they were getting overwritten thank you so much.

:) yeah il have a good look through it and try find out where it is, thank you.

select * from Subscription s inner Join
PermissionGroup pg on s.SubscriberLinkId = pg.PermissionGroupId inner join
DeliverFileSetting df on df.DeliverFileSettingId on s.SubscriptionLinkId
where @PermissionGroupId = SubscriberLinkId

Thanks very much for your help

Hey where exactly do I place this code. The DataContext.SubmitChanges is where I want to track the progress but I can't seem to do it.

Hey thanks very much I have it working. really apreciate your help.

The validation, it goes in to 4 different tables for each record in the grid, the grid could have 1000's of records at a tile so this is whats taking the time.

Hey what you mean by BackgroundWorker1.RunWorkerAsync() [where evere you want to put]
do I not need to do that in the Constructor?

ok the app has a datagrid which loads the data from a file, when the user is happy with the details of the grid they press save then a whole lot of validation takes place and then inserts in to the relevent tables in the database.

Thanks very much for your reply, only issue I have is that in the worker_DoWork method it's not possible to do the loop to report the progress as this is where I will need to upload the data. Thanks

Task loads data from a file and then inserts in to a database.

Hey thanks for your reply, I have checked the files and there are no duplicate class names in the CSS files. Our application can only be ran on IE so I cannot use Firebug. This is a very strange one. Any more ideas? Thanks very much.

Ok only problem I am having is that the PermissionGroupObj is an autogenerated class that I don't really want to go messing with in case it has a knock on affect.

Hi I tried this approach but I get an IEqualityComparer exception.

Sorry about that.

Hi bill, thank you so much for your kind response.

Yeah when I hit restore sorry

I have tried these but nothing works. The controls get hidden behind a data grid that's on the form. Even when I put autoscroll to true they are still hidden.

Worked a treat thanks very much

+222 345 2345 will be the format. Thanks

But the number won't always have a + sign

The format of my phone number will be +233 678 7890, so will this take care of this? cheers.

Ok turns out I had to do this if (value == 5) {
$get('<%= cboCarrier.ClientID %>').style.display = "block";
}

Cheers