C#与SQL2005如何连接？

要连接到数据库，只需单击链接usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingModel;usingSystem.Data;usingSystem.Data.SqlClient;1。
返回结果集：publicstaticDataSetGetDataSet2(stringsql){DataSetds=newDataSet();stringstrConn="server=.;uid=sa;pwd=;database=ShopManegerDB";SqlConnectionconn=newSqlConnection(strConn);SqlDataAdapterda=newSqlDataAdapter(sql,conn);da.Fill(ds,"商店");返回；}2.返回影子受影响的行数publicstaticintupdate(stringsql){stringstrConn="server=.;uid=sa;pwd=;database=ShopManegerDB";SqlConnectionconn=newSqlConnection(strConn);SqlCommandcmd=newSqlCommand(sql,conn);conn。
打开（）;inti=cmd.ExecuteNonQuery();conn.Close();returni;}3.其他SqlServer·ODBCo标准连接（StandardSecurity）：“Driver={SQLServer};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;”1）服务器如果是本地（local）则可以使用“Driver={SQLServer};Server=(local);Database=pubs;Uid=sa;Pwd=asdasd;"2)如果您连接到连接远程服务器，需要指定地址、端口号和网络库"Driver={SQLServer};Server=130.120.110.001;Address=130.120.110.001,1052;Network=dbmssocn;Database=pubs;Uid=sa;pwd=asdasd;"注意：地址参数必须是IP地址且包括端口号。
可信连接：（MicrosoftWindowsNT具有内置安全性）"Driver={SQLServer};Server=Aron1;Database=pubs;Trusted_Connection=yes;"或"Driver={SQLServer};Server=Aron1;Database=pubs;Uid=;Pwd=;"o连接时，会出现一个对话框，用于输入用户名和密码：Conn.Properties("Prompt")=adPromptAlwaysConn.Open"Driver={SQLServer};Server=Aron1;DataBase=pubs;"·OLEDB,OleDbConnection(.NET)oStandardSecurity:"Provider=sqloledb;DataSource=Aron1;InitialCatalog=pubs;UserId=sa;Password=asdasd;"oTrustedconnection:"Provider=sqloledb;DataSource=Aron1;InitialCatalog=pubs;IntegratedSecurity=SSPI;"（连接到特定NamedSQLSer（版本实例时，使用数据源=服务器名称\实例名称；但仅适用于SQLServer2000)例如：“DataSource=MyServerName\MyInstanceName;InitialCatalog=MyDatabaseName;Password=MyPassword;”连接时，会出现一个输入用户名和密码的对话框：Conn.Provider="sqloledb"Conn.Properties("Prompt")=adPromptAlwaysConn.Open"DataSource=Aron1;InitialCatalog=pubs;"o通过IP地址连接："Provider=sqloledb;DataSource=190.190.200.100,1433;NetworkLibrary=DBMSSOCN;InitialCatalog=pubs;UserID=sa;Password=asdasd;"（DBMSSOCN=TCP/IP而不是NamedPipes，DataSource的末尾是要使用的端口号（默认为1433）))SqlConnection(.NET)o标准连接(StandardSecurity)：“DataSource=Aron1;InitialCatalog=pubs;UserId=sa;Password=asdasd;”或“Server=Aron1;Database=pubs;UserID=sa;Password=asdasd;Trusted_Connection=False”（这两个连接字符串的结果是相同）oTrustedconnection）：“DataSource=Aron1;InitialCatalog=pubs;IntegeratedSecurity=SSPI;”或“Server=Aron1;Database=pubs;Trusted_Connection=True;”（这两个连接字符串的结果是一样的）（可以用serverName\instanceName代替DataSource，值为具体的SQLServer实例，但仅适用于SQLServer2000）o通过IP地址连接：“DataSource=190.190.200.100,1433;NetworkLibrary=DBMSSOCN;InitialCatalog=pubs;UserID=sa;Password=asdasd;"（DBMSSOCN=TCP/IP而不是NamedPipes，DataSource末尾是要使用的端口号（默认为1433））oSql连接连接声明：C#:usingSystem.Data.SqlClient;SqlConnectionSQLConn=newSqlConnection();SQLConn.ConnectionString="myconnectionstring";SQLConn.Open();VB.NET:ImportsSystem.Data.SqlClientDimSQLConnAsSqlConnection=NewSqlConnection()SQLConn.ConnectionString="myconnectionstring"SQLConn.Open()·DataShapeoMSDataShape"Provider=MSDataShape;DataProvider=SQLOLEDB;DataSource=Aron1;InitialCatalog=pubs;UserID=sa;Password=asdasd;"·更多o如何定义要使用的协议§示例：&

