using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using web;
using System.Data.SqlClient;

public partial class adminforyoyo_BGAward : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnadd_Click(object sender, EventArgs e)
    {
        string mysql = string.Concat(new object[] { 
                "insert into Award (NAME,ID,VALUE,pic) values ('", tbname.Text.Trim(), "',", tbitemid.Text.Trim(), ",'", 
                tbValue.Text.Trim(), "','", tbpic.Text.Trim(), "')" 
               
             });
        
        new DataProviders().ExecuteSql(mysql);

        this.DataGrid1.DataSource = new DataProviders().ExecuteSqlDs("select * from Award" , "DataGrid1");
        this.DataGrid1.DataBind();
    }
}