ASP.NET

private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
// the data in the dropdownlist boxes must be added.
if (!this.IsPostBack)
{
me = new common();
ds = new DataSet();
conn = new SqlConnection(me.conString);
sda = new SqlDataAdapter("select * from users",conn);
sda.Fill(ds,"users");

projman.DataSource = ds.Tables["users"].DefaultView;
projman.DataTextField = "username";
projman.DataBind();
projman.SelectedIndex = -1;

devlead.DataSource = ds.Tables["users"].DefaultView;
devlead.DataTextField = "username";
devlead.DataBind();
devlead.SelectedIndex = -1;

testlead.DataSource = ds.Tables["users"].DefaultView;
testlead.DataTextField = "username";
testlead.DataBind();
testlead.SelectedIndex = -1;

devteam.DataSource = ds.Tables["users"].DefaultView;
devteam.DataTextField = "username";
devteam.DataBind();
devteam.SelectedIndex = -1;

testfocal.DataSource = ds.Tables["users"].DefaultView;
testfocal.DataTextField = "username";
testfocal.DataBind();
testfocal.SelectedIndex = -1;

sqefocal.DataSource = ds.Tables["users"].DefaultView;
sqefocal.DataTextField = "username";
sqefocal.DataBind();
sqefocal.SelectedIndex = -1;
}
string pgmsg = Request.QueryString.Get("qmsg");
if (!(pgmsg==null))
{
if (pgmsg.Equals("exists"))
{
msg.Text = "The project ID or name exixts already, please enter different value!";
}
}
else
{
msg.Text = "";
}
}

#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);
}

///
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///
private void InitializeComponent()
{
this.submit.Click += new System.EventHandler(this.submit_Click);
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

private void submit_Click(object sender, System.EventArgs e)
{
Response.Write("")
string proid;
proid = domain.SelectedValue + "_" + subdomain.SelectedValue + "_" + projname.Text;
bool projExists = me.chkProj(proid);
if (!projExists)
{
projExists = me.chkProj(projname.Text);
}
else
{
Response.Redirect("newproj.aspx?qmsg=exists");
}
if (!projExists)
{

string userid;
string role;
string type;
// proceed to create the DB records.
string cmdText = "insert into " + Global.project + " values ('" + domain.SelectedValue + "','" + subdomain.SelectedValue + "','" + proid + "','" + projname.Text + "')";
conn = new SqlConnection(me.conString);
com = new SqlCommand(cmdText,conn);
com.Connection.Open();
com.ExecuteNonQuery();
com.Connection.Close();
// create a record for project manager
// TODO

me.attachUser(projman.SelectedItem.Value,proid,Global.projectmanager);
// then for the test lead
me.attachUser(testlead.SelectedItem.Value,proid,Global.testlead);
// then for the dev. lead
me.attachUser(devlead.SelectedItem.Value,proid,Global.devlead);
// After all inserts redirect to base
Response.Write(projman.SelectedItem.Value);
//Response.Redirect("base.aspx");

}
else
{
Response.Redirect("newproj.aspx?qmsg=exists");
}
}
}