? - C# Discussion Boards

14-Feb-09 2:29

Hi all i have a problem that i have been struggling for a week and a half now
this is the function i use to try and update a image in my database

void t(MemoryStream msI)
	{
          string query;
          query ="insert into testimage (id_image,pic) values(" +'"'+"t"+'"' + "," +"@pic)";
          BinaryReader oReader = new BinaryReader(msI);
          System.Data.Odbc.OdbcCommand  cmd = new System.Data.Odbc.OdbcCommand(query,OdbcCon );
	  cmd.Parameters.Add("pic",oReader.ReadBytes((int)msI.Length));
          cmd.Prepare();
          cmd.ExecuteNonQuery();
          MessageBox.Show("Image Added");
	}

But the problem that i get that it doesn't insert any data into the blob field
msI is a Memory Stream that is the image that i want to insert

Any help would be greatly appreciated

ABitSmart14-Feb-09 4:03

ABitSmart

14-Feb-09 4:03

hendrik wrote:
+'"'+"t"+

Looks like a quote mismatch. I think this might be what you want,

query = "insert into testimage (id_image,pic) values('t', @pic)";

hendrik wrote:
cmd.Parameters.Add("pic",oReader.ReadBytes((int)msI.Length));

Second paramter should be a valid OdbcType. You can use the OdbcType enum for it. Also, the parameter name should be @pic

Finally, assign the value of parameter and execute.

e.g.,

System.Data.Odbc.OdbcCommand command = new System.Data.Odbc.OdbcCommand(commandText, connection);<br />
            command.Parameters.Add("@ID", SqlDbType.Int);<br />
            command.Parameters["@ID"].Value = myvalue;

Edit - Forgot to mention the wrong parameter name

hendrik14-Feb-09 4:56

14-Feb-09 4:56

Thanks for the fead back i have implemented like you show still
no image gets saved to the blob field

void t(MemoryStream msI)
{
        string query;
	query ="insert into testimage (id_image,pic) values('t', @pic)";
        BinaryReader oReader = new BinaryReader(msI);
        System.Data.Odbc.OdbcCommand  cmd = new System.Data.Odbc.OdbcCommand(query,OdbcCon );
	//cmd.Parameters.AddWithValue("@pic",oReader.ReadBytes((int)msI.Length));
        cmd.Parameters.Add("@pic", System.Data.DbType.Byte);
	cmd.Parameters["@pic"].Value = oReader.ReadBytes((int)msI.Length);
	cmd.Prepare();
        cmd.ExecuteNonQuery();
        MessageBox.Show("Image Added");
}

Note That msI does have a image in it
Thanks any other ideas will help a lot

Re: Mysql problem with inserting a blob [modified]

ABitSmart14-Feb-09 5:10

ABitSmart

14-Feb-09 5:10

hendrik wrote:
cmd.Parameters.Add("@pic", System.Data.DbType.Byte);

That says your trying to store a byte but your data is a byte array

Maybe you can use the ObdbType.Image datatype.

cmd.Parameters.Add("@pic", OdbcType.Image);

Also, MemoryStream can be directly converted to byte array.
byte[] blob = msI.ToArray()

hendrik14-Feb-09 6:37

14-Feb-09 6:37

Thanks have done that as well
no change to outcome

string query;
query ="insert into testimage (id_image,pic) values('t', @pic)";
msI.Position=0;
//BinaryReader oReader = new BinaryReader(msI);
System.Data.Odbc.OdbcCommand  cmd = new System.Data.Odbc.OdbcCommand(query,OdbcCon );
//cmd.Parameters.AddWithValue("@pic",oReader.ReadBytes((int)msI.Length));
cmd.Parameters.Add("@pic",System.Data.Odbc.OdbcType.Image);
//cmd.Parameters["@pic"].Value = oReader.ReadBytes((int)msI.Length);
cmd.Parameters["@pic"].Value = msI.ToArray();
cmd.Prepare();
cmd.ExecuteNonQuery();
MessageBox.Show("Image Added");

thanks again for your help so far

Just for clarification i'm using Mysql as the DB
and sharpdeveloper for my IDE
And using MySQL ODBC 3.51 Driver for the odbc conention

modified on Saturday, February 14, 2009 12:43 PM

Luc Pattyn14-Feb-09 5:17

Luc Pattyn

14-Feb-09 5:17

Hi,

maybe msI is a stream you just filled with some data and forgot to reposition to the beginning of the data?

try adding msI.Position=0;

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

modified on Sunday, June 12, 2011 8:05 AM

Luc Pattyn14-Feb-09 7:44

Luc Pattyn

14-Feb-09 7:44

Hi,

why is your subject line starting with "MySQL" while your code uses ODBC?

the solution to your problem is in this page[^], read all of it!

PS: don't disable statements by commenting them out, it makes your source unreadable.
the purpose of comments is to clarify things, not obfuscate them.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

modified on Sunday, June 12, 2011 8:06 AM

Re: ?

hendrik14-Feb-09 8:39

14-Feb-09 8:39

Thanks working great after replacing named parameter with a ?
and sorry for not putting every thing needed in the subject
line this was my first time posting on the forum

but i would like to as you one more question if you had 2 parameters
that you would wand to put in the same query how would go about doing that

and the commenting of code was done to show the implementation of the previous replays
Big Grin | :-D

