using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
//在dataset里面加的主键约束；
    public DataSet  DataSetText1()
{
//信任连接,在本地运行没有错，在其它机器上就会错；
        string connStr = "server =.; initial catalog=oxsl; trusted_connection=yes";
string sqlStr = "select * from t_admin_register";
SqlDataAdapter da = new SqlDataAdapter(sqlStr, connStr);
DataSet ds = new DataSet();
da.Fill(ds, "t_admin_register");
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
//创建约束；
        UniqueConstraint uniqueContact = new UniqueConstraint(ds.Tables[0].Columns[2]);
//将约束加入约束集;
        ds.Tables[0].Constraints.Add(uniqueContact);
//创建（行）并加入其中；
//不可访问因为它受保护级别的限制；
//DataRow dr = new DataRow();
        DataRow  dr= ds.Tables[0].NewRow();
dr["p_c_admin_ID"] = 56;
dr["c_class"] = c_class.Text;
dr["c_name"] = username.Text.ToString();
dr["c_pwd"] = pwd.Text.ToString();
int k = 1;
try
{
ds.Tables[0].Rows.Add(dr);
}
catch
{
Response.Write("<script>alert('此用户名已存在，请更换！')</script>");
k = 0;
}
finally
{
if (k == 1)
{
Response.Write("<script>alert('数据添加成功！')</script>");
}
}
return ds;
}
//在dataset里面加入唯一和非空约束；
    public DataSet DataSetText2()
{
//注意还没有更新数据库；
        string connStr = "server =.;database = oxsl;Trusted_connection =yes";
string sqlStr = "select * from t_admin_register";
SqlDataAdapter da =new SqlDataAdapter();
try
{
da = new SqlDataAdapter(sqlStr, connStr);
}
catch
{
Response.Write("<script>alert('连接对象生成错误！')</script>");
}
DataSet ds = new DataSet();
da.Fill(ds, "t_admin_register");
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
ds.Tables[0].Columns[2].AllowDBNull = false;
ds.Tables[0].Columns[2].Unique = true;
//DataRow dr = new DataRow();
        DataRow dr = ds.Tables[0].NewRow();
dr["p_c_admin_ID"] = 56;
dr["c_class"] = c_class.Text;
dr["c_name"] = username.Text.ToString();
dr["c_pwd"] = pwd.Text.ToString();
//清空表单；
        c_class.Text = "";
username.Text = "";
pwd.Text = "";
int k = 1;
try
{
ds.Tables[0].Rows.Add(dr);
}
catch
{
k = 0;
Response.Write("<script>alert('此用户名已存在，请更新！')</script>");
}
finally
{
if (k == 1)
{
Response.Write("<script>alert('数据添加成功！')</script>");
}
}
return ds;
}
protected void Button1_Click(object sender, EventArgs e)
{
GridView1.DataSource = DataSetText2();
GridView1.DataBind();
}