0

Hi,

I am using sql data base the image save in database but it doesnt get viewed in data grid view though rest of the items are viewed. Please help me to come out of this solution.

Regards
Creativz

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;


public partial class Default5 : System.Web.UI.Page
{
    SqlConnection db = new SqlConnection("database=bank;server=.;uid=sa");
    SqlCommand cmd = new SqlCommand();


    protected void Button1_Click(object sender, EventArgs e)
    {
        
            

        SqlDataAdapter da = new SqlDataAdapter("select * from loans", db);
        DataSet ds = new DataSet();
        da.Fill(ds,"bank");
        GridView1.DataSource = ds;
        GridView1.DataBind();
         db.Close();
    }
    
    
    }




<asp:GridView ID="GridView1" AutoGenerateColumns="False" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None">
            <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
            <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
            <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" />           
           
            <Columns>
                <asp:BoundField DataField="fathername" HeaderText="Father Name" />
                <asp:BoundField DataField="mothername" HeaderText="MotherName" />
                <asp:BoundField DataField="ms" HeaderText="Martial Status" />
                <asp:BoundField DataField="occupation" HeaderText="Occupation" />
                <asp:BoundField DataField="docname" HeaderText="Doc Name" />
                <asp:ImageField DataImageUrlField="document" HeaderText="document">
                </asp:ImageField>
                <asp:BoundField DataField="address" HeaderText="address" />
                <asp:BoundField DataField="zipcode" HeaderText="Zipcode" />
                <asp:BoundField DataField="phone" HeaderText="Phone" />
                <asp:BoundField DataField="mobile" HeaderText="Mobile" />
                
                   
           
            </Columns>
           
        </asp:GridView>

Edited by __avd: To change a title.

2
Contributors
1
Reply
3
Views
7 Years
Discussion Span
Last Post by __avd
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.