|
The Image data type is just an array of bytes. In C# you need to get a byte array version of your image and assign this to a paramter in your SqlCommand object.
|
|
|
|
|
What im trying to do is use the OnPaint Method to draw graphics such as a oval in a panel and not in the default form.
Is this possible? Thanks
Thomas
|
|
|
|
|
Handle the paint event for the Panel. To make it easier, derive a class from Panel, so it's all in one spot, outside the form ( for re-use ).
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Thanks for your help!!! It helped me fix my problem.
It was a very easy fix and not sure why I missed it:
//what I had
Graphics g = CreateGraphics();
//What I Changed
Graphics g = world.CreateGraphics();
Thanks again for your help!
|
|
|
|
|
I'm having troubles in my aspx.cs page, I think...
Anyways, in a button_Click method in my aspx.cs page I have this code...
ViewState["isSubmitted"]="true";
However, when I click the button, the value doesn't get saved.../?! Well, at least I dont' think so. I read the isSubmitted value in my Form_Load method..
string str=(string)ViewState["isSubmitted"];
So, here's the deal. When my page runs I click the button, but the value isn't set to true, but then once I click it again, it is saved to true.
WHY?
/\ |_ E X E GG
|
|
|
|
|
Events happen between page_load and page_prerender, so this value has not been stored when you are reading it.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hmm... WEll, I still want my ViewState value to be saved when the user clicks the button, and I want it to be displayed sometime (I don't care if it's in page_load, i just chose it..), where should I put the code to read the ViewState?
/\ |_ E X E GG
|
|
|
|
|
Well, for what you're doing I think you need to overload LoadViewSTate and SaveViewSTate as well, if you want it to persist between pages.
Either way, you can read it anywhere, so long as it's there, and it's not there when you actually click it until the prerender event.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
SO I can access my viewstate property that I set in my button_click after the follwing prerender event?
Ok, what would you do if you wanted to save a value in the view state after a button is clicked and then subsequently display it on the page?
Uverloading those methods sounds like overkill just to do what i'm doing...
/\ |_ E X E GG
|
|
|
|
|
eggie5 wrote: SO I can access my viewstate property that I set in my button_click after the follwing prerender event?
No - the prerender event fires AFTER the click event.
eggie5 wrote: Ok, what would you do if you wanted to save a value in the view state after a button is clicked and then subsequently display it on the page?
If I wanted it to be displayed just on that postback, I'd store it in a member variable, and do the drawing in prerender ( where it belongs ). If I wanted to persist it, I would probably use viewstate.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hi all,
Just a quick query in relation to dependent assemblies, specifically AxInterop.SHDocVw.dll and Interop.SHDocVw.dll as required for this project: http://www.codeproject.com/cs/miscctrl/WebBrowserEx.asp
I'm developing a small piece of software for a local client that requires the MS Web Browser ActiveX control embedded within a particular form. As these DLLs are OS dependent, I'm concerned that my compiled C# program will not work correctly on their machines. The way I see it, I have to provide these two DLLs, otherwise the software generates an "Assembly not found" exception. But if I provide them, they are suited to my OS only.
If the client upgrades their OS without telling me, or a servicepack is automatically deployed, or their version of .NET is upgraded, could this break my software?
If so, what is the best way of getting around this, or at least mitigating the problem to some degree? It's not possible to compile the program on each and every one of his machines, and i only want to distribute the binaries.
Any thoughts would be much appreciated.
Regards,
Ritchie
andrewpritchie(at)gmail.com
|
|
|
|
|
Whats wrong with this picture? I keep getting this error and I"m sure it's because of the image I'm trying to pull out. Never was good are arrays....
public class PictureData
{
public int ID;
public String name;
public byte[] data;
public String contenttype;
}
public PictureData GetPrictureDetails(int ID)
{
SqlConnection myConnection = new SqlConnection(SqlHelper.ConnectionString);
SqlCommand myCommand = new SqlCommand("GetPictures", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter parameterID = new SqlParameter("@ID", SqlDbType.Int, 4);
parameterID.Value = ID;
myCommand.Parameters.Add(parameterID);
SqlParameter parametername = new SqlParameter("@name", SqlDbType.VarChar, 50);
parametername.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(parametername);
SqlParameter parameterdata = new SqlParameter("@data", SqlDbType.Image, 16);
parameterdata.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(parameterdata);
SqlParameter parametercontenttype = new SqlParameter("@contenttype", SqlDbType.VarChar, 50);
parametercontenttype.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(parametercontenttype);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
PictureData myPictureData = new PictureData();
myPictureData.ID = (int)parameterID.Value;
myPictureData.name = (string)parametername.Value;
myPictureData.data= (byte[])parameterdata.Value;
myPictureData.contenttype = (string) parametercontenttype.Value;
return myPictureData;
}
so so lost lol
|
|
|
|
|
Judy101101 wrote: I keep getting this error
What error are you getting ? In those code, or when you try to turn the byte[] into an actual image ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
yes thats the idea I'm using the:
Response.BinaryWrite (myPictureData.data);
|
|
|
|
|
Having written the content type also ? What error are you getting ? Have you tried this code to load an image in a WinForms app, into a Bitmap and display it ? Then you can be sure that the Bitmap is coming out OK without worrying about sending data to a browser.
Bitmap.FromStream is what you want, passing the bytes in via a stream.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I have never pulled an image out of a database. I don't know what a winforms app is? can I use that in C# webform? It's all new to me.
|
|
|
|
|
OK
A winforms app is an app in .NET that makes a windows application instead of a web one. If that's hard for you right now, then perhaps it's an unnecessary diversion. You could perhaps try something like this:
System.IO.MemoryStream ms = new System.IO.MemoryStream(picture.Data);
System.Drawing.Bitmap bmp = System.Drawing.Bitmap.FromStream(ms) as Bitmap;
bmp.Save(@"c:\test.jpg");
which, assuming your data is meant to be a jpg, should save it to disc. If it does, then your class is reading the image fine. picture.Data is meant to be whatever your class instance is, and it's property for the byte[].
At this point I still have no idea what your trouble is. You started by saying you get an error, and you've still not told me what it is.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
ok my reply was dumb, haven't used windows applications at all. lol did I mention I was blond? I think I have to do the Response.BinaryWrite thing. the error I get is
System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
|
|
|
|
|
OK - at that level it looks like your code is not getting to the point of pulling the data from the database. Do you know what line is causing the error ? Do you know how to set breakpoints and step through your code ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
this is my code in pageload:
int ID = 1;
picDB myPic = new picDB();
picDB.PictureData myPictureData = myPic.GetPrictureDetails(ID);
Response.ContentType = myPictureData.contenttype;
Response.BinaryWrite (myPictureData.data);
I get this one error :
General network error. Check your network documentation. that one comes and goes with this same problem. read up on it and it's just a strange thing and stops at my
myCommand.ExecuteNonQuery();
the other error happens at the same point:
A severe error occurred on the current command. The results, if any, should be discarded.
|
|
|
|
|
Judy101101 wrote: GetPrictureDetails
You know there's a typo here, right ?
Judy101101 wrote: myCommand.ExecuteNonQuery();
It looks to me like your problem is connecting to the database.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
here is my stored procedure, I don't think there is anything wrong with it, but never worked with images before
CREATE PROCEDURE GetPictures
@ID int,
@name varchar OUTPUT,
@data image OUTPUT,
@contenttype varchar OUTPUT
AS
SELECT
img_name = @name ,
img_data = @data,
img_contenttype = @contenttype
FROM Image
WHERE
img_pk = @ID
GO
|
|
|
|
|
Here[^] is an article on saving/loading images in SQL Server and C#.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hi...
Close the database connection after you fill myPictureData...
<br />
myConnection.Open();<br />
myCommand.ExecuteNonQuery();<br />
<br />
PictureData myPictureData = new PictureData();<br />
<br />
myPictureData.ID = (int)parameterID.Value;<br />
myPictureData.name = (string)parametername.Value;<br />
myPictureData.data= (byte[])parameterdata.Value;<br />
myPictureData.contenttype = (string) parametercontenttype.Value;<br />
<br />
myConnection.Close();<br />
<br />
return myPictureData;
Free your mind...
|
|
|
|
|
Exactly what error are you getting? Nothing in your code is jumping out at me. The only thing I see that looks like a problem is that your accessing the parameter values after you have closed the connection.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
