Click here to Skip to main content
15,910,981 members
Home / Discussions / C#
   

C#

 
AnswerRe: How to get local web server's home directory? Pin
Colin Angus Mackay26-Sep-04 1:41
Colin Angus Mackay26-Sep-04 1:41 
GeneralRe: How to get local web server's home directory? Pin
CNU27-Sep-04 17:30
CNU27-Sep-04 17:30 
AnswerRe: How to get local web server's home directory? Pin
Colin Angus Mackay27-Sep-04 20:41
Colin Angus Mackay27-Sep-04 20:41 
GeneralCheckers under c# Pin
aeruzcar25-Sep-04 17:31
aeruzcar25-Sep-04 17:31 
GeneralRe: Checkers under c# Pin
SimonS25-Sep-04 22:25
SimonS25-Sep-04 22:25 
GeneralRe: Checkers under c# Pin
Anonymous26-Sep-04 5:50
Anonymous26-Sep-04 5:50 
QuestionCan I put an email to the inbox of the outlook (not outlook express) using outlook object model? Pin
ting66825-Sep-04 16:01
ting66825-Sep-04 16:01 
QuestionTransfer an SQL database? Pin
cemlouis25-Sep-04 14:09
cemlouis25-Sep-04 14:09 
Hi,

Q1: How can I transfer an SQL database manually? I have a database which is named mydb, I looked at the harddrive and found it on "C:\Program Files\Microsoft SQL Server\MSSQL\Data" there is 2 file one of them is mydb.mdf and the lof file of that. I copied these on another machine on the same path but couldn't make it to work???

Q2: I used the below code to EMPTY a table which is named people but it is not working???:

SqlConnection mySqlConnection4 = new SqlConnection("Initial Catalog=mydb;Data Source=" + comboBox1.SelectedItem.ToString() + ";Integrated Security=SSPI;");
mySqlConnection4.Open();
SqlCommand mySqlCommand4 = mySqlConnection4.CreateCommand();
SqlTransaction myTrans;
myTrans = mySqlConnection4.BeginTransaction(IsolationLevel.ReadCommitted,"SampleTransaction");
mySqlCommand4.Connection = mySqlConnection4;
mySqlCommand4.Transaction = myTrans;
mySqlCommand4.CommandText = "EMPTY people" ;
//mySqlCommand4.ExecuteNonQuery();
myTrans.Commit();
mySqlConnection4.Close();


Anyway What is the problem???

Any help would be greatly appreciated...
Cem Louis

AnswerRe: Transfer an SQL database? Pin
Colin Angus Mackay25-Sep-04 14:56
Colin Angus Mackay25-Sep-04 14:56 
Questiontrying to fade in and out a picture on a form? Pin
vista2725-Sep-04 13:46
vista2725-Sep-04 13:46 
AnswerRe: trying to fade in and out a picture on a form? Pin
Alex Korchemniy25-Sep-04 15:03
Alex Korchemniy25-Sep-04 15:03 
AnswerRe: trying to fade in and out a picture on a form? Pin
yoaz26-Sep-04 3:43
yoaz26-Sep-04 3:43 
GeneralReflection and operators Pin
Ben Martin25-Sep-04 12:39
Ben Martin25-Sep-04 12:39 
GeneralRe: Reflection and operators Pin
Alex Korchemniy25-Sep-04 12:58
Alex Korchemniy25-Sep-04 12:58 
GeneralRe: Reflection and operators Pin
Ben Martin25-Sep-04 14:52
Ben Martin25-Sep-04 14:52 
GeneralRe: Reflection and operators Pin
Ben Martin25-Sep-04 20:12
Ben Martin25-Sep-04 20:12 
Generalfind a record Pin
cmarmr25-Sep-04 12:27
cmarmr25-Sep-04 12:27 
GeneralRe: find a record Pin
Alex Korchemniy25-Sep-04 12:44
Alex Korchemniy25-Sep-04 12:44 
GeneralDigi cam wizard Pin
Alex Korchemniy25-Sep-04 12:25
Alex Korchemniy25-Sep-04 12:25 
GeneralDifference between 2 datetime Pin
Apusnaias25-Sep-04 11:48
Apusnaias25-Sep-04 11:48 
GeneralRe: Difference between 2 datetime Pin
Alex Korchemniy25-Sep-04 12:28
Alex Korchemniy25-Sep-04 12:28 
GeneralRe: Difference between 2 datetime Pin
Apusnaias25-Sep-04 12:44
Apusnaias25-Sep-04 12:44 
GeneralRe: Difference between 2 datetime Pin
Roland Bär29-Sep-04 3:39
Roland Bär29-Sep-04 3:39 
Generalsaving a sequence of gif images in a single file Pin
hudhud25-Sep-04 10:15
hudhud25-Sep-04 10:15 
GeneralHelp needed.....Writing a Swap function using pointer variables... Pin
Kiran Satish25-Sep-04 9:44
Kiran Satish25-Sep-04 9:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.