How Can I Display Sql Stored Data Into Datalist

Question

1.00/5 (2 votes)

See more:

Dear all
In my first page i am inserting values (name,city and image) into sql database , and second page fatch all those values from database and display it ,
but my datalist will not display the data . can anybody tell me how can datalist show data from database. I have use two label and one image control into datalist
default.aspx page:
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">

  Name:
<asp:TextBox ID="TextBox1" runat="server">

City:
<asp:TextBox ID="TextBox2" runat="server">

Photo:
<asp:FileUpload ID="FileUpload1" runat="server" />


<asp:Label ID="Label1" runat="server" ForeColor="Red"
Text="Please insert your Image" Visible="False">


<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Save"
Width="125px" />

</form>
</body>
</html>

Default.aspx.cs page:
public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("Data Source=NITIN;Initial Catalog=test;Integrated Security=True");
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
if (FileUpload1.FileName == "")
{
Label1.Visible = true;
}
else
{
string fpath = "~\\Upload\\" + FileUpload1.FileName;
FileUpload1.PostedFile.SaveAs(Server.MapPath(fpath));
string query = "insert into fst values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + fpath + "')";
SqlDataAdapter da = new SqlDataAdapter(query, con);
DataSet ds = new DataSet();
da.Fill(ds);
Response.Write("Values Inserted");
DisplayNextPage();
}
}
public void DisplayNextPage()
{
con.Open();
SqlCommand cmd = new SqlCommand("select*from fst", con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (TextBox1.Text == dr[0].ToString())
{
Session["name"] = dr[0].ToString();
Session["city"] = dr[1].ToString();
Session["img"] = dr[2].ToString();
Response.Redirect("Default2.aspx");
}
}
con.Close();
}
}

default2.aspx page
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">

Welcome
<asp:Label ID="Label1" runat="server" Text="Label">

Your City is
<asp:Label ID="Label2" runat="server" Text="Label">

<asp:Image ID="Image1" runat="server" Height="121px" Width="108px" />

Data Bound Control

<asp:DataList ID="DataList1" runat="server" Width="280px">
<itemtemplate>
<asp:Label ID="Label3" runat="server" Text="Label">

<asp:Label ID="Label4" runat="server" Text="Label">

<asp:Image ID="Image2" runat="server" Height="70px" Width="54px" />

</form>
</body>
</html>

default2.aspx.cs
public partial class Default2 : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("Data Source=NITIN;Initial Catalog=test;Integrated Security=True");

protected void Page_Load(object sender, EventArgs e)
{
Label1.Text = Session["name"].ToString();
Label2.Text = Session["city"].ToString();
Image1.ImageUrl = Session["img"].ToString();
display();
}
public void display()
{
SqlDataAdapter da = new SqlDataAdapter("Select * from fst", con);
DataSet ds = new DataSet();
da.Fill(ds);
DataList1.DataSource = ds;
DataList1.DataBind();
}
}

My Sql data query
create database test
use test
create table fst (sname varchar(50),city varchar(50),snap varchar(100))
select*from fst

Posted 23-Apr-14 1:02am

Member 10273293

Add a Solution

Comments

Sunasara Imdadhusen 23-Apr-14 7:22am

So using this code what is your problem? please do not post entire code it will reduce chances to get solutions from the community.

4 solutions

Solution 2

you need to define itemtemplate for your datalist and then bind the data.

Here are some sampels for reference.

http://www.webcodeexpert.com/2013/06/how-to-bind-datalist-using.html#.U1efpOmKDcs[^]

http://msdn.microsoft.com/en-us/library/aa719635(v=vs.71).aspx[^]

Posted 23-Apr-14 1:15am

Naz_Firdouse

Solution 4

XML

no error
i have solve it Sir the correct code is
<asp:Label ID="Label3" runat="server" Text='<%# Eval("name") %>' ></asp:Label>
<asp:Label ID="Label4" runat="server" Text='<%# Eval("city") %>'></asp:Label>
<asp:Image ID="Image2" runat="server" ImageUrl='<%# Eval("snap") %>' Height="70px" Width="54px" />
Your advice help me a lot , thank you Sir

Posted 24-Apr-14 0:39am

Member 10273293

Solution 3

I don't understand the code can you please tell me how to modify this code , this is my datalist source code and sql query
<asp:datalist id="DataList1" runat="server" width="280px" xmlns:asp="#unknown">
<itemtemplate>
<asp:label id="Label3" runat="server" text="Label">
<asp:label id="Label4" runat="server" text="Label">
<asp:image id="Image2" runat="server" height="70px" width="54px">

