Click here to Skip to main content
12,251,352 members (51,819 online)

Comments by PIEBALDconsult (Top 200 by date)

PIEBALDconsult yesterday View
That's still not a feature of the language.
And if you post a link to a site, that will make you spammer. Don't be a spammer.
PIEBALDconsult yesterday View
History indicates otherwise. :D
PIEBALDconsult yesterday View
P.S. I trust that you are using the word "guys" in its gender-neutral sense.
PIEBALDconsult yesterday View
Languages do not have speed.
"Easy to learn" is in the eye of the beholder and often makes a language "bad" anyway -- compare BASIC with Assembly.
PIEBALDconsult yesterday View
Maybe because of:
If dtHoliday_reg.Rows.Count > 0 Then .... IIf(IsDBNull(dtEmp.Rows(0)("LeaveBal")) ... ?
PIEBALDconsult yesterday View
Never delete.
PIEBALDconsult yesterday View
Add a linefeed to printf("%2d:",i);
PIEBALDconsult yesterday View
Hmmm... that wasn't meant as a comment on your answer.
On the other hand, I do prefer to output linefeeds _before_ the text: printf("\n%2d:",i);
PIEBALDconsult 2 days ago View
Add a linefeed to printf("%2d:",i);
PIEBALDconsult 2 days ago View
Do you have an example? Please use Improve question to add context and detail.
PIEBALDconsult 3 days ago View
Which database system?
Show your SQL statement?
PIEBALDconsult 3 days ago View
Are you in an Active Directory domain? If not, I don't think you can use Integrated Security.
Other than that, ensure that the proper port is open on the "server".
PIEBALDconsult 4 days ago View
Install Office.
Or install the "Microsoft Access Database Engine 2010 Redistributable"
PIEBALDconsult 5 days ago View
It's _your_ homework; _you_ do it.
PIEBALDconsult 5 days ago View
:cough: Regular Expresions :cough:
PIEBALDconsult 29-Apr-16 0:08am View
Don't forget CP:
PIEBALDconsult 27-Apr-16 22:03pm View
Well, have you initialized the studentSubjectsArray ?
And you will likely have an easier time using Lists rather than arrays.
PIEBALDconsult 27-Apr-16 9:47am View
Move your first closing parenthesis.
And you should always include the error messages you receive.

SQL is not good at such text manipulation; you may be better off doing that outside the database; perhaps _before_ you store the values.
PIEBALDconsult 27-Apr-16 0:51am View
Please don't answer your own question.
PIEBALDconsult 27-Apr-16 0:31am View
Don't use foreach, just use indexing.
And I don't think your RegEx does what you want.
Try testing what you have:
PIEBALDconsult 19-Apr-16 21:14pm View
PIEBALDconsult 17-Apr-16 14:09pm View
My understanding is that .net has a lot of "extra" features that maybe should be avoided if one wants to support multiple engines, yes.
I don't know of an actual standard for RegEx.
PIEBALDconsult 17-Apr-16 13:52pm View
Looks OK for .net RegEx.

(?= subexpression) Zero-width positive lookahead assertion.
(?<= subexpression) Zero-width positive lookbehind assertion.
PIEBALDconsult 17-Apr-16 13:49pm View
This is not an answer; it's a question. And you really shouldn't put your email address in a public forum.
PIEBALDconsult 17-Apr-16 13:04pm View
What is the Exception? Please use "Improve question" to add context and detail.
And don't put your email address in a public forum unless you enjoy spam.
PIEBALDconsult 16-Apr-16 12:19pm View
Please don't repost. If you need to add context and detail to your existing post, you should use the "Improve question" button.

You still have not provided enough information for anyone to give you a reasonanble answer.
What is an "SQLDataSource" ?
Which data grid class are you using?
PIEBALDconsult 16-Apr-16 12:04pm View
What's an "sqldatasource" ?
PIEBALDconsult 16-Apr-16 11:51am View
What did you use as a DataSource for the grid?
If you used a DataTable, you can instantiate a new DataView on it, apply a RowFilter, and get the row count on the DataView.
PIEBALDconsult 16-Apr-16 11:48am View
Or try a for command.
PIEBALDconsult 15-Apr-16 23:04pm View
Close it when you're done with it.
PIEBALDconsult 15-Apr-16 0:42am View
No, it's not about the connection; it's about the reader.
PIEBALDconsult 15-Apr-16 0:36am View
How about:
PIEBALDconsult 15-Apr-16 0:33am View
Well you probably do. The Connection still has a reference to the one from the last time you called the method. Close the DataReader, or better yet, use a using statement for the DataReader.
PIEBALDconsult 14-Apr-16 1:31am View
I you have found, SQL is very poor at string manipulation. Doing it in C# should be better. String.Split should do what you specify above.
PIEBALDconsult 13-Apr-16 21:29pm View
Do you want the ?
Or ?
PIEBALDconsult 13-Apr-16 0:10am View
I would store the string from the Readline and then use int.TryParse afterward. Don't try to do both at once.
PIEBALDconsult 13-Apr-16 0:07am View
All that does is call int.Parse which he already says he tried.
In general, don't use Convert, when there's a more direct option.
PIEBALDconsult 12-Apr-16 17:40pm View
First, you shouldn't put data access code directly in the Form; you should have a Data Access Layer in its own class.
Typically, for WinForms, I instantiate the connection and pass it to the DAL.
Then I pass a reference to the DAL into the constructor for the Form; the Form will then hold a reference to the DAL and use it as it requires.

See also:
PIEBALDconsult 12-Apr-16 16:37pm View
There is _never_ a valid reason to implement the Singleton Pattern. And most examples (e.g. database access and logs) are bogus.
PIEBALDconsult 12-Apr-16 16:09pm View
That is a bad idea. While you may need only one connection to one database right now, you may very well need multiple connections some time down the road.
And you should _always_ open and close the connection as you use it and not leave it open for the duration of the application.
PIEBALDconsult 12-Apr-16 16:03pm View
PIEBALDconsult 11-Apr-16 23:18pm View
You may want 3 custom controls rather than forms.
PIEBALDconsult 11-Apr-16 20:58pm View
What's a Power BI?
PIEBALDconsult 10-Apr-16 22:06pm View
The Web App doesn't even know what Operating System it is running on -- it might not even be a windowing OS.
And your question smells of snoopware, so you're unlikely to get help here.
PIEBALDconsult 10-Apr-16 16:27pm View
What error do you get? Use improve question to add context and detail.
And do you really want `End Time` in both expressions in the WHERE clause? Is there no `Start Time` ?
PIEBALDconsult 9-Apr-16 19:40pm View
if (randomnumberone = userdigitone)

Sure you want to assign rather than test for equality?
PIEBALDconsult 7-Apr-16 10:11am View
Dates should _never_ be stored as strings in databases. Please check the datatype.
PIEBALDconsult 7-Apr-16 9:57am View
Yes, as Solution 1 states.
PIEBALDconsult 7-Apr-16 9:56am View
Please don't do that.
PIEBALDconsult 7-Apr-16 1:17am View
Do you own homework.
PIEBALDconsult 7-Apr-16 1:17am View
Do your own homework.
PIEBALDconsult 5-Apr-16 19:16pm View
Can you provide the code for AddtoCustomer ?
PIEBALDconsult 5-Apr-16 0:01am View
There is no difference.
PIEBALDconsult 4-Apr-16 1:28am View
There is no reason for you to use the same language, but it won't matter anyway, as you are unlikely to achieve the goal within a lifetime.
PIEBALDconsult 2-Apr-16 13:40pm View
Instance Constructors (C# Programming Guide)
PIEBALDconsult 2-Apr-16 12:46pm View
Glad to be of service.
PIEBALDconsult 2-Apr-16 12:40pm View
You wrote "bit of them a multidimensional array of floats".
PIEBALDconsult 2-Apr-16 12:32pm View
Do you mean "both" of them?
PIEBALDconsult 2-Apr-16 12:23pm View
Go back and read the Book.
PIEBALDconsult 2-Apr-16 12:16pm View
I suspect you're doing something wrong. It sounds like you just want modeless Forms.
And, without knowing any more about your situation, I would think that someform.Focus() should do the trick.
PIEBALDconsult 2-Apr-16 0:05am View
PIEBALDconsult 31-Mar-16 22:18pm View
Maybe Office 365 doesn't install ACE? If so, you can download it separately.
PIEBALDconsult 31-Mar-16 0:25am View
That's a language; not a system.
PIEBALDconsult 30-Mar-16 23:06pm View
It must still be running. Kill it and try again.
PIEBALDconsult 30-Mar-16 23:05pm View
Which database system?
PIEBALDconsult 30-Mar-16 22:20pm View
And that was from Bing.
PIEBALDconsult 28-Mar-16 19:19pm View
Which is what I do anyway.
PIEBALDconsult 28-Mar-16 10:04am View
Limited datatypes.
Not scalable to many users.
PIEBALDconsult 28-Mar-16 1:11am View
Just because it works on the command line doesn't mean it will work in a batch file.
PIEBALDconsult 28-Mar-16 0:15am View
The commands you list don't make much sense. Are those the actual commands?
And I suspect you need to put quotes around the first one because of the SPACEs in it.
PIEBALDconsult 27-Mar-16 13:02pm View
Sure, but is not a VB sub(routine) equivalent to a void method in C# ?
PIEBALDconsult 26-Mar-16 13:12pm View
The only advice I can give to ensure you always put on the proper cover sheet.
PIEBALDconsult 23-Mar-16 20:04pm View
Never had good luck with linked servers.
PIEBALDconsult 23-Mar-16 1:41am View
In your implementation 1, I trust you are using parameters?
In your implementation 2, just how are implementing "Pushing all records at once in DB"?
And if you are using SQL Server, have you considered using a table-valued-parameter?
PIEBALDconsult 19-Mar-16 12:56pm View
I doubt you want the customers to see the addresses of the other customers, so be sure to use Blind Copy or send separate emails.
PIEBALDconsult 18-Mar-16 22:25pm View
Well, what do _you_ think?
Also look into the Shunting Yard Algorithm.
PIEBALDconsult 16-Mar-16 0:45am View
Ahem, second warning. Posting links as answers to ancient questions smells of spam; please don't do that.
PIEBALDconsult 16-Mar-16 0:13am View
Posting links as answers to ancient questions smells of spam; please don't do that.
PIEBALDconsult 15-Mar-16 20:38pm View
What's an MLP?
PIEBALDconsult 15-Mar-16 19:47pm View
"I think it will be too hard for me to migrate my database structure + content to a new database type"
I doubt that would be an issue.

Certainly I recommend Express, but if you want to stick with CE you might want to put it behind a Web Service to avoid access conflicts and security issues.
PIEBALDconsult 13-Mar-16 23:10pm View
Oh. Never heard of it.
PIEBALDconsult 13-Mar-16 22:12pm View
Which database system?
PIEBALDconsult 13-Mar-16 16:31pm View
Usually by not using foreach.
About all I can recommend is to not search for the table each time -- make a local variable to hold a reference to ds.Tables["FACT"] and use that.
You may also want to use column ordinals as well -- rather than column names.
PIEBALDconsult 13-Mar-16 14:49pm View
What's an LCS?
PIEBALDconsult 13-Mar-16 13:22pm View
PIEBALDconsult 12-Mar-16 17:47pm View
No. Int or nothing.
PIEBALDconsult 12-Mar-16 14:23pm View
OK, so it looks like it's a non-conforming compiler, how odd. Change the return type to int or use a better compiler.
PIEBALDconsult 12-Mar-16 13:57pm View
What compiler? What error do you get?
Please use Improve question to add context and detail.
PIEBALDconsult 12-Mar-16 13:31pm View
There are plenty of ETL packages out there. If you have SQL Server, you have SSIS.
PIEBALDconsult 11-Mar-16 19:39pm View
I use Regular Expressions a lot as well, but it doesn't seem like the right tool for splitting CSV.
PIEBALDconsult 10-Mar-16 23:55pm View
No, but maybe you want a Factory?
PIEBALDconsult 10-Mar-16 11:07am View
0) Don't use Split; Split is hardly ever the correct tool; it is too simplistic. You need something more robust, such as
1) sr.ReadLine().Split -- won't that throw a null reference exception when you reach the end of the file?
PIEBALDconsult 1-Mar-16 21:39pm View
I'd like to help, but SSIS is just too visual. Hard to debug. I get a lot of strange errors, but I just run the job again.
PIEBALDconsult 1-Mar-16 8:35am View
You should educate your user.
PIEBALDconsult 29-Feb-16 23:08pm View
PIEBALDconsult 29-Feb-16 14:03pm View
How about a tool that converts HTML to XHTML?

