C# Discussion Boards - CodeProject

hello

i stored image in sql server DB by follow command:

command.Parameters.Add("@attach", SqlDbType.VarBinary).Value = bytFile;

but now i want to do it by

Parameters.AddWithValue

command.Parameters.AddWithValue("@attach", bytFile);

but it dont work .

thanks

"It dont work" is probably the most useless problem report we get - and we get it a lot. It tells us nothing about what is happening, or when it happens.
So tell us what it is doing that you didn't expect, or not doing that you did.
Tell us what you did to get it to happen.
Tell us any error messages.

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

i have create code like this right now,it is small game. it will show grid pictureboxes when user enter rows and columns in textboxes. also i have several button with image. when i click the button,that mean i choose the image on that button and when i click the picturebox, that image will showing on that picturebox.also user can click button(image) to change the image on picture box.
i don't know how to modify my picturebox image with button.

private void btnGenerate_Click(object sender, EventArgs e)
       {
           //TODO: CLEAR PREVIOUS DRAWN
           panel3.Controls.Clear();

           //set rows and columns
           int rows = Convert.ToInt32(txtRows.Text);
           int columns = Convert.ToInt32(txtColumns.Text);

           PictureBox[,] map = new PictureBox[rows,columns];

           for (int j = 0; j < columns; j++)
           {
               for (int i = 0; i < rows; i++)
               {
                   //show dynamically
                   System.Threading.Thread.Sleep(50);

                   map[i, j] = new PictureBox();

                   map[i, j].Width = 45;
                   map[i, j].Height = 45;
                   map[i, j].BackColor = Color.NavajoWhite;

                   //set first picturebox position
                   if (i == 0 && j == 0)
                   {
                       map[i, j].Location = new Point(100, 100);
                   }


                   map[i, j].Location = new Point(45 * i + 100, 45 * j + 100);
                   map[i, j].BorderStyle = BorderStyle.Fixed3D;

                   //show on the panel
                   panel3.Controls.Add(map[i, j]);



               }
           }

       }

Message Removed

modified 2-Oct-18 16:27pm.

I want to perform some communication between two child forms that are each opened from a parent form (separate button to show each form). I want to change the visibility and value of a numericalUpDown and also the visibility and text of a textbox.

I have used properties, the get part is working perfectly, but the set part works only on the child.show() event, e.g. when I click on Child1Form.button to show the Child2Form the "set" part works, but if I do not show Child2Form, it does not work. and i also do not want to use from setting files.

I used form event handling. The method has gotten fired and the message has shown correctly, but the changes in text and visibility have not.

On the parents side where I call the publisher form, means Child3 form:

C#

Child3 child3 = new Child3();
Child1 child1 = new Child1();
child3.Child1Button2Clicked += child1.child3_Child1Button2Clicked;
child3.Show();

On the subscriber(listener) side:
Event Handling between two child forms that each open from the same parent (Two child - one parent).

C#

public void child3_Child1Button2Clicked(object sender, FormsCommunication e)
{
    NumericalUD1.Visible = e.NumericalUDPass;
    textBox1.Text = e.textBoxPass;
    MessageBox.Show("it got fire" + ": " + e.NumericalUDPass.ToString() + ": " + e.textBoxPass.ToString());
 }

On the publisher side:

C#

public event EventHandler<FormsCommunication> Child1Button2Clicked;

//button click event to set the values and fire the method.

C#

private void Child3Btn1_Click(object sender, EventArgs e)
{
    FormsCommunication formsCommunication = new 
    FormsCommunication("2782",Convert.ToBoolean(false));

    OnChild1Button2Clicked(formsCommunication);

}

protected virtual void OnChild1Button2Clicked(FormsCommunication e)
{
    Child1Button2Clicked?.Invoke(this, e);
}

//the constructor in the EventArgs Class:

C#

public FormsCommunication(string textBox, bool NumericalUD)
 {
    textBoxPass = textBox;
    NumericalUDPass = NumericalUD;   
 }

 public string textBoxPass { get; private set; }
 public bool NumericalUDPass { get; private set; }

Do yourself a favour and scrap that - form2 shouldn't even know form 3 exists, much less try to modify it's behaviour.
See here: Transferring information between two forms, Part 3: Child to Child[^] Form1 needs to know they both exist because it opens them - so all communication goes via the parent.

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

modified 20-Sep-18 3:28am.

Thank you so much for your help.
Is it safe to use from setting files in the user scope and share it between two text boxes for example?

Why would you want to do something that cumbersome?

Perhap you need to explain in more detail exactly what you are trying to do?

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

