Comments by SeanChupas

SeanChupas 28-May-21 11:03am View

No, because the way COALESCE works with STUFF, they work on each row. So you need something to happen after all that is done.

SeanChupas 28-May-21 9:51am View

And you want us to do it?

1, 2, 3, Not it!

SeanChupas 28-May-21 9:47am View

You need to ask a specific question. Show us where you are stuck.

So far all you have done is asked, "Who will do my homework for me?"

SeanChupas 28-May-21 8:28am View

You need to ask a specific question.

SeanChupas 28-May-21 8:28am View

What is your question?

SeanChupas 28-May-21 8:23am View

I don't quite follow you but something like

SELECT COUNT(*) FROM table WHERE field = 1

sounds like is what you need.

SeanChupas 27-May-21 10:08am View

Sounds like you just need to join tables. Very easy but since I can't see your tables or your table structure, I don't know what fields to join on.

Do you know basic SQL? If so, this should be very easy.

SeanChupas 26-May-21 13:23pm View

SELECT ..., ((SELECT statment to get cash amount) - (SELECT statement to get credit note amount)) AS Difference.

Something like that will work.

SeanChupas 26-May-21 12:05pm View

Not sure what you are asking but to subtract 2 columns all you have to do is column1 - column2.

SeanChupas 26-May-21 9:21am View

Where are you stuck?

https://www.w3schools.com/sql/func_sqlserver_substring.asp

SeanChupas 26-May-21 8:04am View

Make sure you have proper indexes. Use monitoring tools to find the slow queries.

SeanChupas 26-May-21 8:02am View

What line of code gives you the error?

SeanChupas 25-May-21 14:32pm View

What is the error?

SeanChupas 24-May-21 11:51am View

Depends on how you are posting, for example, in query string or in body. Then google c# post to rest api examples and go through examples of how to do it.

SeanChupas 24-May-21 11:25am View

As Richard said, you need to talk to IT to find out what accounts they are using.

SeanChupas 24-May-21 11:24am View

Do they have any documentation?

SeanChupas 24-May-21 11:23am View

Your code to call MySql is not correct. Looks like something is null.

SeanChupas 20-May-21 10:40am View

I would suggest you go back through the site and read everything to make sure you followed the steps correctly. If you still have a problem I would look for a different library to use.

SeanChupas 20-May-21 8:20am View

You can debug the source code then.

SeanChupas 19-May-21 13:56pm View

And what is your question?

SeanChupas 19-May-21 13:56pm View

Count(*) and a proper WHERE clause based on date will get you the number of order in last 7 days.

ROW_NUMBER with PARTITION - do not know what the equivalent is in MySql - will get you the second.

SeanChupas 19-May-21 13:30pm View

It means there is an error in the code or you have provided it some data it did not expect or set a setting they didn't code for. You may want to ask on github.

SeanChupas 19-May-21 13:28pm View

So, you just need to fix the deserialization then.

SeanChupas 19-May-21 11:55am View

What is your question?

SeanChupas 19-May-21 11:54am View

Do you have a question?

SeanChupas 18-May-21 16:58pm View

And what does your title have to do with this? Something about a hidden field?

SeanChupas 18-May-21 16:58pm View

1. Some of your code is not helpful and clutters the question. We do not need to see your Edit or List methods, for example. Clean up and format the code so it is much easier to read.
2. I don't see where your code gets called. You do have a Save method so that is what I would expect should be running so put a breakpoint in it and see if it is even running. You may not be calling Save in your view or your ViewModel might not be valid. You have to do some troubleshooting and debugging.

SeanChupas 18-May-21 7:46am View

Sorry no. I am not downloading files from a stranger on the internet.

SeanChupas 17-May-21 12:06pm View

Again, OP is not looking for an answer but rather a discussion.

I'm not sure why that's hard for some people to grasp.

SeanChupas 17-May-21 12:04pm View

There is no other method. That's how you convert it.

You are not being clear about anything, even when you are upset.

SeanChupas 17-May-21 12:03pm View

You are being incredibly rude. I have helped you and others have tried. You are not very good at being clear with your question so we did the best we can.

