I am trying to use the .net connector within my program. I have got add, delete and update working however cannot get search to work. What I would like the program to do is, you enter a value into a textbox and then press a button. The value in the textbox is searched and then the values in the database corresponding to that value are entered into the other text boxes. This is what I have so far:
Private Sub PrescriberSearch()
pre.SelectCommand = New MySqlCommand("SELECT Name FROM Prescriber WHERE Name =?Name like Name = ?Name")
Im writing a simple VB program that connects to an oracle DB which retreives and inserts data to a table I created.[code].....
I want to be able to search through a table I have created to store all the information.Rather than just searching for one variable which would be easy to do, I want to give the user the option to filter out the search from the form.So say the user hits "Find", they would be given access to 10 comboboxes, they would select the information they want to search for (They do not have to select every box) and then click "Do Find".Then the form would display all the results of the query in the form.
Im trying to find out what code i would use if i wanted to search all my records in a table for those who are female...but the problem is what kind of place i should store these records initially, Mdf or Mdb? i've tried using dao code (rs.findfirst...but it says theres an error about read only database or something...)
I am trying to use RAP (rabid application development). So I have created a database with a datagridview to show all information and textboxes to modify the informations. So far so good.
The problem is created when I try to use the search facility on the datagridview. The search is working but the problem is that the textboxes are not following the search criteria . I can configure this manual but I would like to know which is the easier way to configure the textboxes to show the value of my search criteria.
I also want to know how when I finished with the search criteria and empty the search the text boxes to make the connections back as they were before.
I need to do a lookup in a DatagridView column. I would like something with the blazing speed of what recordset.seek used to provide. I am assuming that a similar function/method is available for use with the DVG. What else is there to use that is better than my present implementation.
I have a MS access database connected to a VB2008 developed software. I want to make a search button to search through all the tables in the database. how can I do this?
I want to link a field in table one to a field in table 2 in the database so that they are the same ( whenever I change what is in table 1 table 2 changes to the same automaticaly )
I am trying to do a SQL query that checks for the presence or absence of a character's occurance in a field / column as a condition to retrieve the row. In this case I only need to test for existance of the specified character and in a similar query to test for the non existence. Not where it is or how many, just is it there or is it notI am using VB express.net 2008 and it uses, I think, MS SQL Server 2008.Using VB's instr() I can tell straight away if a string does or doesn't contain a character, but I would like to know this before I retrieve the row.
using the
WHERE .... and [mytable.myfield] LIKE 'Q' or WHERE .... and [mytable.myfield] NOT LIKE 'Q'
produces a result, but not a correct result. It does something but I can not say that it is working even part way.CHARINDEX gets an undefined function error MATCHES also gets an undefined function error?CONTAINS looks like it should work but I am still getting sytax errors with it, so I don't know how to use that predicate yet.
I performed a search by completing this information in my form:
TextBox1: the user types DB-20-RTS DateTimePicker1: selects 7 april 2004 DateTimePicker2: selects 7 april 2004
[Code]....
I don't have errors of syntax in my code the only problem is when I press the search button (it doesn't store me in the columns of datagridview the 5 things I want).
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
I am trying to copy a table from a network database to a local database. I used DAO and could check if the network table existed using a function that tried to assign a TableDef object to the table in question. If there was no error then I assumed that the table existed and the function returned true...Or it would error out and return false.I could then proceed with the copy or not as the case may be.I am converting the code to ADO.net and need to know how to check for a table. [code]
Recently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
Would it be possible to search a table, confining to a specific date range based on a date-time column, and get a count of the 10 most used words in a particular var-char column excluding a list of words?All in SQL?Currently I am pulling out the records that match and sorting through the contents outside of SQL, I would think where I can do it directly on the server it would be more efficient.(SQL 2008)
I don't actually know if I can use any XML file as a database that I can edit and make some changes to it using vb.net 2008 and save them. Because I'm working aboard a war ship and we have a central automatic system to control all the internal communication using standard telephones. to reprogram the extinctions we used to have a MS DOS program and it's so old and now it's totally lost and not found and after a long searching I have found a file that could maintain the extensions and reprogram the system but it's an XML file.
I'm using Visual Basic 2008 Express Edition. What I have is an Access database that will have several tables. What I want to do is connect to the database, enter the name of a table in a text box and query that table. The code that I have now is: [Code] I'm not sure how to modify this code so that tablename = whatever I type in the text box.
I am using SQL server managment express. I have 4 databases in it and got a bug on my computer which I could not get rid of. I saved these to disk and reinstalled windows, I reinstalled SQL server and I am now trying to add my 4 databases. Can any one help me with this, I can add a new database but not an existing.
I have working on a project to add details to a database. I'm having trouble with the connection string, the code is as follows:
Code: Public Function AddContactToDatabase(ByVal sFirstName As String, ByVal sLastName As String, ByVal sAddress1 As String, ByVal sAddress2 As String, ByVal sAddress3 As String, ByVal sAddress4 As String, ByVal dDOB As Date, ByVal sPhone As String)
Using VB 2008 Express /Using SQL Server Express/Database name is "StopData"/Computer name is "LAPTOP"?Here's what I have.
Code: Imports System.Data.SqlClient Public Class frmMain Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
I have a database app that I wrote in VB6 a while back that uses Access as the backend. I have installed the app on Windows 7 pc's and all works fine....most of the time.On some pc's I see an issue where if I replace, rename, or even remove the DB, my app (b/c of something to do with Windows 7) still sees and reads the information from the old DB. It seems no matter what I do, I cannot "remove" the .mdb file from the system. As one can imagine, this is making it very hard to replace the outdated db with an updated version. I never experienced anything like this running the app in the XP environment.
this code is used for login by querying into the database....the logic is like this..it query accoding to the username text box and pass word text box...if there is indeed such rows in the table, then the bacadata.read, else something else happens...i have a few question :
1.is this the right way of login in by checking the row is available or not?
2.is there any enlightment and solution for the appropriate way to login system by using database other than the one teached by my lecturer?
I am developing a software that connects to a database and manipulates product and user data. It works on my computer but it will have to be used by many computers maybe even world wide (who will access the same database) so I have no idea what kind of systems people will have. I still don't know how to ensure that they will be able to connect to the database for I have already had problems in Windows 7 computers which don't have jet oledb.4.0
I am a bit lost here because I don't know if I should first try to do a connect, or if I should first look for a jet oledb engine on the computer where the software is installed. And in case they don't have it installed should I prompt them to install it before running the program further? Or should I pack the engine along with my program? What is the line of thought here to make the program run on (almost) any machine?
how do I use notepad as a database inside a vb.net program.I am making an athletics database/profile program which will include all school records for each and every student.So what I want to know is, how do I use a notepad file, filled with data, to perform search functions on records (like finding the fastest times in a particular event) and sort functions (assending order of times etc.) and view them on a form.
i'm using vb 2008 express editor, and 3.5 compact sql, through my program, i make changes, like altering rows, deleting or adding new rows, to a dataset. i want, that when button 1 is pressed, all changes made to that dataset, are updated to my database. what is the line of code that does this? [Code]
---3 laptops running same VB.NET application locally AND access/share same database located on one of these machines. Is this Possible? an easy way? ---OR would the best sollution create a website with database ?
I'm building an aplication with an MS Access database behind the scene. In many of my forms I'm gonna use DataGridViews to show data from the database, not an entire table but data based on manually built queries. So, I have few questions without answers, by now. Solutions or 1. I haven't decided how will I bring the database into the project: from the menu -> Add New Data Source, or within the code, at runtime. I still don't know which one's best or why.2. How exactly can I execute any SQL query (SELECT, INSERT, UPDATE, DELETE etc) on my Access database from my aplication?
i have an ACCESS database with 3 columns. I establish the connection with the VB 2008 Express and put the data in the form but i don't know how to add the text of a textbox in the database.
I installed Visual Studio 2008 and Office Enterprise 2007 in my new computer.I made some codes for a data reader to get data from an Access dabase. On the step where it will open the connection an exception appeared which says "Microsoft.Jet.Oledb.4.0 provider is not registered on the local machine".