Hi, thanks a million for your reply.
Sometimes there are many data that i want to share between two forms. So it is easier to use from properties.settings.default (for me). that works very good and i can save and retrieve my data in the most simple way. So sometimes i prefer to use from them. setting files with user scope, are accessible all over the program directly. So i am doubtful about their security hazards. That is why i have asked the question.

Do you have any idea how inefficient that is?
Every time you want to access items in memory, you will be going via a hard drive!

You do realise that Properties.Settings is backed by an XML file, so every time you write to them there is a heck of a lot of "read the file, copy it up to the parameter we want, write the new value instead, copy the rest of the file" going on behind the scenes? And reading it means "read the file, scan it for the parameter we want, copy the value" each time?
And that if you want to use the same class in two places, they will clash on the settings file because it only knows about one parameter?

Start doing it a lot - and you will, because "it works" - and you will slug the heck out of your computer. Learn to do it properly, and it not only works better, but is considerably more maintainable.

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

Hi,
I do not know how should i thanks from you for your help and guide. Can you give me a link of an article that how should i save and retrive my data in the minimum time and what the best way is? .thanks a million.

Well, the way I'd do it is to create a separate class to act as a "data transfer" class and fill an instance of that in the property getter.
That way, all the related data is together, and in its correct data format ready to be used.

You presumably know how to create a class?

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

Hi,
As i have gotten your point, Yes i know how to create a class, and how to use from get and set. But my means is about save and retrieve data and not about sharing them. But if you means is a different thing, no unfortunately i have no idea about that and if so, do me a favour and guide me through it, please.
Thaaaaaaaank you again .

modified 25-Sep-18 16:35pm.

i hope the user will input number of rows and number of columns in 2 textboxs, then click the Generate button and a grid of PictureBoxes will be generated on panel.
Initially the grid will be empty.
The Grid is composed of PictureBoxes which are generated dynamically.

All you need is to decide a couple of things, given dX, dY as the usable width and height of the panel inside any edge margins, and R, C are the number of rows and columns.

First pick how big a margin M you want around each panel (we'll assume that M is the same top and side)

width of each image  = (dY - (C - 1) * M) / C
height of each image = (dY - (R -1 ) * M) / R

Now all you need to do is nest two loops, and create your PictureBoxes, setting the Size of each to (width, height) and the Location to (columnNumber * (width + M), rowNumber * (height + M)) (both offset by the margin round the edges of the panel, obviously)
Then add each PictureBox to the Panel.Controls collection.

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

thank you i find a way to create it !

private void btnGenerate_Click(object sender, EventArgs e)
       {
           //TODO: CLEAR PREVIOUS DRAWN
           panel3.Controls.Clear();

           //set rows and columns
           int rows = Convert.ToInt32(txtRows.Text);
           int columns = Convert.ToInt32(txtColumns.Text);

           PictureBox[,] map = new PictureBox[rows,columns];

           for (int j = 0; j < columns; j++)
           {
               for (int i = 0; i < rows; i++)
               {
                   //show dynamically
                   System.Threading.Thread.Sleep(50);

                   map[i, j] = new PictureBox();

                   map[i, j].Width = 45;
                   map[i, j].Height = 45;
                   map[i, j].BackColor = Color.NavajoWhite;

                   //set first picturebox position
                   if (i == 0 && j == 0)
                   {
                       map[i, j].Location = new Point(100, 100);
                   }


                   map[i, j].Location = new Point(45 * i + 100, 45 * j + 100);
                   map[i, j].BorderStyle = BorderStyle.Fixed3D;

                   //show on the panel
                   panel3.Controls.Add(map[i, j]);



               }
           }

       }

what is the best way to process image i have a scenario i have floor map of parking and first i want to allocate as an available slot in the system once it is available slot i need to assign it to one of the staff once assign i want to show this area as red and available slot as green on this floor image. kindly assist me that what is the best way to implement this in C# ASP.NET.

Thanks in advance.

What have you tried?
Where are you stuck?
What help do you need?

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with. And you haven't told us much at all ...

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

If I were doing this, given several assumptions about what you are asking, I'd probably do it using Scalable Vector Graphics (SVG).

This space for rent

Hi all!
New to the forum Wink | ;)

I have a made a application that stores it's settings with the following code:

C#

Properties.Settings.Default.Username= TxtUsername.Text;
Properties.Settings.Default.Password = TxtPassword.Text;
Properties.Settings.Default.Tel = TxtTel.Text;
Properties.Settings.Default.EMail = TxtEMail.Text;
Properties.Settings.Default.Save();

