public TdsCommand (string commandText, TdsConnection connection, TdsTransaction transaction) { this.commandText = commandText; this.connection = connection; this.transaction = transaction; this.commandType = CommandType.Text; this.updatedRowSource = UpdateRowSource.Both; this.designTimeVisible = false; this.commandTimeout = 30; parameters = new TdsParameterCollection (this); }
public TdsCommand(string commandText, TdsConnection connection, TdsTransaction transaction) { this.commandText = commandText; this.connection = connection; this.transaction = transaction; this.commandType = CommandType.Text; this.updatedRowSource = UpdateRowSource.Both; this.designTimeVisible = false; this.commandTimeout = 30; parameters = new TdsParameterCollection(this); }
public static void Main(string[] args) { Console.WriteLine("Start TestSqlConnection."); if (args.Length != 6 && args.Length != 7) { Console.WriteLine( "\nUsage: mono TestSqlConnection.exe Client Table Column Server Database UserID [Password]\n\n" + #if IncludeSybaseAndTdsClient "\tClient is one of the following: SqlClient, TdsClient, or SybaseClient\n" + #else "\tClient is: SqlClient. No support for TdsClient nor SybaseClient\n" + #endif // IncludeSybaseAndTdsClient "\tTable is the name of the database table to select from\n" + "\tColumn is the name of the column in the Table to select from\n" + "\tServer is the SQL Server to connect. Use one of the following forms:\n" + "\t\tHOSTNAME Ex: MYHOST\n" + "\t\tHOSTNAME,port Ex: MYHOST,1433\n" + "\t\tHOSTNAME\\\\instance Ex: MYHOST\\\\NETSDK Note: only works with SqlClient\n" + "\tDatabase is the name of the database to use\n" + "\tUser ID is the user's User ID\n" + "\tPassword is the user's Password Note: if ommitted, a blank password is used\n" + "Exampes:\n" + "\tEx 1: SqlClient employee lname MYHOST pubs myuserid mypassword\n" + "\tEx 3: SqlClient employee lname MYHOST,1443 pubs myuserid mypassword\n" + "\tEx 2: SqlClient Products ProductName MYHOST\\\\NETSDK myuserid mypassword\n" + "\tEx 4: SqlClient employee lname MYHOST pubs myuserid\n" + "\tEx 5: TdsClient sometable somecolumn MYHOST test myuserid mypassword\n" + "\tEx 6: SybaseClient sometable somecolumn MYHOST test myuserid mypassword\n"); return; } string client = args[0]; string tableName = args[1]; string columnName = args[2]; string server = args[3]; string database = args[4]; string userid = args[5]; string password = ""; if (args.Length == 7) password = args[6]; string constr; string sql; Console.WriteLine("\nClient: " + client); Console.WriteLine("Table Name: " + tableName); Console.WriteLine("Column Name: " + columnName); Console.WriteLine("Server: " + server); Console.WriteLine("Database: " + database); Console.WriteLine("User ID: " + userid); Console.WriteLine("Password: "******"SELECT " + columnName + " FROM " + tableName; constr = "Server=" + server + ";" + "Database=" + database + ";" + "User ID=" + userid + ";" + "Password="******";"; Console.WriteLine("\nConnectionString: " + constr); Console.WriteLine("SQL: " + sql); Console.WriteLine("\nCreating Connection..."); IDbConnection con = null; switch (client.ToUpper()) { case "SQLCLIENT": con = new SqlConnection(); break; #if IncludeSybaseAndTdsClient case "TDSCLIENT": con = new TdsConnection(); break; case "SYBASECLIENT": con = new SybaseConnection(); break; default: Console.WriteLine("Invalid client: " + client + "\nUse SqlClient, TdsClient, or SybaseClient"); return; #else default: Console.WriteLine("Invalid client: " + client + "\nUse SqlClient. No support for TdsClient nor SybaseClient."); return; #endif } Console.WriteLine("set connection string..."); con.ConnectionString = constr; Console.WriteLine("open connection..."); try { con.Open(); } catch(SqlException se) { Console.WriteLine("SqlException caught"); Console.WriteLine("Message: " + se.Message); Console.WriteLine("Procedure: " + se.Procedure); Console.WriteLine("Class: " + se.Class); Console.WriteLine("Number: " + se.Number); Console.WriteLine("Source: " + se.Source); Console.WriteLine("State: " + se.State); Console.WriteLine("Errors:"); foreach(SqlError error in se.Errors) { Console.WriteLine(" SqlError:"); Console.WriteLine(" Message: " + se.Message); Console.WriteLine(" Line Number: " + se.LineNumber); Console.WriteLine(" Procedure: " + se.Procedure); Console.WriteLine(" Class: " + se.Class); Console.WriteLine(" Number: " + se.Number); Console.WriteLine(" Server: " + se.Server); Console.WriteLine(" Source: " + se.Source); Console.WriteLine(" State: " + se.State); } Console.WriteLine("StackTrace: " + se.StackTrace); Console.WriteLine("TargetSite: " + se.TargetSite); Exception ie = se.InnerException; if(ie != null) { Console.WriteLine("InnerException:"); Console.WriteLine(" Message: " + se.Message); Console.WriteLine(" Class: " + se.Class); Console.WriteLine(" Number: " + se.Number); Console.WriteLine(" Source: " + se.Source); Console.WriteLine(" State: " + se.State); Console.WriteLine(" StackTrace: " + se.StackTrace); Console.WriteLine(" TargetSite: " + se.TargetSite); } return; } Console.WriteLine("Creating command..."); IDbCommand cmd = con.CreateCommand(); Console.WriteLine("set SQL..."); cmd.CommandText = sql; Console.WriteLine("execute reader..."); IDataReader reader = cmd.ExecuteReader(); Console.WriteLine("read first row..."); if(reader.Read()) { Console.WriteLine(" Value: " + reader[columnName].ToString()); } else { Console.WriteLine(" No data returned. Or either, no permission to read data."); } Console.WriteLine("Clean up..."); // clean up reader.Close(); reader = null; cmd.Dispose(); cmd = null; con.Close(); con = null; Console.WriteLine("Done."); }
public TdsCommand (string commandText, TdsConnection connection) : this (commandText, connection, null) { Connection = connection; }
internal TdsTransaction (TdsConnection connection, IsolationLevel isolevel) { this.connection = connection; this.isolationLevel = isolevel; isOpen = true; }
public TdsDataAdapter (string selectCommandText, TdsConnection selectConnection) : this (new TdsCommand (selectCommandText, selectConnection)) { }
public TdsCommand(string commandText, TdsConnection connection) : this(commandText, connection, null) { }
internal TdsTransaction(TdsConnection connection, IsolationLevel isolevel) { this.connection = connection; this.isolationLevel = isolevel; isOpen = true; }
public TdsDataAdapter(string selectCommandText, TdsConnection selectConnection) : this(new TdsCommand(selectCommandText, selectConnection)) { }