Some examples of prior art to give an idea of the scope of the task:
PIEBALDconsult 29-Feb-16 11:20am View
That's not three-tier; those are layers, there's a difference.
You would have to Improve Question to include some code, whatever problem you're having isn't clear.
PIEBALDconsult 29-Feb-16 11:17am View
I don't often use stored procedures, but I haven't any trouble with them in SSIS.
On the other hand, I _have_ had trouble with queries that involve multiple JOINs (as you have).
What I wound up doing was to have a number of Common Table Expressions, each performing one JOIN -- this sped things up quite a bit.
PIEBALDconsult 29-Feb-16 11:02am View
A European Binary Search Tree or an African Binary Search Tree?
PIEBALDconsult 29-Feb-16 9:11am View
That description does not comply with the ISO definition for the week of the year;
A week that runs "28thDec2015 - 3rdJan2016" would be the last week of the previous year.
I suggest you rethink.
PIEBALDconsult 29-Feb-16 9:08am View
That's not how to use a Dictionary. You'll want a different structure if you need to do that a lot.
PIEBALDconsult 29-Feb-16 9:04am View
The solution is within you; it is not "out there" to be found.
PIEBALDconsult 28-Feb-16 13:37pm View
You don't; that's already built into .net -- now go find it.
PIEBALDconsult 28-Feb-16 11:38am View
That's because there's nothing to explain; you may be over-thinking the situation -- "I'm assuming is first inner and outer loop will execute" -- makes it sound like you haven't full grasped the fundamentals of these flow control statements. Probably because you haven't been paying attention.

