How should I use result of SQL query in ASP.net?

Question

Below code is from Course.aspx

 <asp:Image runat="server" ImageUrl="ShowImage.ashx?id={?}" alt="" Width="600px" Height="450px" />

Below code is from CourseDetail.cs

var courseid = Request.QueryString["courseid"].ToString();
string sql = "SELECT * FROM Course where CourseID=@CourseID";
string[] name = { "@CourseID" };
string[] value = { courseid };
DataTable dt = DataBase.SQLselect(sql, name, value);

ShowImage.ashx?id={courseid} this code works great. I check with any current number suc as ShowImage.ashx?id=5.

Now I want to know how I shloud call CourseID in Course.aspx :

ImageUrl="ShowImage.ashx?id={CourseID} ??

I thought you said the code works great? Whats the problem... — Fizor
– Fizor, Commented Apr 10, 2014 at 6:40
I mean that when I write ShowImage.ashx?id=5 manually , it works, But I need to use CourseID such as ShowImage.ashx?id={Call CourseID} . — Jeyhun
– Jeyhun, Commented Apr 10, 2014 at 6:43

serhads · Accepted Answer · 2014-04-10 06:42:18Z

2

In aspx side put ID to your element.

 <asp:Image runat="server" ID="imgCourse" alt="" Width="600px" Height="450px" />

Than in .cs side call your object.

imgCourse.ImageUrl="ShowImage.ashx?id=" + dt.courseID.ToString();

answered Apr 10, 2014 at 6:42

serhads

4622 gold badges7 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jeyhun Over a year ago

But genereally Dont you know how can I write as I said ?

serhads Over a year ago

What do you mean? Do you want to bind data in aspx side? If yes, your element has to be in repeter,listview etc. And you can bind ID from datasource which is already binded to repeter. For this kind of single element its easy and efficient to set data in .cs side.

Jeyhun Over a year ago

here I dont need repeater. For example you sign in facebook.com and when you go to your Profil page you can see your data (forexample profilphoto).

Collectives™ on Stack Overflow

How should I use result of SQL query in ASP.net?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related