C# Discussion Boards - CodeProject

OriginalGriff20-Dec-15 19:53

20-Dec-15 19:53

Never post your email address in any forum, unless you really like spam! If anyone replies to you, you will receive an email to let you know.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Re: c# classes methods

OriginalGriff20-Dec-15 19:58

OriginalGriff

20-Dec-15 19:58

This is not likely to happen - you are basically asking us to mark you homework before you submit it, which is a long job with little benefit to anyone, and one we can't necessarily do: we don't know what criteria your tutor will be using to "judge" the code as we have no idea what your course it, or how far into it you are.

If you have specific questions then feel free to ask them (probably here: Qutick Answers[^]), or if you have more general discussions about the language then this forum is good. But reading you homework and judging it? Not really our "thing" - what if everyone on your course made the same request? Or everyone doing homework?

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Re: c# classes methods

BillWoodruff20-Dec-15 23:42

BillWoodruff

20-Dec-15 23:42

As you can see from the other responses here, no one is going to do homework for you.

However, everyone can post specific technical questions related to code they are working on; I'd recommend you post those on the C# QA forum.

In your questions be sure to:

0. summarize the problem briefly at the start of the post

1. tag your question appropriately: WinForms ... etc.

2. show carefully selected code that will help us understand what you are doing, and format the code using CP's format facilities.

3. describe any error messages: where did the error occur, etc.

«Tell me and I forget. Teach me and I remember. Involve me and I learn.» Benjamin Franklin

Incorrect syntax near ','

Member 1144944719-Dec-15 5:00

Member 11449447

19-Dec-15 5:00

This command is not working. It gives the error stated in the subject. Anyone knows how to solve it? Thanks.

SqlCommand Command = new SqlCommand("insert into lojas (NIF, Loja, bloqueado, DataFim, lastupdate, Nome) values ('" + grid_lic.CurrentRow.Cells[1].Value + "', " + grid_lic.CurrentRow.Cells[2].Value + "," + grid_lic.CurrentRow.Cells[3].Value + ",'" + grid_lic.CurrentRow.Cells[4].Value + "','" + grid_lic.CurrentRow.Cells[5].Value + "','" + grid_lic.CurrentRow.Cells[6].Value + "')", connection);
Command.CommandType = CommandType.Text;
Command.ExecuteNonQuery();

Re: Incorrect syntax near ','

Dave Kreskowiak19-Dec-15 5:07

Dave Kreskowiak

19-Dec-15 5:07

First you opened your code up to SQL Injection attacks, risking the destruction of your database.

Second, your problem is easily solvable by using parameterized queries and the SqlParameter class.

Google for "C# sql parameterized queries" and you'll find everything you need.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Re: Incorrect syntax near ','

Member 1144944719-Dec-15 10:18

Member 11449447

19-Dec-15 10:18

Actually I had tried another code before which also gave an error:

Additional information: Incorrect syntax near '2015'.

Unclosed quotation mark after the character string ',')'.
The code was this:

       SqlCommand Command = new SqlCommand("insert into lojas (NIF, Loja, bloqueado, DataFim, lastupdate, Nome) values (" + NIF + "', " + loja + "," + bloqueador + ",'" + DataFim + "','" + lastupdate + "','" + Nome + "')", connection);
Command.CommandType = CommandType.Text;
Command.Parameters.AddWithValue("@NIF", grid_lic.CurrentRow.Cells[1].Value);
Command.Parameters.AddWithValue("@Loja", grid_lic.CurrentRow.Cells[2].Value);
Command.Parameters.AddWithValue("@Bloqueado", grid_lic.CurrentRow.Cells[3].Value);
COmmand.Parameters.AddWithValue("@DataFim", grid_lic.CurrentRow.Cells[4].Value);
Command.Parameters.AddWithValue("@lastupdate", grid_lic.CurrentRow.Cells[5].Value);
                    Command.Parameters.AddWithValue("@Nome", grid_lic.CurrentRow.Cells[6].Value);

 Command.ExecuteNonQuery();

Re: Incorrect syntax near ','

Dave Kreskowiak19-Dec-15 11:48

Dave Kreskowiak

19-Dec-15 11:48

That's not how you put together a parameterized SQL string. I don't know where you got that from, but it's definitely not in any documentation.