The best advice I can give is that when trying to do homework, it is best not to try to download someone else's bad code and then try to understand it -- doing such will cripple you. Please start fresh and do it yourself. It is not a difficult task; doing it yourself will likely prove easier than trying to understand that crap you pasted and you will be better for it.
PIEBALDconsult 25-Feb-16 1:08am View
IP addresses are not physical, and a device may have more than one.
And, when using VMware, the VM may move between hosts frequently, so I see no use for knowing the address of any particular host.
PIEBALDconsult 25-Feb-16 1:05am View
It's just a buzzword for a set of tools.
PIEBALDconsult 24-Feb-16 8:43am View
It's _your_ homework; _you_ do it.
PIEBALDconsult 23-Feb-16 23:42pm View
Are you _sure_ it's on that statement?
PIEBALDconsult 23-Feb-16 23:33pm View
Turn it off and back on again?
PIEBALDconsult 21-Feb-16 23:57pm View
Which database system?
PIEBALDconsult 21-Feb-16 13:10pm View
It is not.
The argument that a macro is not a function while a function can't not be a function is meaningless.
Bear in mind also that a simple function may get inlined by a modern compiler. A snippet of code that is too complex to inline should probably not be made into a macro.
PIEBALDconsult 18-Feb-16 23:30pm View
Do not post that as an answer. Use "Improve question" to add it to your question.
PIEBALDconsult 17-Feb-16 19:31pm View
Posting links as answers to ancient questions is frowned upon as it looks like spam. Please don't do that.
PIEBALDconsult 17-Feb-16 15:11pm View
Learn thee XPATH
PIEBALDconsult 16-Feb-16 0:27am View
PIEBALDconsult 15-Feb-16 11:12am View
As I said, "use the debugger".
PIEBALDconsult 15-Feb-16 11:07am View
Use the debugger to see what the actual value of ((LinkButton)sender).CommandArgument is. It probably isn't what you expect.
PIEBALDconsult 15-Feb-16 10:36am View
Please just use "Improve question" to add that detail to the question; it is not an answer.
PIEBALDconsult 15-Feb-16 0:05am View
Posting answers to ancient questions is a suspicious activity, particularly when the entire answer is links to other sites. Please refrain from doing that.
PIEBALDconsult 14-Feb-16 12:01pm View
Actaully, X+-5 still makes sense.
PIEBALDconsult 13-Feb-16 21:29pm View
This is why beginners should _not_ be thrown into GUI development before they've even begun to learn the fundamentals.
PIEBALDconsult 11-Feb-16 19:03pm View
"integrated Security=true"
Do you have a domain controller that allows that?
PIEBALDconsult 11-Feb-16 15:15pm View
Seek thee DATEPART.

