|
hi vikas,
you can create image type field in database and store byte array into this field.Simple follow these steps
1. first of all i assume PictureBox1 hold the picture data. So use following statement
Dim PictureBox1Data As Byte()<br />
If PictureBox1.Image Is Nothing Then<br />
PictureBox1Data = Nothing<br />
Else<br />
PictureBox1Data = imageToByteArray(PictureBox1.Image)'See below this function<br />
End If
2.Now write the SQL query as following
Dim QueryText As String<br />
Dim QueryValue As String<br />
Dim command As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand()<br />
QueryText = "INSERT INTO Settings(PrintCompany,IsUploadLogo,LogoGraphic )"<br />
QueryValue = "Values(@PrintCompany, @IsUploadLogo,@LogoGraphic)"<br />
command.CommandText = QueryText & QueryValue
3. Supply Value to parameter which is in above query, as following
command.Parameters.Add("@PrintCompany", SqlDbType.TinyInt, 10).Value = True<br />
command.Parameters.Add("@IsUploadLogo", SqlDbType.TinyInt, 10).Value =True<br />
If Not PictureBox1Data Is Nothing Then<br />
command.Parameters.Add("@LogoGraphic", SqlDbType.Image, PictureBox1Data.Length).Value = PictureBox1Data<br />
Else<br />
command.Parameters.Add("@LogoGraphic", SqlDbType.Image, 0).Value = System.DBNull.Value<br />
End If
4. Execute query as following
command.ExecuteNonQuery()
step 1 to 4 read data of picture box,convert them byte array and store in related table.Step 1 use following function to convert an image into byte array
Public Function imageToByteArray(ByVal ImageIn As System.Drawing.Image) As Byte()<br />
Dim ms As MemoryStream = New MemoryStream()<br />
Dim FormatImage1 As Imaging.ImageFormat = ImageIn.RawFormat<br />
ImageIn.Save(ms, FormatImage1)<br />
'ImageIn.Save(ms, Imaging.ImageFormat.Bmp)<br />
Return ms.ToArray()<br />
End Function
hope this helps
|
|
|
|
|
hi we R Using to Insert query to store imaga data
in Vb.NET
Means Something Like
insert into EmployeeTable(EmployeeID,Emp_Name,Address,Cell#,Image)
But there is an Error in concatination to Byte Type
The Data for image Is Byte Type How we can Manage The Query In case
and Im Database Field's DataType is Image,
It has to Store Binay Data
and I dont Want to Use
"command.Parameters.Add"
this way Plz Can U Help
|
|
|
|
|
Hi
I want to insert images in database (SQL Server 2005) Through VB.NET (Visula Studio 2005)
I m using Insert Query for this Purpose Means Somethink Like
Insert into EmployeeTable(EmployeeID,EmployeeName,EmployeeAddrress,EmloyeeContact#,EmployeeImage) Values (EmployeeID,Name,Address,Contact,Image)
But Here is a problem image data is Byte Type
and it is not concatenated in the Query Becoz Query Develops a string
this is the problem
And Can U please tell me the Proper way to Store and retrieve Image through programming
in VB.NET and i dont want to Use stored procedures for that purpose and
Also Don't want to Use "command.Parameters.Add" ethos Plz Provide any Other Solution
I m using
Datareader instead of Dataset
thanks and regards,
Amna
|
|
|
|
|
Hi guys ,
i am sorry if i am asking an irrelevent question.
actually i am looking for crack of telerik control toolkit for windows applicaiton , any one can help me , thanks in advance .
Tauseef A Khan
MCP Dotnet framework 2.0.
|
|
|
|
|
Let's see. You come to a site where developers, who work hard writing code for a living and are pouring their time and money into various projects, hoping to get some renumeration back, and ask them to crack some other developers code open for you, stealing it from that developer. ARE YOU OUT OF YOUR FRICKIN' MIND!?!?!?! 
Ballsy. Real ballsy.
|
|
|
|
|
Dont get angry, I am not stealing , being a developer i am just asking a developer to help me via allowing me to use his\her product without money.
Tauseef A Khan
MCP Dotnet framework 2.0.
|
|
|
|
|
ghumman63 wrote: being a developer i am just asking a developer to help me via allowing me to use his\her product without money
In the real world we call that stealing. Don't know where you live but you seriously need a wakeup call.
ghumman63 wrote: I am not stealing
YES YOU ARE!
|
|
|
|
|
there is nothing bad with that , i do allow my fellows to use my products without purchasing license ,and i think its humanity and ethics.
Tauseef A Khan
MCP Dotnet framework 2.0.
|
|
|
|
|
ghumman63 wrote: there is nothing bad with tha
There is, telerik doesn't allow you to use there products for free, even not for own use, so doing so or trying to do so is WRONG.
ghumman63 wrote: i do allow my fellows to use my products without purchasing license
If you want to give out your work for free that's your business, but when doing so you can only use products that are free as well(or that you payed for).
Really crawl from under that rock that you live under and wake up. Using a payable product for free (or trying too) is stealing. I guess next thing you'll say is that downloading movies or games or music or software (payable software) or ... ,without paying for it, is also not stealing.
I don't know what you do for a living but I'm sure that you get payed for it, how would you feel if your boss came up to you telling you that you have to work for free.
Now stop trying to defend your position nobody here will agree with you, you are stealing from a fellow developer and that's unacceptable.
|
|
|
|
|
ghumman63 wrote: i do allow my fellows to use my products without purchasing license
That is your business. If Telerik wanted to give away their software for free to you then that would be fine. As it is, Telerik are in the business to make money and to do that people have to pay them for the software. That includes you.
|
|
|
|
|
ghumman63 wrote: Dont get angry, I am not stealing
Yes, you are stealing. And I'm not just angry. I'm f*cking FUMING at the audacity of such a statement that software theft is not stealing.
ghumman63 wrote: being a developer i am just asking a developer to help me via allowing me to use his\her product without money.
No, you are not. You are asking a third party (other developers) to assist you in breaking the protection built into a piece of software. You are not asking Telerik who are the only people on this earth who can legally give you what you want. i.e. A free license to their software.
|
|
|
|
|
ghumman63 wrote: i am looking for crack of telerik control toolkit for windows applicaiton
You putrid piece of scum, I work damned hard to ensure that I can earn money from developing software. For that to happen people need to pay me money for the software that I write. With that money I can then afford to put food on my table and a roof over my head. Meanwhile, you are looking for a crack for commercial software so that you don't have to pay the hard working developers who spent a lot of time creating those products.
That, you disgusting rancid pustule of humanity, is called theft. You are stealing from hard working developers. Stealing the very food from their children's mouths.
|
|
|
|
|
Ditto. It's incredibly hard to make good software these days that doesn't get ripped off. Ghumman63 is a low life for even asking this question.
I think there should be a site wide rule that if someone asks to for serial keys, warez, hacks, etc.....they should automatically be banned without question. Put that restriction very clearly on the registration page and if it happens, boot them without mercy.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
I thought this "question" sounded familiar. You asked this very same thing back in August and got the same answer. Did you really think the answer ws going to change??
|
|
|
|
|
Wow! So he did[^]. It seems that the response he got then wasn't enough. I wonder if everyone wading in today will convince him... Probably not, but one can only live in hope I suppose.
|
|
|
|
|
Chris Maunder ("How to get your question answered wrote:
8. Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
11. We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.
Subject is inappropriate and illegal. Delete the posts and enforce the ban.
My 2 cents worth (which is currently worth .014052 euros).
Cheers!
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Check out my next reply to him...
|
|
|
|
|
ahhahhahahaha.....nice.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Here's another idea. Why don't you call Telerik and ask them for the crack? I guarantee that they have at least one.
|
|
|
|
|
5 words. This guy is an idiot! My vote for banishment. 
How many bytes of text have I typed in my lifetime??? Man, I wish I kept track...
|
|
|
|
|
Banishment! Take the walk of shame and never come back!
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Hello Everyone,
I have a file access question that hopefully one of you can help me out with. I'm doing a WEB project where I have to access a text file that is located inside a password protected zip folder. First what I want to know is if someone can point me in the right direction as far as reading the file programmatically with VB.NET. I know how to access the file if it wasn't in a zipped folder and password protected (yes I do have the password, nothing malicious going on).
Second, if I'm unable to go to the ftp address and and see the file that way, does someone know how I can get started on logging in to the directory, unzipping the folder, and downloading it to my web directory through the VB.NET code behind. This is a web app where I need to access a tab-delimited text file and display the data and possibly insert it into a DB.
Thanks for any help!
|
|
|
|
|
There's zip libraries you can buy, perhaps some of those support passworded zips. Otherwise, I'd look at if winzip takes a command line with a password.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
For the extraction of a password zip file, check out DotNetZip. Free, open source, the examples are pretty decent, and Cheeso maintains it well. Pretty good utility for zip files under 2/4 gigs in size (max size dependent on CPU type).
All_Beagle wrote: Second, if I'm unable to go to the ftp address and and see the file that way, does someone know how I can get started on logging in to the directory, unzipping the folder, and downloading it to my web directory through the VB.NET code behind. This is a web app where I need to access a tab-delimited text file and display the data and possibly insert it into a DB.
If you do not have direct access to the directory and you need to use FTP, I think you'll have to download the file and then extract it since there aren't native commands for FTP to unzip files. Do a code project or google search for endless examples on how to FTP.....not that difficult to implement.
Cheers!
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
As of February 2009, DotNetZip works with ZIP files above 4g in size. Get v1.7 or later.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
