protected void Page_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString; string strQuery = "select SOCIETY, IMAGE from IMG_UPLOAD"; SqlCommand cmd = new SqlCommand(strQuery); SqlConnection con = new SqlConnection(strConnString); SqlDataAdapter sda = new SqlDataAdapter(); cmd.CommandType = CommandType.Text; cmd.Connection = con; try { con.Open(); sda.SelectCommand = cmd; sda.Fill(dt); GridViewIMG.DataSource = dt; GridViewIMG.DataBind(); } catch (Exception ex) { Response.Write(ex.Message); } finally { con.Close(); sda.Dispose(); con.Dispose(); } }
protected void Page_Load(object sender, EventArgs e) { String soname = ""; Label1.Text = Session["value2"].ToString(); if (Label1 != null) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString); conn.Open(); SqlCommand cmd1 = new SqlCommand("SELECT SNAME FROM ADMIN_REG WHERE USERNAME=@USERNAME", conn); cmd1.Parameters.AddWithValue("@USERNAME", Label1.Text); SqlDataReader usernameRdr = null; usernameRdr = cmd1.ExecuteReader(); while (usernameRdr.Read()) { soname = usernameRdr["SNAME"].ToString(); Label2.Text = soname; } } SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString); SqlCommand cmd2 = new SqlCommand("SELECT IMAGE FROM IMG_UPLOAD WHERE USERNAME=@USERNAME", con); cmd2.Parameters.AddWithValue("@USERNAME", Label1.Text); DataTable dt = new DataTable(); SqlDataAdapter sda = new SqlDataAdapter(); cmd2.CommandType = CommandType.Text; cmd2.Connection = con; try { con.Open(); sda.SelectCommand = cmd2; sda.Fill(dt); GridViewIMG.DataSource = dt; GridViewIMG.DataBind(); } catch (Exception ex) { Response.Write(ex.Message); } finally { con.Close(); sda.Dispose(); con.Dispose(); } }