And I have never seen anything as monstrous as that other part.
PIEBALDconsult 10-Feb-16 21:00pm View
My first thought is that the device is likely expecting 8-bit characters, whereas .net generally uses 16-bit characters. If that's the problem, I'm unsure how to work around it. But look into the to see whether or not it helps.
PIEBALDconsult 9-Feb-16 8:09am View
I suspect you want to JOIN data from the tables.
PIEBALDconsult 9-Feb-16 8:08am View
"i change some line in dll files"
That makes no sense. Do you actually mean the code? Or the DLL that results from compiling it?
Even the DLL _can_ be edited in certain ways and there's nothing you can do about it. Don't spend your time worrying about such things.
PIEBALDconsult 8-Feb-16 23:16pm View
How about Withdraw(-800) ?

Very poorly-written code.
PIEBALDconsult 8-Feb-16 21:09pm View
Easier tends to be better. Always seek a way you can just use a simple SQL statement rather than use a cursor and/or fetch the data to the client and back.
PIEBALDconsult 8-Feb-16 19:35pm View
Why not just UPDATE expired=true WHERE Created_Date < seven days ago?
PIEBALDconsult 8-Feb-16 15:03pm View
PIEBALDconsult 7-Feb-16 23:53pm View
One does not simply connect two PCs via a network cable. Is there a switch between them? Or just a cable? If the latter, it has to be a different type of cable.
PIEBALDconsult 7-Feb-16 23:50pm View
Be sure the appropriate port is open on the server.
PIEBALDconsult 7-Feb-16 22:27pm View
You probably mean three _tier_ architecture. Look it up.
PIEBALDconsult 7-Feb-16 10:18am View
I suspect it's due to the apostrophes around '@pictureBox6' I suggest you remove them.
You need to learn to use parameters, every time, especially when using data from users.
PIEBALDconsult 7-Feb-16 0:23am View
That looks OK; are you sure that the data exists?
PIEBALDconsult 6-Feb-16 23:10pm View
I suspect the problem is:

