m.h.movahedi
دوشنبه 08 آذر 1389, 22:14 عصر
سلام
مشکل کد زیر (که برای ایجاد دیتا بیسه)چیه؟
sql_connection = new SqlConnection(connection_string);
if (sql_connection.State == ConnectionState.Open)
sql_connection.Close();
connection_string = "Integrated Security=SSPI;Initial Catalog=master;Data Source=.\\SQLEXPRESS;";
sql_connection.ConnectionString = connection_string;
sql_connection.Open();
sql_order = "CREATE DATABASE HOTEL On Primary (Name=HOTEL_Data,Filename='" + Directory.GetCurrentDirectory()+"\\SQL#\\HOTEL.Mdf',size=50)"
+"Log on (Name=HOTEL_Log,FileName='"+Directory.GetCurrentDirectory()+"\\SQL#\\HOTEL.Ldf',size=50)";
sql_command = new SqlCommand(sql_order, sql_connection);
sql_command.CommandType = CommandType.Text;
sql_command.ExecuteNonQuery();
sql_connection.Close();
این کد خطای زیر رو ایجاد میکنه
"Directory lookup for the file \"F:\\C-prog\\HOTEL\\HOTEL\\bin\\Debug\\SQL#\\HOTEL.Mdf\" failed with the operating system error 2(The system cannot find the file specified.).\r\nCREATE DATABASE failed. Some file names listed could not be created. Check related errors."}
متن کامل خطا
System.Data.SqlClient.SqlException: Directory lookup for the file "F:\C-prog\HOTEL\HOTEL\bin\Debug\SQL#\HOTEL.Mdf" failed with the operating system error 2(The system cannot find the file specified.).
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at HOTEL.Form1.Form1_Load(Object sender, EventArgs e) in F:\C-prog\HOTEL\New Folder\Form1.cs:line 64
در ضمن من این کد رو تو لود فرم مینویسم واز سی شارپ 2008 استفاده میکنم
مشکل کد زیر (که برای ایجاد دیتا بیسه)چیه؟
sql_connection = new SqlConnection(connection_string);
if (sql_connection.State == ConnectionState.Open)
sql_connection.Close();
connection_string = "Integrated Security=SSPI;Initial Catalog=master;Data Source=.\\SQLEXPRESS;";
sql_connection.ConnectionString = connection_string;
sql_connection.Open();
sql_order = "CREATE DATABASE HOTEL On Primary (Name=HOTEL_Data,Filename='" + Directory.GetCurrentDirectory()+"\\SQL#\\HOTEL.Mdf',size=50)"
+"Log on (Name=HOTEL_Log,FileName='"+Directory.GetCurrentDirectory()+"\\SQL#\\HOTEL.Ldf',size=50)";
sql_command = new SqlCommand(sql_order, sql_connection);
sql_command.CommandType = CommandType.Text;
sql_command.ExecuteNonQuery();
sql_connection.Close();
این کد خطای زیر رو ایجاد میکنه
"Directory lookup for the file \"F:\\C-prog\\HOTEL\\HOTEL\\bin\\Debug\\SQL#\\HOTEL.Mdf\" failed with the operating system error 2(The system cannot find the file specified.).\r\nCREATE DATABASE failed. Some file names listed could not be created. Check related errors."}
متن کامل خطا
System.Data.SqlClient.SqlException: Directory lookup for the file "F:\C-prog\HOTEL\HOTEL\bin\Debug\SQL#\HOTEL.Mdf" failed with the operating system error 2(The system cannot find the file specified.).
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at HOTEL.Form1.Form1_Load(Object sender, EventArgs e) in F:\C-prog\HOTEL\New Folder\Form1.cs:line 64
در ضمن من این کد رو تو لود فرم مینویسم واز سی شارپ 2008 استفاده میکنم