protected void Page_Load(object sender, EventArgs e)
{
List <RegistrationFormHtml5.Entities.User> users = (List <RegistrationFormHtml5.Entities.User>)Session["users"];
UserDetails.DataSource = users;
UserDetails.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
using (SqlConnection sqlcon = new SqlConnection(connectionString))
{
sqlcon.Open();
SqlDataAdapter sqlDa = new SqlDataAdapter("select * from Userreg where Vehicle1 = '" + TextBox1.Text + "'", sqlcon);
DataTable dtb1 = new DataTable();
sqlDa.Fill(dtb1);
UserDetails.DataSource = dtb1;
UserDetails.DataBind();
}
}
private void LoadUserInfo(string UserID)
{
try
{
string ConnectionString = WebConfigurationManager.ConnectionStrings["YahooCon"].ConnectionString;
MySqlConnection viewTemplate = new MySqlConnection(ConnectionString);//explisionremoteEntities{0}", Request.QueryString["ID"]);
string query = String.Format("SELECT Email,Username FROM Users WHERE UsersID='" + UserID + "'");
using (MySqlDataAdapter viewTemplateSet = new MySqlDataAdapter(query, viewTemplate))
{
DataSet viewDSet = new DataSet();
viewTemplateSet.Fill(viewDSet);
UserDetails.DataSource = viewDSet;
UserDetails.DataBind();
//UserName.Text = viewDSet.Tables[0].Rows[0]["Username"].ToString();
}
}
catch (Exception ex)
{
Response.Write("<br>Error: <br>" + ex.Message);
}
}