I suggest you go back and lookup more stuff to read. This is what the string should look like:

"INSERT INTO lojas (NIF, Loja, bloqueado, DataFim, lastupdate, Nome) 
    VALUES (@NIF, @Loja, @Bloqueador, @DataFim, @lastupdate, @Nome)"

line breaks are there to make it readable on the site.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Re: Incorrect syntax near ','

Foothill21-Dec-15 6:00

Foothill

21-Dec-15 6:00

Dave is correct that is not the correct way to build a parameterized query in C#. However, if you want to know where your SQL statement was getting broken.

SQL

values (" + NIF + "', " + loja + "," + bloqueador + ",'" + DataFim + "','" + lastupdate + "','" + Nome + "')

When this query is parsed it will become

SQL

values(NIF',Loja,bloqueador,'DataFim','latupdate','Nome')

Can you spot the error?

if (Object.DividedByZero == true) { Universe.Implode(); }

Re: Incorrect syntax near ','

Dave Kreskowiak21-Dec-15 7:09

Dave Kreskowiak

21-Dec-15 7:09

You replied to the wrong person. I got the notice you replied, the OP didn't.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

How can I include house address finder in my application?

naouf1019-Dec-15 3:21

naouf10

19-Dec-15 3:21

I am building EPOS system (takeaway order software) with C# and everything went as I planed and I almost done programming it.

The application works where customers provide their Postcode when they want to order something and based on their postcode I should get a list of street names and when I select the street name I get a list of house numbers, then select the number to deliver the food to.

I noticed that all nowadays takeaways use this address finder which included in their EPOS which works with no need for internet connection.

Now the problem is: know do I build / include this address finder in my EPOS system? I do not want to use online address search in my EPOS. Do I have to use another special application to like address finder?

I am really stuck at this point and I can not go further programming my POS till I solve this address finder issue. Please help me with any peace of information you know in how to solve this issue. Thank you

Re: How can I include house address finder in my application?

OriginalGriff19-Dec-15 4:08

OriginalGriff

19-Dec-15 4:08

Almost certainly, you want an online API - Google can help: Postcode to address API[^] as the databases tend to be pretty big, and companies tend to change for them (the UK database for example, is £2 per postcode area, per user, per year).

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Re: How can I include house address finder in my application?

Mycroft Holmes20-Dec-15 12:01

Mycroft Holmes

20-Dec-15 12:01

OriginalGriff wrote:
is £2 per postcode area, per user, per year

Crikey that can add up quickly. What I found was the bastards keep changing the postcode boundaries so last years data is invalid.

Doesn't a postcode cover just a few houses in the UK?

Never underestimate the power of human stupidity
RAH

Re: How can I include house address finder in my application?

Gerry Schmitz19-Dec-15 8:59

Gerry Schmitz

19-Dec-15 8:59

What is your concern? Cost?

How much is a "valid" address worth?

Is this app for yourself? (You can get free access to address finder APIs / data while in development) Would a user of your app be prepared to pay a few cents for a valid address?

I've developed address finders for call centers and shipping companies. It's part of providing a better service.

Re: How can I include house address finder in my application?

naouf1019-Dec-15 11:09

naouf10

19-Dec-15 11:09

Hi Gerry and thank you for your reply. yes this app for myself, my EPOS will be free for some time and then will be sold for very cheap because my app is new. Therefore I might cost too much to buy an address finder app. I can not find any address database in the internet. Can you please guide me how can I access this address finder APIs / data? or do I have to develop address finder as you did? please help me. Thank you

Re: How can I include house address finder in my application?

Gerry Schmitz19-Dec-15 12:01

Gerry Schmitz

19-Dec-15 12:01

I assume from your profile you're in the UK.

In the first case, wrote a custom SQL Server free text incremental search of the NZ PAF database; here's the UK PAF link:

http://www.poweredbypaf.com/register-for-free-use-of-paf/[^]

In the other case, we used PCA Predict web services (again UK based) to search "the world" using calls from C# (you can also call from a web page). Incremental searching is free up to a limit; then a small charge for a final selection.

http://www.pcapredict.com/en-gb/address-capture-software/[^]

Re: How can I include house address finder in my application?

naouf1020-Dec-15 2:22

naouf10

20-Dec-15 2:22

Thank you Gerry for this information but as I understood from your explanation that I have to use online services ( PAF database and PCA Predict web services) to search for the address (list of street names and and house numbers) by its Postcode. Am I right?

I asked you this because I don't want to use online service as my EPOS will not have internet connection.
In the UK, most of EPOS don't use online services to locate addresses. Yesterday I check one computer which contains EPOS which can do address lookup but there is no address database in this PC and on the same time this PC has not internet connection But it has MS MapPoint and it has some Postcode APIs. So how this PC find the full address? does it use MapPoint to find address ?

Please help me I am confused, I would appreciate it if you answer my questions? Thank you

Re: How can I include house address finder in my application?

jschell20-Dec-15 11:21

jschell

20-Dec-15 11:21

naouf10 wrote:
as my EPOS will not have internet connection

How could that possibly work?

There might be a nomenclature problem but it seems that you want to create a order server where someone orders food to be picked up and/or delivered. If the person is at the shop there is no need for the person's address. If the person is not at the shop then both they and the shop must have internet access.

But other than that, for now, make them type the address in. Get everything else working and then add that.

Re: How can I include house address finder in my application?

naouf1021-Dec-15 1:56

naouf10

21-Dec-15 1:56

Customers can phone in to make an order and their order will be saved and printed out and delivered to their home Smile | :)

so this EPOS does not have internet access.

So that is why I am wondering how this EPOS can find the address from the postcode although there is no internet access nor address database in the PC? but this PC has Ms MaPPoint and some C# APIs.

Do you have any idea how possibly the PC can find the address? Thank you

Re: How can I include house address finder in my application?

jschell30-Dec-15 6:53

jschell

30-Dec-15 6:53

naouf10 wrote:
how this EPOS can find the address from the postcode although there is no internet access nor address database in the PC?

Simple then - it cannot.

The data must come from somewhere.

cant run my C# program after installation - only if i Run as administrator

goldsoft18-Dec-15 22:59

goldsoft

18-Dec-15 22:59

hi
cant run my C# program after installation - only if i Run as administrator.

in my setup i set the

InstallAllUsers = True

i change the app.manifest file to

<requestedExecutionLevel level="requireAdministrator" uiAccess="false" />

allso i try to remove this app.manifest file and i try to change to

requestedExecutionLevel level="asInvoker" uiAccess="false"  - and same problem

and after the install, when i try to run the program - The software is not running

only if i click on the exe file and run as administrator.

thanks

modified 19-Dec-15 6:13am.

Re: cant run my C# program after installation - only if i Run as administrator

Dave Kreskowiak19-Dec-15 4:18

Dave Kreskowiak

19-Dec-15 4:18

With the information you provided, it's impossible to tell you why your app won't run.

What does your app supposed to do? What is it actually doing? Are there any error messages?

As it stands, it sounds like you've written your application so only an administrator can run it because of something your app is doing.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Re: cant run my C# program after installation - only if i Run as administrator

Richard MacCutchan19-Dec-15 21:15

Richard MacCutchan

19-Dec-15 21:15

Did you rebuild the app with the second manifest?

Storing path of a selected Listbox File

Member 1218422117-Dec-15 11:50

Member 12184221

17-Dec-15 11:50

Hi,
I need a help

I want to store path of selected item of Listbox in a string variable .

Example:
List Box Items:
ABC
XYZ
MNF

if I select XYZ in list box ..I should be able to store its path as D:\Music\XYZ in a string ...ex: string path=D:\Music\XYZ

Thank you

Re: Storing path of a selected Listbox File

Mycroft Holmes17-Dec-15 12:07

Mycroft Holmes

17-Dec-15 12:07

string sPath = string.format("D:/Music/{0}",SelectedText);

or you can use System.IO.Path.Combine().

Never underestimate the power of human stupidity
RAH

Re: Storing path of a selected Listbox File

Member 1218422117-Dec-15 12:24

Member 12184221

17-Dec-15 12:24

Thanks For your precious comment.. but here we assumed that file root is D:/music.

What to do if the next file location is something like.. D:/Music/Old...
and some other file location like
D:Music/new

Thanks

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.