网格视图中的问题从数据库中检索图片 [英] Problem in Grid View Retrieving Pictures From Database
本文介绍了网格视图中的问题从数据库中检索图片的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我在为我的项目工作。我已成功将图片插入数据库，但是当我想使用网格视图在网页上显示时，它会显示其他详细信息但不显示图像。
这是用于将图像插入数据库的代码。
I am Working on My Project. I have Successfully Insert Pictures into the the database but when i want to display this on the web page using Grid View, it displays other details but doesn't display the images.
This is the Code For Inserting Images into the Database.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
public partial class AddParty : System.Web.UI.Page
{
DBClass db1 = new DBClass();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void BtnAddParty_Click1(object sender, EventArgs e)
{
int userId = 0;
string message = string.Empty;
try
{
FileUpload img = (FileUpload)PartyimgUpload;
FileUpload img2 = (FileUpload)PartyFlagimgUpload;
Byte[] imgByte = null;
Byte[] imgByte2 = null;
if (img.HasFile && img.PostedFile != null)
{
//To create a PostedFile
HttpPostedFile File = PartyimgUpload.PostedFile;
//Create byte Array with file len
imgByte = new Byte[File.ContentLength];
//force the control to load data in array
File.InputStream.Read(imgByte, 0, File.ContentLength);
}
if (img2.HasFile && img2.PostedFile != null)
{
//To create a PostedFile
HttpPostedFile File1 = PartyFlagimgUpload.PostedFile;
//Create byte Array with file len
imgByte2 = new Byte[File1.ContentLength];
//force the control to load data in array
File1.InputStream.Read(imgByte, 0, File1.ContentLength);
}
db1.sqlcmd = new SqlCommand("UspAddParty");
using (SqlDataAdapter sda = new SqlDataAdapter())
{
db1.sqlcmd.CommandType = CommandType.StoredProcedure;
db1.sqlcmd.Parameters.AddWithValue("@PartyName", TxtBxPartyName.Text.Trim());
db1.sqlcmd.Parameters.AddWithValue("@PartyLeader", TxtBxPLeader.Text.Trim());
db1.sqlcmd.Parameters.AddWithValue("@PartyAddress", TxtBxPAdress.Text.Trim());
db1.sqlcmd.Parameters.AddWithValue("@PartyLogo", imgByte);
db1.sqlcmd.Parameters.AddWithValue("@PartyFlag", imgByte2);
db1.sqlcmd.Parameters.AddWithValue("@PartyDescription", TxtBoxPartyDescription.Text.Trim());
db1.sqlcmd.Connection = db1.sqlcon;
db1.sqlcon.Open();
userId = Convert.ToInt32(db1.sqlcmd.ExecuteScalar());
//Response.Write(userId);
//int id = Convert.ToInt32(cmd.ExecuteScalar());
//lblResult.Text = String.Format("Employee ID is {0}", id);
//Image1.ImageUrl = "~/ShowImage.ashx?id=" + id;
switch (userId)
{
case -1:
message = "Party Name already exists.\\nPlease choose a different Party Name.";
break;
default:
message = "Registration successful.\\nParty Id: " + userId.ToString();
break;
}
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + message + "');", true);
}
}
catch
{
}
finally
{
TxtBxPartyName.Text = null;
TxtBoxPartyDescription.Text = null;
db1.sqlcon.Close();
Server.TransferRequest(Request.Url.AbsolutePath, false);
}
}
}
CREATE PROC UspAddParty
@PartyName NVARCHAR(30),@PartyLeader Varchar(50),@PartyAddress Varchar(max), @PartyLogo image,@PartyFlag image, @PartyDescription VARCHAR(MAX)
AS
BEGIN
SET NOCOUNT ON;
IF EXISTS(SELECT PartyId FROM TblParty WHERE PartyName = @PartyName)
BEGIN
SELECT -1 -- Party exists.
END
ELSE
BEGIN
INSERT INTO TblParty (PartyName,PartyLeader,PartyLogo,PartyFlag,PartyAddress,PartyDescription) VALUES(@PartyName,@PartyLeader,@PartyLogo,@PartyFlag,@PartyAddress,@PartyDescription) SELECT @@IDENTITY
SELECT SCOPE_IDENTITY() -- PartyId
END
END
这是在网页上显示整个数据的代码。
Here is the Code For Displaying This Whole data on the Web page.
<div style="width:96%; height:450px; margin:0 auto; margin-removed70px; border:3px groove black; overflow: scroll;">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="Black" GridLines="Horizontal">
<Columns>
<asp:BoundField DataField="PartyName" HeaderText="PartyName" SortExpression="PartyName" />
<asp:BoundField DataField="PartyLeader" HeaderText="PartyLeader" SortExpression="PartyLeader" />
<asp:BoundField DataField="PartyAddress" HeaderText="PartyAddress" SortExpression="PartyAddress" />
<asp:BoundField DataField="PartyLogo" HeaderText="PartyLogo" SortExpression="PartyLogo" />
<asp:BoundField DataField="PartyFlag" HeaderText="PartyFlag" SortExpression="PartyFlag" />
<asp:BoundField DataField="PartyDescription" HeaderText="PartyDescription" SortExpression="PartyDescription" />
</Columns>
<FooterStyle BackColor="#CCCC99" ForeColor="Black" />
<HeaderStyle BackColor="#333333" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Right" />
<SelectedRowStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F7F7F7" />
<SortedAscendingHeaderStyle BackColor="#4B4B4B" />
<SortedDescendingCellStyle BackColor="#E5E5E5" />
<SortedDescendingHeaderStyle BackColor="#242121" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ECII(Old)ConnectionString %>" SelectCommand="SELECT [PartyName], [PartyLeader], [PartyLogo], [PartyFlag], [PartyAddress], [PartyDescription] FROM [TblParty]"></asp:SqlDataSource>
</div>
推荐答案
ConnectionStrings：ECII（旧）ConnectionString％> SelectCommand = SELECT [PartyName]，[PartyLeader]，[PartyLogo]，[PartyFlag]，[PartyAddress]，[PartyDescription] FROM [TblParty] > < / asp：SqlDataSource >
< < span class =code-leadattribute> / div >
ConnectionStrings:ECII(Old)ConnectionString %>" SelectCommand="SELECT [PartyName], [PartyLeader], [PartyLogo], [PartyFlag], [PartyAddress], [PartyDescription] FROM [TblParty]"></asp:SqlDataSource> </div>
这篇关于网格视图中的问题从数据库中检索图片的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