mysql错误号1045

HECKREAD1020HY000ER_DISK_FULL1021HY000ER_DUP_KEY102223000ER_ERROR_ON_CLOSE1023HY000ER_ERROR_ON_READ1024HY000ER_ERROR_ON_RENAME1025HY000ER_ERROR_ON_WRITE1026HY000ER_FILE_USED1027HY000ER_FILSORT_ABORT1028HY000ER_FORM_NOT_FOUND1029HY000ER_GET_ERRNO1030HY000ER_ILLEGAL_HA1031HY000ER_KEY_NOT_FOUND1032HY000ER_NOT_FORM_FILE1033HY000ER_NOT_KEYFILE1034HY000ER_OLD_KEYFILE1035HY000ER_OPEN_AS_READONLY1036HY000ER_OUTOFMEMORY1037HY001ER_OUT_OF_SORTMEMORY1038HY001ER_UNEXPECTED_EOF1039HY000ER_CON_COUNT_ERROR104008004ER_OUT_OF_RESOURCES104108004ER_BAD_HOST_ERROR104208S01ER_HANDSHAKE_ERROR104308S01ER_DBACCESS_DENIED_ERROR104442000ER_ACCESS_DENIED_ERROR104542000ER_NO_DB_ERROR104642000ER_UNKNOWN_COM_ERROR104708S01ER_BAD_NULL_ERROR104823000ER_BAD_DB_ERROR104942000ER_TABLE_EXISTS_ERROR105042S01ER_BAD_TABLE_ERROR105142S02ER_NON_UNIQ_ERROR105223000ER_SERVER_SHUTDOWN105308S01ER_BAD_FIELD_ERROR105442S22ER_WRONG_FIELD_WITH_GROUP105542000ER_WRONG_GROUP_FIELD105642000ER_WRONG_SUM_SELECT105742000ER_WRONG_VALUE_COUNT105821S01ER_TOO_LONG_IDENT105942000ER_DUP_FIELDNAME106042S21ER_DUP_KEYNAME106142000ER_DUP_ENTRY106223000ER_WRONG_FIELD_SPEC106342000ER_PARSE_ERROR106442000ER_EMPTY_QUERY106542000ER_NONUNIQ_TABLE106642000ER_INVALID_DEFAULT106742000ER_MULTIPLE_PRI_KEY106842000ER_TOO_MANY_KEYS106942000ER_TOO_MANY_KEY_PARTS107042000ER_TOO_LONG_KEY107142000ER_KEY_COLUMN_DOES_NOT_EXITS107242000ER_BLOB_USED_AS_KEY107342000ER_TOO_BIG_FIELDLENGTH107442000ER_WRONG_AUTO_KEY107542000ER_READY107600000ER_NORMAL_SHUTDOWN107700000ER_GOT_SIGNAL107800000ER_SHUTDOWN_COMPLETE107900000ER_FORCING_CLOSE108008S01ER_IPSOCK_ERROR108108S01ER_NO_SUCH_INDEX108242S12ER_WRONG_FIELD_TERMINATORS108342000ER_BLOBS_AND_NO_TERMINATED108442000ER_TEXTFILE_NOT_READABLE1085HY000ER_FILE_EXISTS_ERROR1086HY000ER_LOAD_INFO1087HY000ER_ALTER_INFO1088HY000ER_WRONG_SUB_KEY1089HY000ER_CANT_REMOVE_ALL_FIELDS109042000ER_CANT_DROP_FIELD_OR_KEY109142000ER_INSERT_INFO1092HY000ER_UPDATE_TABLE_USED1093HY000ER_NO_SUCH_THREAD1094HY000ER_KILL_DENIED_ERROR1095HY000ER_NO_TABLES_USED1096HY000ER_TOO_BIG_SET1097HY000ER_NO_UNIQUE_LOGFILE1098HY000ER_TABLE_NOT_LOCKED_FOR_WRITE1099HY000ER_TABLE_NOT_LOCKED1100HY000ER_BLOB_CANT_HAVE_DEFAULT110142000ER_WRONG_DB_NAME110242000ER_WRONG_TABLE_NAME110342000ER_TOO_BIG_SELECT110442000ER_UNKNOWN_ERROR1105HY000ER_UNKNOWN_PROCEDURE110642000ER_WRONG_PARAMCOUNT_TO_PROCEDURE110742000ER_WRONG_PARAMETERS_TO_PROCEDURE1108HY000ER_UNKNOWN_TABLE110942S02ER_FIELD_SPECIFIED_TWICE111042000ER_INVALID_GROUP_FUNC_USE111142000ER_UNSUPPORTED_EXTENSION111242000ER_TABLE_MUST_HAVE_COLUMNS111342000ER_RECORD_FILE_FULL1114HY000ER_UNKNOWN_CHARACTER_SET111542000ER_TOO_MANY_TABLES1116HY000ER_TOO_MANY_FIELDS1117HY000ER_TOO_BIG_ROWSIZE111842000ER_STACK_OVERRUN1119HY000ER_WRONG_OUTER_JOIN112042000ER_NULL_COLUMN_IN_INDEX112142000ER_CANT_FIND_UDF1122HY000ER_CANT_INITIALIZE_UDF1123HY000ER_UDF_NO_PATHS1124HY000ER_UDF_EXISTS1125HY000ER_CANT_OPEN_LIBRARY1126HY000ER_CANT_FIND_DL_ENTRY1127HY000ER_FUNCTION_NOT_DEFINED1128HY000ER_HOST_IS_BLOCKED1129HY000ER_HOST_NOT_PRIVILEGED1130HY000ER_PASSWORD_ANONYMOUS_USER113142000ER_PASSWORD_NOT_ALLOWED113242000ER_PASSWORD_NO_MATCH113342000ER_UPDATE_INFO1134HY000ER_CANT_CREATE_THREAD1135HY000ER_WRONG_VALUE_COUNT_ON_ROW113621S01ER_CANT_REOPEN_TABLE1137HY000ER_INVALID_USE_OF_NULL113842000ER_REGEXP_ERROR113942000ER_MIX_OF_GROUP_FUNC_AND_FIELDS114042000ER_NONEXISTING_GRANT114142000ER_TABLEACCESS_DENIED_ERROR114242000ER_COLUMNACCESS_DENIED_ERROR114342000ER_ILLEGAL_GRANT_FOR_TABLE114442000ER_GRANT_WRONG_HOST_OR_USER114542000ER_NO_SUCH_TABLE114642S02ER_NONEXISTING_TABLE_GRANT114742000ER_NOT_ALLOWED_COMMAND114842000ER_SYNTAX_ERROR114942000ER_DELAYED_CANT_CHANGE_LOCK1150HY000ER_TOO_MANY_DELAYED_THREADS1151HY000ER_ABORTING_CONNECTION115208S01ER_NET_PACKET_TOO_LARGE115308S01ER_NET_READ_ERROR_FROM_PIPE115408S01ER_NET_FCNTL_ERROR115508S01ER_NET_PACKETS_OUT_OF_ORDER115608S01ER_NET_UNCOMPRESS_ERROR115708S01ER_NET_READ_ERROR115808S01ER_NET_READ_INTERRUPTED115908S01ER_NET_ERROR_ON_WRITE116008S01ER_NET_WRITE_INTERRUPTED116108S01ER_TOO_LONG_STRING116242000ER_TABLE_CANT_HANDLE_BLOB116342000ER_TABLE_CANT_HANDLE_AUTO_INCRMENT116442000ER_DELAYED_INSERT_TABLE_LOCKED1165HY000ER_WRONG_COLUMN_NAME116642000ER_WRONG_KEY_COLUMN116742000ER_WRONG_MRG_TABLE1168HY000ER_DUP_UNIQUE116923000ER_BLOB_KEY_WITHOUT_LENGTH117042000ER_PRIMARY_CANT_HAVE_NULL117142000ER_TOO_MANY_ROWS117242000ER_REQUIRES_PRIMARY_KEY117342000ER_NO_RAID_COMPILED1174HY000ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE1175HY000ER_KEY_DOES_NOT_EXITS1176HY000ER_CHECK_NO_SUCH_TABLE117742000ER_CHECK_NOT_IMPLMENTED117842000ER_CANT_DO_THIS_DURING_AN_TRANSACTION117925000ER_ERROR_DURING_COMMIT1180HY000ER_ERROR_DURING_ROLLBACK1181HY000ER_ERROR_DURING_FLUSH_LOGS1182HY000ER_ERROR_DURING_CHECKPOINT183HY000ER_NEW_ABORTING_CONNECTION118408S01ER_DUMP_NOT_IMPLMENTED1185HY000ER_FLUSH_MASTER_BINLOG_CLOSED1186HY000ER_INDEX_REBUILD1187HY000ER_MASTER1188HY000ER_MASTER_NET_READ118908S01ER_MASTER_NET_WRITE119008S01ER_FT_MATCHING_KEY_NOT_FOUND1191HY000ER_LOCK_OR_ACTIVE_TRANSACTION1192HY000ER_UNKNOWN_SYSTEM_VARIABLE1193HY000ER_CRASHED_ON_USAGE1194HY000ER_CRASHED_ON_REPAIR1195HY000ER_WARNING_NOT_COMPLETE_ROLLBACK1196HY000ER_TRANS_CACHE_FULL1197HY000ER_SLAVE_MUST_STOP1198HY000ER_SLAVE_NOT_RUNNING1199HY000ER_BAD_SLAVE1200HY000ER_MASTER_INFO1201HY000ER_SLAVE_THREAD1202HY000ER_TOO_MANY_USER_CONNECTIONS120342000ER_SET_CONSTANTS_ONLY1204HY000ER_LOCK_WAIT_TIMEOUT1205HY000ER_LOCK_TABLE_FULL1206HY000ER_READ_ONLY_TRANSACTION120725000ER_DROP_DB_WITH_READ_LOCK1208HY000ER_CREATE_DB_WITH_READ_LOCK1209HY000ER_WRONG_ARGUMENTS1210HY000ER_NO_PERMISSION_TO_CREATE_USER121142000ER_UNION_TABLES_IN_DIFFERENT_DIR1212HY000ER_LOCK_DEADLOCK121340001ER_TABLE_CANT_HANDLE_FULLTEXT1214HY000ER_CANNOT_ADD_FOREIGN1215HY000ER_NO_REFERENCED_ROW121623000ER_ROW_IS_REFERENCED121723000ER_CONNECT_TO_MASTER121808S01ER_QUERY_ON_MASTER1219HY000ER_ERROR_WHEN_EXECUTING_COMMAND1220HY000ER_WRONG_USAGE1221HY000ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT122221000ER_CANT_UPDATE_WITH_READLOCK1223HY000ER_MIXING_NOT_ALLOWED1224HY000ER_DUP_ARGUMENT1225HY000ER_USER_LIMIT_REACHED122642000ER_SPECIFIC_ACCESS_DENIED_ERROR1227HY000ER_LOCAL_VARIABLE1228HY000ER_GLOBAL_VARIABLE1229HY000ER_NO_DEFAULT123042000ER_WRONG_VALUE_FOR_VAR123142000ER_WRONG_TYPE_FOR_VAR123242000ER_VAR_CANT_BE_READ1233HY000ER_CANT_USE_OPTION_HERE123442000ER_NOT_SUPPORTED_YET123542000ER_MASTER_FATAL_ERROR_READING_BINLOG1236HY000ER_WRONG_FK_DEF123742000ER_KEY_REF_DO_NOT_MATCH_TABLE_REF1238HY000ER_CARDINALITY_COL123921000ER_SUBSELECT_NO_1_ROW124021000ER_UNKNOWN_STMT_HANDLER1241HY000ER_CORRUPT_HELP_DB1242HY000ER_CYCLIC_REFERENCE1243HY000ER_AUTO_CONVERT1244HY000ER_ILLEGAL_REFERENCE124542S22ER_DERIVED_MUST_HAVE_ALIAS124642000ER_SELECT_REDUCED124701000ER_TABLENAME_NOT_ALLOWED_HERE124842000ER_NOT_SUPPORTED_AUTH_MODE124908004ER_SPATIAL_CANT_HAVE_NULL125042000ER_COLLATION_CHARSET_MISMATCH125142000ER_SLAVE_WAS_RUNNING1252HY000ER_SLAVE_WAS_NOT_RUNNING1253HY000ER_TOO_BIG_FOR_UNCOMPRESS1254HY000ER_ZLIB_Z_MEM_ERROR1255HY000ER_ZLIB_Z_BUF_ERROR1256HY000ER_ZLIB_Z_DATA_ERROR1257HY000ER_CUT_VALUE_GROUP_CONCAT1258HY000ER_WARN_TOO_FEW_RECORDS125901000ER_WARN_TOO_MANY_RECORDS126001000ER_WARN_NULL_TO_NOTNULL126101000ER_WARN_DATA_OUT_OF_RANGE126201000ER_WARN_DATA_TRUNCATED126301000ER_WARN_USING_OTHER_HANDLER126401000ER_CANT_AGGREGATE_COLLATIONS126542000ER_DROP_USER126642000ER_REVOKE_GRANTS126742000

MyEclipse编程报错说.....Exception:Table'empdb.emp'doesn'texist

异常信息表明没有emp表。
检查数据库是否已正确创建。