Comments by Member 12349103 (Top 91 by date)

Richard
your String.Format code above works great I will mark as solved.
My generic error was due to a date format in the string 6/8/2021.
I got to work on that.
Thanks for the tip

Richard
I am getting that error when trying to create the file this is the code.
error on this line.
bmpScreenshot.Save(myFilepath, ImageFormat.Png);

Thank you

#region Save Image

            string MyDesktopPath = Environment.GetFolderPath(
            System.Environment.SpecialFolder.DesktopDirectory) + "\\";

           // this.Size = new Size((int)(8.5 * 96f), (int)(11 * 96f));

            using (Bitmap bmpScreenshot = new Bitmap(Bounds.Width, Bounds.Height, PixelFormat.Format32bppArgb))
            {
                bmpScreenshot.SetResolution(128f, 128f);
                Rectangle rect = new Rectangle(0, 0, this.Bounds.Width, this.Bounds.Height);
                this.DrawToBitmap(bmpScreenshot, rect);

                // Build the filename
                string myFilepath = Path.Combine(MyDesktopPath, string.Format("{0} {1} {2}.png", txt_CHKR.Text, txt_PN.Text, label67.Text));
                if (myFilepath == "")
                {
                    Console.WriteLine("Form image save FAILED!");
                    return;
                }
                bmpScreenshot.Save(myFilepath, ImageFormat.Png);
                Console.WriteLine("Form image saved: {0}", myFilepath);
            }

            Convert();
            #endregion

wendelius

how can I save the subject line as the Image name?

works great

Dave
typo I tried mailItem.Subject = txt_CHKR.Text; txt_PN.Text; // Need Help here

Wow did not know that
Thanks for the info

Wendelius
I need to delete the table daily it will have over 10000 row, so after 100 days I would be in the million on Auto increment. How would I use the above statement in a Button Click?

You are correct BillWoodruff.
Thanks works great.

That sill lets them do as will, say No it still saves

I just want them to look at what they entered again, The above code if they select no it stills saves to the database.

This is what worked.
OleDbDataAdapter theDataAdapter =
new OleDbDataAdapter("SELECT [ID], FORMAT([Production_Date], 'M/d/yyyy') as [Production_Date],[Part_Number],[Cart],[Qty],[Process],[Model],[User] FROM [Sheet1$]", theConnection);

this is working for me, but way are the 3 times show in the label?

do you have an example

Ralf If the user does nothing the form still stays open

That's what I cant figure out.

I have added my Save button when i enter text in the textbox and dont select the Datetime picker it saves the date.

string txtQuery = "insert into Roster (Tech_Role, Employee, Picture, Employee_Number, Shift, Zone, Supervisor, On_Board_Date_into_Material_Handling,"
+ "Basic_Skills, TCAT_Certifaction, Basic_Skills_Fork_Pass, Basic_Skills_Tug_Pass, Regional_Training, Job_Observation_Training, " +
"Advance_Training, Previous_Safety_Training," + "Current_Safety_Training, MH_Employee_Active )values('"
+ cb_Role.Text + "', '" + tb_Name.Text + "', '" + pictureBox1.Text + "' ,'"
+ tb_Employee_Number.Text + "', '" + cb_Shift.Text + "', '" + tb_Zone.Text + "', '"
+ tb_Supervisor.Text + "','" + dateTimePicker1.Text + "','" + dateTimePicker7.Text +
"','" + cb_TCAT.Text + "','" + cb_Fork.Text + "','" + cb_Tug.Text + "','"
+ dateTimePicker2.Text + "','" + dateTimePicker3.Text + "','" + dateTimePicker4.Text + "'" +
",'" + dateTimePicker5.Text + "','" + dateTimePicker6.Text + "','" + cb_Active.Text + "')";

This worked for the populating the combobox with the exception of after I save the combobox is blank, I cant select a different one for the next entry.

