如何从数据库中检索图像并将其显示在asp.net中滑块的网页上。这些图像可以从管理员动态添加或删除。 [英] how to retrieve the images from database and display it on webpage in slider in asp.net.This images can be added or removed dynamically from admin.

问题描述

如何在c＃asp.net.please中实现这一点帮助 asap ...



编辑 - asap（紧急）删除

how to implement this in c# asp.net.please help asap...

Edit - asap (urgency) removed

推荐答案

以下代码将给出从数据库显示图像的想法

< br $>




string roll_no = 您的搜索参数

string sConn = System.Configuration.ConfigurationManager.ConnectionStrings [YOUR_CONNECTIONSTRING_NAME]。ToString（）;

SqlConnection objConn = new SqlConnection（sConn）;

objConn.Open（）;

string sTSQL =从图片中选择img，其中Roll_no = @ roll_no;

SqlCommand objCmd = new SqlCommand（sTSQL，objConn）;

objCmd.CommandType = CommandType.Text;

objCmd.Parameters.AddWithValue（@ roll_no，roll_no.ToString（））;

object data = objCmd.ExecuteScalar（）; //这将把你的形象视为对象

objConn.Close（）;

objCmd.Dispose（）;

context.Response.BinaryWrite（（byte []）data）; //这将在屏幕上写下您的图像





--------------------------------------------- ----------------------------

Image1.ImageUrl = ImageHandler.ashx？roll_no = + txtrollno.Text; //图片网址





=> ImageHandler.ashx //这是一个处理器，上面的所有代码都是写作

创建HANDLER的步骤： -

添加新项目=>选择GENERIC HANDLER。

Following code will give the idea for showing image from database



string roll_no = "Your Search Parameter"
string sConn = System.Configuration.ConfigurationManager.ConnectionStrings["YOUR_CONNECTIONSTRING_NAME"].ToString();
SqlConnection objConn = new SqlConnection(sConn);
objConn.Open();
string sTSQL = "select img from Images where Roll_no=@roll_no";
SqlCommand objCmd = new SqlCommand(sTSQL, objConn);
objCmd.CommandType = CommandType.Text;
objCmd.Parameters.AddWithValue("@roll_no", roll_no.ToString());
object data = objCmd.ExecuteScalar(); //THIS WILL TAKE YOUR IMAGE AS OBJECT
objConn.Close();
objCmd.Dispose();
context.Response.BinaryWrite((byte[])data);//THIS WILL WRITE YOUR IMAGE ON SCREEN


-------------------------------------------------------------------------
Image1.ImageUrl = "ImageHandler.ashx?roll_no=" + txtrollno.Text; //IMAGE URL


=>ImageHandler.ashx // THIS IS A HANDLER WHERE ALL THE ABOVE CODE TO BE WRITTEN
STEPS TO CREATE HANDLER :-
ADD NEW ITEMS =>SELECT GENERIC HANDLER.

这篇关于如何从数据库中检索图像并将其显示在asp.net中滑块的网页上。这些图像可以从管理员动态添加或删除。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！