SeanChupas 17-May-21 12:02pm View

User wants to hear experience from other people that have gone through the process. That's completely valid.

SeanChupas 17-May-21 8:55am View

Just make it clear you are looking for a general discussion on the topic and if anyone has any experience in it. Otherwise, you'll get a lot of people telling you to consult a lawyer. Sometimes people on this site have a hard time having a discussion in the discussions section.

SeanChupas 17-May-21 8:52am View

You probably have something in SchoolmanagementDataSet that is causing it.

SeanChupas 17-May-21 8:50am View

I do not understand what you mean. You wanted to know how to convert dt into a datetime and I told you how to do that.

Whether you put that code into a function and call it or you do it inline, does not matter. That's up to you.

SeanChupas 17-May-21 8:49am View

Because I misread the question. But finding java code is just as easy.

SeanChupas 17-May-21 8:48am View

In that case, one of the discussion forums would be more appropriate to post this. This is the Quick Answers section so the quick answer is, consult a lawyer. ;)

SeanChupas 14-May-21 16:33pm View

Is restricting based on file extension sufficient?

SeanChupas 14-May-21 16:17pm View

I am not sure what you mean. I gave you code that will convert unix UTC to c# datetime. Where you put it and how you call it is up to you.

SeanChupas 14-May-21 15:00pm View

What do you mean how do you call it?

SeanChupas 14-May-21 13:06pm View

The documentation is says it is in unix utc format. So, just google that to find out how to make sense of it. Seriously, we have been trying to help you over and over. Not sure why you are overcomplicating it.

SeanChupas 14-May-21 13:05pm View

You have to know what those numbers mean. So, read the documentation and find out what they mean.

SeanChupas 14-May-21 13:02pm View

I just looked at a sample response and they have:

"sunrise": 1560343627,
"sunset": 1560396563

So, YES, your question IS how to convert those numbers to date time, right?

SeanChupas 14-May-21 13:00pm View

I know you don't want to convert that specific number to date time. But you want to convert sunrise to date time, right?

SeanChupas 14-May-21 12:50pm View

But you haven't even answered my question. All you want to do is convert 1620792785 to an actual datetime, right? If not, what IS your question?

Because you are not being clear on what you need help with.

SeanChupas 14-May-21 12:42pm View

What is the actual question?

SeanChupas 14-May-21 12:40pm View

Use a parameter query, not a concatenated one.

But I don't understand. You say that IssuedBy is coming from the username but then ask how you give those values.

No idea what you mean.

SeanChupas 14-May-21 12:35pm View

This is how you simple down your question. You said, "Convert Sunrise and Sunset time accurately." OK, what format is sunrise in? You mentioned it might look like 1620792785. But what is that number? How would you convert it?

Once you answer that question all you have to do is write code to convert it. Very easy.

SeanChupas 14-May-21 12:32pm View

Help with what? I tried reading your mind but all I got was something about a pineapple and a squirrel.

SeanChupas 14-May-21 12:23pm View

I do not understand.

SeanChupas 14-May-21 12:22pm View

Where is your upload code? You need to click Improve Question and clear out all of the non relevant code. It's too much code to look through. There's no reason to post your Delete method, for example. Clean it up so we can see it easier.

SeanChupas 14-May-21 8:56am View

Not enough to know what you did wrong.

SeanChupas 13-May-21 16:18pm View

What is the value of employees[selectedIndex-1][1]

SeanChupas 13-May-21 15:00pm View

So whatever is in employees[selectedIndex-1][1] is not an integer. Right? So, just fix that.

SeanChupas 13-May-21 14:24pm View

What can we do about it? You need to use your developer tools and figure out what is going on.

SeanChupas 13-May-21 13:14pm View

OK.

SeanChupas 11-May-21 14:17pm View

No.

SeanChupas 10-May-21 8:51am View

So, leave it as System.Data.SqlClient, right?

SeanChupas 6-May-21 16:15pm View

I am confused. You do not know how to add 2 buttons to a form?

And what's this about reading a database?

I have no idea what you are asking.

SeanChupas 5-May-21 16:32pm View

These are basically step by step instructions so what would a diagram give you?