protected void FillCombobox()
{
sql_con = new SQLiteConnection
("Data Source=GameDay.db;Version=3;new=False;Compress=True;");

SetConnection();
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
string CommandText = "select * from Teams";
DB = new SQLiteDataAdapter(CommandText, sql_con);
DS.Reset();
DB.Fill(DS);
DT = DS.Tables[0];
cb_Home.DisplayMember = "Team_Names";
cb_Home.ValueMember = "Team_Names";
cb_Home.DataSource = DS.Tables[0];
sql_con.Close();

}

Thanks for the reply I tried this but I think I'm not looking at the correct table.
DataBase Name GameDay tables inside are DataBase and Teams. ComboBox is looking at Teams. Any suggestions?

protected void FillCombobox()
{
sql_con = new SQLiteConnection
("Data Source=GameDay.db;Version=3;new=False;Compress=True;");

SQLiteConnection conn = new SQLiteConnection(sql_con);
DataSet ds = new DataSet();
try
{
sql_con.Open();
sql_cmd = new SQLiteCommand("select ID,Team_Name from GamnDay group by ID,TeamNames", sql_con);
SQLiteDataAdapter DB = new SQLiteDataAdapter();
DB.SelectCommand = sql_cmd;
DB.Fill(DS);
cb_Home.DisplayMember = "Team_Names";
cb_Home.ValueMember = "ID";
cb_Home.DataSource = DS.Tables[0];
}

catch (Exception ex)
{

}
finally
{
// sql_con.Open();
// sql_con.Close();

}
}

Phil.o Do you have an example?

How do I add screen shots?

It still shows the same result. 12/30/1899

It still shows 12/30/1899 when I reopen the app / database

Both answers helped me learn something today, Thank you both.

how do I clear

I have a dialog with a password

I uploaded a link of the Debugger, not sure how to add image
d1=28.444
d2=28.444
d3=0
AL=28.444

This is returned in the cell instead of the data from the cell. DataGridViewTextBoxCell { ColumnIndex=13, RowIndex=0 }

This is for my button click? Every word has an error, apparently I dont know where to put this.

That's what I need to accomplish bur I cant get that code to work at all.

I accept this answer, as it guided in the direction to fix the problem.

Bear with me I'm new add the lines to the button click.
and got error "Object reference not set to an instance of an object.
on line
if (!Decimal.TryParse(comboBox1.SelectedValue.ToString(), out decItemValue))

Wendelius

well done I added loadgrid method to the end of my Refresh_Click event and it worked.

Thank you

that was a copy and paste error, sorry.

Thanks that did the trick

How would i use that in the above code?

If that's the best you can do keep your comments to yourself.
Wasted 10 seconds of your lift typing that.

1. Be courteous. Everyone here helps because they enjoy helping, not because it's their job.

I have added more information

Thanks Guys...

Solution 1 almost did the trick but getting error on the l in this line.
System.NullReference

foreach (Lunch s in l)

I will add Write and Read code.

Thanks

