Re: Date conversion from YYMMDD to CCYYMMDD - C# Discussion Boards

dan!sh 31-Mar-14 19:33

dan!sh

31-Mar-14 19:33

Windows Form based development is different from doing WPF. I would recommend doing what you are comfortable with. After all, someone else is paying for a software product he needs and not for you learning new things.

Shady George31-Mar-14 19:39

Shady George

31-Mar-14 19:39

I've taken that into account, I think I'm going to do the project in both, Window Forms and WPF. That way, I'll only bill for the forms development (I can write it in my sleep anyway, there's nothing earth shattering about it).

dan!sh 31-Mar-14 19:50

dan!sh

31-Mar-14 19:50

I think you can start with using MVVM in the windows form application. That way you do not really need to make much effort to convert it to WPF application. Here[^] is an article to start off with.

Shady George1-Apr-14 7:35

Shady George

1-Apr-14 7:35

Thanks for the reference, I'll have a good look at it this morning.

V.31-Mar-14 21:41

31-Mar-14 21:41

depends on how large and complicated it is.
I would recommend a good book to start from. If you have done Asp.Net you'll feel comfortable reasonably quick (it is more similar to designing web pages than in designing forms).

However if the project is large or could become large, it is probably better to keep with what you know.

V.

(MQOTD rules and previous solutions)

OriginalGriff wrote:
V is absolutely right

Date conversion from YYMMDD to CCYYMMDD

Shady George1-Apr-14 7:39

Shady George

1-Apr-14 7:39

It's not a big project by any stretch, but it's one of those that has the capability of growing. I've written the same kind of thing lots of times before. There's just one (new) bit I'm unsure of, and that's a legal requirement to identify sellers (The New Zealand second hand dealers act is quite rigid on that), but I'm sure I'll find a way to do it.

Member 1071407431-Mar-14 15:41

Member 10714074

31-Mar-14 15:41

surprised i even have to do this still... in any case, does anyone know of a C# routine to convert this?

of course I can do it the hard way, but was hoping there was something i could just pass this to and it spit out the right date for me.

thanks

Re: Date conversion from YYMMDD to CCYYMMDD

Peter Leow31-Mar-14 16:21

Peter Leow

31-Mar-14 16:21

First , the program must validate that it is a valid date as per your original format, then can do the necessary conversion, see example:

using System;
using System.Globalization;

