using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb ;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace placar
{
	/// <summary>
	/// Summary description for WebForm1.
	/// </summary>
	public partial class WebForm1 : System.Web.UI.Page
	{
		//e:\\home\\seuloginftp\\dados\\roko.mdb
		//C://Inetpub//wwwroot//placar//dados//game.mdb
		OleDbConnection Conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='E:\inetpub\vhosts\marciobaraldi.com.br\httpdocs\dados\game.mdb';Persist Security Info=False");

		protected void Page_Load(object sender, System.EventArgs e)
		{
			// Put user code to initialize the page here

			string nome, verifica, StrSql;
			int pontos;

			
			verifica = Request.QueryString.ToString();

			if (verifica !="")
			{	


				nome = Request.QueryString["nome"].ToString ();
				pontos = Convert.ToInt32(Request.QueryString["pontos"]);
				StrSql = "insert into tb_placar (nome, pontos) values ( '" + nome + "', " + pontos.ToString() + ");";

				if (nome !="")
				{
				
					Response.Write (Atualiza("insert into tb_placar (nome, pontos) values ( '" + nome + "', " + pontos.ToString() + ");").ToString());

					
				}
			}

			Conn.Close();



		}

		public string Atualiza (string StrSql)
		{				


			System.Data.OleDb.OleDbCommand comando = new OleDbCommand (StrSql.ToString(),Conn);

			Conn.Open();
			
			comando.ExecuteNonQuery();//.ToString();				
			
			comando.CommandText = "SELECT @@IDENTITY";
			return comando.ExecuteScalar().ToString();
			
			//Conn2.Close();



		}	

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
		}
		#endregion
	}
}