private void btnWrite_Click(object sender, EventArgs e)
        {
            using (SaveFileDialog sfd = new SaveFileDialog() { Filter = "csv|*.csv", ValidateNames = true })
            {
                if (sfd.ShowDialog() == DialogResult.OK)
                {
                    using (var sw = new StreamWriter(sfd.FileName))
                    {
                        var writer = new CsvWriter(sw);
                        writer.WriteHeader(typeof(Lunch));
                        var l = lunchBindingSource.DataSource as List<Lunch>;
                        foreach (Lunch s in l)

                        {
                            writer.WriteRecord(s);
                        }
                    }
                    MessageBox.Show("Your Data has been Successfully saved.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
        }

        

        private void btnRead_Click(object sender, EventArgs e)
        {
            using (OpenFileDialog ofd = new OpenFileDialog() { Filter = "CSV|*.csv", ValidateNames = true })
            {
                if (ofd.ShowDialog() == DialogResult.OK)
                {
                    var sr = new StreamReader(new FileStream(ofd.FileName, FileMode.Open));
                    var csv = new CsvReader(sr);
                 //  lunchBindingSource.DataSource = csv.GetRecords<Lunch>().ToString();
                    lunchBindingSource.DataSource = csv.GetRecords<Lunch>(); /// use to create file
                }
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            lunchBindingSource.DataSource = new List<Lunch>();
        }
    }
}

When i try to save a new .Csv and load i get the error.

Thanks guys been a lot of help this code worked for me how it helps others.
I used it in all on all the boxes.

 private void tbLayers_TextChanged(object sender, EventArgs e)
        {
            try
            {
                int SqIn, comBo;


                if (string.IsNullOrEmpty(tbSqIn.Text) || string.IsNullOrEmpty(tbPallet.Text))
                    return;

                int.TryParse(tbSqIn.Text, out SqIn);
                int.TryParse(tbPallet.Text, out comBo);

                if (SqIn > 0)
                    tbTotesPerLayers.Text = (comBo / SqIn).ToString();
                else
                    tbTotesPerLayers.Text = string.Empty;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

Attempt to divide by zero.

Thanks for your input the program runs fine within Visual Studio with no errors.When I run the exe I get the error, some of the boxes auto populate the data so as I type the tb populates 0 until I finish. Again runs fine within VS.All boxes have this type of format.

private void tbCasePerTier_TextChanged(object sender, EventArgs e)
        {
            int Height, TotesLayers;

            int.TryParse(tbHeight.Text, out Height);
            int.TryParse(tbTotesLayers.Text, out TotesLayers);

            string defaultText = "Height in zero";
            tbTotesPerLayers.Text = Height == 0 ? defaultText : (TotesLayers / Height).ToString();

Thanks guys it is user friendly now.
Thanks again for the tips

Dave very true statement, i am in the process of converting it with a csv helper. I am new to this took me 3 mo. to get it working the whole app is math calculations. I have learned alot in this journey. can you elaborate more on a configuration solution? I dont mine home work just need a direction.

thanks

i have accepted a solution little late on your snark

Thanks for the tips Home work time.

Apology

I have a Winform that calculates x amount of boxes and divides it but minutes in a day if it runs into a time that i have coded (Lunch) it skips that amount of time then finishes the calculation. I would like to have the same app but with different times that i hard code.The user can select app 1 or app 2 from lets say a splash screen. Do i add the 2nd app to the solution project and add click events?

to add the same program to the existing program but code in the different program is modified. do i do a simple Add to existing Item to the solution?

Sorry was trying to add an image

The delivery duration changes, currently lunch is 30 min I have it in datagrid2 fixed. The delivery duration can run right up to lunch at that time it stops for the 30 min. after that time the duration continues. User enters start time. I'm not sure if you can see the image I have attached wasn't sure if i attached it correctly.

Any other solution?

Any other solutions

I have a several textbox and combo box the user inputs data for a math calculation.
If I have 140 boxes and can get 34 to a container I will need 4 containers
4 containers divided by 1350 min is 337 min apart
My first container time will be 00:00 the next one will be 337 min from there and so on.
I can get those calculations now I need to subtract, skip or jump over lunch time 10:50 – 11:20
140/34 = 4 containers
4/1350 = 337 min apart
Start time 00:00 Start time

Hide   Expand   Copy Code

var start_time = dateTimePicker1.Value.ToString("HH:mm");
            var start_time_array = start_time.Split(':');
            var today = DateTime.Now;
            var trailer_count = Convert.ToInt32(tbTrailer_Needed.Text);
            var minutes_apart = Convert.ToDouble(tbTime_Between.Text);
            var calculated_start_time = new DateTime(today.Year, today.Month, today.Day, Convert.ToInt16(start_time_array[0]), Convert.ToInt16(start_time_array[1]), 00);


            var trailers = new List<Trailer__Time>();
            for (var i = 0; i < trailer_count; i++)
            {
                if (i == 0)
                {
                    calculated_start_time = calculated_start_time.AddMinutes(0);
                }
                else
                {
                    calculated_start_time = calculated_start_time.AddMinutes(minutes_apart);
                }

                trailers.Add(new Trailer__Time
                {
                    Trailer_Number = i,
                    Delivery_Time = calculated_start_time.ToString("HH:mm")
                });


            }

Where can i find an example to do this in a TextBox?

You are correct let say I have a CSV file I put in a time 1:00-1:30 Times to aviod. When the time calculates i want it to skip that time frame. Im sure if you seen how it all works it would be a simple code for you. Thank you for being Patient

Not to string here's the code it reads and writes

private void btnWrite_Click(object sender, EventArgs e)
{
using (SaveFileDialog sfd = new SaveFileDialog() { Filter = "csv|*.csv", ValidateNames = true })
{
if (sfd.ShowDialog() == DialogResult.OK)
{
using (var sw = new StreamWriter(sfd.FileName))
{
var writer = new CsvWriter(sw);
writer.WriteHeader(typeof(Lunch));
foreach (Lunch s in lunchBindingSource.DataSource as List<lunch>)
{
writer.WriteRecord(s);
}
}
MessageBox.Show("Your Data has been Successfully saved.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}



private void btnRead_Click(object sender, EventArgs e)
{
using (OpenFileDialog ofd = new OpenFileDialog() { Filter = "CSV|*.csv", ValidateNames = true })
{
if (ofd.ShowDialog() == DialogResult.OK)
{
var sr = new StreamReader(new FileStream(ofd.FileName, FileMode.Open));
var csv = new CsvReader(sr);
// lunchBindingSource.DataSource = csv.GetRecords<lunch>().ToString();
lunchBindingSource.DataSource = csv.GetRecords<lunch>(); /// use to create file
}
}
}

private void Form1_Load(object sender, EventArgs e)
{
lunchBindingSource.DataSource = new List<lunch>();
}
}
}

CHill60
Again excellent
got it to run with an error its on (var timesToAvoid = (List<string>)dataGridView2.DataSource;)it is just a simple CSV class file no time format just text. I think thats the issue

error (unhandled exception 'system.invalidCastexception occured in Trailer time. Unable to cast object of type 'system.window.forms.bindingsource' to type

system.collection.genneric.list' system.string

Where should i add that code in mine btw Brilliant answer
confused with this line error at lt. & and gt:)
(
var timesToAvoid = (List & lt; string>)dataGridView2.DataSource;)

From textbox Combo and a datetime picker

Which returns a value to textbox Trailer_Needed

Anyone else I cant find an answer.

thanks

I can populate the information but have not seen a straight forward solution to subtract the times. I have been working on this for 2 mo. I'm new to code it could be done in a day for an experience coder. Thanks for the suggestion i will stay with text box.

I dont know what lines to edit in my code to make it work.

Getting error when add to my code. an object reference is required for a non static field, method or property to datetime.ToString(string)

I corrected the typo any suggestions on how to fix it?

I have removed the Math.Ceiling from the second If statement and added it to the first and get an error textbox can not be used in this meathod

this part of my code only gives me a start time and dont increment the minutes.

DateTime date = Convert.ToDateTime(start_time);
TimeSpan Time = new TimeSpan Parse(minutes_apart);
DateTime combine = minutes_apart + start_time ();

this is the code thats not populating in my datagrid it just gives me my start time not increment the minutes..

the code is strong was showing how i get the information to the question i asked,

I have 2 textboxes one the user enters a time 20:15 and another textbox that has minutes this is calculated from other boxes 225:00. A third textbox that has the number of conatines. Out put should be 20:15 6 containers 225:00 minutes apart. 20:15:00,0:00:00,3:45:00,7:30:00,11:15:00,15:00:00