public class Program
{
    public static void Main()
    {
        string dateString = "140331";   // in yyMMdd format
        DateTime result;
        if (DateTime.TryParseExact(dateString, "yyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None, out result)){

            Console.WriteLine(result.ToString("yyyyMMdd"));   // output 20140331
        } else {
            Console.WriteLine("Data invalid");  
        }
    }
}

Re: Date conversion from YYMMDD to CCYYMMDD

Member 107140741-Apr-14 6:56

Member 10714074

1-Apr-14 6:56

thank you

ASP .Net issue with Oracle client

Rock Star.31-Mar-14 4:05

Rock Star.

31-Mar-14 4:05

Hi All,

After developing the application with oracle client 9.2 on my machine, when I am trying to run the application on server with having Oracle client 10.1, I am not able to run it.
Is it possible to run an application build with 9.2, on server having oracle client 10.1 on it.

Thanks

Rock Star

Re: ASP .Net issue with Oracle client

Pete O'Hanlon31-Mar-14 4:14

L'Exception ArgumentException was not Operated

31-Mar-14 4:14

It's difficult to say with the scant information you've supplied. How are you connecting to Oracle? What drivers are you using? Are you getting any exceptions?

remiki31-Mar-14 2:35

31-Mar-14 2:35

Hello,
wanting to display a photo after it is recorded,
an error message is displayed me "L'Exception ArgumentException was not Operated"

DataSet ds = new DataSet();
                    adpt.Fill(ds, "client");
                    int c = ds.Tables["client"].Rows.Count;
                    if (c > 0)
                    {
                        Byte[] btpht = new Byte[0];
                        btpht = (Byte[])(ds.Tables["client"].Rows[c - 1]["photo"]);
                        MemoryStream phtosssss = new MemoryStream(btpht);

                        try
                        {
                        //Here is the Message
                            pictureBox1.Image = Image.FromStream(phtosssss);//the error is appear here
                            
                        }
                        catch (Exception ex)
                        { MessageBox.Show(ex.Message); }
                    }

Soyons toujours à la disposition des autres

Pete O'Hanlon31-Mar-14 3:12

31-Mar-14 3:12

Put a breakpoint on the line that creates your byte array and check that you have populated it after you step over the row. You're looking for a reasonably large value in there.

remiki31-Mar-14 3:22

31-Mar-14 3:22

look all that i Did

void prece_dent()
      {
          //try{
              if (INDEX != 1)
              {
                  INDEX--;
                  lblenre.Text = "" + INDEX + " / " + rowCount;
                  OdbcConnection cnx = new OdbcConnection("DSN=KINGMINDONGO");
                  cnx.Open();
                  OdbcDataReader dtr;
                  OdbcCommand comded = new OdbcCommand("select *from client where code_client=" + @Convert.ToDecimal(code_client.Text));
                  comded.Connection = cnx;
                  dtr = comded.ExecuteReader();
                  for (int i = 0; i < INDEX; i++) dtr.Read();
                  code_client.Text = dtr.GetInt32(0).ToString();
                  nom.Text = dtr.GetString(1);
                  prenom.Text = dtr.GetString(2);
                  societe.Text = dtr.GetString(3);
                  date_naissance.Text = dtr.GetDate(4).ToString();
                  lieu_naissance.Text = dtr.GetString(5);
                  adresse.Text = dtr.GetString(6);
                  tel.Text = dtr.GetInt32(7).ToString();
                  fax.Text = dtr.GetInt32(8).ToString();
                  e_mail.Text = dtr.GetString(9);
                  compte_bancaire.Text = dtr.GetInt32(10).ToString();
                  banque.Text = dtr.GetString(11);


                  OdbcDataAdapter adpt = new OdbcDataAdapter(comded);
                  dtr.Close();
                  DataSet ds = new DataSet("client");
                  adpt.Fill(ds, "client");
                  int c = ds.Tables["client"].Rows.Count;
                  if (c > 0)
                  {

                      //var data = (Byte[])(ds.Tables["client"].Rows[c - 1]["photo"]);
                      //var stream = new MemoryStream(data);

                      Byte[] btpht = new Byte[0];
                      btpht = (Byte[])(ds.Tables["client"].Rows[c - 1]["photo"]);
                      MemoryStream phtosssss = new MemoryStream(btpht);

                      //try
                      //{
                          pictureBox1.Image = Image.FromStream(phtosssss);

                     // }
                      //catch (Exception ex)
                      //{ MessageBox.Show(ex.Message); }
                  }

Pete O'Hanlon31-Mar-14 4:04

31-Mar-14 4:04

And how many bytes are in your byte array?

remiki31-Mar-14 4:13

31-Mar-14 4:13

my problem is to recover the recorded image and display it in the picturebox

Pete O'Hanlon31-Mar-14 4:15

31-Mar-14 4:15

Yes, I got that. What I'm trying to get to here is what data is in your memory stream after you have read it from the database? Do you have any bytes there to convert into an image?

Dave Kreskowiak31-Mar-14 4:19

Dave Kreskowiak

31-Mar-14 4:19

You're not listening. We'll try this again.

How many bytes are in the array before you send it to the MemoryStream?!

If it's zero, your query didn't return any image data, therefore you can't make a Bitmap from it.

A guide to posting questions on CodeProject

How to debug small programs

Dave Kreskowiak

remiki31-Mar-14 4:21

31-Mar-14 4:21

what can i do?? by seeing my codes?

can't you help??

Pete O'Hanlon31-Mar-14 4:38

31-Mar-14 4:38

No we can't help, not until you actually check that you have data in your byte array.

Byte[] btpht = new Byte[0];
btpht = (Byte[])(ds.Tables["client"].Rows[c - 1]["photo"]);

After you step over this line, how many bytes are in btpht? Oh, and you don't need to new up the byte beforehand.

remiki31-Mar-14 4:57

31-Mar-14 4:57

i don't know what to say in my database, i have only one registration

Dave Kreskowiak31-Mar-14 4:48

Dave Kreskowiak

31-Mar-14 4:48

WE ARE TRYING TO HELP!!!!!!!!!!!!!!!!!!!!!! Mad | :mad:

The problem is that you're not listening and you're not doing what we're telling you to do to help diagnose the problem! You're NOT helping us help you!

YOU have to do the work! We don't have access to your machine and we can't see your monitor, so how else is this going to get fixed??

A guide to posting questions on CodeProject

How to debug small programs

Dave Kreskowiak

modified 31-Mar-14 10:55am.

remiki31-Mar-14 5:11

31-Mar-14 5:11

i use Access data-base
and i have used OLE object in my image data

remiki31-Mar-14 5:15

31-Mar-14 5:15

when I created my data base in access, is displaying binary data (my image data)

Pete O'Hanlon31-Mar-14 5:25