|
Hi all! Im having a problem with datagridview. A MySQL Query, with int32 column my datagridview show as System.Byte[].
Any suggestion?
Thanks!!
|
|
|
|
|
gonzaloleon wrote: with int32 column my datagridview
Is it an Int32 in the table-definition? Or did you mean an Int32-column in the DGV?
What does your query look like? Can you run a "SHOW CREATE TABLE" query on the table and dump the result here?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
I'm uncertain what you mean by your question.
Are you saying it is displaying as byte[] and you don't want it to?
Or you want it to display as byte[] and it isn't?
|
|
|
|
|
It's a problem with MySQL Server Version, i upgrade to 5.6 and there's no more problems.
Thanks All!
|
|
|
|
|
I wanted to know wether I could use your Simple Instant Messenger in a windows app and if yes how do I??
|
|
|
|
|
Is this from an article? If it is, you should really post this request on the article itself. The chances of the author happening on by this post and seeing your question is very small.
|
|
|
|
|
Thank you for the sugesstion.I am very new to this .Once again thank u.
|
|
|
|
|
I find the Import and Export examples in SQL Excel Files with C#2005, share with me.
|
|
|
|
|
Did you try typing that into Google first? It's amazing what you'll find by using a search engine.
|
|
|
|
|
Steady on there!
That's pretty damn close to the OP actually doing some work for himself!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
What was I thinking!
|
|
|
|
|
there are many examples on network but only one code short, I did not test much error, have code read i don't understand to do something, I look for good running, the code has been optimized and short, read perspicuous
|
|
|
|
|
If you're looking for the perfect code to copy and paste into our own app, you've come to the wrong place.
We'll help you with YOUR code the YOU write. Nobody is going to hunt down the perfect piece of code for you.
|
|
|
|
|
nothing is hunting download my code because I want to share them with people like me that is the case, you can see my code fails: "Not a legal OleAut date" when importing excel2007 into SQL Server 2005
|
|
|
|
|
Member 2458467 wrote: nothing is hunting download my code because I want to share them with people like me that is the case
That made no sense at all. I have no idea what you're trying to say.
|
|
|
|
|
I am be an error importing the Excel2007: "Not a legal OleAut date", you see my code below:
public static void ImportToSql(string excelfilepath)
{
string ssqltable = "TABHD";
string myexceldataquery = "SELECT * FROM [dbo_TABHD]";
try
{
string sexcelconnectionstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source =" + excelfilepath + "; Extended Properties=\"Excel 12.0; HDR=Yes; IMEX=2\"";
string ssqlconnectionstring = @"server = itfriend;Database=HD;integrated security = true";
string sclearsql = "delete " + ssqltable;
INSERTING IT.INSTEAD I WANT TO UPDATE TABLE DATA"
SqlConnection sqlconn = new SqlConnection(ssqlconnectionstring);
OleDbConnection oledbconn = new OleDbConnection(sexcelconnectionstring);
OleDbCommand oledbcmd = new OleDbCommand(myexceldataquery, oledbconn);
oledbconn.Open();
OleDbDataReader dr = oledbcmd.ExecuteReader();
SqlBulkCopy bulkcopy = new SqlBulkCopy(ssqlconnectionstring);
bulkcopy.DestinationTableName = ssqltable;
bulkcopy.WriteToServer(dr);
Console.WriteLine(".xlsx file imported succssessfully into database.", bulkcopy.NotifyAfter);
oledbconn.Close();
}
catch (Exception ex)
{
//handle exception
MessageBox.Show(ex.Message.ToString(), "Warning !");
}
}
|
|
|
|
|
Somewhere in your Excel sheet that you're trying to import there is an invalid date.
It's not that hard to figure out. All you have to do was copy and paste the exception message into Google and you would have had your answer in about 5 seconds.
|
|
|
|
|
if i change string sexcelconnectionstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source =" + excelfilepath + "; Extended Properties=\"Excel 12.0; HDR=Yes; IMEX=2\""; of execl 2007 as excel 2003 and file excel 2003(note conten like it), it's not warning error: "Not a legal OleAut" and import excel2003 into SQL Server very good, why excel 2007 be warning ?
Excel connection strings
https://connectionstrings.com/excel/
|
|
|
|
|
Those connection strings are identical.
I have no idea what this means:
Member 2458467 wrote: of execl 2007 as excel 2003 and file excel 2003(note conten like it),
|
|
|
|
|
file Excel2007 and file excel2003 the same content, that is since I use Office2007 file excel2003 to convert to file Excel2007, have you got test my code ?
modified 19-Sep-14 2:33am.
|
|
|
|
|
I create a program play video by C#, using VLC library. But I dont know how to make the text on the video in the form when it is playing.
I try to use label but it has back color with the text. It is not nice.
How can I make the text on the video? Pls help me...
|
|
|
|
|
|
Hi,
Is it possible to create an encrypted xml using C# without having to decrypt it everytime I want to insert or read from it?
I want to store my application connection string passwords and email credentials in that file.
Thanks,
Jassim
Technology News @ www.JassimRahma.com
|
|
|
|
|
No.
Think about it: why do you encrypt a file? To prevent people from reading it's content. If you could read it without decrypting it, so could anyone else, and it wouldn't be encrypted then, would it?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
sorry what I wanted to say is without decrypting the physical file so decrypting will be on my application level not the actual physical file.
Technology News @ www.JassimRahma.com
|
|
|
|