16,004,587 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Ekona_Pikin (Top 75 by date)
Ekona_Pikin
7-May-15 18:04pm
View
tried thta @Julia ,to no avail:(
Thanks
Ekona_Pikin
7-May-15 18:04pm
View
@Ryan sorry fi I did not reply on time,what can I do?I am creating that particular Column Cells[7] on the fly
Ekona_Pikin
7-May-15 14:22pm
View
@gggusfson,I get this error=> "Object reference not set to an instance of an object."and I get break on ==> if (row.Cells[7].Value.ToString() == slim[0])
Ekona_Pikin
15-Apr-15 11:12am
View
Thanks Richy
Ekona_Pikin
15-Apr-15 11:12am
View
great appreciate it SA.
Ekona_Pikin
7-Apr-15 5:22am
View
Hi @ Sinisa some of the columns are created dynamically especially the one I want colors display if cells value is 'BAD or 'GOOD' i,e column[7]
Ekona_Pikin
5-Apr-15 13:54pm
View
So you are trying to create Dataset dynamically and passing to ReportViewer?
Ekona_Pikin
4-Apr-15 11:26am
View
Great, glad is working for you too.
Ekona_Pikin
4-Apr-15 11:10am
View
Yea goto to toolbox and grab dateTimePicker1, click on it and paste the method you would be using to connect to your database and what ever you want to do including your select statement as seen in mine,Note if you are using access DB instead of '{0:}'<== use #{0}# and you should be set.
Ekona_Pikin
4-Apr-15 6:52am
View
Thanks you rock sir George, c# is fun again:))did what you said what happens is i kept using an HH instead of hh and reversed dt.String() nice touch sir I learned through this appreciative Happy weekend
Ekona_Pikin
4-Apr-15 5:36am
View
Deleted
OK
Ekona_Pikin
4-Apr-15 3:01am
View
Hi@ George I did something like this and some data pulled in,but not filtering quite right ==> (WHERE DateColum1 = #{0:MM/dd/yy mm:ss}# AND DateColum2 #{0:MM/dd/yy mm:ss}#" , dt.ToString());
Ekona_Pikin
4-Apr-15 2:18am
View
hi @George I still just get column headers with no data, Note in the Access DB DateColumn field is stored in this format ==> MM/dd/yyyy mm:ss
Ekona_Pikin
2-Apr-15 10:51am
View
Hey Marciej,just so you know It did worked now when ever I used Group By clause So thanks again:))
Ekona_Pikin
2-Apr-15 7:06am
View
Deleted
Thats right thanks marciej, AVG() along with other functions like SUM() are all reserved words in access,but I have even tried AVG(Expresion) Group By (primary key) for instance to no avail it appears using AGGREGATE fucx from c#=>Access has some isues.
Ekona_Pikin
2-Apr-15 6:22am
View
Hi Phil, I got that comma though that was a typo from me ,In my app is without the comma you pointed out ,I still get this bisare error"The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect."
Ekona_Pikin
1-Apr-15 9:39am
View
A Coding Guru amongst us everyday learners thanks sir Maciej:))
Ekona_Pikin
31-Mar-15 15:36pm
View
what are you trying to achieve ?
Ekona_Pikin
30-Mar-15 11:38am
View
Hello Mark sorry I did not test ,but just did now and is on point too sorry sir :))
Ekona_Pikin
30-Mar-15 11:34am
View
Deleted
hi Richy , I accepted ur solution and gave it 5 star
Ekona_Pikin
30-Mar-15 10:51am
View
Thanks for all your help anyone who posted or try solve this problem I have tested both solution 2 and 3 and they are all on point :)) So for future reference The authors of both solutions 2 and 3 are RIGHT.
Ekona_Pikin
30-Mar-15 10:42am
View
Thanks Maciej:))
Ekona_Pikin
30-Mar-15 10:42am
View
Thanks Richy:))
Ekona_Pikin
30-Mar-15 10:35am
View
Maciej, what about the other conditions?
Ekona_Pikin
30-Mar-15 10:12am
View
Deleted
Yea thanks @ Mark I have changed to to And ,but am still getting missing Operand
Ekona_Pikin
28-Mar-15 6:12am
View
Thanks@ Member11428137:)
Ekona_Pikin
27-Mar-15 22:31pm
View
I ve tried @Tadit thats why am here to see if I could get some help
Ekona_Pikin
20-Mar-15 23:41pm
View
Deleted
where do suggest i use given my code @ChrisCrateBoss?
Ekona_Pikin
20-Mar-15 15:10pm
View
good idea:))
Ekona_Pikin
20-Mar-15 14:41pm
View
UPDATE, I got it to work kinda weird now only if I click on the column cell and it has to be manual typed any suggestions?
Ekona_Pikin
20-Mar-15 13:49pm
View
@ Manchanx thanks for your guidance all the way, could not get this program to work properly.
Ekona_Pikin
20-Mar-15 11:45am
View
I guess something is wrong with code then
Ekona_Pikin
20-Mar-15 11:34am
View
I have no idea, @manchanx
Ekona_Pikin
20-Mar-15 11:29am
View
is wrong?
Ekona_Pikin
20-Mar-15 11:24am
View
yes method gets hit ,but that line did not
Ekona_Pikin
20-Mar-15 11:14am
View
Yes is definitely not hittiing it
Ekona_Pikin
20-Mar-15 11:02am
View
The three created columns are still empty, just data from the DB are seen.
Ekona_Pikin
20-Mar-15 10:46am
View
Yes the hit was positive
Ekona_Pikin
20-Mar-15 10:45am
View
Deleted
Yes it hit it now
Ekona_Pikin
20-Mar-15 10:32am
View
Nothing, I hover my mouse aroung only saw cellContentClick
Ekona_Pikin
20-Mar-15 10:20am
View
what can I do now?
Ekona_Pikin
20-Mar-15 10:16am
View
Oh yes I did what you said,but there was no halt or break
I did exactly as you instructed.
Ekona_Pikin
20-Mar-15 10:11am
View
I thought you meant , if I gave up?
Ekona_Pikin
20-Mar-15 10:08am
View
I have actually just a wrote a queryy that performs all the calculation by creating anew table but then I can call that table instead from my app, but isues when change is made in orginal table is not automatically updated into the new query=> changed to table so am just not having any good leads
Ekona_Pikin
20-Mar-15 10:06am
View
No Manchanx, still working on it no lead:(
Ekona_Pikin
20-Mar-15 8:54am
View
runs fine on debug mode ,no isuues
Ekona_Pikin
20-Mar-15 8:41am
View
Deleted
pls how do I implement that ?
Ekona_Pikin
20-Mar-15 8:16am
View
could you demonstrate for me how Joan
Ekona_Pikin
20-Mar-15 8:15am
View
yes data from access DB shows
Ekona_Pikin
20-Mar-15 7:59am
View
I dont knoiw for sure Joan ,my database is Access, would that be acceptable?
Ekona_Pikin
20-Mar-15 7:56am
View
nithing just happen I dont know why manchanx
Ekona_Pikin
16-Mar-15 13:40pm
View
Deleted
The other app is a scanning application it scans units to be built.Some of these units have problems like a standard unit weighs could be TR345BN-BB and its Target weight might be 135lbs ,but if otherwise I want to be able to check before sending it down to the next process, my application will go in take data already scanned does some calculation and it will be up to the person doing the count to make decision based on what ever deliverable the program has accomplished.
Ekona_Pikin
16-Mar-15 13:17pm
View
I would have Two [Buttons and a RichTextBox], one to connect to the Access_DB and another to perform some calculations based on what it pulled from the Database.
Ekona_Pikin
16-Mar-15 12:55pm
View
Yes there is another app that adds data to the Access DB and mine wants to access the Data and display results with calculations.
Ekona_Pikin
16-Mar-15 12:20pm
View
Access has been used as the DB in this case ,I was wondering if I could use c# to automate the process of pulling from the Access DB every so and so minutes and perform some calculations form and dump the results in an excel file, I have built this application, but the user would have to perform some click_events on WinForm.
Ekona_Pikin
16-Mar-15 12:14pm
View
Thanks SA, this just a standloen c# App would it possible to do something like this
with Acess DB?
Ekona_Pikin
16-Mar-15 12:13pm
View
Thanks OriginaGriff, but this is just a stand alone c# Application and the database is Access is it possible my boss is on my neck, just want to see if there is better way I could just change to as suggested.
Ekona_Pikin
11-Mar-15 15:21pm
View
Awesome Richy:)
Ekona_Pikin
6-Mar-15 15:12pm
View
Hey thanks OriginalGriff,but I used the solution above it was just what I wanted
Ekona_Pikin
6-Mar-15 15:09pm
View
WORKED LIKE CHARM ,man you are awesome thank you very much God bless you man.
Ekona_Pikin
6-Mar-15 14:38pm
View
Deleted
Hi Ramza360 what method do you suggests sir?
Ekona_Pikin
4-Mar-15 19:13pm
View
It just prints randomly
some times it start in the middle, bottom and top,
I want it to have an order either from bottom to top or top to bottom
Ekona_Pikin
4-Mar-15 18:58pm
View
Deleted
Hi Chris find below is my code I just want that everytime I populate the listbox
it should perform task according to the way the occure
for instance
from top to bottom CIS402.pdf, CIS330.pdf, CIS411.pdf,CIS244.pdf, all these are files that I want to print but I want them to print from top to bottom starting from CIS402.pdf
This my code so far
Ekona_Pikin
4-Mar-15 18:16pm
View
Deleted
sorry SA ,I just meant if on the listbox the first Item was re45.pdf, and second item re55.pdf, it should print the them respectively with re45.pdf first and re55.pdf second
Ekona_Pikin
4-Mar-15 10:15am
View
Deleted
Hi Ramza360 I'm back everuthing is working like charm only I have been notified there are some lil issues. For items on the listbox could be ==>PRINTERONE.pdf,printtwo.pdf,printthree.pdf is there a way for me to make it print in that order? and not just printing randomly?
Ekona_Pikin
21-Feb-15 13:15pm
View
Hey Ramza, I reduced the System.Threading.Thread.Sleep(3000);==>(1000)
and my printer sees it now:))
I will test it well Monday at work ,I really appreciate all your support.
Thanks again
Ekona_Pikin
21-Feb-15 12:31pm
View
ok thanks alot
Ekona_Pikin
21-Feb-15 10:58am
View
Deleted
it goes to c:\\slimyyyy(folder) grabs files that in listbox say LE4506.pdf and opens and close...very fast..
Thats how I have it
private void PrintDocument(string path)
{
ProcessStartInfo info = new ProcessStartInfo();
info.Verb = "print";
info.FileName = path;
info.CreateNoWindow = true;
info.WindowStyle = ProcessWindowStyle.Hidden;
Process p = new Process();
p.StartInfo = info;
p.Start();
p.WaitForInputIdle();
System.Threading.Thread.Sleep(10000);
if (!p.CloseMainWindow())
{
p.Kill();
}
}
private void btn_PrintMacro_Click(object sender, EventArgs e)
{
string dir = @"C:\slimyyyy";
if (Directory.Exists(dir))
{
string[] files = Directory.GetFiles(dir);
if (files.Length > 0)
{
foreach (string file in files)
{
string fileName = Path.GetFileName(file);
foreach (object item in listBox1.Items)
{
if (fileName == item.ToString())
{
PrintDocument(Path.GetFullPath(file));
// MessageBox.Show("Print job is queued now just and relax:)))");
}
}
}
}
}
}
Ekona_Pikin
21-Feb-15 10:43am
View
ok
Ekona_Pikin
21-Feb-15 10:38am
View
so can I change it to like maybe 10,0000?
Ekona_Pikin
21-Feb-15 10:21am
View
Hi Ramza, please sorry I dont know if am missing something
everything seems to work well but when I go to my printer there is no printed stuff..
Ekona_Pikin
20-Feb-15 19:07pm
View
Awesome I am changing right now , you are a savior Ramza, thanks a bunch for all the help.
Ekona_Pikin
20-Feb-15 18:07pm
View
Hi Ramza360,you are awesome, there is an issue I have implemented your code
but I adobe just try to open a nd closes back right off. I dont know why
and also I dont want to select an item each time before brows a folder .
I dont knoiw if there would be an easier way to just make a click_Event
whereby all items in the are scanned and /or compared with that of selected folder in this case c:\\slimyyyy ,an if an item in the listbox say re4506ly.pdf exist in slimyy ==> send to the default printer..for printing.
Thanks you very much.
Ekona_Pikin
20-Feb-15 13:12pm
View
Deleted
Hi, Ramza360 thanks for your code , I want to be able to do this on a button_click though.
But I am trying your code right now and will update the community asap of the results.
Ekona_Pikin
20-Feb-15 8:35am
View
Yes Ryan the goal is to look at items in in the listBox which could be RE4507S.pdf and if this item exist in "c:\\slimyyy" send it to the default printer.
Show More