protected string LookUpEmailBasedOnPhoneName() { string phone = TextBox3.Text; string name = TextBox2.Text; try { SqlConnection connection = new SqlConnection("Data Source = itksqlexp8; Integrated Security = true"); connection.Open(); connection.ChangeDatabase("itk485nnrs"); string query = "Select email from signuptable where cellPhone = '"+phone+"' and firstname='"+name+"'"; SqlCommand command = new SqlCommand(query, connection); var reader = command.ExecuteReader(); if (reader.Read()) { emailFromSignUpTable = reader["email"]+""; connection.Close(); } reader.Close(); } catch(Exception ex) { Response.Write("Some error occured: "+ex.Message); } return emailFromSignUpTable; }
public void TestCleanup() { var repositoryType = Instance.GetType(); if (repositoryType == typeof(JsonRepository)) { if (Directory.Exists(JsonWorkingFolder)) { Directory.Delete(JsonWorkingFolder, recursive: true); } } else if (repositoryType == typeof(SqlRepository)) { using (var cnn = new SqlConnection(SqlConnectionString)) using (var cmd = new SqlCommand("EXEC sp_MSforeachtable @command1 = 'TRUNCATE TABLE ?'", cnn)) { cnn.Open(); cnn.ChangeDatabase(SqlDatabaseName); cmd.ExecuteNonQuery(); } } else if (repositoryType == typeof(MongoRepository)) { var server = new MongoClient(MongoConnectionString).GetServer(); server.DropDatabase(MongoDatabaseName); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { populateCatagories(); Session["prevAList"] = ""; Session["prevBList"] = ""; SqlConnection dbConnection = new SqlConnection("Data Source=itksqlexp8;Integrated Security=true"); //string img= "../UserWebForms/"; dbConnection.Open(); dbConnection.ChangeDatabase("nasa_SilentAuction_v1"); //string sqlQuery = "select * from item where approvalStatus=" +true; SqlCommand cmd = dbConnection.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "select * from item where approvalStatus= 1"; //string strQuery = "select * from item where approvalStatus=1"; //SqlCommand cmd = new SqlCommand(strQuery, dbConnection); cmd.CommandType = CommandType.Text; //cmd.CommandText = CommandText.te cmd.Connection = dbConnection; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); // SqlDataReader pendingListDisplay = cmd.ExecuteReader(); da.Fill(dt); DataList1.DataSource = dt; DataList1.DataBind(); dbConnection.Close(); } }
protected void Page_Load(object sender, EventArgs e) { // Important: If didn't check this, the list will get re-populated (and the 1st item will be the selected one)! if (!IsPostBack) { SqlConnection dbConnection = new SqlConnection("Data Source=itksqlexp8;Integrated Security=true"); dbConnection.Open(); dbConnection.ChangeDatabase("nasa_SilentAuction_v1"); string SQLString = "SELECT DISTINCT categoryName,categoryPrefix FROM category"; SqlCommand cmd = new SqlCommand(SQLString, dbConnection); SqlDataReader ddlValues; ddlValues = cmd.ExecuteReader(); DropDownList1.DataSource = ddlValues; DropDownList1.DataValueField = "categoryPrefix"; DropDownList1.DataTextField = "categoryName"; DropDownList1.DataBind(); dbConnection.Close(); } }
public static SqlConnection GetConnection(string sConnection, string sDatabase) { SqlConnection dbconnection = null; try { dbconnection = new SqlConnection(sConnection); dbconnection.Open(); if (sDatabase.Trim() != string.Empty) { dbconnection.ChangeDatabase(sDatabase); } } catch (System.InvalidOperationException e) { throw new Exception("GetConnection error: " + e.Message); } catch (System.Data.SqlClient.SqlException e) { throw new Exception("GetConnection error2: " + e.Message); } return dbconnection; }
protected void BindDataToUserList() { try { SqlConnection dbConnection = new SqlConnection("Data Source=itksqlexp8;Integrated Security=true"); dbConnection.Open(); dbConnection.ChangeDatabase("nasa_SilentAuction_v1"); String searchString = "select distinct buyerid from item where buyerid is not null"; SqlCommand SQLString = new SqlCommand(searchString, dbConnection); SqlDataAdapter da = new SqlDataAdapter(SQLString); DataTable dt = new DataTable(); da.Fill(dt); DropDownList1.DataSource = dt; DropDownList1.DataValueField = "buyerid"; DropDownList1.DataTextField = "buyerid"; DropDownList1.DataBind(); dbConnection.Close(); //Adding "Please select" option in dropdownlist DropDownList1.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select a buyer", "")); } catch (SqlException exception) { System.Diagnostics.Debug.WriteLine("<p>Error code " + exception.Number + ": " + exception.Message + "</p>"); } }
/// <summary> /// becareful /// </summary> /// <param name="connectionString"></param> /// <returns></returns> public static Boolean dropDB(String connectionString="") { try { SqlConnectionStringBuilder pa = new SqlConnectionStringBuilder(connectionString); using (SqlConnection sqlconnection = new SqlConnection(connectionString)) { sqlconnection.Open(); // if you used master db as Initial Catalog, there is no need to change database sqlconnection.ChangeDatabase("master"); string rollbackCommand = @"ALTER DATABASE ["+pa.InitialCatalog+"] SET SINGLE_USER WITH ROLLBACK IMMEDIATE"; SqlCommand deletecommand = new SqlCommand(rollbackCommand, sqlconnection); deletecommand.ExecuteNonQuery(); string deleteCommand = @"DROP DATABASE [" + pa.InitialCatalog + "]"; deletecommand = new SqlCommand(deleteCommand, sqlconnection); deletecommand.ExecuteNonQuery(); return true; } } catch (Exception ex) { Debug.WriteLine(ex); return false; } }
private void buttonConnections_Click(object sender, EventArgs e) { SqlConnection objCon = new SqlConnection(); /** option 1: The "HardCoded" way **/ objCon.ConnectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog = DB1; Integrated Security=True;"; /** option 2: The "Before .Net v2.0" way**/ objCon.ConnectionString = ConfigurationSettings.AppSettings["Conn2"]; /** option 3: The "Common" way (Note: You must have a reference to the System.Configuration .dll) **/ objCon.ConnectionString = ConfigurationManager.ConnectionStrings["Conn3"].ConnectionString; objCon.StateChange += new StateChangeEventHandler(objCon_StateChange); try { objCon.Open(); objCon.ChangeDatabase("Northwind"); MessageBox.Show("Database is now: " + objCon.Database); } finally { objCon.Close(); } MessageBox.Show("Database state after Close(): " + objCon.State.ToString()); }
void populateDropDown() { SqlConnection dbConnection = new SqlConnection("Data Source=itksqlexp8;Integrated Security=true"); try { dbConnection.Open(); dbConnection.ChangeDatabase("nasa_SilentAuction_v1"); String query = "SELECT * FROM USERS WHERE approvalStatus=1"; SqlCommand cmd = new SqlCommand(query, dbConnection); SqlDataReader data = cmd.ExecuteReader(); while (data.Read()) { ListItem u = new ListItem(); u.Text = (string)data["userID"]; u.Value = (string)data["userID"]; buyerIdList.Items.Add(u); } } catch (SqlException exception) { Response.Write("Error Code: " + exception.Message); } }
protected void getBidderDetails() { string userid = Session["user_id"].ToString(); try { SqlConnection dbConnection = new SqlConnection("Data Source=itksqlexp8;Integrated Security=true"); dbConnection.Open(); dbConnection.ChangeDatabase("nasa_SilentAuction_v1"); String searchString = "select * from users " + " where userId = @userID; "; SqlCommand SQLString = new SqlCommand(searchString, dbConnection); SQLString.Parameters.AddWithValue("@userID", userid); SqlDataReader idRecords = SQLString.ExecuteReader(); if (idRecords.Read()) { bidderName.Text = idRecords["firstName"].ToString().ToUpper(); bidderNumber.Text = idRecords["bidder_no"].ToString(); } idRecords.Close(); dbConnection.Close(); } catch (SqlException exception) { Response.Write("<p>Error code " + exception.Number + ": " + exception.Message + "</p>"); } }
protected bool checkIfItemSoldToThisUser() { bool itemSold = false; string userid = Session["user_id"].ToString(); try { SqlConnection dbConnection = new SqlConnection("Data Source=itksqlexp8;Integrated Security=true"); dbConnection.Open(); dbConnection.ChangeDatabase("nasa_SilentAuction_v1"); String searchString = "select * from item where buyerID = @userID"; SqlCommand SQLString = new SqlCommand(searchString, dbConnection); SQLString.Parameters.AddWithValue("@userID", userid); SqlDataReader idRecords = SQLString.ExecuteReader(); if (idRecords.Read()) { itemSold = true; } idRecords.Close(); dbConnection.Close(); } catch (SqlException exception) { Response.Write("<p>Error code " + exception.Number + ": " + exception.Message + "</p>"); } return itemSold; }
protected void updateUserProfile(object sender, EventArgs e) { SqlConnection dbConnection = new SqlConnection("Data Source=itksqlexp8;Integrated Security=true"); try { dbConnection.Open(); dbConnection.ChangeDatabase("nasa_SilentAuction_v1"); string name = Session["user_id"] as string; str = "Update users set firstName='" + fname.Text + "', lastName='" + lname.Text + "', addressLine1='" + addressLine1.Text + "', addressLine2='" + addressLine2.Text + "', city='" + city.Text + "', stateName='" + state.Text + "', phoneHome='" + phoneNumber.Text + "', phncarrier='" + networkProvider.SelectedValue + "', email='" + email.Text + "', password='******' WHERE userID='" + userid1.Text + "'"; SqlCommand sqlCommand = new SqlCommand(str, dbConnection); var x = sqlCommand.ExecuteNonQuery(); string message = "Bingo! your profile has been Updated. For confirmation we have sent you an email, Happy Bidding :)" ; textMessage = new SMSService(networkProvider.Text, phoneNumber.Text, message); textMessage.SendTextMessage(textMessage); UpdateReply.Text = "Data Updated Successfully, Please check your inbox :)"; } catch (SqlException exception) { Response.Write("<p>Error code " + exception.Number + ": " + exception.Message + "</p>"); } }
static void Main(string[] args) { String sc = "Data Source=.\\sqlexpress;Initial Catalog=MASTER;Integrated Security=true;"; using (SqlConnection c = new SqlConnection(sc)) { String cmd = "CREATE DATABASE VS2010"; using (SqlCommand k = new SqlCommand(cmd, c)) { //SqlCommand faz parte do modelo CONECTADO //ExecuteNonQuery retorna o número de linhas afetadas c.Open(); k.ExecuteNonQuery(); c.ChangeDatabase("VS2010"); k.CommandText = "CREATE TABLE PESSOA (COD_PESSOA INT, NOME_PESSOA VARCHAR(50), SEXO_PESSOA CHAR(1))"; k.ExecuteNonQuery(); c.Close(); } } Console.WriteLine("funcionou"); Console.ReadKey(); }
protected void LookUpForAdminAccess() { string adminAccess = ""; try { SqlConnection connection = new SqlConnection("Data Source = itksqlexp8; Integrated Security = true"); connection.Open(); connection.ChangeDatabase("itk485nnrs"); string tempEmail = Session["loginEmail"].ToString() ; string query = "Select access from signuptable where email = '" + tempEmail + "'"; SqlCommand command = new SqlCommand(query, connection); var reader = command.ExecuteReader(); if (reader.Read()) { adminAccess = reader["access"] + ""; connection.Close(); } reader.Close(); } catch (Exception ex) { Response.Write("Some error occured: " + ex.Message); } Session["adminAccess"] = adminAccess; }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack) { Page.Validate(); if (Page.IsValid) { SqlConnection dbConnection = new SqlConnection("Data Source=.\\SQLEXPRESS;Integrated Security=true"); try { dbConnection.Open(); dbConnection.ChangeDatabase("ConservationSchool"); string SQLString = "SELECT * FROM students WHERE studentID=" + studentID.Text; SqlCommand checkIDTable = new SqlCommand(SQLString, dbConnection); SqlDataReader idRecords = checkIDTable.ExecuteReader(); if (idRecords.Read()) { Response.Redirect("ReturningStudent.aspx?studentID=" + studentID.Text); idRecords.Close(); } else { validateMessage.Text = "<p>**Invalid student ID**</p>"; idRecords.Close(); } } catch (SqlException exception) { Response.Write("<p>Error code " + exception.Number + ": " + exception.Message + "</p>"); } } } }
public List<MysteryGame> GameList(string ConnectionStringValue, string databasename, string filter) { List<MysteryGame> returnValue = new List<MysteryGame>(); SqlConnection sqlConn = new SqlConnection(ConnectionStringValue); if (sqlConn.State == ConnectionState.Closed) sqlConn.Open(); sqlConn.ChangeDatabase(databasename); SqlCommand spHandler = new SqlCommand("spGames", sqlConn); spHandler.Parameters.AddWithValue("@step", 3); spHandler.Parameters.AddWithValue("@filter", filter); spHandler.CommandType = CommandType.StoredProcedure; SqlDataAdapter daGameHandler = new SqlDataAdapter(spHandler); DataTable dtGameHandler = new DataTable(); daGameHandler.Fill(dtGameHandler); var convertedList = (from rw in dtGameHandler.AsEnumerable() select new MysteryGame() { gameid = Convert.ToString(rw["gameid"]), download = Convert.ToString(rw["download"]), drawdate = Convert.ToString(rw["drawdate"]), submitter = Convert.ToString(rw["submitter"]), name = Convert.ToString(rw["name"]), platform = Convert.ToString(rw["platform"]), goal = Convert.ToString(rw["goal"]), specialrequirements = Convert.ToString(rw["specialrequirements"]), tournamentraceresult = Convert.ToString(rw["tournamentraceresult"]), notes = Convert.ToString(rw["notes"]), draws = Convert.ToString(rw["draws"]), pastebin = (Utilities.PasteBinPass(Convert.ToString(rw["pastebin"]))) ? Convert.ToString(rw["pastebin"]) : "pastebin not provided" }).ToList(); return convertedList; }
/// <summary> /// Mains this instance. /// </summary> public static void Main() { Console.WriteLine("To get this working fix dbPath and db connection string if required!"); // Get DB structure. string createClone = string.Empty; using (var northwindDbContext = new NorthwindEntities()) { createClone = (northwindDbContext as IObjectContextAdapter).ObjectContext.CreateDatabaseScript(); } string createDBScript = "" + "IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'NorthwindTwin')"+ "DROP DATABASE NorthwindTwin;" + "CREATE DATABASE NorthwindTwin ON PRIMARY " + "(NAME = NorthwindTwin, FILENAME = '" + dbPath + "NorthwindTwin.mdf', SIZE = 5MB, MAXSIZE = 10MB, FILEGROWTH = 10%) " + "LOG ON (NAME = NorthwindTwinLog, FILENAME = '" + dbPath + "NorthwindTwin.ldf', SIZE = 1MB, MAXSIZE = 5MB, FILEGROWTH = 10%);"; using (var db = new SqlConnection("Server=.; Database=master; Integrated Security=true")) { // Create empty DB db.Open(); var initializeEmptyDB = new SqlCommand(createDBScript, db); initializeEmptyDB.ExecuteNonQuery(); db.ChangeDatabase("NorthwindTwin"); // Create twin structure. SqlCommand createTwin = new SqlCommand(createClone, db); createTwin.ExecuteNonQuery(); } Console.WriteLine("Cloning Done!"); }
public override void Execute(SqlConnection dbConnection, string destDBName) { if(CanNotExecute) return; base.Execute(dbConnection, destDBName); if (dbConnection.State == ConnectionState.Closed) dbConnection.Open(); string currentDirectory = Directory.GetCurrentDirectory(); if (SourceStream == null) SourceStream = File.OpenRead(currentDirectory + "\\Scripts\\Tables.txt"); using (SourceStream) { if (SourceStream == null) throw new Exception(Resources.FileNotFound); foreach (string commandText in FileHelper.LoadItemsLines(new StreamReader(SourceStream))) { try { string tempCommand = commandText.Replace("[NewDataBase]", "[" + destDBName + "]"); Statement statement = DBHelper.ParseCommand(tempCommand); SqlCommand command = dbConnection.CreateCommand(); command.CommandTimeout = AppConfig.CommandTimeOut; string prevDBName = dbConnection.Database; dbConnection.ChangeDatabase(destDBName); command.CommandText = CreateCommandText(dbConnection, statement); dbConnection.ChangeDatabase(prevDBName); command.ExecuteNonQuery(); } catch (Exception ex) { Errors.Add(ex); } } } dbConnection.Close(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["user_id"] == null) { Response.Redirect("../Default.aspx"); } else { SqlConnection dbConnection = new SqlConnection("Data Source=itksqlexp8;Integrated Security=true"); try { dbConnection.Open(); dbConnection.ChangeDatabase("nasa_SilentAuction_v1"); string name = Session["user_id"].ToString(); userid1.Text = name.ToString(); string SQLString = "SELECT * FROM users WHERE userID='" + name + "'"; SqlCommand checkIDTable = new SqlCommand(SQLString, dbConnection); SqlDataReader idRecords = checkIDTable.ExecuteReader(); if (idRecords.Read()) { do { fname.Text = idRecords["firstName"].ToString(); lname.Text = idRecords["lastName"].ToString(); addressLine1.Text = idRecords["addressLine1"].ToString(); addressLine2.Text = idRecords["addressLine2"].ToString(); city.Text = idRecords["city"].ToString(); state.Text = idRecords["stateName"].ToString(); phoneNumber.Text = idRecords["phoneHome"].ToString(); networkProvider.SelectedValue = idRecords["phncarrier"].ToString(); email.Text = idRecords["email"].ToString(); Password1.Text = idRecords["password"].ToString(); } while (idRecords.Read()); } idRecords.Close(); } catch (SqlException exception) { Response.Write("<p>Error code " + exception.Number + ": " + exception.Message + "</p>"); } } } }
public void TestCleanup() { using (var cnn = new SqlConnection(SqlConnectionString)) using (var cmd = new SqlCommand("EXEC sp_MSforeachtable @command1 = 'TRUNCATE TABLE ?'", cnn)) { cnn.Open(); cnn.ChangeDatabase(SqlDatabaseName); cmd.ExecuteNonQuery(); } }
private static object PullSql(string conn, string db, string query, string error, SQLReturn type) { var result = new object(); try { using (var c = new SqlConnection(conn)) { c.Open(); c.ChangeDatabase(db); SqlDataReader reader = new SqlCommand(query, c).ExecuteReader(); switch (type) { case SQLReturn.Bool: result = false; while (reader.Read()) { if (reader != null) { result = true; break; } } break; case SQLReturn.Item: result = String.Empty; while (reader.Read()) { if (reader != null) { result = reader[0].ToString(); break; } } break; case SQLReturn.List: var Results = new List<string>(); while (reader.Read()) { Results.Add(reader[0].ToString()); } result = Results; break; } } } catch (SqlException e) { Messaging.ThrowException(error, e); } catch (Exception e) { Messaging.ThrowException(error, e); } return result; }
private static void RunSql(string sql, string dbName) { using (var con = new SqlConnection(connection_string)) { con.Open(); con.ChangeDatabase(dbName); using (var cmd = con.CreateCommand()) { cmd.CommandText = sql; cmd.ExecuteNonQuery(); } } }
public static void ssb_get_certificate_blob( SqlString dbName, SqlString certName, out SqlBytes blob) { SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder(); scsb.ContextConnection = true; SqlConnection connection = new SqlConnection(scsb.ConnectionString); connection.Open(); using (connection) { connection.ChangeDatabase(dbName.Value); string tempPath = Path.GetTempPath(); string certFile = Path.Combine( tempPath, Path.GetRandomFileName()); try { if (false == Directory.Exists(tempPath)) { Directory.CreateDirectory(tempPath); } SqlCommand cmd = new SqlCommand( String.Format( @"BACKUP CERTIFICATE [{0}] TO FILE = '{1}';", certName.Value.Replace("]", "]]"), certFile), connection); cmd.ExecuteNonQuery(); blob = new SqlBytes(File.ReadAllBytes(certFile)); } finally { if (File.Exists(certFile)) { try { File.Delete(certFile); } catch (IOException) { } } } } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["studentID"] == "") Response.Redirect("Default.aspx"); else { SqlConnection dbConnection = new SqlConnection( "Data Source=.\\SQLEXPRESS;Integrated Security=true"); string studentID = Request.QueryString["studentID"]; schedule.Text = "<p>Student ID: " + Request.QueryString["studentID"] + "</p>"; try { dbConnection.Open(); dbConnection.ChangeDatabase("ConservationSchool"); string classInfo = "SELECT * FROM registration WHERE studentID=" + studentID; SqlCommand studentSchedule = new SqlCommand( classInfo, dbConnection); SqlDataReader scheduleRecords = studentSchedule.ExecuteReader(); if (scheduleRecords.Read()) { schedule.Text += "<table width='100%' border='1'>"; schedule.Text += "<tr><th>Class</th><th>Days</th><th>Time</th></tr>"; do { schedule.Text += "<tr>"; schedule.Text += "<td>" + scheduleRecords["class"] + "</td>"; schedule.Text += "<td>" + scheduleRecords["days"] + "</td>"; schedule.Text += "<td>" + scheduleRecords["time"] + "</td>"; schedule.Text += "</tr>"; } while (scheduleRecords.Read()); schedule.Text += "</table>"; } else schedule.Text += "<p>You have not registered for any classes! Click your browser's Back button to return to the previous page.</p>"; scheduleRecords.Close(); } catch (SqlException exception) { Response.Write("<p>Error code " + exception.Number + ": " + exception.Message + "</p>"); } dbConnection.Close(); } }
protected void Button1_Click(object sender, EventArgs e) { if (Page.IsPostBack) { Page.Validate(); if (Page.IsValid) { // Reading from Web.Config //string connectionString = ConfigurationManager.ConnectionStrings["ConservationSchoolConnectionString"].ConnectionString; //SqlConnection dbConnection = new SqlConnection(connectionString); SqlConnection dbConnection = new SqlConnection("Data Source=itksqlexp8;Integrated Security=true"); // SqlConnection dbConnection = new SqlConnection("Data Source=BLLIM-LT;Integrated Security=true"); // SqlConnection dbConnection = new SqlConnection("Data Source=.\\SQLEXPRESS;Integrated Security=true"); try { dbConnection.Open(); dbConnection.ChangeDatabase("itk485nnrs"); //string SQLString1 = "INSERT INTO userLogin VALUES( '" + fnameId.Text + "','" + lnameId.Text + "')"; string SQLString1 = "INSERT INTO anonymousbiddertable VALUES( '" + fnameId.Text + "','" + lnameId.Text + "','" + cellId.Text + "')"; SqlCommand checkIDTable1 = new SqlCommand(SQLString1, dbConnection); checkIDTable1.ExecuteNonQuery(); Session["firstname"] = fnameId.Text; Session["lastname"] = lnameId.Text; Session["cellPhoneNo"] = cellId.Text; Response.Redirect("bidOnline.aspx"); //SqlDataReader idRecords = checkIDTable.ExecuteReader(); //if (idRecords.Read()) //{ // Response.Write("Hello, " + username.Text); // idRecords.Close(); //} //else //{ // Response.Write("**Invalid Match **"); // //Label1.Text = "<p>**Invalid Match **</p>"; // idRecords.Close(); //} } catch (SqlException exception) { Response.Write("<p>Error code " + exception.Number + ": " + exception.Message + "</p>"); } } } }
protected void Page_Load(object sender, EventArgs e) { SqlConnection dbConnection = new SqlConnection( "Data Source=.\\SQLEXPRESS;Integrated Security=true"); try { dbConnection.Open(); dbConnection.ChangeDatabase("forecast"); string retString = "SELECT * FROM outlook ORDER BY city"; SqlCommand outlookCommand = new SqlCommand(retString, dbConnection); SqlDataReader outlookRecords = outlookCommand.ExecuteReader(); if (outlookRecords.Read()) { Response.Write("<table width='100%' border='1'>"); Response.Write("<tr><th>City</th><th>State</th><th>Day</th><th>High</th><th>Low</th><th>Conditions</th></tr>"); do { Response.Write("<tr>"); Response.Write("<td>" + outlookRecords["city"] + "</td>"); Response.Write("<td>" + outlookRecords["state"] + "</td>"); Response.Write("<td>" + outlookRecords["day"] + "</td>"); Response.Write("<td>" + outlookRecords["high"] + "</td>"); Response.Write("<td>" + outlookRecords["low"] + "</td>"); Response.Write("<td>" + outlookRecords["conditions"] + "</td>"); Response.Write("</tr>"); } while (outlookRecords.Read()); Response.Write("</table>"); } else Response.Write("<p>Your query returned no results.</p>"); outlookRecords.Close(); } catch (SqlException exception) { Response.Write("<p>Error code " + exception.Number + ": " + exception.Message + "</p>"); } dbConnection.Close(); addForecast("INSERT INTO outlook VALUES('Tucson', 'AZ', 'Tuesday', 102, 72, 'Partly cloudy')"); addForecast("INSERT INTO outlook VALUES('Williamsburg', 'VA', 'Wednesday', 90, 71, 'Mostly clear')"); }
public static SqlConnection loadDB() { SqlConnection dbConnection = null; try { dbConnection = new SqlConnection("Data Source=itksqlexp8;Integrated Security=true"); dbConnection.Open(); dbConnection.ChangeDatabase("it368_Auction_Project"); } catch (SqlException exception) { Console.Write("<p>Error code " + exception.Number + ": " + exception.Message + "</p>"); } return dbConnection; }
public bool createDatabase(string n) { using (con = __initConnection(false)) { con.Open(); con.ChangeDatabase("master"); using (com = new SqlCommand("CREATE DATABASE " + n, con)) { // cannot parameterize without getting a syntax error => need to find where sanitization happens internally try { com.ExecuteNonQuery(); return true; } catch (Exception ex) { HttpContext.Current.Response.Write(ex.ToString()); return false; } } } }
private void CreateConnectionAndDB() { try { m_conn = new SqlConnection(textBoxServer.Text); m_conn.Open(); SqlCommand exists = m_conn.CreateCommand(); string dbname = textBoxDBName.Text.Replace(" ", "").Trim(); exists.CommandText = "if not exists(select * from sys.databases where name = '" + dbname + "') create database " + dbname + ";"; exists.ExecuteNonQuery(); m_conn.ChangeDatabase(dbname); } catch (Exception x) { m_conn = null; MessageBox.Show(x.Message); } }
public override void InvokeHandler(CommandSetState state) { var diagram = state.CurrentDocView.CurrentDiagram; var modelRoot = diagram.Store.ElementDirectory.FindElements<ModelRoot>().Single(); var connectionString = modelRoot.ConnectionString; var dlg = new GenerateSQLForm(); if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK) { var sqlGenerator = new DbSchemaGenerator(diagram) { CleanUpDbSchema = dlg.CleanupDbSchema, UseNavigationPropertyNameForFKeys = dlg.UseNavigationPropertyNameForFKeys, }; var sb = sqlGenerator.GenerateScripts(); System.IO.File.WriteAllText(dlg.Filename, sb.ToString()); if (dlg.OverwriteDatabase) { //Creating a connection to the given database using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { var originalDatabase = sqlConnection.Database; sqlConnection.Open(); //Switching to master database sqlConnection.ChangeDatabase("master"); ServerConnection svrConnection = new ServerConnection(sqlConnection); //Recreating database and executing the query file DropAndRecreateDatabase(originalDatabase, svrConnection); svrConnection.ExecuteNonQuery(System.IO.File.ReadAllText(dlg.Filename)); } ModelerTransaction.Enter(() => { //Importing the new schema from database var sync = new Utilities.DbSchemaImporter(diagram); sync.FullDatabaseReload = true; sync.ImportModels(); }); } System.Windows.Forms.MessageBox.Show("Sql script generation completed."); } }