ref default(System.Nullable)
PIEBALDconsult 6-Feb-16 22:58pm View
The best revenge is living well. One day at a time.
PIEBALDconsult 6-Feb-16 16:06pm View
Maybe try a Dictionary?
PIEBALDconsult 6-Feb-16 8:20am View
There is no S in OOP.
PIEBALDconsult 6-Feb-16 1:41am View
No, it's not impossible; there are several companies out there doing it. But they have forty years or more of a head-start on you. They have hundreds of highly-skilled engineers working on it, and still things get through.
Are you thinking you can develop even a very simple and unreliable anti-virus in a week? A month? A year?
It's simply not worth the effort; you'll only wind up delaying your product and still wind up installing some available product when you eventually give up.
How much time are you willing to waste before that occurs?
What does your customer want? Are they willing to risk their systems running an unknown anti-virus? Are you willing to be sued when a customer's systems go kablooie?
PIEBALDconsult 6-Feb-16 1:00am View
Anti-virus is very difficult; you (and I) are not capable of doing even as well as the worst product out there. Pick one and install it; don't waste your time.
PIEBALDconsult 6-Feb-16 0:57am View
Yeah, what Sergey said.
So if you _do_ do that, be sure that the block times out after some period of time.
You could keep a database table of suspect addresses and the date/time that they last became blocked.
PIEBALDconsult 5-Feb-16 21:40pm View
PIEBALDconsult 5-Feb-16 18:17pm View
"Would be great to have some debate"

This is not the forum for that. Try
PIEBALDconsult 4-Feb-16 23:11pm View
Do not _ever_ use IN or NOT IN with a subquery; convert it to a JOIN of some sort. Same for EXISTS.
PIEBALDconsult 4-Feb-16 17:52pm View
"i should create classes for each table,that have some method to modify database like update-delete-Insert-select"

