|
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. ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
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.
|
|
|
|
|
Thanks dave for ur reply and suggestion, but my job is to deliver product its managers choice how they are going to use such application.They have to decide its good or bad.
Regards
ravi
|
|
|
|
|
Hi,
Am handling the text in textbox for the below code, it works fine, I like to handle the text presents in the word document or a string value for the below code instead of Textbox1.Handle, is there any way to pass the string value as IntPtr.
Private Sub Button48_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button48.Click<br />
messge(Textbox1.Handle)<br />
End Sub
Private Sub messge(ByVal value As IntPtr)<br />
' <br />
'<br />
'<br />
End Sub
Kindly suggest me
Thanks,
Nanda
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
