VB (5or6) Does Something Wierd With Image Data While Saving To Sql2000
Apr 27, 2006
Vb stores an image (bitmap/jpg) in a SQL2000 image field. For some
reason it doubles the size by adding 00 for each byte. But sometimes it
doesn't add 00 (0000.0000) but 01 or 20 or ?? and also the byte that
should be transferd is changed...
So SQLImageData = Imagebyte + 00
and sometimes
SQLImageData = CHANGEDImagebyte + xx.
Hi, Does anyone know how to deal with image data type within stored procedure when using SQL2000? I have a table and there is an image data type column. In this table I need to make a copy of one row within a table through a SP /it means to retrieve the whole row within SP, change another columns data (but, that the image is not modified) / and save the modified row back to the same table. Problem is, that within SP is not alowed to use local varaibles of image data type. Does anyone know a solution for this? Please. Thank you.
Hi i am using textcopy to store image (named as mypic.jpg) in image column. But i am getting error : text or image pointer and timestamp retrieval failed
I guess this is bacause of image size ... The default image column length is 16. I tried changing it but it's not changing and Books Online shows that the image column can store max upto 2 GB.
I just want to know also how to change that size to say 100kb?????
Using: Compact Framework 1.0 and SQL Server CE 2.0
i want to save an image to my sql server ce 2.0 database on the device. In the Compact Framework 1.0 the Image class does not have .FromStream method, and the PictureBox class does not .Save method.
Has anyone done this before in SQL CE 2.0 and CF1.0
well, i'm using vs2005 and sql server 2000.i've got this snippet for uploading an image and creating itz thumbnail and also saving the thumbnail and the original image in a folder.but i also want the path of the image and the thumbnail to be stored in sql 2000 database, instead of saving the images in sql.can some one plz provide me the way.thanx in advance.-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click' Initialize variablesDim sSavePath As StringDim sThumbExtension As StringDim intThumbWidth As IntegerDim intThumbHeight As Integer' Set constant valuessSavePath = ".Image"sThumbExtension = "_thumb"intThumbWidth = 160intThumbHeight = 120' If file field isn’t emptyIf Not fileUpEx.PostedFile Is Nothing Then' Check file size (mustn’t be 0)Dim myFile As HttpPostedFile = fileUpEx.PostedFileDim nFileLen As Integer = myFile.ContentLengthIf nFileLen = 0 ThenlblStatus.Text = "No file was uploaded."ReturnEnd If' Check file extension (It must be .JPG)If System.IO.Path.GetExtension(myFile.FileName).ToLower() = ".jpg" Then' Read file into a data streamDim myData() As Byte = New Byte(nFileLen) {}myFile.InputStream.Read(myData, 0, nFileLen)' Make sure a duplicate file doesn’t exist. If it does, keep on appending an ' incremental numeric until it is uniqueDim sFilename As String = System.IO.Path.GetFileName(myFile.FileName)Dim file_append As Integer = 0While System.IO.File.Exists(Server.MapPath(sSavePath + sFilename))file_append = file_append + 1sFilename = System.IO.Path.GetFileNameWithoutExtension(myFile.FileName) + file_append.ToString() + ".jpg"End While' Save the stream to diskDim NewFile As System.IO.FileStream = New System.IO.FileStream(Server.MapPath(sSavePath + sFilename), System.IO.FileMode.Create)NewFile.Write(myData, 0, myData.Length)NewFile.Close()' Check whether the file is really a JPEG by opening itDim myCallBack As System.Drawing.Image.GetThumbnailImageAbort = New System.Drawing.Image.GetThumbnailImageAbort(AddressOf ThumbnailCallback)Dim myBitmap As Drawing.BitmapTrymyBitmap = New Drawing.Bitmap(Server.MapPath(sSavePath + sFilename))' If jpg file is a jpeg, create a thumbnail filename that is unique.file_append = 0Dim sThumbFile As String = System.IO.Path.GetFileNameWithoutExtension(myFile.FileName) + sThumbExtension + ".jpg"While System.IO.File.Exists(Server.MapPath(sSavePath + sThumbFile))file_append = file_append + 1sThumbFile = System.IO.Path.GetFileNameWithoutExtension(myFile.FileName) + file_append.ToString + sThumbExtension + ".jpg"End While' Save thumbnail and output it onto the webpageDim myThumbnail As System.Drawing.Image = myBitmap.GetThumbnailImage(intThumbWidth, intThumbHeight, myCallBack, IntPtr.Zero)myThumbnail.Save(Server.MapPath(sSavePath + sThumbFile))imgPicture.ImageUrl = sSavePath + sThumbFile' Displaying success informationlblStatus.Text = "Image uploaded successfully!"' Destroy objectsmyThumbnail.Dispose()myBitmap.Dispose()Catch errArgument As ArgumentExceptionSystem.IO.File.Delete(Server.MapPath(sSavePath + sFilename))End TryElselblStatus.Text = "The file must have an extension of JPG or GIF"ReturnEnd If End SubPublic Function ThumbnailCallback() As BooleanReturn FalseEnd Function
I am trying to store about millions of pictures in Web server with lots of traffic. some poeple told me. SQL server cannot handle it and may freeze quickly. can anybody tell me which way is better and more efficent? store image in SQL server image field or store in server's harddrive?
I am really hoping there is someone out there with the answer to my problems??
I need to save customer signatures to our SQL DB and then display them on a Crystal Report. The problem is that the client uses Crystal v6. I am saving the image to an Image field using an ADO rs on a VB6 application. It saves fine and will read back fine. Crystal however has a problem and throws an error "Not Supported".(Later versions of Crystal erad the images fine)
Northwind Database has a Table 'Categories' which as images that crystal v6 is able to display. As of yet I have been unable to save images in this format. I have tried .bmp,.jpg ...... I have also tried appendChunk..
All the images on Northwind start with '0x151C2...'
can some one help me. im using visual studio.net 2005. its a web application.i have a database with attribute name logo. so i want to upload an image and save it into the database and than display it into the image box to preview how the image looks like.can some one please help me as i am very new in using C# codes and visual studio.net 2005
I am using asp.net+sql server 2000 to upload a image to database.the wired thing is, if I upload images from some folder like my documents/my pictures, the error message like 'String or binary data would be truncated' will be there and fail to upload. but I move those images to another folder like c: emp and then upload again, it works fine. any ideas? thanks a lot.
I would like to retrieve and view .jpg pictures that have been stored in a Data Type "image", Length "16", SQL2000 field. Any ideas on "How to......." Thanks alot and enjoy HandyMac
When i click upload image button when my database table has no any row, the selected image is saved(one row saved in table). If i continue and select a different image, i get no error sa if the image has been saved but when i view the images i have been saving, its strange even if i saved 10 records they all contain the first image that i saved. In short only the first image is saved the rest of the rows are just duplicates of the first row. so it basically becomes a table of ten rows but with same data rows(same image). Code is below. Protected Sub btnupload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Dim intLength As Integer Dim arrContent As Byte() If FileUpload.PostedFile Is Nothing Then Lblstatus.Text = "No file specified." Exit Sub Else Dim fileName As String = FileUpload.PostedFile.FileName Dim ext As String = fileName.Substring(fileName.LastIndexOf(".")) ext = ext.ToLower Dim imgType = FileUpload.PostedFile.ContentType If ext = ".jpg" Then ElseIf ext = ".bmp" Then ElseIf ext = ".gif" Then ElseIf ext = "jpg" Then ElseIf ext = "bmp" Then ElseIf ext = "gif" Then Else Lblstatus.Text = "Only gif, bmp, or jpg format files supported." Exit Sub End If intLength = Convert.ToInt32(FileUpload.PostedFile.InputStream.Length) ReDim arrContent(intLength) FileUpload.PostedFile.InputStream.Read(arrContent, 0, intLength) If Doc2SQLServer(txtTitle.Text.Trim, arrContent, intLength, imgType) = True Then Lblstatus.Text = "Image uploaded successfully." Else Lblstatus.Text = "An error occured while uploading Image... Please try again." End If End If End Sub Protected Function Doc2SQLServer(ByVal title As String, ByVal Content As Byte(), ByVal Length As Integer, ByVal strType As String) As Boolean Try Dim cnn As Data.SqlClient.SqlConnection Dim cmd As Data.SqlClient.SqlCommand Dim param As Data.SqlClient.SqlParameter Dim strSQL As String strSQL = "Insert Into Images(imgData,imgTitle,imgType,imgLength,incident_id) Values(@content,@title,@type,@length,@incident_id)" Dim connString As String = "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|safetydata.mdf;Integrated Security=True;User Instance=True" cnn = New Data.SqlClient.SqlConnection(connString) cmd = New Data.SqlClient.SqlCommand(strSQL, cnn) param = New Data.SqlClient.SqlParameter("@content", Data.SqlDbType.Image) param.Value = Content 'cmd.Parameters.AddWithValue(param) cmd.Parameters.AddWithValue("@content", Content)
param = New Data.SqlClient.SqlParameter("@title", Data.SqlDbType.VarChar) param.Value = title cmd.Parameters.Add(param) param = New Data.SqlClient.SqlParameter("@type", Data.SqlDbType.VarChar) param.Value = strType cmd.Parameters.Add(param) param = New Data.SqlClient.SqlParameter("@length", Data.SqlDbType.BigInt) param.Value = Length cmd.Parameters.Add(param) cmd.Parameters.AddWithValue("@incident_id", id.Text) cnn.Open() cmd.ExecuteNonQuery() cnn.Close() Return True Catch ex As Exception Return False End Try End Function
I am using the 3-tiered architecture design (presentation, business laws, and data acess layers). I am stuck on how to send the image the user selects in the upload file control to the BLL and then to the DAL because the DAL does all the inserts into the database. I would like to be able to check the file type in the BLL to make sure the file being uploaded is indeed a picture. Is there a way I can send the location of the file to the BLL, check the filetype, then upload the file and have the DAL insert the image into the database? I have seen examples where people use streams to upload the file directly from their presentation layer, but I would like to keep everything seperated in the three classes if possible. I also wasn't sure what variable type the image would be in the function in the BLL that receive the image from the PL. If there are any examples or tips anyone can give me that would be appreciated.
I am wondering if it is possible to use SSIS to sample data set to training set and test set directly to my data mining models without saving them somewhere as occupying too much space? Really need guidance for that.
"pRecordSet" is an ADO recordset. The database column "MyColumn" is of type "decimal(19,10)".
The most important question for me is, if the regional settings of the database server or the regional settings of the client PC are considered during the conversion from the string to the decimal value. For example in standard French regional settings the "." would not be recognized as decimal separator.
I am also wondering if the language of the database instance, in which this data is saved, is considered during this conversion or any other settings of this database instance.
So my general question is: Does anybody know exactly what rules apply during the above mentioned conversion?
I am trying to automate a basic task using SQL Server 2005 Express.
Currently I have a query script that I run and then save the results as a CSV file. I need to do this on a daily basis and so I am looking to find out how best to go about this. There are a multitude of third party tools that claim to be able to do this - can anyone recommend this or enlighten me of the best way to set up this automation.
Hi,There are 3 tablesTable,TableDetails,TableDaily.With structureTABLE:TableID UserID Money---------- ---------- ----------(int) (int) (money)TABLEDETAILS:TableDetailsID TableID ItemID PaidForItem DayID---------- ---------- ---------- ---------- ----------(int) (int) (int) (money) (int)TABLEDAILY:TableDailyID TableID PaidForItem Money Total Change---------- ---------- ---------- ---------- ---------- ----------(int) (int) (money) (money) (PaidForItem + Money) (money)"Table" holds id for user and his money amount, which changes during time. "TableDetails" holds data about items user bought, amount paid for them and dayid which relates to one particular day."TableDaily" holds history. I do not know how to update this table.I created job whish runs stored procedure. This procedure sums "PaidForItem" using group by TableID and WHERE DAYID = '11'.Problem is with Change column. This column sould hold difference between today's Total and previous one etc.Current procedure looks like this:INSERT INTO TableDaily (TableID, PaidForItem, Money, DayID)SELECT TableDetails.TableID, SUM(PaidForItem) AS PaidForItem, Table.Money, (SELECT DayID FROM Days WHERE (Aktive = 1)) AS DayIDFROM TableDetails INNER JOIN Table ON TableDetails.TableID = Table.TableID GROUP BY TableDetails.TableID, Table.Money
Hi I’m making a very primitive shopping cart. I’ve created a table containing a list of products and using an SQLdataSource with a GridView I’ve got the products displayed – simple. What I now need is to add a button with an Insert command, but the SQL needs to add a row of data to a different table – tblShoppingBasket. I’ve tried adding in the insert command and changing the SQL but it doesn’t add a new record, although is also doesn’t through and error. The second part of the problem is need to pass the productID from the row they selected (pressed the button that triggered the insert command) and add this to the shoppingBasket table via the insert SQL. I’d really be grateful for any help (code below). ThanksRichard <asp:SqlDataSource ID="SqlDataSource_GenralProducts" runat="server" ConnectionString="<%$ ConnectionStrings:AquilaConnectionString %>" SelectCommand="SELECT * FROM [tblProducts] WHERE ([productAgeGroup] = @productAgeGroup)" InsertCommand="INSERT INTO [tblShoppingBasket] ([userID], [productID]) VALUES (@userID, @productID)"> <SelectParameters> <asp:Parameter DefaultValue="3" Name="productAgeGroup" Type="Int32" /> </SelectParameters> <InsertParameters> <asp:Parameter Name="userID" Type="Object" DefaultValue="123"/> <asp:Parameter Name="productID" Type="Int32" /> </InsertParameters> </asp:SqlDataSource> <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" DataKeyNames="productsID" DataSourceID="SqlDataSource_GenralProducts"> <Columns> <asp:ImageField DataImageUrlField="productThumbNail" DataImageUrlFormatString="../images/shop/thumbNails/{0}"> </asp:ImageField> <asp:BoundField DataField="productLabel" HeaderText="Product:" SortExpression="productLabel" /> <asp:BoundField DataField="productDescription" HeaderText="Description:" SortExpression="productDescription" /> <asp:BoundField DataField="productCost" HeaderText="Cost:" SortExpression="productCost" /> <asp:ButtonField ButtonType="Button" CommandName="insert" Text="Add to Shopping Basket" /> </Columns> </asp:GridView>
Im using MS visual web developer. I have created a website and used the database they set up by using admin tools. One page requires the take the users comment and to save it into the database. I've tried a formview and connected it to the database which worked. the problem is i cannot save whatever the user types into the textbox. {insert query didnt work with this set up }INSERT INTO aspnet_Membership(Comment) VALUES ('CommentTextBox.Text') Error: cannot set userId or to null. and if i make it allow nulls its going to move on to the next column. I would appreciate some help please. Thank you in advance.
Here is a structure of my table create table events( event_id integer primary key identity(1,1), event_name varchar(200), event_date datetime,) Note: The event_id is a automacally and we don't need to insert record in this field. for example i have inserted 10 records in a table then i deleted all records manually from sql server but when again I save the record the event_id field shows started from 11 even the table was empty, although it should be start from 1?
Hello all ... I am facing a problem in the evaluation form that I am working on ... I have 3 textboxes which are Trainee ID, Trainee Name and Trainee Department I want the Trainee ID to be saved in the Evauaiton form , The trainee id is a foregin key in the Evaluation table in my SQL table, it is coming from the trainee table where the Trainee ID is primary key and it is incremneting ... I want the same Trainee Id to be sent to both Trainee and evaluation table , but at the same time , i want whenever a user open the evaualtion form an id will be shown and it will be inccremented ...
Hope that is clear ... How I can solve this problem?
Hi there, I have a web page (Visual Studio 2005, Asp.net 2.0) that has a series of textboxes and dropdownlists on it. I want people to be able to enter their information and click submit. When they click the submit button I want their information to save to a Sql Server 2005 database. I am having a lot of trouble finding any information on this topic. If someone could give me some sample code I would really appreciate it. Thanks
Hi Every one I m using FCKeditor in my web application and my requirement is to create and edit documents in FCKeditor. The problem is in storing the data. it is not storing the data in the DB. its only stors some html code but it is incomplete. Please some one Solve this problem
Heres my requirement from a financial analysis im doing...I have just calculated an industry averages on financial ratios...Now i wanna upload this industry average to the system...so that I can compare it to the individual companies' averages after calculating a particular company's average; meaning i wanna be able to call the industry average of a particular ratio (eg Current Ratio) after calculating a company's corresponding ratio...Is there a code fragment i can use for this ?? Thanks in advance...Adam
Hi, I have a problem. The thing is that when I enter the values in a text boxes like evendate.text = "02/11/07" and desc.text="hello how r u" then I click on Save Button and its save in the SQL DATABASE but after this if I click on Refresh Button every time from the internet Explorer its automatically again save the data in the database although I have empty the textboxes. The code is below: <script runat="server"> sub SaveEvent(sender as object, e as EventArgs) dim con as new SQLConnection("server=london-home; Database=tony; uid=rashid2; pwd=test; ") dim cmd as new SQLCommand("insert into events values('" & desc.text & "','" & DateTime.Parse(eventdate.text) & "')",con) con.open() cmd.executenonquery() con.close() clearform() display() end sub sub display() dim con as new SQLConnection("server=london-home; Database=tony; uid=rashid2; pwd=test; ") dim cmd as new SQLCommand("select * from events",con) con.open() dim SDR as SQLDataReader SDR = cmd.ExecuteReader() if SDR.HasRows = true then ViewEvents.DataSource = SDR ViewEvents.DataBind() end if con.close() end sub sub clearform() eventdate.text="" desc.text="" end sub sub Reset(sender as object, e as EventArgs) clearform() end sub</script> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Untitled Document</title> <style type="text/css"> #display_prod{float:left;} #prod{margin-top:0;} </style> </head><body> <table border="1" align="center" cellpadding="5" cellspacing="0"><tr><td valign="top"> <form id="prod" runat="server" enctype="multipart/form-data"><table id="display_prod" width="554" border="1" cellspacing="0" cellpadding="0" align="left" height="400"> <tr valign="top" height="20"> <td> </td> <td> <table border="1" align="center" cellpadding="10" cellspacing="0"> <tr> <td>PRODUCTS DESCRIPTION <asp:Label runat="server" ID="lbl"></asp:Label></td> </tr> </table> </td> </tr> <tr valign="top"> <td> <table align="left" id="menu" width="150" border="1" cellpadding="0" cellspacing="0"> <tr align="center"> <td><a href="home.aspx">Main</a></td> </tr> <tr align="center"> <td><a href="Events.aspx">Change Password</a></td> </tr> <tr align="center"> <td><a href="events.aspx">Events</a></td> </tr> </table> </td> <td align="left"> <table width="390" border="1" cellpadding="0" cellspacing="0"> <tr> <td width="100" >Enter Date :</td> <td width="243" ><asp:TextBox runat="server" ID="eventdate" BackColor="#FFFFFF" Width="100"></asp:TextBox> mm/dd/yy</td> </tr> <tr> <td>Description :</td> <td><asp:TextBox runat="server" ID="desc" TextMode="MultiLine" Columns="20" Rows="3" BackColor="#FFFFFF" MaxLength="200"></asp:TextBox> max 200</td> </tr> <tr> <td> </td> <td> <asp:Button runat="server" ID="btnsubmit" Text="Save" OnClick="SaveEvent"></asp:Button> <asp:Button runat="server" ID="btnreset" Text="Reset"></asp:Button> </td> </tr> </table> <table width="390" border="1" align="left" cellpadding="0" cellspacing="0"> <tr> <td> <asp:DataGrid runat="server" ID="ViewEvents" AutoGenerateColumns="false"> <columns> <asp:TemplateColumn> <itemtemplate> <table id="tt" border="1" cellpadding="5" cellspacing="0"> <tr> <td><asp:Label runat="server" ID="eventname" Text='<%#container.DataItem("event_name")%>' ></asp:Label></td> <td><asp:Label runat="server" ID="pdesc" Text='<%# trim(DataBinder.Eval(Container.DataItem,"event_date","{0:MM/dd/yyyy}")) %>' ></asp:Label></td> </tr> </table> </itemtemplate> </asp:TemplateColumn> </columns> </asp:DataGrid> </td> </tr></table> </td> </tr> </table>
I am pretty mcuh new to sql and I read all your previous replies..I jsut have my questions answered.If you can help me that would be great!
I can acces the date base using Server manager then retireve the data using the query .But now I need to convert that obtained the data into csv file n then save it into csv file. IF you can help me out that would be great.
Hi,This is driving me nuts, I have a table that stores notes regarding anoperation in an IMAGE data type field in MS SQL Server 2000.I can read and write no problem using Access using the StrConv function andI can Update the field correctly in T-SQL using:DECLARE @ptrval varbinary(16)SELECT @ptrval = TEXTPTR(BITS_data)FROM mytable_BINARY WHERE ID = 'RB215'WRITETEXT OPERATION_BINARY.BITS @ptrval 'My notes for this operation'However, I just can not seem to be able to convert back to text theinformation once it is stored using T-SQL.My selects keep returning bin data.How to do this! Thanks for your help.SD
Hi,I'm using the following code to open a data base and show it's contentin a Data Grid View----Code-----Imports System.Data.SqlClientPrivate Sub Form1_Load(ByVal sender As System.Object, ByVal e AsSystem.EventArgs) Handles MyBase.LoadDim conn As New SqlConnection("DataSource=./wideserver;Path="c:/cct.mdf";UserId=username;Password=Password;")Using (conn)conn.Open()Dim com As SqlCommand = conn.CreateCommand()Using (com)com.CommandType = CommandType.Textcom.CommandText = "Select * From users"Dim da As New SqlDataAdapter(com)Using (da)Dim dt As New DataTable("usertable")Using (dt)da.Fill(dt)Dim dgv As New DataGridView()dgv.Dock = DockStyle.Filldgv.DataSource = dtMe.Controls.Add(dgv)End UsingEnd UsingEnd UsingEnd UsingEnd Sub-----end code-----The following code allow me to see the table data in a Data Grid Viewbut now i want to save the changes in the table (after makingmodifications in the dgv)i use : dta.update(dt)but that don't work !!!!!!Any Help and thanks a lotOmar Abidwww.omarabid.uni.cc
Hello everyone I have a stored procedure that I am trying to save datetime data to at the moment I can create a string that will output 25/05/2007 18:30 Does anyone know the best way to get this into the correct format for my SP parameter cmdPublish.Parameters.Add(new SqlParameter("@datPublishDate", System.Data.SqlDbType.DateTime)); cmdPublish.Parameters["@datPublishDate"].Value = ???? Thanks
Hi all, I have an requirement that, I want to save data getting from text boxes etc..,on button click the data should be saved in database and also the data must be saved as word document with a file name with in the same database table which i am saving the data..i hope it's clear... I reached upto saving the data under button click..but I stuck up in converting the data to word and saving the same data in server ..??how to convert page data into word and at the same time i want that doc file to save in a table in serverThanks & Regards,Vamsee.
I have a page for saving a "home" data. As the page unloads I will redirect the user to the page on which he can add the photos to this "home".
Well I structured my photo adding page with first requesting the "homeID" which is an auto Integer (PK). Because it's renaming the uploaded photos with the homeID and _01, _02...
Because of that i need to send the user to the photo adding page with "response.redirect......aspx?homeID=.....
homeID= ???
But I don't know how to get the homeID value, that the SQL Server automaticly selects for the data. As it is just saving it...
Yesterday I was looking to the processor usage in the Task Manager of Windows NT when a script of mine was running. The script was an InfoPump Script; which is a tool from the DecisionBase suite from CA (was previously owned by Platinum). This script contains SQL statements that select data from several tables and stores the result into another table. The SQL code used for this looks fine to me. The query was running on a Compaq Proliant 5500 with 4 500 Mhz Xeon processors, 1 GB RAM, NT Server 4, SP 5, RAID 5. The SQL Server is configured to use all resources and SQL has normal priority on NT. When the select part was running al four processors were used for about 75% and when the store happens only 1 processor is used for 100%. Why is the store not spread over all four processors? It only uses one processor and it seems to be a bottleneck.