I disagree; please don't do that.
PIEBALDconsult 4-Feb-16 8:03am View
You may not have provided enough information.
Are you filling a DataTable from the file?
And then providing the DataTable to the DataGridView as the DataSource?
If so, maybe you need to call DataTable.AcceptChanges after loading it, but before passing it to the DataGridView.
PIEBALDconsult 3-Feb-16 20:51pm View
I suspect you are making things very difficult for yourself. What are you actually trying to accomplish. Forget the "how", focus on the "what". And then improve your question.
PIEBALDconsult 3-Feb-16 0:47am View
Provided you use, you never need to install anything else on the client.
The server has to have the server installed, there's no way around that.
You might want SQL Server Compact instead, but you still need to install it.
PIEBALDconsult 3-Feb-16 0:35am View
PIEBALDconsult 2-Feb-16 14:06pm View
We can't decide that for you.
PIEBALDconsult 2-Feb-16 14:05pm View
We will not do your homework.
PIEBALDconsult 2-Feb-16 11:50am View
That depends entirely on your development environment and we have no way of knowing that without you telling us.
PIEBALDconsult 1-Feb-16 23:39pm View
You will likely need to make more than one call. But you can also encapsulate it in a method to hide those details.
PIEBALDconsult 1-Feb-16 23:37pm View
My first guess is that the project type is actually set to Console Application rather than Windows Application. Check that first.
PIEBALDconsult 1-Feb-16 22:19pm View
How about DELETE FROM table WHERE employeeID=1001 AND ColumnX IS NULL ?
PIEBALDconsult 31-Jan-16 20:32pm View
So what if they're not needed; he shouldn't remove them.
If your team has a coding/style standard, then you should follow it, if the standard is not to put in the parentheses (which is very likely) then you should _not_ put them in in the first place; and if you do, then _you_ should remove them, not your teammates.
If you accepted a job writing VB (as I did once), then dummy up and write VB, not C#!
And VB does not lend itself to "writing less code".
PIEBALDconsult 31-Jan-16 14:45pm View
Gee, wouldn't a database offer a significant benefit here?
PIEBALDconsult 31-Jan-16 14:00pm View
Whether or not it is or does has no meaning -- as a student, because you are unknown and have nothing of value to begin with, you can't just say "I'm going to create a honey pot". Only a known enterprise, like a large bank or retailer, can make a honey pot.
PIEBALDconsult 31-Jan-16 13:49pm View

PIEBALDconsult 31-Jan-16 12:28pm View
How about a Script Task?
PIEBALDconsult 31-Jan-16 10:59am View
PIEBALDconsult 31-Jan-16 10:58am View
All and none.
PIEBALDconsult 31-Jan-16 10:57am View
Of those, XML is the quickest to learn and it's used for _everything_.
PIEBALDconsult 31-Jan-16 10:29am View
Perhaps you could show a small amount of sample data and what value you want to calculate.
PIEBALDconsult 31-Jan-16 10:19am View
That's the "how"; I want to know the "what".
PIEBALDconsult 30-Jan-16 15:07pm View
"you have to change your database-table-column"
Or use ISNULL (or similar) in the SELECT statement.
PIEBALDconsult 30-Jan-16 12:33pm View
Always create the file with the same name, then rename it.
PIEBALDconsult 30-Jan-16 11:34am View
Yes, you can create Controls and add them to a Form dynamically. Had you simply _tried_ that instead of coming here and asking, you'd already have it done now.
Controls are _not_ variables.
PIEBALDconsult 30-Jan-16 11:04am View
No. Variables can't be declared dynamically in languages such as VB. But you could use a Dictionary or an array or something.
What are you trying to do?
PIEBALDconsult 29-Jan-16 23:26pm View
"It is equivalent to this:"

