|
Can anyone tell me how to store an image from a c# windows form, to a MS SQL Server Database.
I've been struggling with this for some time now - please help me if you can.
Thanks in advice,
Peter
|
|
|
|
|
First, you must convert your image into a bit stream, then save it into a nimage field in your SQL Server.
1. Search about transforming your image into a stream.
2. Search about storing streams into SQL Server.
It's not that hard.
Free your mind...
|
|
|
|
|
I was going along these lines, but part of my problem is that the ways I have seen to do this involve reading the image from a file to put it into a stream, then saving it as an array of bytes. This can then be reversed at the other end.
I need to be able to create a byte-array of a System.Drawing.Image.Bitmap variable, to reduce the overhead of saving the file first. As for storing in the SQL server, I did consider using a web-service which re-constructed the stream before saving in the server - not sure if this is possible.
There is an 'image' data type in MS SQL, and I was hoping it was going to be as easy as doing an INSERT non-query directly from my c# application, but there seems to be serialization issues here because the System.Drawing.Image.Bitmap data tybe does not implement IConvertable (or something like that).
Thanks for your reply - if anyone can help me any further with this problem, I would be MOST grateful.
Thanks
peter 
|
|
|
|
|
Take a look at Bitmap.Save method. You can save it to a memory stream. Then send that memory to the DB.
There is a formatter in the System.Web namespace, named LosFormatter (No documentation), that converts any byte array into a string. You can use it to serialize it into a string, then send it thru the webservice.
I recomend you to use a Store Procedure to store the Image in the DB instead of a direct INSERT.
Free your mind...
|
|
|
|
|
|
Thankyou all for your help - Im a good few steps closer to my solution.
Thanks again,
Peter
|
|
|
|
|
Anybody know how, and if, this can be done?
Thanks in advance.
Kyosa Jamie Nordmeyer - Cho Dan
Portland, Oregon, USA
|
|
|
|
|
You're doing it. The default system.mdw file is used for every database you create.
Create a new workgroup file (mdw) and start access using this mdw file. Each database you create will use this mdw file for user and password info.
Grtz, Guus
|
|
|
|
|
I would like to know if there is a way of reading two excel sheets and comparing the second excel sheet to the first. 
silly widdle wabbit
|
|
|
|
|
You can import Microsoft Exel Object to your application and with that componet you can do exel thins. You can search this site to find articles about it. I don't know which language do you use to give you a link. Also you can get a query from a exel file and interact with them as a table. Look for OpenDataSource in onlinw book for SQL Server.
Mazy
No sig. available now.
|
|
|
|
|
How can i conect to sql server database at web server?
I want to connect to sql server database at web server directly
to allow the user to view and modify the data i know i can use web service to
do that but i want to connect to db directly
how can i do that
thanks i advance.
|
|
|
|
|
In your connection string give a IP of your server instead of computer name.
Mazy
No sig. available now.
|
|
|
|
|
|
Is this on a web page? If the viewstate is off or the list not otherwise repopulated on a page refresh then there won't be anything to select (because ASP.NET is stateless and doesn't retain information from one page request to the next)
If it is in a WinForm application then I have never seen this behaviour.
--Colin Mackay--
EuroCPian Spring 2004 Get Together[^]
|
|
|
|
|
Thanks. I think it was a viewstate problem. Fiddled with a bunch of properties on the control, and it seems to be working fine now. It is a webform.
|
|
|
|
|
I am using this SQL query to insert into an access database using oleDbCommand:
INSERT INTO Events (ID, Code, Hour, Day, Location, Name, Cost) VALUES (0, 'code', '5:05 pm', '11/3/2004', 'loc', 'name', '23.56')
I keep getting an insert error, although when testing the query through Access it works fine. I have tried both using command parameters and hard-coding the data in as it is above, with the same results.
Any suggestions?
|
|
|
|
|
Here is the entire source that I have so far in this section:
ds = New DataSet
myCommand.Fill(ds, "Data")
id = ds.Tables("DATA").Rows.Count()
txtID.Text = id
strQuery = "INSERT INTO Events (ID, Code, Hour, Day, Location, Name, Cost) VALUES (" _
& Int(id) & ", '" _
& txtCode.Text & "', '" _
& txtTime.Text & "', '" _
& txtDate.Text & "', '" _
& txtLocation.Text & "', '" _
& txtName.Text & "', '" _
& txtCost.Text & "')"
cmd = New OleDbCommand(strQuery, myConnection)
cmd.ExecuteNonQuery()
|
|
|
|
|
The ID column, is Autonumeric ?
The Hour and Day Column, what type are they ?
Free your mind...
|
|
|
|
|
ID is standard number. Handling the increment in code.
All other columns are text.
|
|
|
|
|
I don't see nothing wrong with your select statement.
Did you check the size of the fields ?
What's the error description ?
Free your mind...
|
|
|
|
|
Are you repeating a value on a column that is indexed as primary key ?
Free your mind...
|
|
|
|
|
Uhhhm, no. And no. In fact, right now that table is empty. And everything is configured as a text value. I was really hoping it was the SQL, but now it looks like maybe the code itself. Or something else. Funny thing. That exact same code (with different fields and parameters) works perfectly in the same database, different table.
I'll have to look at it more thoroughly, I guess.
Thanks
|
|
|
|
|
One possibility is that Access requires literal date data to be set off by #, as in #11/03/2004#. This may apply to time values, as well, though Clippy won't tell me that no matter how hard I ask.
"Another day done - All targets met; all systems fully operational; all customers satisfied; all staff keen and well motivated; all pigs fed and ready to fly" - Jennie A.
|
|
|
|
|
Do you have a specific error message?
What is the schema definition of the Events table? (what are the field types and sizes for each field in the table)
Any identity/autogenerated columns? Is there primary key defined?
|
|
|
|
|
How can I get a list of tables from a SQL server database so that I can then display the list in a Repeater or DataList control? I would also like to get the Table Description property. My ultimate goal is to display my lookup tables (all begin with zlk) with hyperlinks that open forms for maintaining these tables.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
