|
Hi
I could help you, in one of my project i have done the mail merge and create the mailing labels also.
But could you explain the probelm properly i can't understand waht you want to know. ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Hi all,
I am trying to code for storing images into database as bytes and for its retrieval. It worked well. But if we try to load more than two pictures one by one then it shows an error as follows.
---------------------------
Visual Studio Just-In-Time Debugger
---------------------------
An unhandled win32 exception occurred in VB6.EXE [1160]. Just-In-Time debugging this exception failed with the following error: No installed debugger has Just-In-Time debugging enabled. In Visual Studio, Just-In-Time debugging can be enabled from Tools/Options/Debugging/Just-In-Time.
Check the documentation index for 'Just-in-time debugging, errors' for more information.
---------------------------
OK
---------------------------
I used GlobalAlloc function to allocate bytes of memory in my heap. I allocates almost 26347868 bytes in memory. I tried to free memory by using GlobalFree. But the result is same.
I will be thankful to you for your help.
Dileep trying to work as a freelancer.
|
|
|
|
|
Post your declaration of GlobalAlloc and GlobalFree - it looks like you may be passing the wrong parameter type...?
|
|
|
|
|
Dileep_Vickey wrote: But if we try to load more than two pictures one by one
So what does this mean? Let's see the code that is storing and retrieving the images. How big are these images, in bytes?
|
|
|
|
|
Hi all,
Sorry to be late.
Dave Kreskowiak wrote: So what does this mean?
I meant, I can open any picture i stored in sql database in a picturebox. I stored picture as bytes. Opening of first and second picture (randomly from database) work smoothly. But when i try to open third image then it will show that error. I used following function to retrieve image from collection of bytes.
Public Function PictureFromBits(abPic() As Byte) As IPicture
' abPic() as a byte array
Dim nLow As Long
Dim cbMem As Long
Dim hMem As Long
Dim lpMem As Long
Dim IID_IPicture As GUID
Dim istm As stdole.IUnknown
Dim ipic As IPicture
On Error GoTo Out
GlobalFree (hMem)
nLow = LBound(abPic)
On Error GoTo 0
cbMem = (UBound(abPic) - nLow) + 1
hMem = GlobalAlloc(GMEM_MOVEABLE, cbMem)
If hMem Then
lpMem = GlobalLock(hMem)
If lpMem Then
MoveMemory ByVal lpMem, abPic(nLow), cbMem
Call GlobalUnlock(hMem)
If (CreateStreamOnHGlobal(hMem, CTrue, istm) = S_OK) Then
If (CLSIDFromString(StrPtr(sIID_IPicture), IID_IPicture) = S_OK) Then
Call OleLoadPicture(ByVal ObjPtr(istm), cbMem, CFalse, IID_IPicture, PictureFromBits)
End If
End If
End If
End If
GlobalFree (hMem)
Exit Function
Out:
MsgBox "Out"
End Function
I think this is a problem regarding memory. Please help.
Dave Kreskowiak wrote: How big are these images, in bytes?
I opened images with almost all sizes. eg: 57060 Bytes.
Thanking for your interest.
|
|
|
|
|
How can I take backup and restore SQL server 2000 database using vb.net 2005.
Pls help me out. If possible give me the code to do it its very urgent.
Thanx in adv.
Regards
Paramhans
|
|
|
|
|
To do a backup you need to issue the following command to your SQL Server:-
"BACKUP DATABASE myDbName TO DISK = 'd:\Backup\myBackupFile'"
for example :-
Dim connection As New System.Data.SqlClient.SqlConnection<br />
Dim command As New System.Data.SqlClient.SqlCommand<br />
<br />
With connection<br />
.ConnectionString = myConnectionString<br />
.Open()<br />
With command<br />
.Connection = connection<br />
.CommandType = CommandType.Text<br />
.CommandText = "BACKUP DATABASE myDbName TO DISK 'd:\Backup\myBackupFile'"<br />
.ExecuteNonQuery()<br />
End With<br />
.Close()<br />
End With
To do a restore is as above, except the SQL command to issue is :-
sSql = "RESTORE DATABASE myDbName FROM DISK = 'd:\Backup\myBackupFile'"
Be aware the path to the backup file is local to your SQL Server, not your workstation.
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
Thanks Steve for the code u have given. I have successfully taken backup of the database using this code but when I m trying to restore the database following error has been thrown:
Exclusive access could not obtained because the database is in use.
RESTORE DATABASE is terminating abnormally.
Can u help me on this?
Once again thanks for your help.
Regards
Paramhans
|
|
|
|
|
Try issuing the following command to SQL Server
USE Master <br />
<br />
ALTER DATABASE yourdatabasename SET MULTI_USER WITH ROLLBACK IMMEDIATE;<br />
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
hi ,
i want to print some part of my message as subscript & superscript. i store sub & sup tag in database with message .Anybody have any idea how can i acheive this thing using vb.net.
i already try crystal report but there r no option for this thing.
any help will be appreciated.
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
What is the container that's going to be displaying this message? Is this a report? A web page? A RichTextBox? ?? Whatever that container is is going to dictate how you format and store your data that requires this formatting.
|
|
|
|
|
sir,
i post a message related to this subject at here
http://www.codeproject.com/script/comments/forums.asp?msg=2071396&forumid=1646#xx2071396xx
actually i will fetch all my data from database to crystal
report. But crystal report does not support subscript & superscript. so i want to ask there are any other option in vb.net from which i fetch data from database and print in subscript & superscript form(in database field i enter sub & sup tag for support subscript & superscript)
require some guidance and link which help me
thanks
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
Crystal Reports supports RichText fields, but NOT all of the RichText formatting commands. This question would be better asked in the forums on BusinessObjects own website.
|
|
|
|
|
sir,
can i do same work(subscript & superscript) without crystal report
Please guide me.
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
I thought the whole point was to generate a report? What else are you going to use to replace Crystal Reports?
|
|
|
|
|
sir,
Presently i have no idea about this thing.I am searching alternate way to solve this problem(with & without image support) on INTERNET.
have any idea what should i do ?
if possible, please provide some code or Links
Thanks for your support
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
I don't have any code or links because I've never had to support superscript and subscript in any reports.
You're going to have to do your own research for a reporting package that supports this kind of formatting in either RichText or HTML. You have a title of "Software Engineer". Stop begging and start engineering.
|
|
|
|
|
Hi,
I have a webpage with a check boxes. The user must be able to select which fields he/she wants to include in a SELECT statement. So I am going to have 1 checkbox for each field. I want these checkboxes to be created dynamically for each field.
I was thinking of doing it like this, for example with the long description field:
LongDescription AS "Long Description"
The "LongDescription" will probably be the name of the checkbox. And the "Long Description" will be displayed next to the checkbox as a description to the user.
How do I return columns only and not the rows of the records, how would I do this? I am using VB.NET 1.1.
Regards
ma se
|
|
|
|
|
ma se wrote: How do I return columns only and not the rows of the records
Hi,
You really mean column names?. If you are using recordset then you can take field anmes by adors.fields(index).name.
|
|
|
|
|
I'm using VB.NET 1.1 and not using recordset.
|
|
|
|
|
Hi,
I have a data reader populated with rows from my SQL SELECT statement.
I am looping through the coloums to write it to a XML file. But I need the name of the column for the name of the element. This is how I am looping through it and writitng it. It's only a section of my code:
With writer
' Loop through the fields
For i = 0 To dr.FieldCount
.WriteElementString("[ column name ]", dr.Item(i))
Next
End With
Please can someone help?
Regards
ma se
|
|
|
|
|
I hust changed the start of the loop to:
For i = 0 To dr.FieldCount - 1
|
|
|
|
|
Why are you writing this out to an XML file yourself? The DataSet and DataTable classes already do this for you, using their WriteXml methods.
|
|
|
|
|
i am using dotnet 2003.i am doing my project in vb.net windows application.i have two form in my project.first form is datagrid .In second form label and textboxes are avilable to save the entering values in datagrid of first form through this 2nd form.my problem is,in 2nd form,if i enter letter a in findtextbox and i click find button means,i want to display the values automatically (assyst in companynametextbox,vijay in contactpersontextbox,cbe in addresstextbox)in 2nd form.
for example,
in first form,
there are 4 columns named as companyname,contactperson,address in datagrid.
values are assyst for companynamecolumn,vijay for contactperson column,cbe for address column.now values in datagrid like below
companyname contactperson address
assyst vijay cbe
in 2nd form,there are 4 label and 4 textbox.textbox are named as findtextbox,companynametextbox,contactpersontextbox,addresstextbox.
my problem is,
in second form,
if i enter letter a in findtextbox and i click find button means,i want to display the values automatically (assyst in companynametextbox,vijay in contactpersontextbox,cbe in addresstextbox)in 2nd form.
during runtime in vb.net windows application.so how i do these.plz help me.
|
|
|
|
|
How to send messages from one mechine to another in vb.net application
Regards
ravi
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