Except for that the former allows for more precise placement of breakpoints.
PIEBALDconsult 29-Jan-16 23:21pm View
Take it to Bugs&Sugs.
PIEBALDconsult 28-Jan-16 21:10pm View
There's no such thing as "too many".
PIEBALDconsult 28-Jan-16 0:32am View
Fire whoever wrote that; it's dreadful. The only statement that makes any sense is the first one; the rest are ridiculous.
What are you trying to accomplish?
A few simple rules:
0) Don't ever use Convert
1) Dates as strings are to be used only for display, or writing to text files
1.1) If writing a date to a stream, use an ISO 8601 format; e.g. YYYY-MM-DD HH:MM:SS
2) Otherwise keep dates in properly-typed variables, such as DateTime
2.2) Do all calculations and comparisons in DateTimes
3) I repeat; don't ever use Convert
PIEBALDconsult 26-Jan-16 19:16pm View
For what you describe, I prefer not to sort, but to insert in a sorted manner.
To insert a value, start at the "end" and shift the existing values down until you reach the correct spot, then just insert. Done.
PIEBALDconsult 26-Jan-16 18:28pm View
That is not a good idea! I don't care who else is doing it; it's BAD!
PIEBALDconsult 26-Jan-16 0:05am View
That's not your job. The customer will decide how and where to download and install SQL Server and any other things your application requires.
The customer may already have a suitable server set up. Also, someone may download your app today, but not install it until after the next version of SQL Server is available.
All you can do is specify that your app requires SQL Server, perhaps with a minimum version level. You do not try to install it.
PIEBALDconsult 25-Jan-16 19:29pm View
PIEBALDconsult 25-Jan-16 16:35pm View
Everyone should speak more precisely. "SQL" does not mean any individual product. When I learned SQL, we had only Oracle and DBase available.
PIEBALDconsult 25-Jan-16 16:30pm View
MySQL is one of many implementations of the SQL standard. :D
PIEBALDconsult 25-Jan-16 15:50pm View
Have you populated OUTLET?
PIEBALDconsult 25-Jan-16 12:06pm View
In a stack maybe?
PIEBALDconsult 25-Jan-16 10:33am View
This one?
PIEBALDconsult 25-Jan-16 10:24am View
But the method should have a constraint on the generic type, and the constraint should probably specify an Interface, at which point this seems to have little benefit over solution 1. Still good, of course, and maybe necessary in some cases.
PIEBALDconsult 24-Jan-16 20:58pm View
Well, get on it, time's a-wastin'.
PIEBALDconsult 24-Jan-16 20:55pm View
What you have seems OK, so it's unclear what problem you are having. Please use Improve question to add more details about the problem.
PIEBALDconsult 24-Jan-16 20:51pm View
Dictionary?! Array!
PIEBALDconsult 24-Jan-16 14:33pm View
You should probably be using OleDb classes.
PIEBALDconsult 24-Jan-16 11:05am View
Of course, but you'll need towrite some code.
PIEBALDconsult 23-Jan-16 22:03pm View
Both are correct. And the feedback you received on your earlier question is correct.
PIEBALDconsult 23-Jan-16 22:02pm View
Ah, I see now this is a repost.
PIEBALDconsult 23-Jan-16 15:25pm View
We can't help you unless you help yourself. We can't answer your questions unless you answers ours.
PIEBALDconsult 23-Jan-16 14:49pm View
No reason to vote at all.
PIEBALDconsult 23-Jan-16 14:38pm View
That's the wrong direction.
PIEBALDconsult 23-Jan-16 14:26pm View
As I said: "ASCII"
PIEBALDconsult 23-Jan-16 14:13pm View
Once the data is in the DataGridView it's too late -- you need to assign the values _before_ that.
Is or is not the data stored in a database?
PIEBALDconsult 23-Jan-16 12:02pm View
I assume so, though I could never understand Oracle's join syntax.
PIEBALDconsult 23-Jan-16 11:58am View
Yes, I know, but you don't provide enough information to allow us to provide much assistance and we're unlikely to write code for you even if you do.
PIEBALDconsult 23-Jan-16 11:56am View
PIEBALDconsult 23-Jan-16 11:12am View
I'd have to see some data and results.
Not that it will help, but I do wonder why you use a CREATE TABLE followed by an INSERT SELECT rather than a SELECT INTO.

Advertise | Privacy | Mobile
Web01 | 2.8.160426.1 | Last Updated 1 Jan 1900
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid