- Code: Select all
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px"
CellPadding="3" CellSpacing="2" DataKeyNames="MI_PRINX"
DataSourceID="SqlDataSource1" EnableModelValidation="True">
<Columns>
<asp:CommandField ShowSelectButton="True" SelectText="Image" />
<asp:BoundField DataField="ROUTE" HeaderText="ROUTE" SortExpression="ROUTE" />
<asp:BoundField DataField="INST_KEY" HeaderText="INST_KEY"
SortExpression="INST_KEY" />
<asp:BoundField DataField="INST_TYPE" HeaderText="INST_TYPE"
SortExpression="INST_TYPE" />
<asp:BoundField DataField="ACCT_KEY" HeaderText="ACCT_KEY"
SortExpression="ACCT_KEY" />
<asp:BoundField DataField="STATUS" HeaderText="STATUS"
SortExpression="STATUS" />
<asp:BoundField DataField="DMZ" HeaderText="DMZ" SortExpression="DMZ" />
<asp:BoundField DataField="CUST_NAME" HeaderText="CUST_NAME"
SortExpression="CUST_NAME" />
<asp:BoundField DataField="ADDRESS_LINE1" HeaderText="ADDRESS_LINE1"
SortExpression="ADDRESS_LINE1" />
<asp:BoundField DataField="ADDRESS_LINE2" HeaderText="ADDRESS_LINE2"
SortExpression="ADDRESS_LINE2" />
<asp:BoundField DataField="ADDRESS_LINE3" HeaderText="ADDRESS_LINE3"
SortExpression="ADDRESS_LINE3" />
<asp:BoundField DataField="ADDRESS_LINE4" HeaderText="ADDRESS_LINE4"
SortExpression="ADDRESS_LINE4" />
<asp:BoundField DataField="ADDRESS_LINE5" HeaderText="ADDRESS_LINE5"
SortExpression="ADDRESS_LINE5" />
<asp:BoundField DataField="METER_KEY" HeaderText="METER_KEY"
SortExpression="METER_KEY" />
<asp:BoundField DataField="SIZE" HeaderText="SIZE" SortExpression="SIZE" />
<asp:BoundField DataField="INSTALL_DATE" HeaderText="INSTALL_DATE"
SortExpression="INSTALL_DATE" />
<asp:BoundField DataField="CONS_01" HeaderText="CONS_01"
SortExpression="CONS_01" />
<asp:BoundField DataField="CONS_02" HeaderText="CONS_02"
SortExpression="CONS_02" />
<asp:BoundField DataField="CONS_03" HeaderText="CONS_03"
SortExpression="CONS_03" />
<asp:BoundField DataField="X" HeaderText="X" SortExpression="X" />
<asp:BoundField DataField="Y" HeaderText="Y" SortExpression="Y" />
<asp:BoundField DataField="Z" HeaderText="Z" SortExpression="Z" />
<asp:BoundField DataField="MI_STYLE" HeaderText="MI_STYLE"
SortExpression="MI_STYLE" />
<asp:BoundField DataField="MI_PRINX" HeaderText="MI_PRINX"
InsertVisible="False" ReadOnly="True" SortExpression="MI_PRINX" />
</Columns>
<FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
<HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
<PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
<RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ATBGISMAPDBConnectionString %>"
SelectCommand="SELECT * FROM [DBCUSTOMER] WHERE ([CUST_NAME] LIKE '%' + @CUST_NAME + '%')">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="CUST_NAME" PropertyName="Text"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>
Nah disini yang bikin ane bingung karena belum dapet sample yang pas (ane selalu dapet contoh file image-nya dari satu table). jadi pilihan Image itu akan memanggil file image yang ada di table METER_SURVEY.
Mohon pencerahannya mastah-mastah asp.net untuk mengatasi permasalah tersebut.
Makasih..

