Comments by dnibbo - CodeProject

dnibbo 6-Apr-21 4:23am View

Thanks Chill60
All of your suggestions are good workarounds, I was hoping someone had found a way to get the bound grid to work as a quick win. However, there does not seem to be a way which is a shame :(
I have taken away the bindings and now populate the dgv manually with an 'addable' row. I can then just ignore empty rows. User is delighted with the results so all good now :)

I a sure in the 'old days' you could drag a datasource onto a form and away you go...

dnibbo 1-Apr-21 11:33am View

That looks like a possible solution but I don't understand why we can use a bound datagridview?
In theory you should be able to drag a datatable onto a form and boom, job done!
I need to write a few of these and dont have that much time so was looking for a quick solution. I guess this it is not going to be the case so will write my own as I have in the past.
I am just a bit surprised that there is not an obvious workaround for something that to me seems so simple...

Thanks

dnibbo 31-Mar-21 11:08am View

Apologies, I was getting frustrated...
This is .NET 4.5, I am using VB but I am sure c# will be the same as it is not in my code that the problem occurs.
I will post some images to illustrate the problem.
Thanks Chilli

dnibbo 14-Aug-20 3:48am View

Please note that the above does not work properly either.
Files seem to get to the c:\pub folder but not the deployment folder and manually copying does not work.
I am now getting: Parser Error Message: Could not load the assembly 'App_Web_uznma5bb'. Make sure that it is compiled before accessing the page.
The search goes on :(

dnibbo 2-Aug-20 6:53am View

Hi Sandeep

Thanks for the reply, it did look hopeful but alas it does not fix the problem.
That path specifies where VS will compile to.
Once compiled, I have no idea why, it copies it to another temp publish folder called C:\Users\myusernamexx\AppData\Local\Temp\WebSitePublish\WebPortalNet4-872599845

I need to somehow get it to use a different path for that bit.
I have looked in that .pubxml to see if there are any other paths that can be overridden but cant see anything.

One site suggested <PublishTempFoldername>C:\Pub\ but that didn't seem to work.

Thanks

dnibbo 2-Aug-20 6:36am View

It is Visual Studio that generated the directory name not me :(

dnibbo 15-Jun-20 13:10pm View

Thanks Chill, I was actually after WinForms rather than WebForms but it did help. I am not sure why it shows as v150 in nuget? Anyway, it looks like Corrected.Microsoft.ReportingServices.ReportViewerControl.Winforms 150.1358.0 is the one. Cheers

dnibbo 24-Jan-20 7:37am View

I don't think there is anything wrong with what you have if I am reading this correctly. NOT IN is perfectly OK.
Are you trying to find all 'parts' that have no Tradecode?

You could use

SELECT p.PartID, p.SupplierID
    FROM #parts p
    LEFT OUTER JOIN #TradeCodes t ON t.PartID = p.PartID
    WHERE t.TradeCode IS NULL

dnibbo 24-Jan-20 7:27am View

Thanks but that is the problem, I cannot trap it, the HTTP POST throws an exception and the exception does not contain the error.
The code works just fine, it is the API that is returning Bad Request when it fails validation, it is not a malformed request and not a coding error but a bad API.
As stated, my question is how does Postman get the error when it is not available in the .NET stack trace?
Code posted below but I am certain that is not where the problem is.

dnibbo 24-Jan-20 7:03am View

The code is below, the first time I POST the request it works, subsequent POST's fail as the record already exists.

 
Dim wrResult As HttpWebResponse 
Try  
'   post customer details  
Dim sURL As String = _baseURL & "Customer"
Dim WebRequest As WebRequest = HttpWebRequest.Create(sURL)
WebRequest.ContentType = "application/json"
WebRequest.Credentials = GetCredential(sURL)
WebRequest.PreAuthenticate = True
WebRequest.Method = "POST"
Dim sJson As New StringBuilder
sJson.Append("{")
sJson.Append("""No"": ""XXX"",")
sJson.Append("""Name"": ""FRED""")
sJson.Append("}")
Dim postData As Byte()
Dim utf As New UTF8Encoding
postData = utf.GetBytes(sJson.ToString)
WebRequest.ContentLength = sJson.Length
Using stream = WebRequest.GetRequestStream()
   stream.Write(postData, 0, postData.Length)  
End Using  
wrResult = WebRequest.GetResponse()  
' CODE DOES NOT GET HERE ON FAILING REQUEST  
If Not wrResult.StatusCode = HttpStatusCode.Created Then      
    Throw New Exception("Customer XXX not created in Dynamics.")  
End If  
wrResult.Close()
Catch wex As WebException  
' BAD REQUEST WEB EXCEPTION CAUGHT HERE BUT ERROR MESSAGE NOT EXPOSED aNYWHERE  ???? 
End Try

dnibbo 24-Jan-20 6:58am View

Thanks Jimmson but Postman can see the error 'record already exists'.
Only the SERVER would know if the record already existed so it is the server not the client that has decided the request was bad.

dnibbo 24-Jan-20 5:52am View

Deleted

That IS the problem, I cannot trap it, the HTTP POST throws an exception and the exception does not contain the error.
The code works just fine, it is the API that is returning Bad Request when it fails validation, it is not a malformed request and not a coding error but a bad API.
As stated, my question is how does Postman get the error when it is not available in the .NET stack trace? I am happy to post my code but that is not where the problem is.

dnibbo 24-Jan-20 4:41am View

Actually the above was a bad example as the JSON I posted was invalid.
However, if I try to create the same record twice I still get the Bad Request error with the below in Postman (still cant catch in code)

    
"error": {
   "code": "Unknown",
   "message": "The record already exists.  CorrelationId:  862fae85-f342-43a4-96e7-191f0fae561c."
    }
}

It just looks like the API throws the Bad Request exception if the request fails validation but I just cant see how to catch this in a .NET application.

dnibbo 29-Jul-19 7:49am View

Apologies for not being clear.
A WYSIWIG editor so users can build their own HTML in a text box style control with formatting tools.
The result will be saved to a database and later used to add the formatted text to web pages.

Basically users want to be able to edit web content without knowing HTML.

Thanks

dnibbo 23-Aug-18 6:47am View

Thanks for the reply.
You are quite right, I was looking in the application logs but it was in the system logs.
There was a message saying that it had been disabled due to a series of failures.
Investigating ...

dnibbo 8-Aug-18 10:38am View

Thanks, the picturebox is the only control on the dialog and is dopcked to full screen.
I did wonder if it had zero size or something so inspected the objects and all is good.
What I have discovered is the picture box is actually showing the ErrorImage.
Hard to tell as the default ErrorImage is the same as the default InitialImage.
I changed the error image and that is what is being displayed now.
So how do I diagnose why the error image is being used? The code is in a try/catch but no exceptions are displayed.
So I guess the question has changed a little... what makes a picturebox display the errorImage instead of the Image.

Thanks again

dnibbo 8-Aug-18 10:15am View

Hi Jochen

Thanks for the reply.

I only added the save file to prove that the picture box image was as expected, which it was.
I removed the save file and tried the refresh method but still it will not show the image.

Thanks

dnibbo 12-Jan-18 7:40am View

Thanks David,
Could not get fiddler to work at all but I am not familiar with the product and the documentation is not that clear on how to invoke it from VS.

Will look into netstat next.

As for you last question, yes, I am trying to run the project from within visual studio so it will be running under localhost.

Thanks

dnibbo 25-Oct-17 11:03am View

Thanks Dave K

Agree that the device I have is not going to be the solution.
Cant really code around it either as the PC will be multi user / multi tasking and another user may have a word doc open etc. so unable to even guarantee which app will intercept the 'keyboard'.
Still searching for a scanner that connects to the serial port or can do the 'serial over USB thing' .... anyone?

Thanks

dnibbo 25-Oct-17 10:59am View

Thanks CPallini
I agree, the serial converters are designed to make serial devices USB not the other way around.
The search for a Serial reader goes on...

dnibbo 30-Jun-17 10:35am View

Hi, thanks for the suggestion. I tried your method and it does work but still the results are slow. Poor DB design to blame here...
I will add what I have found to be the quickest solution.
Thanks you for your time.

dnibbo 30-Jun-17 10:17am View

Thanks for your time and your reply. However, as per proposal 1, think I will only have read permission Thanks anyway.

dnibbo 30-Jun-17 10:17am View

Hi, thanks for your reply but not allowed to create tables.
I know I can droop it straight after but I think my credentials will only have read permissions when this puppy goes live.
Really appreciate your time though.

dnibbo 20-Jun-17 4:06am View

But when you create a new database it will be in the default directory and therefore still need to be moved wouldn't it?

As it happens, SQL was able to read the data but not update it so we surmised that it was using the server\users permissions.
We changed that to full control and could then set read only to False.

Not entirely sure what the implications are here but it seems to work OK?

Thanks

dnibbo 20-Jun-17 4:05am View

Hi thanks, not sure if it was that exact article but read several similar ones. Our problem is that the NT Service accounts don't show up when we click the 'Check names' button.
We even tried the 'Advanced' option and then clicked on 'Find Now' which shows all available accounts; again the NT Server ones do not show up.

dnibbo 18-Nov-16 11:50am View

Thanks, interesting looking bit of software.
I thought I would write my own server task to scan the folder for changes and generate the 3 different sizes I need. I can crop any whitespace at the same time also.

dnibbo 18-Nov-16 11:15am View

Thank you that make perfect sense when you say it like that.

dnibbo 20-Jul-16 6:52am View

Thanks but what I am after is the ability to run it from within Visual Studio.
From Visual Studio you can already launch the website in IE or chrome and can change the site on the fly and see the results immediately.
Unfortunately this is effectively how it is rendered on the device running Visual Studio.
To see how it renders on a tablet or phone I currently have to publish the web application and copy to our IIS server and then view it which takes an age.
I am sure I have seen someone using one but have no idea what it was called and it is a difficult question for google as it does not return anything that can help.
Any other VS web developers out there? What do you use?

Thanks

dnibbo 8-Jun-16 11:30am View

Sorry I always do this.
I have an existing VB.NET WinForms project and I would like to add a new dialog with this control embedded into it.
Thanks

dnibbo 8-Jun-16 11:29am View

Thanks for the reply.
I did try this also but all I get is a more up-to date exe which still does not appear in the toolbox when referenced. I am by no means expert when it comes to custom controls so I don't really know how they work.

dnibbo 24-Feb-16 9:15am View

I would post it under a solution if there was one but there isn't; only a proposed solution which does not help! How do I keep the question going?
It seems you can comment on a proposed solution or offer a solution but cannot say 'hey wait no-one has solved this anyone else got any ideas?'...

dnibbo 23-Feb-16 9:33am View

Sigh

dnibbo 23-Feb-16 8:05am View

Appreciate your time but... are you sure?
There is the wiki article (link below!) which I must confess I cannot get working but the page infers that it is possible.

dnibbo 14-Jan-16 7:41am View

Are you saying that the aspx files are in the folder but not in the project?
If so you can use the Project-->Add Existing Item option the add it back in the project. (or Ctrl+D)

dnibbo 1-Dec-15 6:21am View

Sorry I was just using that as an example.
When I type the full URL with the page name it works fine but when I type just the URL it does not load the start page that I have selected in the Visual Studio project.
I will run the browse from IIS and see what I get.
Thanks

dnibbo 16-Sep-15 12:02pm View

I agree your solution works and trust you when you say that converting is a bad idea. But surely this is an error in SQL?
I will use your method (tested and verified) for this query and any others I find but am still amazed that this error could exist in such a major and widely used database system.
Thanks for your time and advice.

dnibbo 16-Sep-15 7:50am View

Thanks very much Tomas, works perfectly.

dnibbo 13-Aug-14 9:24am View

No problem. I really appreciate your taking the time for me.
I am starting to think that they have blocked us for over-usage.

dnibbo 13-Aug-14 7:56am View

No, that's the odd bit.
If I use my phone it is OK on 3g but when connect to the Wi-Fi here and then it times out like the PC does. All other sites are OK.

dnibbo 13-Aug-14 7:18am View

That just confuses me more.
My PC is pointing to our DNS server.
The DNS server is pointing to 127.0.0.1 which is the local host is it not?

dnibbo 13-Aug-14 5:23am View

Ha... as I said this is not really my area.
I though having our own DNS servers meant that we did not use Google/OpenDNS etc.
How can I find out which one we are using?

dnibbo 13-Aug-14 5:00am View

we have our own Windows server 2008 R2

dnibbo 13-Aug-14 4:53am View

Thanks for the reply. I did try chrome and get:
Google Chrome could not load the web page because nominatim.openstreetmap.org took too long to respond. The website may be down or you may be experiencing issues with your Internet connection.

I guess that means it has resolved the URL; so the question now is why does it time out when accessed via browsers on our network but works on a phone with hardly any reception?

dnibbo 19-May-14 11:11am View

Thanks Daniel, I did not realise quite what these config settings were.
I have changed it to a RollingFileAppender and I getting my log messages now.
Thanks so much for your help.

dnibbo 19-May-14 6:46am View

Hi Daniel

Thanks for taking the time to reply.
I am a bit closer but still am unable to get any logs.
When the code executes the GetLogger method I get an error from log4net:

log4net:ERROR XmlHierarchyConfigurator: Could not create Appender [MyAppender] of type [MyModuleName.MyAppender]. Reported error follows.
System.TypeLoadException: Could not load type [MyModuleName.MyAppender]. Tried assemembly [log4net, Version 1.2.10.0, etc...
log4net:ERROR XmlHierarchyConfigurator: Appender named [MyAppender] not found.

I am using vb.net so I may have converted the code incorrectly:
_log = LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)
_log.Debug("Module Initialised")

Thanks

Comments by dnibbo (Top 45 by date)