SeanChupas 5-May-21 14:27pm View

The problem is there are many ways of doing things so you are asking someone to start from scratch and do all the work for you, rather than helping you fix what you had.

It's usually easier to fix what you have than ask a volunteer on this site to take their time to do all the work.

SeanChupas 5-May-21 14:24pm View

30 minutes? ROFL.

SeanChupas 5-May-21 14:23pm View

The most important skill as a developer is knowing how to debug. And turns out it's pretty easy to do so.

SeanChupas 5-May-21 8:58am View

You'll need to use the javascript window.setTimeout function. Which I see you have, so what is the problem?

SeanChupas 30-Apr-21 11:10am View

Can you do this server side instead of using JavaScript?

SeanChupas 30-Apr-21 11:08am View

There are many ways to do it so it would help if you could show us where you are stuck.

IF you have the sites html why can't you search it?

SeanChupas 29-Apr-21 16:01pm View

What are you stuck on?

SeanChupas 28-Apr-21 16:29pm View

Can you not fix the error? You are trying to reference something by an index but that something does not exist. We can't see what it is or what line of code is 200. You have to do that. But it's very easy. Debug.

SeanChupas 28-Apr-21 16:16pm View

No idea. But if you posted some relevant code I bet I could make some suggestions.

SeanChupas 26-Apr-21 14:37pm View

Are you high? Or is making up weird stuff just normal for you?

SeanChupas 26-Apr-21 13:36pm View

I answered the OP's question. No reason to be rude.

SeanChupas 26-Apr-21 9:02am View

Ability to log to console should not be a deciding factor of what type of project to make.

SeanChupas 26-Apr-21 9:01am View

They can, but OP was asking why they couldn't find them in the toolbars. Because they are not there, until you go and manually put them in.

SeanChupas 23-Apr-21 15:24pm View

There's too much code there for me to try and dig through it. All you should have to do is debug it and track down what is going on.

SeanChupas 23-Apr-21 14:54pm View

What can we do to help?

SeanChupas 23-Apr-21 14:53pm View

That's because console apps do not have forms. If you want a form, don't do a console app, do a windows forms app.

SeanChupas 23-Apr-21 13:54pm View

Fix the connection string.

SeanChupas 22-Apr-21 8:35am View

No way for us to know how to help without seeing what you have done.

SeanChupas 21-Apr-21 14:12pm View

Because it takes too long. You can increase the timeout but should also look at optimizing the sql.

SeanChupas 21-Apr-21 9:45am View

What is your question?

SeanChupas 21-Apr-21 9:36am View

You have not given enough information for anyone to help you.

SeanChupas 20-Apr-21 14:03pm View

Write code to do it. Do you really think you have told us enough information to be able to do anything?

SeanChupas 20-Apr-21 14:02pm View

I do not understand your question.

SeanChupas 20-Apr-21 9:49am View

Why did it not work?

SeanChupas 19-Apr-21 13:27pm View

No thank you.

SeanChupas 16-Apr-21 14:32pm View

What exactly is the problem?

SeanChupas 16-Apr-21 14:31pm View

You have a bunch of code. Where are you stuck?

SeanChupas 15-Apr-21 14:39pm View

Debug the code, walk through it step by step and find out what the problem is. Easy.

SeanChupas 15-Apr-21 10:02am View

It sounds like it is a project they are working on and would like to learn.

SeanChupas 14-Apr-21 16:12pm View

Then you'd never had a good tuning, have you. ;)

SeanChupas 13-Apr-21 16:12pm View

We have no idea what instructions your teacher gave you. I'm not sure why you thought we could clear this up.

SeanChupas 13-Apr-21 14:12pm View

Something is null and you just need to debug it to find out. My guess is objBoxsetDataAdapter.SelectCommand is null.

SeanChupas 13-Apr-21 10:10am View

Be a sports jock? Or a hot girl?

SeanChupas 13-Apr-21 9:14am View

What is your question?

SeanChupas 13-Apr-21 9:10am View

What is your question?

SeanChupas 13-Apr-21 8:51am View

Have you compared the barcode to one that is valid? Maybe you have a width set and so it's getting stretched or compressed?

