Click here to Skip to main content
15,916,945 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
AnswerRe: how to create setup file for a sql server 2000 database project in vb.net Pin
Paul Conrad25-Jul-07 11:51
professionalPaul Conrad25-Jul-07 11:51 
QuestionForm with no titlebar Pin
kaleem tarar25-Jul-07 6:39
kaleem tarar25-Jul-07 6:39 
AnswerRe: Form with no titlebar Pin
Luc Pattyn25-Jul-07 8:22
sitebuilderLuc Pattyn25-Jul-07 8:22 
GeneralRe: Form with no titlebar Pin
Paul Conrad25-Jul-07 9:02
professionalPaul Conrad25-Jul-07 9:02 
GeneralRe: Form with no titlebar Pin
kaleem tarar25-Jul-07 10:50
kaleem tarar25-Jul-07 10:50 
GeneralRe: Form with no titlebar Pin
Paul Conrad25-Jul-07 11:01
professionalPaul Conrad25-Jul-07 11:01 
GeneralRe: Form with no titlebar Pin
Luc Pattyn25-Jul-07 12:01
sitebuilderLuc Pattyn25-Jul-07 12:01 
QuestionDatagrid image help Pin
boyindie25-Jul-07 6:33
boyindie25-Jul-07 6:33 
Hi
I have built a datagrid which should populate a set of images whose urls are stored in my database, and set each of the images in my datagrid to there corresponding addresses

I have a simple databind method which binds a dataset from a select query into my datagrid

But i am not sure how to access the image address return values, so that I can populate the values thru my datagrid.

here is my code this far

any help much appreciated
Cheers
Boyindie

<code> <asp:DataGrid runat=server ID=dgImage AllowPaging="True" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" GridLines="None" Height="73px" Width="385px" DataKeyField="imageId">
<Columns>
<asp:BoundColumn DataField=imageId HeaderText="Image ID" ></asp:BoundColumn>
<asp:TemplateColumn HeaderText=Products >
<ItemTemplate ><asp:Image runat=server ID=imageHolder ImageUrl="~/test/<%imagetable %>" />
</ItemTemplate>
</asp:TemplateColumn>
<asp:ButtonColumn HeaderText="View item" CommandName=getDetails ButtonType=PushButton Text=Select></asp:ButtonColumn>
</Columns>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditItemStyle BackColor="#2461BF" />
<SelectedItemStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<AlternatingItemStyle BackColor="White" BorderColor="#0000C0" />
<ItemStyle BackColor="#EFF3FB" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
</asp:DataGrid></code>

<code>'Builds .net mysql connection and passes connection string into method
Dim connection As New MySqlConnection(connectionString)
'Open connection to DB
connection.Open()

'Create mySql command string for passing query or SPROC(Stored Procedure)
Dim cmdString As New MySqlCommand
'Set Command to equal mySql connection, so can pass SQL query
cmdString.Connection = connection
'Set command string to equal SPROC
cmdString.CommandText = "sp_image"
'ONLY PLACE THIS IF SPROC, sets the command to a SPROC
cmdString.CommandType = CommandType.StoredProcedure


'Create dataAdaptor for passing data between .net and mySQL
Dim dataAdaptor As New MySqlDataAdapter

'Sets command object to datAdaptor
dataAdaptor.SelectCommand = cmdString


'Creates a dataset which will be filled with data from
'dataAdaptor
Dim ds As New DataSet
dataAdaptor.Fill(ds)

'Creates Table which is filled data from dataset
Dim dataTable As New DataTable

dataTable = ds.Tables(0)

'Sets datagrids source to datatable
dgImage.DataSource = dataTable
'binds ds to datgrid
dgImage.DataBind()</code>
QuestionHow to do .Net performance measures? Pin
ffgtrg1616g261225-Jul-07 2:59
ffgtrg1616g261225-Jul-07 2:59 
AnswerRe: How to do .Net performance measures? Pin
Paul Conrad25-Jul-07 8:57
professionalPaul Conrad25-Jul-07 8:57 
GeneralRe: How to do .Net performance measures? Pin
ffgtrg1616g261225-Jul-07 22:48
ffgtrg1616g261225-Jul-07 22:48 
GeneralRe: How to do .Net performance measures? Pin
Paul Conrad26-Jul-07 10:11
professionalPaul Conrad26-Jul-07 10:11 
Question.Net 2.0, Classic ASP, and IIS 5.x Pin
#realJSOP25-Jul-07 1:43
professional#realJSOP25-Jul-07 1:43 
AnswerRe: .Net 2.0, Classic ASP, and IIS 5.x Pin
kubben25-Jul-07 2:06
kubben25-Jul-07 2:06 
AnswerRe: .Net 2.0, Classic ASP, and IIS 5.x Pin
Pete O'Hanlon25-Jul-07 3:13
mvePete O'Hanlon25-Jul-07 3:13 
Questionchanging the input language only for my own application Pin
jamilkhan00724-Jul-07 20:57
jamilkhan00724-Jul-07 20:57 
QuestionVisual Studio Pin
boyindie23-Jul-07 23:03
boyindie23-Jul-07 23:03 
AnswerRe: Visual Studio Pin
Colin Angus Mackay23-Jul-07 23:18
Colin Angus Mackay23-Jul-07 23:18 
GeneralRe: Visual Studio Pin
boyindie23-Jul-07 23:21
boyindie23-Jul-07 23:21 
Questiondoubt Pin
shankari.L23-Jul-07 22:59
shankari.L23-Jul-07 22:59 
AnswerRe: doubt Pin
Paul Conrad24-Jul-07 5:52
professionalPaul Conrad24-Jul-07 5:52 
QuestionRiddle me this Batman... Pin
BoneSoft23-Jul-07 5:28
BoneSoft23-Jul-07 5:28 
AnswerRe: Riddle me this Batman... Pin
Dave Kreskowiak23-Jul-07 5:53
mveDave Kreskowiak23-Jul-07 5:53 
GeneralRe: Riddle me this Batman... [modified] Pin
BoneSoft23-Jul-07 6:09
BoneSoft23-Jul-07 6:09 
GeneralRe: Riddle me this Batman... Pin
Dave Kreskowiak23-Jul-07 6:50
mveDave Kreskowiak23-Jul-07 6:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.