|
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.
|
|
|
|
|
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
|
|
|
|
|
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";
DateTime result;
if (DateTime.TryParseExact(dateString, "yyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None, out result)){
Console.WriteLine(result.ToString("yyyyMMdd"));
} else {
Console.WriteLine("Data invalid");
}
}
}
|
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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
{
pictureBox1.Image = Image.FromStream(phtosssss);
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
Soyons toujours à la disposition des autres
|
|
|
|
|
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.
|
|
|
|
|
void prece_dent()
{
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)
{
Byte[] btpht = new Byte[0];
btpht = (Byte[])(ds.Tables["client"].Rows[c - 1]["photo"]);
MemoryStream phtosssss = new MemoryStream(btpht);
pictureBox1.Image = Image.FromStream(phtosssss);
}
|
|
|
|
|
And how many bytes are in your byte array?
|
|
|
|
|
my problem is to recover the recorded image and display it in the picturebox
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|
|
what can i do?? by seeing my codes?
can't you help??
|
|
|
|
|
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.
|
|
|
|
|
i don't know what to say in my database, i have only one registration
|
|
|
|
|
WE ARE TRYING TO HELP!!!!!!!!!!!!!!!!!!!!!! 
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??
modified 31-Mar-14 10:55am.
|
|
|
|
|
i use Access data-base
and i have used OLE object in my image data
|
|
|
|
|
when I created my data base in access, is displaying binary data (my image data)
|
|
|
|
|
You still haven't told us if you've stepped over that line of code and checked the size of it. We aren't trying to trick you here. You really do need to check that you've populated it first.
|
|
|
|
|
i said that until now, just one picture in my database
|
|
|
|
|
But is that picture actually making it through to your code? That's what we have been trying to get you to check. Look, do what I asked and put a breakpoint on your code and step over that line - then check how big your byte array is. It's not difficult. I'm not asking you to rewire the space shuttle. I'm just asking you to check that you are getting, in this field, what you would be expecting. Then, if you are, we have ruled out one problem and we can move onto potential causes.
|
|
|
|
|
Nobody, and especially your application, cares what YOU think is in the database. What is at hand is what the CODE thinks! And you're not even attempting to answer that question.
|
|
|
|
|
Do you know what debugging is?
It means you run the program, but stop it at some point (it is called a breakpoint). Then you can execute the code line by line and check the values of the variables (right-click - quickwatch).
What Pete and Dave are trying to explain is that the bytes that are in the database need to be copied into your code (adpt.Fill(ds, "client");). If that didn't work than the conversion from Byte[] to Image won't work.
So their question is: What is the "Length" of the btpht object AFTER this line: btpht = (Byte[])(ds.Tables["client"].Rows[c - 1]["photo"]);
Hope this helps.
(PS: respond to them the answer, not to this message)
|
|
|
|
|
until now i don't have an idea because it's my first time to use it, can't you tell me how to do about "LENGTH"?????
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
