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