Loading the settings works just fine, but with one exception.
If I change the code in any way, the settings changes to "\r\n\t\t\t\t".
I can image it is because the application has changed or something like that.
But is there any way to make it so it changes to "" instead?
Want to make a function to check if the settings have been set by checking each of them if they are null. Dosent work that well if they either are null or contain "\r\n\t\t\t\t".

Note that I am using SharpDevelop, I am at work and I can't get VS Studio here, unfortunatly.

I am a 100% online student trying to learn C#. My instructor has not been of help, so I am looking for help elsewhere.

My homework is to create a program that will convert measurements:

"

In the English measurement system, 1 yard equals 3 feet and 1 foot equals 12 inches. Use this information to create an application that lets the user convert distances to and from inches, feet, and yards. Use list boxes for the user to select units being converted from and another list box for the user to select units being converted from. 
 
Write your code in the following order
Program must check for correct input into the textbox. Hint: use TryParse.
Check that user has selected a from unit. If not, let user know no unit has been selected.
Check that user has selected a to unit. If user selects the same unit for both from and to, let them know that they need to select a different unit.

"

I believe I have my TryParse correct. It will make sure a measurement has been entered, a from distance has been selected and a to distance has been selected. After that, I am not sure where to proceed. I don't know how to grab what is selected in the from groupbox to the to groupbox and then convert. Any help would be appreciated. Thanks!

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace Distance_Converter
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void convertButton_Click(object sender, EventArgs e)
        {
            double distanceInput;
            double inches;
            double feet;
            double yards;
            string measurementFrom;

            if (double.TryParse(distanceTextBox.Text, out distanceInput));
            {
                if (fromListBox.SelectedIndex != -1)
                {
                    if (toListBox.SelectedItem = != -1)
                    {
                        

                    }
                }

            }

        }
    }
}

Image of UI: Capture — imgbb.com[^]

Your tryparse is correct but you are not doing the job asked of you, you test the input but do nothing if it is incorrect.

Do each test in isolation rather than nesting them.
Test that the input will parse as a double (add a message to a string if it fails)
Test that the distance input is not zero

Test that a from unit has been selected (add a message to a string if it fails)
test that a to unit has been selected
test that the selected unit type are not the same (have the same selectindex)

Tell the user of any errors in the testing phase

Use the selectedindex to get the unit type for each listbox from the underlying collection

You now have the distance, the from type and the to type. The conversion is a simple math operation.

Never underestimate the power of human stupidity
RAH

I'm relearning C#, and due to my lack of funds, am using a computer that's over 5 years old and cannot even create console apps except using an online compiler. For some reason, Visual Studio will not create console apps. But that's beside the point.

I was given a file, and the task to sort out which items go on which shelf. It uses a lot of classes and arrays, my weak point in C#. So I thought I'd post here to see if someone could help me out with this.

The program itself is:

 * At ACME warehouse the warehouse manager has observed orders taking a long time to pick and
 *  believes that moving more popular items to easier to access locations may help.
 *
 * - Workers pick an order by placing items on a pallet at the dock door.
 * - Products are stored (inefficiently) in a single aisle with multiple shelves.
 * - As the shelf number increases, it is located further down the aisle and
 *   further away from the dock door.
 * - On average it takes 5*X seconds for a warehouse worker to retrieve an item
 *   from shelf X and place it on the pallet.
 * - A warehouse worker can only carry a single item at a time.
 * - A shelf can only hold one type of item.
 *
 * Which items should be on which shelves to optimize picking speed based on
 *  yesterday's orders?
 *
 *
 * Example output
 *
 * Shelf 1:      Item 12
 * Shelf 2:      Item 11
 * Shelf 3:      Item 10
 * Shelf 4:      Item 09
 * Shelf 5:      Item 08
 * Shelf 6:      Item 07
 * Shelf 7:      Item 06
 * Shelf 8:      Item 05
 * Shelf 9:      Item 04
 * Shelf 10:     Item 03
 * Shelf 11:     Item 02
 * Shelf 12:     Item 01
 *
 */

OrderRepository orderRepo = new OrderRepository();

// write your code here

Console.WriteLine("Order " + Order[1].OrderLine[1]);

