|
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
|
|
|
|
|
Creating Desktop Application Remote Controls with the .NET Compact Framework (Part 1)
By CJCraft.com. Here[^] in CP will Help you.
Regards,
Satips.
|
|
|
|
|
Define "message". Are you thinking of writing both the client and server applications? Is this a chat application? Are you interacting with another application that you did or didn't write? More information is needed to answer this question.
|
|
|
|
|
Hi Dave
Thank for ur reply
Actualy i wanted to create desktop application where administrator can view his department employees work status, if he found anybody is taking long time then he can communicate to that employee through application.
Only Administrator and employee can communicate through application .
Hope this will clear ur doubt
regards
ravi
|
|
|
|
|
This is no different than any other chat application. You just have to add a little bit of security.
The way you describe it, it's just another tool for a bad manager to become worse by micro-managing.
|
|
|
|