Visual Basic

Re: An unhandled win32 exception occured in VB6.EX

13-Jun-07 3:50

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?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Dileep_Vickey13-Jun-07 21:22

Dileep_Vickey

13-Jun-07 21:22

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.

Sql server database backup.

Paramhans Dubey12-Jun-07 21:23

Paramhans Dubey

12-Jun-07 21:23

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

Re: Sql server database backup.

Steven J Jowett12-Jun-07 22:04

Steven J Jowett

12-Jun-07 22:04

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'

Re: Sql server database backup.

Paramhans Dubey14-Jun-07 19:18

Paramhans Dubey

14-Jun-07 19:18

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

Re: Sql server database backup.

Steven J Jowett14-Jun-07 22:42

Steven J Jowett

14-Jun-07 22:42

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'

print subscript & superscript in report

Rupesh Kumar Swami12-Jun-07 21:17

12-Jun-07 21:17

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)

Dave Kreskowiak13-Jun-07 3:48

13-Jun-07 3:48

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.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Rupesh Kumar Swami13-Jun-07 4:05

13-Jun-07 4:05

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)

Dave Kreskowiak13-Jun-07 7:08

13-Jun-07 7:08

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.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Rupesh Kumar Swami14-Jun-07 20:40

14-Jun-07 20:40

sir,
can i do same work(subscript & superscript) without crystal report

Please guide me.

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

Dave Kreskowiak15-Jun-07 12:57

15-Jun-07 12:57

I thought the whole point was to generate a report? What else are you going to use to replace Crystal Reports?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Rupesh Kumar Swami16-Jun-07 0:09

16-Jun-07 0:09

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)

Dave Kreskowiak16-Jun-07 3:51

Returning Columns Name Only

16-Jun-07 3:51

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.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Brendan Vogt12-Jun-07 21:14

Re: Returning Columns Name Only

12-Jun-07 21:14

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

Dileep_Vickey12-Jun-07 21:34

Dileep_Vickey

12-Jun-07 21:34

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.

Re: Returning Columns Name Only

Brendan Vogt12-Jun-07 22:08

SQLDataReader Column Name Needed

12-Jun-07 22:08

I'm using VB.NET 1.1 and not using recordset.

Brendan Vogt12-Jun-07 20:30

Re: SQLDataReader Column Name Needed

12-Jun-07 20:30

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

Brendan Vogt12-Jun-07 21:05

Re: SQLDataReader Column Name Needed

12-Jun-07 21:05

I hust changed the start of the loop to:

For i = 0 To dr.FieldCount - 1

Dave Kreskowiak13-Jun-07 3:45