SQL Query:
create database test
use test
create table fst (sname varchar(50),city varchar(50),snap varchar(100))
Now please tell me where to edit the code so that datalist display all value from sql

Posted 23-Apr-14 20:11pm

Member 10273293

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ravikhoda · Accepted Answer · 2014-04-23T01:10:00

Solution 1

i think you need to use Eval function on the html part in your code to bind datalist with your data. use something like below

ASP.NET

<asp:label id="Label3" runat="server" text="<%#Eval("ColumnName")%>" xmlns:asp="#unknown">


</asp:label>

Posted 23-Apr-14 1:10am

ravikhoda

Comments

Member 10273293 23-Apr-14 7:37am

i have try this but this code will not display image in datalist

ravikhoda 23-Apr-14 7:39am

for image you can again bind the img with src / imageurl tag.

<asp:Image ID="Image2" runat="server" Height="70px" Width="54px" ImageUrl='<%#Eval("ColumnName")%>' />

append the path of the image with above .

Member 10273293 23-Apr-14 7:43am

show the error "server tage not in well formatted"
and my code looking like this
Data Bound Control<br />
<asp:DataList ID="DataList1" runat="server" Width="280px">
<itemtemplate>
<asp:Label ID="Label3" runat="server" Text="<%#Eval("sname")%>">

<asp:Label ID="Label4" runat="server" Text="<%#Eval("city")%>">

<asp:Image ID="Image2" runat="server" Height="70px" Width="54px" ImageUrl='<%#Eval("snap")%>' />

<br />
<br />

ravikhoda 23-Apr-14 8:00am

src="Admin/images/<%#Eval ("Image") %>" this is what i used one of my code. where my images are placed inside the admin/images folder. try this and let me know if works.

Member 10273293 24-Apr-14 2:12am

I don't understand the code can you please tell me how to modify this code , this is my datalist source code and sql query
<asp:DataList ID="DataList1" runat="server" Width="280px">
<itemtemplate>
<asp:Label ID="Label3" runat="server" Text="Label">
<asp:Label ID="Label4" runat="server" Text="Label">
<asp:Image ID="Image2" runat="server" Height="70px" Width="54px" />

SQL Query:
create database test
use test
create table fst (sname varchar(50),city varchar(50),snap varchar(100))
Now please tell me where to edit the code so that datalist display all value from sql

ravikhoda 24-Apr-14 2:24am

Well first tell me how do you store your image. is it stored directly in the database or you just save the name of the image in the database and origional image is saved on server in some folder ? in my case i was storing the name of the file in database and save file inside image folder so according to my above code

i get the image name value from the database and bind it with src attribute of the image.

src='Admin/images/<%#Eval ("Image") %>'

so in this way my src becomes url/admin/images/imagename.jpg and it loads completely on the browser. i hope this will help you.

Member 10273293 24-Apr-14 2:31am

I have using this code to insert image in sql database, in this code Upload is a folder name which is attached in this project.
protected void Button1_Click(object sender, EventArgs e)
{
if (FileUpload1.FileName == "")
{
Label1.Visible = true;
}
else
{
string fpath = "~\\Upload\\" + FileUpload1.FileName;
FileUpload1.PostedFile.SaveAs(Server.MapPath(fpath));
string query = "insert into fst values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + fpath + "')";
SqlDataAdapter da = new SqlDataAdapter(query, con);
DataSet ds = new DataSet();
da.Fill(ds);
Response.Write("Values Inserted");
DisplayNextPage();
}
}

ravikhoda 24-Apr-14 4:44am

so now you need to add change your datalist html like this

<img src='upload/<%#eval("Image")%>' alt='<%#eval("Image")%>'/>

this will work as i am using the same thing in one of my code.

Member 10273293 24-Apr-14 6:15am

this is also not working

ravikhoda 24-Apr-14 6:30am

did you get any error ?

Member 10273293 24-Apr-14 6:35am

no error
i have solve it Sir the correct code is
<asp:Label ID="Label3" runat="server" Text='<%# Eval("name") %>' >
<asp:Label ID="Label4" runat="server" Text='<%# Eval("city") %>'>
<asp:Image ID="Image2" runat="server" ImageUrl='<%# Eval("snap") %>' Height="70px" Width="54px" />
Your advice help me a lot , thank you Sir

ravikhoda 24-Apr-14 6:44am

great.