The functions are:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace WarehouseOptimization
{
    public class Order
    {
        public OrderLine[] orderLines;
        public int id;
        public string customerName;
    }

    public class OrderLine
    {
        public int quantity;
        public string itemName;
    }

    public class OrderRepository
    {
        public Order[] GetYesterdaysOrders()
        {
            Order[] orders = new Order[] {
                                new Order{
                                    id = 1,
                                    orderLines = new OrderLine[] {
                                        new OrderLine{ itemName = "Item 01", quantity = 1},
                                        new OrderLine{ itemName = "Item 02", quantity = 3},
                                        new OrderLine{ itemName = "Item 03", quantity = 25},
                                        new OrderLine{ itemName = "Item 04", quantity = 12},
                                    },
                                },
                                new Order{
                                    id = 2,
                                    orderLines = new OrderLine[] {
                                        new OrderLine{ itemName = "Item 01", quantity = 1},
                                        new OrderLine{ itemName = "Item 08", quantity = 42},
                                        new OrderLine{ itemName = "Item 09", quantity = 13},
                                        new OrderLine{ itemName = "Item 12", quantity = 37},
                                    },
                                },
                                new Order{
                                    id = 3,
                                    orderLines = new OrderLine[] {
                                        new OrderLine{ itemName = "Item 12", quantity = 16},
                                    },
                                },
                                new Order{
                                    id = 4,
                                    orderLines = new OrderLine[] {
                                        new OrderLine{ itemName = "Item 10", quantity = 11},
                                        new OrderLine{ itemName = "Item 11", quantity = 10},
                                    },
                                },
                                new Order{
                                    id = 5,
                                    orderLines = new OrderLine[] {
                                        new OrderLine{ itemName = "Item 06", quantity = 7},
                                        new OrderLine{ itemName = "Item 07", quantity = 2},
                                        new OrderLine{ itemName = "Item 12", quantity = 14},
                                    },
                                },
                                new Order{
                                    id = 6,
                                    orderLines = new OrderLine[] {
                                        new OrderLine{ itemName = "Item 05", quantity = 17},
                                    },
                                },
                                new Order{
                                    id = 7,
                                    orderLines = new OrderLine[] {
                                        new OrderLine{ itemName = "Item 03", quantity = 5},
                                        new OrderLine{ itemName = "Item 07", quantity = 2},
                                    },
                                },
                                new Order{
                                    id = 8,
                                    orderLines = new OrderLine[] {
                                        new OrderLine{ itemName = "Item 02", quantity = 13},
                                        new OrderLine{ itemName = "Item 07", quantity = 7},
                                        new OrderLine{ itemName = "Item 09", quantity = 2},
                                    },
                                },
                                new Order{
                                    id = 9,
                                    orderLines = new OrderLine[] {
                                        new OrderLine{ itemName = "Item 01", quantity = 4},
                                        new OrderLine{ itemName = "Item 06", quantity = 17},
                                        new OrderLine{ itemName = "Item 07", quantity = 3},
                                    },
                                },
                                new Order{
                                    id = 10,
                                    orderLines = new OrderLine[] {
                                        new OrderLine{ itemName = "Item 11", quantity = 12},
                                        new OrderLine{ itemName = "Item 12", quantity = 1},
                                    },
                                },

                             };

            return orders;
        }

    }
}

I used Excel to figure out the proper order for everything:

Quote:
number item
68 12
42 8
30 3
24 6
22 11
17 5
16 2
15 9
14 7
12 4
11 10
6 1

With this, item 12 is most ordered, so it should go on shelf 1, and so on.

My question is how do I sort all this stuff program-wise?

Thanks in advance for your help.

So you have a collection of Order objects (class) each of which has a collection of OrderLine objects (class). You need to work with the total collection of OrderLine independent of the containing Order.

I would create another collection of Orderline and loop through the Order collection and add each OrderLine to the new collection

static void Main(string[] args)
{
    //Create an instance of the repository class
    OrderRepository oRepository = new OrderRepository();

    //Get the kist of orders
    List<Order> lOrders = oRepository.GetYesterdaysOrders().ToList();

    //Create a new collection to insert the line into
    List<OrderLine> oLines = new List<OrderLine>();

    //loop through the orders and get the lines
    foreach (Order Item in lOrders)
    {
        //add the lines from each order into the main collection
        oLines.AddRange(Item.orderLines);
    }
    Console.WriteLine(string.Format("Order Lines {0}", oLines.Count));

    //print each orderline in the amin collection
    foreach (OrderLine oLine in oLines.OrderByDescending(x => x.quantity))
    {
        Console.WriteLine(string.Format("Item {0} Qty {1}", oLine.itemName,oLine.quantity));
    }
    Console.ReadLine();

    //You now need to aggregate the main collection by the item no to get the sum of the quantity for each item then prin it.
}

The above code will give you an idea how to manipulate the collections - you need to research how to aggregate the collection to meet your needs.

Never underestimate the power of human stupidity
RAH

to do a project , SOAP webservice from client to server for sending work order and based on the request generate the response