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].....
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).
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?
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].....
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].....
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 ).
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?
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 RepliesI have been coding an application for a LeaderBoard for a game. I have all the Login sorted using Mysql and even have all the Account infomation displaying in lables etc. for account info form. Now I am trying to UPDATE information and this is how I was trying to do this...
Dim UpdateInfo As New MySqlDataAdapter
Dim mycommand As New MySqlCommand()
Dim mydata As MySqlDataReader
Dim query = "UPDATE Login SET Pword = '" + UpdateTxtBox.Text + "' WHERE Uname = " + Login.Uname
mycommand.Connection = conn
mycommand.CommandText = query
UpdateInfo.SelectCommand = mycommand
mydata = mycommand.ExecuteReader()
But comes back with an Error saying... Unknown column 'username here' in 'where clause'. Now the username is in the database as I have just logged in with it and I am taking it I have the Query wrong somewhere.
This is my code for displaying data, but there's always the TIME on my date column
[Code]...
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]...
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"?
error " Unable to cast object of type 'MySql.Data.MySqlClient.MySqlException' to type 'MySql.Data.MySqlClient.MySqlDataReader'. " ?
THIS IS THE CODE Ssql = "SELECT ItemID, Prodname, qty, Desc, Cost * FROM items ORDER BY ItemID ASC"
[Code]...
I want it so every time I click an ITEM in the Listbox it displays ALL the data into the textbox. I know there's an easy way using table adapters and binding the listbox, but I'd prefer to do it this way for my project.
So this is what I got.
Lst.DataSource = ds
Lst.DisplayMember = "tblStudent.FirstName"
Lst.ValueMember = "tblStudent.StudentID"
[code]....
It only adds the first rows details to the text box when I click the second record the first rows details are still there.
I have a data logging application that stores data in a table in a MySQL database. Data with a TimeStamp is logged into the table anytime the data from the sensor changes. This means that there maybe 2 seconds between data points or there maybe 20 seconds between points depending on how the data is changing.
When I need the data I have 2 dates and use this command to fill a table..SELECT FROM myTable WHERE timeStamp > date1 AND timeStamp < date2 This gets all the data that has a TimeStamp between the given dates, but in most case the first date in the returned table will be after date1, so I need to get the data from one row before the date returned in the table to know what the data was at date1.How can I get the data row that immediately precedes the returned data set?
i want 2 select data from data gridview and want retrive that data into another form in to the textbox ...is it possible ? i 'm doing like this for that
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.[code...]
I want display data from database in Listbox...Here is my code, It is not working. In Listbox it is displaying as Object[,].Array..
[Code]...
I would like to know if there's anything that can display data differently than what's stored in the DB.Here's my example. I have a column called Active and in the DB table, 0 represents Active, -1 represents InActive.In my report, when showing whether or not a listing is Active, I'd rather have the words Active and Inactive rather than 0 and -1.
View 3 RepliesIt appears my connection to the db is correct when I select different options the datagrid displays the correct number of records. So I am not sure why I can not see the data in the grid.[code]....
View 4 RepliesI want my mysql data to be showed on datagridview, i'm doing like this but it's not displaying. [code]....
View 4 RepliesCan someone show a beginner how to display data in a chart.I am using VB 2010 and my form displays a datagridview.The Datgridview has 2 fields. Date and numberfield.I would like to show the date along the bottom of a simple bar chart with each number from the numberfield above the relevant date
View 2 RepliesI am working on a program in VB 2008 that will generate a due list. What I need to do is look in a dataset for customers that are due this month and display it in a grid that can be orded by their city. I know how to do a query to that dataset and find the appointments, I do not know how to display the information in a grid from for sorting.
View 3 RepliesWhat I am trying to accomplish is this: I have a login page were a student logs in. After the login the student will be taken to a student user page. This page has 2 list boxes. The first is showing the exams that he has passed and the other shows the exams he has yet to complete or fail. I can not get any data to display in my list box. If I can figure the first one out I can do the second one easily but I can not get the first one to work. Here is my code that I have so far:
Private Sub Student_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Label1.Text = "Welcome " & _passedText
[Code].....
i have problem in displaying data in list box after i click in any row in datagrid view
here is the code
Dim sql As String
Dim conn As New System.Data.OleDb.OleDbConnection
Dim lst, lst2 As New ListBox
[code]....
I want to Display My Table Data In Textbox.I Have around 20 columns in my Table and I want to display each of that on particular TextBox.I am using SQL Server as Database.
View 1 RepliesI am attempting to display a datagrid with the results of two different queries. I want one to display, wait two minutes,display the second query, wait again then start over. I am unable to get either grid to display. If I run either query individually without the wait they display perfectly. How can I do this?
[Code]...
My code is below. What I "hoped" it woudl do is when I press the button on my form it would open / load my xml data and display the data in my TextBox.
What it does - it compiles fine and runs but when I press the button nothing appears in my TextBox.
[Code]...
My code is below. What I "hoped" it would do is when I press the button on my form it would open / load my xml data and display the data in my TextBox. I have on my form one TextBox and one button. What it does - it compiles fine and runs but when I press the button nothing appears in my TextBox.
Visual Basic Express
Code:
Imports System
'Imports System.IO
Imports System.Xml
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
[Code] .....
I tried the same.. but its not displaying any data from database[code]...
View 2 RepliesI have a textbox where a user enters a code that is connected to their account. It will then display a welcome message in place of the textbox where they entered their information. It used to work up until I added more code for it to query another database. That ended up messing up my page and since I have deleted that code, I must've forgotten something, or maybe my code was messy to begin with....but now my welcome message is always the wrong person's name. In fact, no matter what code you type in, it displays the same person's name.This person doesn't even have a code in the database. I tried adding IS NOT NULL and ISLIKE 'B%' so that i
View 1 Replies