I have the following fields in my table:
English
Math
Science
Computer
[code].....
How do I get to display only the students records with a grade 85 and above in all subjects?
i have a problem in displaying records between two dates...i have two datetimepickers to choose date from datebase...start date and end date..when i choose start date 1/1/2009 and end date 1/12/2009 then all the records between 1/1/2009 and 1/11/2009....the records of date 1/12/2009si not shown...date format is month/day/year.....i have posted my code below..
Dim rpt As New CrystalReport8() 'The report you created.
Dim cn As SqlConnection
Dim cmd As New SqlCommand()
[Code].....
How do I display the concatenated records in my combobox? I have the following codes
Private Sub frmAssignSubjects_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If cnn.State = ConnectionState.Closed Then cnn.Open()
If rdoHS.Checked = True Then
[code].....
What should I put in the DisplayMember and ValueMember? If I will not concatenation, I just use "LastName" and "IDNO" in my DisplayMember and ValueMember respectively then records get to display in my combo.
I managed to displayed records from two tables in one datagridview and the first column being a combobox. Now, I would like to get those records displayed and save it to another table. this what I did.
For i As Integer = 0 To dtgLoad.Rows.Count - 1
Using command As New SqlCommand("INSERT INTO tblteachersload (Teacher ,SubjectName) " & _
"VALUES (@Teacher, @Subject)", cnn)
With command.Parameters
.AddWithValue("@Teacher", Me.dtgLoad("Column1", 0).Value)
[Code] ......
I would like to loop through the records of the datagridview and then save the same to a table.
I want to display the correct records in my SectionName dropdown list whenever the user select/check an radio button (Elem or HS). No radio button is checked during design time but when I run the app, the SectionName dropdown list show Elem records. also when I checked the HS radio button the SectionName dropdown list records does not changed at all..
Private Sub frmLoading_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If cnn.State = ConnectionState.Closed Then cnn.Open()
[Code]....
I have coded this not sure how to get it to display correctly to the lblGrade box. I have set it up for. Supposed to take the average of three grades and display the letter grade for the average of the three grades.
Here is the code
Public Class frmMain
Private Function CalculateGrade _
(ByVal txtTest1 As Decimal, ByVal txtTest2 As Decimal, _
ByVal txtTest3 As Decimal) As String
Dim AverageScore As Double
[Code] .....
I have a homework assignment to code an application that allows the Prof to display a grade based on the numnber of points he enter. The grading scale is : 0-299 -F; 300-349- D; 350-399- C; 400-449- B; 450-500- A. We are to store the minimum points in a 5 element one dimensional Integer array name intPonts and store the grades in a 5 element one dimensional String array name strGrades. The arrays should be parallel arrays. The procedure should search the intPoints array for the number of points entered by the user and then display the corresponding grade from the strGrades array.
I have stored the minimum points and grades in a one dimensional integer and string array respectively. I have coded the program, and when I put in random points, it gives me the letter grade. For example, if I put in 376 it will display a "C"; if I put in 200, it will display an "F". However, if I put in anything over 449, it will NOT display an "A", it just leaves the lbl blank. I am stumped on how to get the code to read pass 449 points.
here is my code:
' Name: Carver Project
' Purpose: Displays a grade based on the number of points the user enters
' Programmer: <Paul J. Williams> on <February 27, 2010>
[code]....
Is there any way to have my code display the min and max grade without having to re due most of it?
View 2 RepliesI need to display a grade based on the number of points entered. store the min and grade in a 2d array here's my code that I have currently:
Dim strGrade(,) As String = {{"0", "F"},
{"300", "D"},
{"350", "C"},
[code]....
I want to search the records from the textbox and display the records to the datagridview, if there are no records, just display empty on the datagridview.
this is not working:
Dim sqlsearch As String
sqlsearch = "SELECT * FROM setting WHERE mname LIKE '%" & TextBox.Text
[code].....
This is going out to the forum at large. Where can I find the most complete explanation of the use of the DataGridView control in VB.Net? Any publication, or on-line reference except MSDN, please. I can never make heads or tales of MSDN.
Likewise, a complete tutorial on the usage of XML within the .Net Framework would be appreciated. Same qualifications as above.
I want to search the records from the textbox and display the records to the datagridview, if there are no records, just display empty on the datagridview.[code]
View 8 RepliesI wanted to identify the conflicted schedule of each of the section. If there's conflict then the two or more subjects that are conflict will be colored to make then noticeable. They are in datagridview. I don't know what's wrong but there are some that although they are conflict they are not highlighted. Here's my code:
For item As Integer = 0 To DataGridClass.RowCount - 1
For item2 As Integer = 0 To DataGridClass.RowCount - 1
If DataGridClass.Rows(item).Cells(ClassID).Value <> DataGridClass.Rows(item2).Cells(ClassID).Value And
[code]....
How do i display all records from access to richtextbox? Now only the last row is being displayed. I need all records in MS access to be displayed. Im using VB 2008 express with MS access 2007.
Private Sub btnRetrieve_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRetrieve.Click
'---provider to be used when working with access database---
[Code]....
Essentially, what I'm trying to do is build a table of data dynamically on a page that is 3 columns wide by however many long.Working off a Classic ASP example, I've gotten as far as trying that, but not all the records display and they still render on the page as rows instead of columns.[code]I'm not overly certain how to do it, and I'm fairly sure it's probably really simple to do on a view page.My other option is to set a finite amount of records to be created and build the table on the page from that, but I'd much rather do it dynamically.I guess also an alternative option would be to use a repeater control? Though I don't know if this is a control that will work with MVC.
View 3 RepliesI know how to display a records to my combobox from my database but right now I am ran out of idea on how I will display a teacher who has a teaching load in elementary and high school.. I have DEPT field which I has either ELEM or HS. What would be the best thing to solve this kind of problem?
I have two option buttons labeled "HS" and "ELEM". I would like that if any of the option button is selected the name of the teachers who are handling elementary ang highschool will appear in the combobox.
On formload I checked the value of the option button and assign either "HS" or "ELEM" like [code]...
I'm just beginer in VB.net and i would like to ask for some tips. I'm already connected to SQL server database, I need example how to display records in textbox in the form (without using databinding) and how to programm button to go to the next record.
View 1 RepliesI have a code that display records from access to 3 different textboxs. But I want to display all fields retrieved from access to RichTextBox but only the last field is displayed. How can i display all data onto the RichTextBox? Attached is the code i used on 3 textboxes. (currently using VB 2008 express and access 2007)
Imports System.Data.OleDb
Public Class Form1
Inherits System.Windows.Forms.Form
[code]....
i have this problem on retrieve 3 records from database.i did it in a way that i have a few button.when i press on one of the button which have a value of bee then it will go into the database and search for bee.it will return me the result on bee at the same time it will also return both top and bottom record of bee.
How do i do that in SQL or VB.NET
How to display whole records from database in Gridview and also do filteration using textbox ?
View 1 RepliesBelow is the code snippet where i would like to display a msgbox if there are no matching records. I always get a NullReferenceException at iRows = ds.Tables
[Code]...
me with an example of how to display data (some text) in a combobox?
View 13 RepliesI have a form which contains two Time and Date Picker as StartDate and EndDate. I wish to search record from MS Access database within the date range (StartDate and EndDate) and then display the result in ListView.
I have learned from (jmcilhinney) that I have made a mistake somewhere, but I am newbie in VB, so please rectify the error and re-post the corrected code for me indicating the line where I have made mistake.
[Code]...
I cant figure out how to show the records from the datagrid to textboxes
View 3 Repliesim using this code to display records in a datagrid.. DataGrid1.DataSource = mycls.ShowData
mycls.Showdata is a function that in a class that i used to display data.. what i want is to create a progress bar that indicates the actual loading of the data to the grid.. cause it has some delay in displaying if data is to large..
I am a newbie to the .net developing world. i want to display a set of records on my asp.net page.
On a grid control (gridview, repeater etc), I want to display the list of sales people and the clients that they represent. This is how it needs to look on my asp page:
Employee ID: 123456
Name: John
Last Name: Smith
Email: johnsmith@abc.com
Phone: 201-123-4567
[Code]...
I'm trying to use listview control in vb.net or vb2008 express edition to display records from my database after it is being queried.I have two column headers in my listview control which are named Account# and Authorized Users. I was able to display the records from the database into the listview control but i don't know how to arrange it in a proper column where it should be displayed cause what happen is all records are being combined in one column which other records should be aligned to the other column.What I want is to display the account numbers in aligned with the Account# column header and the names should be aligned in Authorized Users column header. Here's the codes I used:
[Code]...
I wonder how we keep records alive in listview..i m entering data into listview from textboxes...but when i stop and again run the program i get new listview...the record i added from textboxes are not there..i want to display the records everytime i run the program.[code]...
View 2 RepliesI'm trying to connect foxpro table (dbf) to VB.NET. I'm trying to display the records of that table to listview in VB.NET. Here is my
I got an error message here, the error says "cannot open the file"
vb.net
Imports System.Data.SqlClient
Imports System.Data.OleDb
Public Class Form3
[Code].....
I have a problem in listing records in listview.
example: Date today: 2/11/2011
Book Due Date
BOOK1 2/8/2011
BOOK2 2/15/2011
I think the problem is in query, and I can't figure it out. I have two queries..
First is this: "SELECT * FROM `tbl_trans` WHERE `t_bk_duedate` >= '" & DateValue(Now) & "'" It must only show the "BOOK2", but unfortunately, it displays all the records.
The second query is: "SELECT * FROM `tbl_trans` WHERE `t_bk_duedate` < '" & DateValue(Now) & "'" It must display the "BOOK1" but displays nothing at all.