I am coding a Student Management System using VB.NET and Access DOn the Form for Teacher Bio-Data, I want to use a table in which I can place Teacher Qualifications in a tabular format. In other words, say, the teacher had Primary, Secondary and Tertiary education. I want to put a header as Qualifications, Year and Grades. Is there any such tool in Visual Studio that I can use?
View 9 RepliesI'm a newbie in asp.net. When using FormView, there is a big amount of code in ItemTemplate, EditItemTemplate and InsertItemTemplate which is almost identical.
[Code]...
ListView allows the use of LayoutTemplate - but I didn't see any examples that insert this kind of code in LayoutTemplate. And inserting this code in LayoutTemplate would result in an error.DetailView allows to produce code automatically but I'd like to use a specific design (for ex. using "fieldset" that encompasses some fields).
I have 1 access database with 3 tables How do I make the combobox get data from one table and input it to another table?ex.I have a table with all my Carriers and another table with jobs that are assigned to Carriers?
View 3 RepliesI have a program that continuously reads in hex values as part of an rfid reader. My question is: How would I write code that detects when this changes? i.e. I have a visual basic textbox that is continuously updated as so:
[Code]...
And it points to the name of my form. This occurs at the "newArray(p) = strangeCardNames" line of code. If anyone else has an idea for how I can either fix this or another method to detect a change and store it in a variable,
Is there a way to repeat two popup input boxes (in succession) until the user presses cancel?
Dim hours As Integer
Dim letterGrade As String
Do
hours = InputBox("Total credit hours", "Total credit hours", )
letterGrade = InputBox("Letter Grade", "Letter Grade", )
Loop
The input boxes continue to repeat but when I hit cancel nothing happens... I'm sure I'm missing something to tell it when I cancel to go back to the MainForm I just don't know what it is.....
I have an Infopath form that retrieves data from a datasource, then populates a repeating table with a dynamic number of rows depending on employid. Once the data is populated, a "user" can enter numbers, times, etc. That part works fine. Now, what I would like to do is submit the data to a sql database. I just can't figure out how to navigate through each record of the repeating table. I have tried the following code, but have been unsuccessful. I can not get the XpathNodeIterator to work on the secondary datasource.
Dim domNav As XPathNavigator = Me.DataSources("getEmpHourlyPaycodes").CreateNavigator()
Dim rows As XPathNodeIterator = domNav.Select("/my:myFields/my:ReturnedData")
While rows.MoveNext()
Dim field1 As String = rows.Current.SelectSingleNode( _
"my:descriptn", NamespaceManager).Value
' Submit code will go here.
End While
I've worked out how to display charts in VB 2010 Express, but now I'm needing the user to input data into a spreadsheet/table that will be used within the program. I know that table is no longer available and neither is the OWC11 set. Is my remaining option then to use DataGridView? I know it is SQL based and I don't have much experience there yet, but I didn't want to commit to it if there is another method that would work just as well. The values that are put in by the user does not need to be preserved.
View 3 RepliesI have three tables in my SQL Server DB. I need to import some CSV files into these tables. First table is a Order Table, which will contain all the order level information from that customer in that CSV File. Each order has multiple items and the second table is an item level data. Third table is a mapping table which shows the mapping for each customer . for a Customer say A ,
[Code]...
I have a combobox that I am populating with the contents of a dataset (from an access database). The field that it is showing has lots of values that repeat. I want to remove the repeats of the data so that only unique records are shown in the combo box. I imagine this can be done with the SQL for the data adaptor? I tried: "SELECT type FROM products GROUP BY type" and "SELECT DISTINCT type FROM products" but both still showed the repeating records.
View 8 RepliesI'm trying to find the right RegEx to capture some (potentially) repeating data. I don't know how many times it will repeat. If I give an exanple of the data and what I want to capture can anyone point me in the right direction? It's the .Net regex engine (Visual Basic)
[Code]...
the form loads, it loads the fetch data from mysql in a datagridview, but when i click cancel button, it will again load the same data.
View 1 RepliesStarting from a table like this:
| Code | Year |
---------------
| A01 | 2001 |
| A01 | 2002 |
| B01 | 2002 |
| C01 | 2003 |
I have to arrive to this:
| Code | Year |
---------------
| A01 | 2001 |
| B01 | 2002 |
| C01 | 2003 |
I have to group the first column (Code) and from the second (Year) I have to get the data 'less common as possible' compared to all the other records. I try to explain this with the example: for the code 'A01' I have 2 years: '2001' and '2002'. I have to take '2001' because it's the one that not recurs in the other records. In the case that there aren't available values 'Year' that not recurs in the other records, it's good to take whatever value.
The data are in the form of array in memory and to interact with them I'm useng some LINQ queries.
I want to create small database which handles Student Attendance Record it will store the roll calls of students on daily basis that teachers collect from the students in the class on paper and then later transfer it on computer .So my database Must contain Month, Year, Program (BCS, BIT, MS, MCS, MIT etc) Batch (1st, 2nd etc) and Subject (English, Math, Geography etc)
Suppose I want to Search for the Attendance Sheet of any month, year, Program, Batch or Subject, it returns me the required dataSo i come up with the Datadase which includes 5 dimension tables and one fact tableDimension Tables1. Student (StudentID, Name, other Attributes)2. Program (Program_Name, other Attributes)3. Date (Date, Week, Month, Year)4. Batch (Batch_Number, Description)5. Subject (Subject_Name, other Attributes)Fact TableAttendanceTable ( StudentID, Program, Date, Batch, Subject, Status)but the problem come when certain columns are repeating again and again which is time consuming for database operator and shows inconsistent behaviour of database.
Look at it: my Fact table would be like this [code]....
problems:1. The StudentId is repeating which shouldn't (Primary Key),2.It wastes a lot of time coz i'm repeating the data again and again Like Program, Date and Batch which shouldn't be in consistent Databases.
I need to create a generic for all the classes having common data.I am having a Test.xsd dataset.In that dataset I am having 3 Table Adapter.
pgaddressTableAdapter1
pgaddressTableAdapter2
pgaddressTableAdapter3
Code is here. You can see all these classes having same methods. I want to create a generic class for these class.
[Code]...
On geting input into DataGridViewTextBoxColumn but the column should not accept input of data that is not integer like; 10003, 2.00, 1500.00
View 3 RepliesI have data entries in my database that have a common field. For example:
account_id type user_id
1 new 1
2 old 3
3 new 1
4 old 1
I am using a query like this(mysql): SELECT account_id, type, user_id FROM table WHERE user_id = 1
This is just all theoretical. The problem that I am having with this is it is only returning the first result in this case account_id 1. How can I get it to find all the results with the user_id 1 because in the way I am thinking that it is failing is that it is finding only the first result and then ending?
Option Strict On Public Class Form1 Private Sub btnDistance_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDistance.Click 'The btnEnterSpeed click event accepts and displays up to ten speeds from the user'and then calculates and displays average speed
[Code]...
I cannot figure out how to incorporate the number of days into the input box then get it to loop and count the number of times the User inputs in the number of days. Then I have to incorporate it into the equation to get the total distance D = MPH * Hours. What I have right now wil not count up the number of days and locks up after I input one number and will not add anything to the listbox. Because I also have to make sure that they cant add nonnumaric values and the number of hours per day cannot exceed 20. I have put things in and taken them out but it has been 2 days and I am lost now
how to input a data/value to excel through vb input form and get the data/value from excel back to the input form?? (For example: put a number into exel A1 from input form and get another number from ecel B1 bact to the input form)
View 1 RepliesI've been working on some code to add together input from an input box to make a string and display it in a message box. I've put the code in a loop so that it will add all input into the string until nothing is entered in the input box.
Dim stringInput As String
Dim message As String
Do Until stringInput = String.Empty
[Code].....
All I get is just the last input entered to show up in the message box and none of the previous entries. How do I get all the input to be added together and show up in the message box?
He wants to create a new table in the database (his using vb.net, mysql). The tricky thing is that he wants to name the new table from the the input being encoded into a textbox.
To create and name a new table from the input in the textbox.
I have a form that requires input from a user that will update a database table. So they are offered input boxes. What the input box will do is ask the user to enter a date, what that will then do is to mark a field marked 'code' in my sql table as "holiday" for that entire day.
View 4 Repliesive been learning Vb.net at uni. Ive never used it before and im finding it a little difficult ( supposed to be easy )i usually code in c++ and MFC Problem I have craeted the database and added all the fields to the form.
View 3 RepliesI have tried everything I can to get beyond this error which shows below as <<<<< error here. It is trying to fill a dataset from a data adapter. If I change the SELECT statement to just SELECT * FROM xTable I get the correct number of records in each table. But anytime I try with a more complex statement I get the error message shown below which indicates System.Data.Common.DbDataAdapter.Fill(DataSet dataSet. I've completely erased all data and entered a new set of test data so I know there is no problem with relationships. Each table has primary key which is foreign key in other table. IS there something wrong with the Imports section: Imports System
[Code]...
I created a database and table programmatically with this [code]...
View 4 RepliesHow can I program a multiplication table that will input the x and y as columns and rows.
View 4 Repliesim looking for an example script. I saw one yesterday but for the life of me I can't find it again today.The task I have is to allow the user to search 1 database table via input controls on an aspx page where they can select and , or , equals to combine fields, generating the sql on the fly with concat/stringbuilder or similar. (it runs behind the corp firewall)someone point me in the right direction of an example or tutorial I've been working on the page, but have run into problems. Here is the Page_load;
[Code]...
I am having a problem on setting the SQL CE table column a field type. What field type does a column that only accepts only two inputs..
Example: If a table has a column named Gender..it should only accepts two types of input...like Make or Female.
I have three table and I want to put the three table's data in one variable and from that variable i will produce the datatable and then want to write the data in CSV file.I am Following this step..
Void
GetDetails()
DataClasses1DataContext
[code].....
I need to code a basic multiplication table in VB. I need a popup input box to ask the user to enter a number, then a label to display the multiplication table for that number from 1 to 9.
[Code]...
I have just started with vb and would like to know if there is a way to input several boxes of data on one form and display individual pieces of that data on several other forms at timed events in the future?
View 1 Replies