惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

WordPress大学
WordPress大学
D
Darknet – Hacking Tools, Hacker News & Cyber Security
Hacker News: Ask HN
Hacker News: Ask HN
N
News and Events Feed by Topic
Forbes - Security
Forbes - Security
The Last Watchdog
The Last Watchdog
TaoSecurity Blog
TaoSecurity Blog
Schneier on Security
Schneier on Security
SecWiki News
SecWiki News
V
Vulnerabilities – Threatpost
Project Zero
Project Zero
O
OpenAI News
W
WeLiveSecurity
Security Archives - TechRepublic
Security Archives - TechRepublic
Exploit-DB.com RSS Feed
Exploit-DB.com RSS Feed
H
Hacker News: Front Page
Cisco Talos Blog
Cisco Talos Blog
Spread Privacy
Spread Privacy
Help Net Security
Help Net Security
P
Privacy & Cybersecurity Law Blog
K
Kaspersky official blog
S
Security @ Cisco Blogs
Latest news
Latest news
AWS News Blog
AWS News Blog
U
Unit 42
Martin Fowler
Martin Fowler
阮一峰的网络日志
阮一峰的网络日志
S
Secure Thoughts
CTFtime.org: upcoming CTF events
CTFtime.org: upcoming CTF events
Application and Cybersecurity Blog
Application and Cybersecurity Blog
Know Your Adversary
Know Your Adversary
Scott Helme
Scott Helme
博客园 - 司徒正美
B
Blog RSS Feed
C
Check Point Blog
Hacker News - Newest:
Hacker News - Newest: "LLM"
D
Docker
Google Online Security Blog
Google Online Security Blog
Jina AI
Jina AI
aimingoo的专栏
aimingoo的专栏
Recent Commits to openclaw:main
Recent Commits to openclaw:main
Last Week in AI
Last Week in AI
月光博客
月光博客
C
CXSECURITY Database RSS Feed - CXSecurity.com
S
SegmentFault 最新的问题
NISL@THU
NISL@THU
T
The Blog of Author Tim Ferriss
C
Cisco Blogs
Attack and Defense Labs
Attack and Defense Labs
小众软件
小众软件

博客园 - 雪影

C#异步提示和技巧 关于System.Windows.Forms.DateTimePicker的一个Bug 关于frameset中指定区域回退的实现 如何编写出拥抱变化的代码? WCF RIA Services Domain Serive的生命周期和数据交互 [译]WCF RIA Services中的集合(2) [译]WCF RIA Services中的集合(1) windows8应用安装挂起的一个原因 WPF 详解模板 Silverlight --- Behavior技术(四) Silverlight --- Behavior技术(三) Silverlight --- Behavior技术(二) Silverlight --- Behavior技术(一) Silverlight的依赖属性与附加属性(六) Silverlight的依赖属性与附加属性(五) Silverlight的依赖属性与附加属性(四) Silverlight的依赖属性与附加属性(三) Silverlight的依赖属性与附加属性(二) Silverlight的依赖属性与附加属性(一)
从数据库读取图片,并固定显示
雪影 · 2006-10-18 · via 博客园 - 雪影

<asp:datagrid id="DG_Persons" Width="168px" HeaderStyle-HorizontalAlign="Center" Runat="server"
                            BorderColor
="Black" ItemStyle-BackColor="Beige" HeaderStyle-ForeColor="#ffffff" HeaderStyle-Font-Bold="True"
                            HeaderStyle
-BackColor="#ff0000" AutoGenerateColumns="False">
                            
<ItemStyle BackColor="Beige"></ItemStyle>
                            
<HeaderStyle Font-Bold="True" HorizontalAlign="Center" ForeColor="White" BackColor="Red"></HeaderStyle>
                            
<Columns>
                                
<asp:TemplateColumn HeaderText="图片">
                                    
<ItemTemplate>
                                        
<asp:Image id=Image3 Height="186px" ImageUrl='<%# FormatURL(DataBinder.Eval(Container.DataItem, "imgid")) %>' Width="212px" Runat="server">
                                        </asp:Image>
                                    
</ItemTemplate>
                                
</asp:TemplateColumn>
                            
</Columns>
                        
</asp:datagrid>

 Private Sub BindGrid(ByVal id)

        
Dim strCnn As String = "server=.;database=master1;uid=sa;pwd="

        
Dim myConnection As SqlConnection = New SqlConnection(strCnn)
        
Dim dst As New DataSet
        
Dim sda As SqlDataAdapter
        
'Dim myCommand As SqlCommand = New SqlCommand("SELECT * FROM image1 where imageid=" & i, myConnection)
        sda = New SqlDataAdapter("SELECT * FROM KS_img where imgID=" & id, myConnection)
        
'myCommand.CommandType = CommandType.Text
        dst.Clear()
        sda.Fill(dst, 
"aaa")

        
Try

            myConnection.Open()
            row 
= table.NewRow
            
'row.Item("照片") = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
            row.Item("imgid"= dst.Tables("aaa").Rows(0).Item(0)
            row.Item(
"Img"= dst.Tables("aaa").Rows(0).Item(1)
            
'row.Item("PersonImage") = dst.Tables("aaa").Rows(0).Item(2)
            'row.Item("PersonImageType") = dst.Tables("aaa").Rows(0).Item(3)
            table.Rows.Add(row)
            table.GetChanges()

            myConnection.Close()
            
Me.DG_Persons.DataSource = table
            
Me.DG_Persons.DataBind()

        
Catch SQLexc As SqlException

            Response.Write(
"Error occured while Generating Data. Error is " & SQLexc.ToString())

        
End Try

    
End Sub