- using System;
			
 
			- using System.Data;
			
 
			- using System.Configuration;
			
 
			- using System.Collections;
			
 
			- using System.Web;
			
 
			- using System.Web.Security;
			
 
			- using System.Web.UI;
			
 
			- using System.Web.UI.WebControls;
			
 
			- using System.Web.UI.WebControls.WebParts;
			
 
			- using System.Web.UI.HtmlControls;
			
 
			- using System.Data.SqlClient;
			
 
			-   
 
			- public 
			partial class
			dbTest_Insert :
			System.Web.UI.Page
			
 
			- { 
 
			
				- 
				SqlConnection
				
				connection;
				
 
				- protected 
				void Page_Load(object
				sender, 
				EventArgs e)
				
 
				- { 
 
				
					- 
					connection
					
					=
					
					new
					
					SqlConnection(ConfigurationManager.ConnectionStrings["GamesConnection"].ConnectionString);
 
				 
				- } 
 
				- protected 
				void btnSubmit_Click(object
				sender, 
				EventArgs e)
				
 
				- { 
 
				
					- 
					SqlCommand
					
					command
					
					=
					
					new
					
					SqlCommand("INSERT 
					INTO gameTable(gameName, gamePlatform) VALUES (@id_gameName, 
					@id_gamePlatform)",
					
					connection);
					
 
					-   
 
					- 
					SqlParameter
					
					nameContent
					
					=
					
					new
					
					SqlParameter("@id_gameName",
					
					SqlDbType.VarChar);
					
 
					- 
					nameContent.Value
					
					=
					
					txtGameName.Text;
					
 
					- 
					command.Parameters.Add(nameContent);
					
 
					-   
 
					- 
					SqlParameter
					
					platformContent
					
					=
					
					new
					
					SqlParameter("@id_gamePlatform",
					
					SqlDbType.VarChar);
					
 
					- 
					platformContent.Value
					
					=
					
					txtGamePlatform.Text;
					
 
					- 
					command.Parameters.Add(platformContent);
					
 
					-   
 
					- 
					connection.Open();
					
 
					- 
					command.BeginExecuteNonQuery();
					
 
					- 
					connection.Close();
					
 
					-   
 
					- 
					Response.Redirect("Results.aspx");
 
				 
				- }
 
			 
			- }
 
		 
		 |