Asp.net - Displaying Different Pictures In GridView Depending On The Data?
Dec 14, 2011
I am creating a WEB report in Visual Studio 2010 in VB.net. The report needs to display a table (please see the attached image). I am thinking to use the GridView component which i think it's the most appropriate one to choose. In the database there are students' data and marks. I can't alter the database in any way and i have to use Visual Studio 2010 with VB.
What i need to do is to show 3 different pictures(for example) depend on the student's marks. I got the pictures file in PNGs but this can be flexible.For example, over 70 will be a Smile picture. over 60 will be the Normal face. and over 40 will be the picture with no smile. I bit difficult for me to explain but i hope u get my point.
So pls advice me how can i achieve this. I am quite a newbie to this pls put as detail as you can. if there is a choice between client and server side script, i prefer server side script. Data source can be flexible (sql, or linq or anything).
View 1 Replies
ADVERTISEMENT
Nov 11, 2009
I have tried connecting to mysql and its working ghood now but the problem is am not able to display it in gridview or datagrid so that the data shown will look formatted
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
Dim conn As ADODB.Connection
[Code].....
View 1 Replies
Oct 19, 2011
I'm trying to create a document that displays a list of items, with details below each item. I feel like what I'm trying to do should be relatively simple, and the answer is hiding under my nose, but I can't find what I'm looking for.
For an example, let's say I'm just listing people, with a child list of their favorite foods.
This is how the data will eventually be displayed:
[Code]...
I'm trying to do this with a gridview control. I'm not sure that's what I should be using. But what I'm having trouble with, is getting the gridview to only list items with a unique USERID. And then using that unique USERID to list each item individually below.
Is there any kind of "automated" way of pulling this off using standard .net controls without going in and manually piecing it all together from the codebehind?
View 1 Replies
Apr 28, 2009
I am using a ListView control to display Pictures along with description and caption. I used to save the full path of the image in the url field, so when I display them in the ListView I don't need to edit anything. Now I am using something like:
HttpContext.Current.Server.MapPath("~/photos/") + savedURL
How can I edit my ListView to make it show the images?
I used to do the same to GridView when in GridViews RowDataBound event I manipulate the contents like:
Dim photo As New Image
photo.ImageUrl = "~/photos/" + e.Row.Cells(TheCellNumber).Text
e.Row.Cells(0).Controls.Clear()
e.Row.Cells(0).Controls.Add(photo)
View 3 Replies
Feb 17, 2010
if i pressed the RadioButton .. ENGLISH.. only Teacher's which teach English will be displayed in the listbox and so on. there is in access table called TEACHER which has all these information. i used the following code for displaying the TEACHERS' name in listbox and it worked pefectly but what i want is displaying according to radiobutton checked.
Sub conxn1()
Connection.Open()
Dim da As New OleDb.OleDbDataAdapter("select * from Teacher ", Connection)
[Code]....
View 5 Replies
Oct 10, 2007
Hey, Just trying to loop through my gridview and change the color of the row if the first cell equals a given value. This is the code I am trying but does not work.
vb
With gvItemList
For i = 1 To .Rows.Count - 1
If .Rows(i).Cells.Item(0).ToString = stValue Then
.Rows(i).BackColor = Drawing.Color.CadetBlue
End If
[Code]...
View 7 Replies
Jun 6, 2011
I want the web browser to run much quicker: To acheive this I would like to disable the vb webbrowser from displaying pictures. I could not find a property to do this, within the vb browser settings + I would rather not have to fiddle with computer's registry files.
View 3 Replies
Jun 6, 2011
I want the web browser to run much quicker:To acheive this I would like to disable the vb webbrowser from displaying pictures.I could not find a property to do this, within the vb browser settings
View 1 Replies
Mar 5, 2011
i have 2 tables assignment and feedback, in a gridview it displays all the assignments, the assignments then get feedback. im then wanting to change the view feedback button in the gridview depending on if there is new feedback for example:the feedback table has a state field in it so when its 1 i want that image button to change to the one with the +
View 1 Replies
Dec 6, 2010
Im trying to change the information on each row depending on the result from the query. Im thinking that at the minute my problem is that I'm only returning the first result from the query into the result.
e.g. query returns row 1 with '1232' row 2 '1243' but result is only ever set to '1232'
View 1 Replies
May 7, 2011
I have a query which is pulling values from a table in MS Access
SELECT
tblInstructor.InstructorID,
tblInstructor.Football AS InstructorRole,
[code].....
View 2 Replies
Dec 6, 2010
I am quite new to visual basic & programming, so please bare with me. After spending at least 64 hours designing and coding a cinema booking, i have stumbled across a little problem.The task i am having trouble with is creating a graph, using only labels and/or textboxes, to display a number of stars depending on how many seats have been booked in a screen. Here is an example of sample design i have been given:
[Code]...
View 4 Replies
Sep 1, 2011
I have a gallery which holds a large number of thumbnail images and I want to show 6 at a time.
I have this working using the code below, but I can not get the images to display as 2 rows of 3 - it shows as 6 rows of 1.
I can get the desired result by using a datalist but that stops the pageindex function from working.
I'm sure there's an easy solution but I can't figure it out.
<asp:GridView id="GridView1" runat="server" AutoGenerateColumns="False" AllowPaging="True" PageSize="6" onpageindexchanging="PageIndexChanged" PagerSettings-Mode="NextPrevious" PagerSettings-NextPageText="Next" PagerSettings-PreviousPageText="Previous">
[Code].....
View 3 Replies
Nov 21, 2011
I am working on an ASP.Net website and have a GridView displaying some data,in the OnRowDataBound event I am setting the border of the row for certain rows based on some criteria. This all worked fine when I was testing my pages locally, however when I put these pages within our master page (this is part of a company intranet site) the row borders disappear in IE yet display fine in firefox.
Is there anything that could be causing this? So far there is no CSS style applied that I know of as I set the border inside the event handler like so:
e.Row.BorderStyle = BorderStyle.Solid
e.Row.BackColor = Color.FromName("#fed69c")
e.Row.BorderColor = Color.FromName("Red")
[code].....
View 2 Replies
May 10, 2012
I have two comboboxes say
DDL 1 : Artist
DDL 2: Albums
And a Gridview containing (album name, artist name, no.of tracks, year, etc), What I want to achieve is: when an option(artist1) in DDL1 is chosen, then the albums related to DDL1 needs to display in DDL2 and also it must update the appropriate values in the gridview (artistname, albums(album name -no of songs, year)etc... based on the selection made (language: Asp.net(VB)-Sql server ).
View 2 Replies
Oct 10, 2011
This is a follow up to my previous question: Filter DirectoryInfo files by date in asp.net
I have a gridview that is populating data from DirectoryInfo. However, I only want to display certain columns, and customize the column names and the hyperlink value in the row.
My code is:
Dim files As FileInfo() = New DirectoryInfo(strDirectoryPath).GetFiles().Where(Function(x) x.LastWriteTime >= (dtStartDate) AndAlso x.LastWriteTime <= (dtEndDate)).ToArray()
[Code]....
How can I loop through the columns, to display only "name", "extension" and LastWriteTime?
View 1 Replies
May 20, 2010
I am doing my application with ASP and VB and I want to display a list off rows in a gridview and associate a contextual menu to each line.
View 2 Replies
Aug 20, 2011
I'm having a problem displaying an image from an ObjectData Source created by function which adds iems to a list(of T) class. The ObjectData Source then becomes the gridviews Data Soource. All the other fields are displaying, except the image.
[Code]...
View 1 Replies
Mar 15, 2010
I have a gridview that is bound to a datasource on a Windows Form (VB.NET). The grid displays a list of "certifications", and each "certification" can be associated with many languages. So in the grid, I'd like to display "languages" as a column, and display a comma delimited list of the language names for each "certification".
In the "certification" class, one of the properties is a list of "language" objects, and each "language" has an ID (guid), name (string), and value (integer).
So in the datasource, I have the list of "languages", but I can't figure out how to display them in a column on the grid. The gridview won't let me add the language list property as a column.
So is the ONLY way to add a new property on the "certification" class, which returns a string that contains the comma delimited list, and show THAT on the grid? Or is there a way to display that list of "languages"?
View 1 Replies
Jul 14, 2010
I have a web page where I am trying to populate the PSI # into the txtPSI depending on which customer is selected in ddlCustomers.I have written it a way it has worked on a past project and it compiles with no errors, however it doesn't work when it runs.
The code adder is not working so I had to add it manually.
Protected
Sub ddlCustomers_SelectedIndexChanged(ByVal
sender As
[code]....
View 5 Replies
Jul 18, 2012
i have a DB table and a form the following fields , combobox and textboxes, what i need is how to write a query to retrieve data from the table when the user select some record from combobox
View 7 Replies
Jun 6, 2011
Oddly enough, I've worked around this issue, but it's still annoying me. I worked around it by sending too-long writes, with padded zeroes; the code works but sends a few hundred unnecessary bytes. Specifically, I need to send exactly 992-byte packets instead of 7 or 19-byte packets
View 2 Replies
Jun 29, 2010
Let's say I have an employee class with ID, Forename, Surname, Initials and Email Address properties.
At present, you can construct an Employee object by passing a data row which, typically will include all these fields. However, sometimes I only want the ID, Forename and Surname but still want to populate an object.
[Code]...
However obviously if certain fields are not present in the data row, I will have an error. Is there a quick way of populating the object based on the fields that are present within the data row without a) having to have separate subs for each circumstance and b) without having to try / catch (or something similar) around each property? I know other languages have options like this - where if there is no value, it will be another value (i.e. a default).
View 5 Replies
Mar 9, 2009
I am building a real estate website. I have a table for properties (i.e. "houses"), a table for pictures, a table for features, etc. So each property's data comes from three, not only one table. I need to provide a function that retrieves requested property data depending on a search criteria, for example:
[Code]...
View 3 Replies
Jan 24, 2012
So im trying to fill a combo box with data from a database but depending on how much a pregressbar is filled THis is what im trying:
Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Form1.ProgressBar9.Value <= 10 Then
Me.Level1TableAdapter.Fill(Me.CTDBDataSet1.Level1)
[code]....
View 2 Replies
Mar 7, 2012
I'm trying to gather some WMI data, search that data and depending on the results change the color of a textbox and append some text.I can acheive this using a select statement but was hoping there is a more elegant solution as what I have generates a lot of similar code At the moment, the WMI data contains two properties I'm interested "State" and "ReplicatedFolderName". The"State" value determines the color and text that goes in the text box, however there are different textboxes for each replicated folder name.What I have which works is
Code to gather WMI data
For each mo in queryCollection
If (CShort(mo("State"))) = 2 Then[code]........
View 3 Replies
May 13, 2011
I created a sql stored procedure that will insert data for me depending on user input. Now I would like to know usually I would do something of this nature
Dim con As New SqlConnection(connectionString)
Dim cmd As New SqlCommand("usp_userinput", con) 'references connectionstring and calls store procedure
cmd.CommandType = Data.CommandType.StoredProcedure 'sets default to be storeprocedure
lblMessage.Text = String.Empty
With cmd.Parameters
If (Session("UserInitials")) IsNot Nothing Then
.AddWithValue("@UserInitials", Session("UserInitials").ToString())
End If
End With
That is just an example how i usually approach calling the stored procedure in vb. However for this particular form I am going to have 50 or 60 textboxes which each one would require a session state variable.Seems a little tedious to have to create a session state variable for each textbox on the form.
View 1 Replies
Apr 1, 2010
i have a problem with a SELECT statement.I have a table <EisagogiStoixeion> with 6 columns, one of then is < AgonPeriodos>. I want to display data in a datagridview depending on the column <AgonPeriodos>. I use the Select statement like this :
SELECT * from EisagogiStoixeion where AgonPeriodos = '" & textbox1.text &"'.
Value not set for one or more required parameters. This is my problem on the fill command.
If i don't use the where statement everything is ok and i can see the data including the data from the AgonPeriodos column.
View 16 Replies
Nov 8, 2009
Im using a black n white image of a human as my back ground and panels to display the same bits in color when the area is clicked. What isn't working for me is the panels are slightly overlapped and one will always be on top of the other. it is transparent so you can see the back ground, but not the panel underneath it when it has a picture in it.
View 6 Replies
Nov 23, 2009
I am new for working with vb dot net. I have developed sample project with Ms.Access data base and some pictures I have a doubt on how to package. If you have answer ,sent me a step by step procedure. I have to some custom installation also.
View 1 Replies
