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.
I have been trying to install VB2010 Express, which directs me to uninstall VS2010 Beta. I have been primarily successful in this, but I keep getting error 1402, as follows:Form "Microsoft Visual Studio 2010 Professional Beta 2 Setup - Update Page":
Uninstalling Components:
[completed - check] Microsoft Office Development Tools for Visual Studio 2010 (x64) [completed - check] Microsoft Visual Studio 2010 Professional Beta 2 [pending - double bar] Microsoft Visual Studio Macro Tools
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?
I'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)
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.
im trying to save data (0 or 1) from vb2010 to SQL2008.
How can I do it inside vb2010? In class or form? which 1 is recommended?
The following is I write in form class:
If Trim(CChar(cElectrical)) = CheckState.Checked Then loDataAdpr.InsertCommand.Parameters.Add("@scopee", OleDbType.Char).Value = "1" Else loDataAdpr.InsertCommand.Parameters.Add("@scopee", OleDbType.Char).Value = "0" End If
im trying to save my inserted data from vb2010 to sql db.
This is my New Contact form interface:
This is the message after i inserted all fields:
My "add" in clsDbConnect: Public Sub AddContactRecord(ByVal cClientName As String, ByVal cCompany As String, _ ByVal cAddress As String, ByVal cFax As String, ByVal cPhone As String, _
I have used a data repeater and linked it with the data source. The program lists all the names of clients from the database with an ID number and also a URL.My first question is how can i make the url that is displayed as a link label, link to the default browser when clicked. I normally use the Shell("c:/program files/internet explorer/iexplore.exe "URL HERE") command but i'm not sure how to make this work with the data repeater?
My second question is to do with starting services, i need to take the ID number from the current data repeater record and then place it within a service name, for example if the service was callled Client_** the two ** represent the client ID. This then needs to start the service when button is clicked on the current record on the data repeater.
My third and final question is how to query a field in a current record of a data repeater, for example if i wanted to query a field called ID for that current record shown, is there a function i need to use to call the information?
I am presently using VB2010 to develop charting application. I have noticed that whent he applications are developed on my hp dv7-2270us notebook and stored on an external harddrive, if these same applications are then opened on my dell latitude d610, i will recieve a corrupted external harddrive error. Usually this can be repaired with check disk.
I am using vb2010 and the like @lastname +'%' to try and create a search query. It seems to work until I try the test query which brings up nothing within the test query window. Sometimes it even seems to wipe out the data I have put in for testing. I did get it to work once in one project.
Let me preface this by saying I'm VERY limited in my programming knowledge/experience using any language. I mean I have extremely basic capabilities and don't quite understand this stuff inside and out like most of you do.Anyway, I'm trying to code a fantasy football draft program in VB 2010 that utilizes the MS Internet Transfer Control 6.0. It will retrieve the HTML from a website, say ESPN, and parse the data into player names, rankings, and other stats. Should all be simple strings/sub-strings. It will then populate a DataGridView control so that each row in the DGV has the player's name, ranking, projections for the season, etc. After this has been populated, the program will be designed to allow me to draft players and assign them to the various teams automatically. I am the commissioner and we do an off-line draft, so I will just make picks for everyone and submit them online later.
I have written lots of code with the ADO Library in VB Excel and previous versions of Visual Basic. With the dissappearance of the recordset object, how do we perform data manipulation with an attached Access Database? It seems things could be a lot easier, and less complicated by now, however, the best methods appe
Does anyone have a list of OleDBTypes and how they match up with MS Access and SQL Server Data types. I would like this to be able to better write code for my parameter collections. Plus when looking at all the options availible with intellisense when programming in vb2008 v.s. SQL datatypes, there are some not so obvious choices.Here is the list I get from VB2008 using Intellisense:
I have the following code that needs to connect to my four spreadsheets for FileName(). I havent built the loop yet for the other three, but I am so used to working with a variable. Is this the best way (datatable) to get a single cell from a spreadsheet and if so how do I view the data once it is in the datatable? Ideally I would like myDataArray(3) to hold the 4 cell values. Please help. I am stuck. I want to be able to get the cell value $K2 form each sheet without invoking Excel. I think I am close, but dont know how to get the data from the table. These four cell values will be displayed and then emailed to our Country Director.
I am migrating a project from VS2008 to VS2010 (Framework 4)and I keep getting the following error when trying to use databinding with a child property in VB2010.
I have a TCPListener demo setup and working. The demo program has been supplied by Bill Chung, here:[URL]..the Listener uses a DataGrid to output whatever data is received but currently it doesnt store it.
Ive created a simple database and linked it to my project. what i need help with is getting the data that is currently outputted in the DataGrid to be stored into my DB table.
I have a program that simply checks if the account number and pass word match. And if not it allows you to create it. But i have no idea on how to create something that will hold the data and will allow the user to add and remove sets of data.
So, I'm making my program which let's people auto-update other programs. Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim path As String = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) & "UpdateFiles" Label1.Text = "Finding updates..."'To do: Find all files in the folder, and let em update one at a time. Write names of Plugins to label2.text ProgressBar1.Maximum = 10000
What I want to happen is that the button from my system will remove the previous data from database and then insert new data to database from text file. Im done with inserting new data. The thing is that I dont how to control or where to put the Delete Command from my code.
I have used VB (versions 2 - 6) through many years; however, I am crash-course training myself into the VB2008 / VB2010 world kicking a screaming. I would like suggestions as to what SQL database access method should I focus more on in my learning process without making me feel that I'm a million years behind. I know I have WinForms where I can create a datasourse and drag / drop fields or tables on a form to create a grid (not really what I'm looking for).
My trouble isn't so much designing the form but in how I access the database. Theres XML, LINQ to SQL, ADO.NET, and many other methods. Not only do I need to grasp these methods quickly but I also need to know what type of projects I should create. What I mean is...I was thinking that I would design a WinForm app; however, I see that there are WPF apps and others to chose from. This is getting deep. I know it depends on the project that I'm working on. My plans are to write an app based off of either an SQL Express 2008 or SQL Server 2008 database. This first app will be standalone for now but may later become multi-user. I know I'm far behind on my learning curve coming from VB6. I have read a bit on VB2005 / 2008 / 2010. I own both VB2008 and VB2010. I use VB2008 at work. I know ADO.NET is still alive but by what I read online, it's a dying method and is only kept for backward compatibility. XML and LINQ to SQL and other methods are all pretty new to me.
Before getting started, I'm new to VB and currently using Visual Basic 2010 Express. Just want to make sure I've got this in the right forum and my apologies if I'm not.[code]...
I have 16 cities (those would be my string variables, right?) that I want to appear on my 16 labels in random order without repeating when I click the button. So basically label 1 can be any of my 16 cities, label 2 then will be any of 15 left available cities, and so on and so on.
I have a datagridview that is being loaded from a dataset. This dataset is the result of a SQL Statement (which could be my problem). The MS Access Client table is the main table and contains 2 records, however, after loading the dataset, the row count is 3.
Below is the procedure where I load the dataset and then the DGV.
Public Function LoadClientDataSet() Try strSQL = "SELECT A.clientID, A.name, B.phone, B.zipCode, B.stateCD " & _
If say in my datatable i have one column called order number and one column called line. Whats the best way to keep repeating the order number into everyrow, whilst incrementing the line number until i add a new value in the order number column.
I'm working on a Bingo game that generates a random letter and number.
Dim RandN As New Random() Dim randnumber = RandN.Next(1, 30) Dim RandL As New Random() Dim randletter = RandL.Next(1, 5)
All that works, but I'd like it not to repeat a combination. Any tips on how to do that?
Also the random numbers tend to be repetitive and the random letter is never 5. I think the random number has been 30 before but I can't be sure. Is there a way to fix that or just a better way to do the random numbers?
there are 8 text boxes where user should put 8 answers, but when he type one answer in one text box it cant be found in some other text box.Basically when button is clicked there should be check for repeated answers.
I searched the forum and the web in general but did not find anything that answered my question.I am trying to create repeating sections (much like you can do in InfoPath development) in VB. For example, I would have a dozen textboxes in a section which the user would be able to fill out.