SeanChupas 12-Apr-21 16:21pm View

I do not understand what you are asking.

SeanChupas 12-Apr-21 16:08pm View

What is your question?

SeanChupas 12-Apr-21 13:37pm View

What is your question?

SeanChupas 7-Apr-21 14:20pm View

And?

SeanChupas 7-Apr-21 13:11pm View

You need to post your question here, not a link to it.

SeanChupas 7-Apr-21 9:28am View

All you have to do is debug the code. You need to make sure the proper parameters are getting passed and that all the code is correct. We can't do that for you.

SeanChupas 7-Apr-21 9:26am View

Where are you stuck exactly?

SeanChupas 7-Apr-21 9:25am View

There is no way we can help you because you need to define what you mean by a thin client and also where you are stuck. What exactly are you looking for here?

SeanChupas 6-Apr-21 15:17pm View

No idea what you are asking.

SeanChupas 6-Apr-21 8:00am View

Deleted

You should take your own advice and try something before saying it can be done. You cannot use System.Windows.Forms in a .Net Core Console App without doing other things.

SeanChupas 6-Apr-21 7:57am View

Sure thing bossy.

SeanChupas 5-Apr-21 16:42pm View

Google it. Tons of examples online and more code that can be easily relayed in a comment box here.

SeanChupas 5-Apr-21 14:24pm View

You could do it in the Framework? Possibly, but I doubt it. A console app is just an old black DOS command window. I don't think, though I never tried it, that it could show Dialogs.

SeanChupas 1-Apr-21 13:54pm View

Step 1, unconfuse thyself. You can't solve a problem you do not understand.
Step 2, write out what you need to do in English and then translate that into Assembly.

It's unlikely that anyone here will do all of this for you so I'd suggest asking something more specific.

SeanChupas 30-Mar-21 16:05pm View

What is the question?

SeanChupas 30-Mar-21 9:39am View

Refer to the documentation.

SeanChupas 29-Mar-21 16:01pm View

A better option is to put javascript on the a tag instead of having a link.

SeanChupas 29-Mar-21 14:28pm View

You crazy.

SeanChupas 29-Mar-21 11:45am View

What code do you have already?

SeanChupas 29-Mar-21 9:43am View

To be able to do what exactly? We need more details.

SeanChupas 25-Mar-21 9:13am View

What do you want us to do? You have to debug it and find out why the values are not what you expect. It's very easy to do.

SeanChupas 22-Mar-21 15:38pm View

If you cannot connect to the db what can we do?

SeanChupas 22-Mar-21 15:36pm View

Use < button >

SeanChupas 22-Mar-21 11:55am View

You need to do some debugging. Uri is null, you need to find out which Uri it is referring to. Is it a line in your code or a configuration setting somewhere. You'll have to debug it and figure out what it is referring to.

SeanChupas 22-Mar-21 9:31am View

I have not done much Java but the error says something is null.

SeanChupas 22-Mar-21 9:30am View

What is the question?

SeanChupas 18-Mar-21 13:13pm View

It's very easy. Fix your code.

SeanChupas 18-Mar-21 13:13pm View

You said everything is working except that you can't see anything?

I also built a time travel machine and it all works, only thing is you can't see it right now.

SeanChupas 18-Mar-21 13:05pm View

You need something outside of the website to do this. A windows service or a console app that is run by scheduled task will work.

SeanChupas 18-Mar-21 11:03am View

What guide? What specifically are you stuck on?

SeanChupas 17-Mar-21 16:55pm View

Yes, in your render function you need to either create a disabled button or a regular button.

SeanChupas 17-Mar-21 16:25pm View

What more do you need?

SeanChupas 17-Mar-21 16:16pm View

Not likely. If you cannot explain the issue then that means you don't understand it very well.

SeanChupas 16-Mar-21 10:25am View

That game is not going to do much at all. Did you have a question?

SeanChupas 15-Mar-21 13:45pm View

Behave!

SeanChupas 14-Mar-21 18:49pm View

All that code does is add a listener. Where is the code that would then execute?

Comments by SeanChupas (Top 132 by date)