Re: ?

Luc Pattyn14-Feb-09 9:53

Luc Pattyn

14-Feb-09 9:53

hendrik wrote:
Thanks

you're welcome.

hendrik wrote:
if you had 2 parameters ...

then I would recommend you read this page[^] twice. Big Grin | :-D

Luc Pattyn [Forum Guidelines] [My Articles]

modified on Sunday, June 12, 2011 8:06 AM

Re: ?

hendrik14-Feb-09 18:26

RTSP/SDP - defining mp3 format?

14-Feb-09 18:26

Luc Pattyn wrote:
then I would recommend you read this page[^] twice. Big Grin

thanks i don't know how i mist that the first time

TableLayoutPanel

Silvyster14-Feb-09 1:33

Silvyster

14-Feb-09 1:33

Hello, I have a problem on the table layout panel control. I wanted to create a program that on run time I could set the table layout panel's number of rows and columns. My Problem is that the spaces of each boxes on the table are not evenly distributed. How do I make it evenly distributed?

Re: TableLayoutPanel

usermans14-Feb-09 2:10

usermans

14-Feb-09 2:10

This code worked fine for columns, it can also be slightly modifed to fit for rows:

tableLayoutPanel1.ColumnStyles.Clear();
int numOfColumns = 4;
tableLayoutPanel1.ColumnCount = numOfColumns;
for (int i = 0; i < numOfColumns ; i++ )
{
	ColumnStyle cStyle = new ColumnStyle();
	cStyle.SizeType = SizeType.Percent;
	cStyle.Width = 100 / numOfColumns;
	tableLayoutPanel1.ColumnStyles.Add(cStyle);
}

Vicer14-Feb-09 1:26

Vicer

14-Feb-09 1:26

Is possible to define mp3 format in SDP protocol ?
In examples i found only definition for various voice comunication or asf/wma format.

DataGridView, Checkbox Column, Sorting [modified]

usermans14-Feb-09 0:59

usermans

14-Feb-09 0:59

Hello, I have a DataGridView on a Windows Form , it has 3 columns, one of them is a CheckboxColumn, the other two columns are set to be automatically sortable.
The problem is that when I sort one of the sortable columns, the selected checkboxes in the CheckBox column are lost..
How can I keep the checked checkboxes checked after performing a sort on another column.

modified on Saturday, February 14, 2009 7:20 AM

Colorizing listview rows according to value

kanchoette14-Feb-09 0:34

kanchoette

14-Feb-09 0:34

If I populate a listview with somethinglike:

foreach (DebtorDataSet.DebtorListRow row in debtorDataSet.DebtorList.Rows)
{
  ListViewItem item = listView.Items.Add(row.Code);
  item.SubItems.Add(name);
  item.SubItems.Add(row.IsPostcodeNull() ? "" : row.Postcode);
  item.SubItems.Add(row.IsTelephoneNull() ? "" : row.Telephone);
}

How can I set the backcolor of a row to red if row.Telephone is null please?

Re: Colorizing listview rows according to value

usermans14-Feb-09 1:35

usermans

14-Feb-09 1:35

Well, The method ListViewItem.SubItems.Add() can take a simple string to create a subitem, but it also can take a ListViewItem.ListViewSubItem object to do the same thing.
So, you can create ListViewItem.ListViewSubItem subitem, set its BackColor property to whatever you want, and then add it to the SubItems collection of your ListViewItem

ListViewItem.ListViewSubItem it1 = new ListViewItem.ListViewSubItem();
it1.BackColor = Color.Red;
item.SubItems.Add(it1);

need help with graphics

Mubeen.asim13-Feb-09 23:59

Mubeen.asim

13-Feb-09 23:59

hello...
my form has a static image like a photo of 100 computers. then my application pings the systems and if the destination is reachable then the corresponding computer must have a green light else a red one.
the problem is that the image has to be the same and only a part of it has to be changed,
i am thinking of doing this with the help of graphics in c# and would be pleased if any other methods work.... thank you .

Re: need help with graphics

Calin Tatar14-Feb-09 2:42

Calin Tatar

14-Feb-09 2:42

yes, you could use GDI+ support from System.Drawing namespace.
please reffer to System.Drawing.Image class[^]

Calin

Re: need help with graphics

Mubeen.asim14-Feb-09 7:55

Mubeen.asim

14-Feb-09 7:55

thank you very much...

How to run WS in Win server 2003

E_Gold13-Feb-09 21:14

E_Gold

13-Feb-09 21:14

hi evryone
how can i run WS in Win server 2003 ?
i need to make virtual directory to put there my WS file
but it give me only make Web to put there my WS file

what can i do ?
i make many WS that work on Win XP and all work excelent, whay in Win 2003
it dosent ?

thank's for any help

Christian Graus13-Feb-09 22:36

Christian Graus

13-Feb-09 22:36

What is WS ?

Christian Graus

Driven to the arms of OSX by Vista.

Eddy Vluggen13-Feb-09 23:32

Eddy Vluggen

13-Feb-09 23:32

I'll bet he means a "website". Been like this since Chris made us pay per character for each post. Text is expensive, so we need to cut down on the length of the messages. Unsure | :~

I are troll Smile | :)

ABitSmart14-Feb-09 0:09

ABitSmart

14-Feb-09 0:09

WS[^]

(I guess so)