how do i search a varchar field in a sql database and get rid of the char unless it is an number 0 thru 9 and then add that number to the monthly calendar todays date to determine a due date?
View 4 RepliesI'm pulling records from a db table (sybase) where I have run into a problem with a long varchar field. Using the OLEdb class I convert the field into a string variable which works fine in most cases, but there are problem with a few records. Examining the field in the database it shows that the value is not null, but the length of the field is 0.(SELECT field, length(field) FROM table). When I try to convert this into a string the result is rubbish.strContent = objReader.Item(i). I can't figure out what's the problem here, so I have avoided the issue by doing a table update before I start the process of getting data (I set the field value to null if field.length = 0
View 3 RepliesI am creating a search function which searches a database for keywords in a selected field in FilmTable (name of table to be searched)
This is the SQL I am using:
CODE:
It is saying there is an error in the FROM syntax
I have a search function in my app which is a groupbox with a textbox that contains the search keyword and a couple of radiobuttons. Do I have to create a keydown event for every single radiobutton and textbox? Or is there a better way? I tried making a keydown event for the groupbox but that didn't work.
If your interested, this is my
Private Sub Search()
Dim textBoxContents As String = txtBoxKeyword.Text
Dim keyword As String = Nothing
[code]....
i need a functionality that adodb.recordset have on ado.net right now im developing my project in school but seem to difficult for me to handle give me an idea what should im going to use here can i hindrance that made me stock.i what to retrieve the last row on the database to be able to automate my primary key code that been a varchar(10).i know some basic stuff on connecting thru ado.net,inserting,updating,deleting could you have some advice or post some example that might use of it..
View 7 RepliesThere are lots of questions about this but I've not been able to solve my problem using the answers to any of them (after many, many attempts..)
I'm working in vb.net creating an asp.net web application. I have an SqlDataSource and a GridView on my page.
I want to change the DoNotMail boolean value represented by a Gridview checkbox and automatically update in the database if the checkbox is checked from 0 (False, Will Mail) to 1 (True, Won't Mail) here is the code I used. [code]...
is it possible to do a two way sync on the entire gridview when the user hits a button so you don't have to do an update every time a row is changed? because the user might check the box and then check another box then uncheck a box and it would be a lot of updates...
I created a local Database in VB2008 with 4 tables, the problem is that I have a textbox in one table and a combobox in other table and I want that the information that I put in textbox appear after in combobox from the other table... that's possible?
Table: Filmes ... Field: NomeTextBox
Table: Tempo de Aluguer ... Field: Nome_FilmeComboBox
Dim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query
View 1 RepliesI have create a database program in vb, with 3 forms, on the second form, I have populated it with fields from 'databaseDataSet'.
Basically my question to you is that I want to create a search field at the top of this form that when the user inputs a query, it searches through the last name field and goes to the matching record.
[URL]
I have an access database called BKWThermDB1. Within than I have a table called THERMOWELL_DATA. within this table I have a column called QuoteNumber. All I want to do is search that column for an existing number so I can let the user know that this number already exists and to create a different number. I am using the code below which will tell me my Column exists. How can I alter the code to tell me if a certain number exists within that column?
Imports System.Data.OleDb
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
I have some coding which displays a label if the value of a textbox matches any of the first values of each line in a textfile.[code]....
View 4 RepliesI am trying to do a SQL query to see if an Address already exists in my database. My addresses are structure like this:
line1
line2
line3
city
state
zipcode
country
Sometimes line2 and line3 are NULL values in my database.I am using .NET TableAdapter and DataTable to make my query. When I try to pass in my line2 parameter (@line2) it is equal to a string with value = nothing. My database does not interpret this as NULL and says the records don't match, but I know they do? How do I pass in a string = nothing and have it compare to a NULL value in the database as being equal? I have tried string = DBNULL.value but won't compile.I have done similar comparisons with integers etc. using integer = Nullable (of integer) but this does not exist for strings.
In my SQL Service I have a customer name in these formats
Lastname FirstName
Lastname/FirstName
FirstName LastName
FirstName/LastName
It just depends how a user enters it in.
HOw can I search for LastName/FirstName if a users enters a search string of FirstName LastName??
I am creating a database in VB.NET for a movie rental place. I currently have three forms;
Member Information
DVD Information
Borrow DVDs
What I would like to do is when I am viewing a member's details, if I click a button 'Borrow DVD for Member', the member's ID number transfers over to the Borrow DVDs table in the Member ID which also would hold some information from the DVD Information table, but I'm sure if i can figure out how to do this firstly, I will be able to apply the same rule and work it out myself.I have been trying to use a query statement like;
INSERT INTO [Borrow DVDs].[Member ID] [IN goodstuffvideos.mdb]
SELECT [Member Information].[Member ID]
FROM [Member Information]
but that has been coming up with error codes and completely not working.
Borrow DVDs table fields are: Borrow ID, Member ID, DVD ID Number, Hiring Fee, Borrowing Limit?
DVD Information table fields are: DVD ID Number, Title, Rating, Hiring Fee, Borrowing Limit Member?
Information table fields are: Member ID, Family Name, Given Name, Address, Town/Suburb, Postcode?
The error coming up is; Error in INSERT statement. Unable to parse query text.And under that it says The query cannot be represented graphically in the Diagram and Criteria Pane.
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 )
Im working on a small program that is suppost to make my life easier but im running into a little problem:I want to search active directory using the Description field as the search field but somehow my code below doesnt return anything.[code]
View 2 RepliesI have a combo box on my application (working with VB.net) called CmbAttendantstatus. I have sent the dropdownstyle = dropdownlist at the Properties level of the combobox.
There are 200 field types e.g;
Current Attendant
Ever Attendant
Never Attendant etc
The issue is I can only select one from the list, fine, but I want to be able to type the first letter on the combobox and it takes me to the nearest field type rather than looking through the entire drop list. For example I want Never Attendant, I just need to type N and the drop list takes me to anything starting from N and if I add E for example any field starting with NE shows up for selection. Presently, when the dropdownlist is selected you are not allowed to type anything...
Using VB 2008 with Access database I'm trying to make a search field (txtSearch), but I'm not getting success with code in the button (cmdSearch). I'm making this manually, not using the Query Builder, and the result will be displayed in a datagridview (added to the form dragging the table from the Datasource Panel). So, the datagrid is already populated (with no SQL). What code must I use for the cmdSearch, to return the txtSearch.Text (or part of it) in the Datagridview? I've tried this: "Select Product, Price, Quantity FROM tblProducts WHERE Product LIKE txtSearch.Text & '*'" (but it doesn't work).
View 1 RepliesI had a dataSet which link to a database. I need to add one field inside the database, After adding the field, how can I update and link it to the dataSet?
View 4 RepliesI'm trying to make an appointment scheduler here. The table has an AppID column which just increments 1 every time a new appointment is added. That works fine. It also has an ID column that gets a unique doctor ID assigned to it so the program knows which doctor has which patient.
Now, when I try to add a new row, no matter what I try, the ID field gets a -1. I've tried assigning it the doctor's ID that I'm currently browsing as well as hard coding it to be a "3" and it still shows as -1. So this means that while it [B]does[/B] save and update the new row, it adds that -1 in the ID column and thus the program can't tell which doctor has it so it won't show in my program. I don't know if this is because I've tried so many data sets that it's getting them confused or what, but here is the code that I am using to try to save this:
[Code]...
I can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
View 2 RepliesI have an ASP.Net form, where it grabs a value from a textbox:
[Code]...
I have a form with a button that says "Open CSV".I want to be able to click that button. Then browse for a .CSV file, and after I select the file, populate a combobox with all of the headers of the .CSV.I would then be mapping these headers to fields in my database, then import the .CSV data into my database.
View 3 Repliesi have a table name product , when i m inserting data into product i need to first check if Product Name already exist in database if yes i want to exit. basically i want to know how to get data from the database and how to access columns in asp.net .
View 4 RepliesI have a database called NurseLocationI have a table called CoverList with two fields UserId and CoveringI can connect to the database fine and read the fields into variables that I can use in my program. w I want to take an existing variable called userFullName and put it into the Covering field where the UserId is = to "LHV"This is my code on button click to do that.But I was told I shouldn't use INSERT because it creates a new field
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Declare variables and get username from active directory
[code].....
im trying to gather information from 3 tables at once
[Code]...
How to sum the number value(textbox) to my database field ?
the red section doesn't sum the value(textbox) to my data field.[code]...
The table has an AppID column which just increments 1 every time a new appointment is added. That works fine. It also has an ID column that gets a unique doctor ID assigned to it so the program knows which doctor has which patient.Now, when I try to add a new row, no matter what I try, the ID field gets a -1. I've tried assigning it the doctor's ID that I'm currently browsing as well as hard coding it to be a "3" and it still shows as -1. So this means that while it does save and update the new row, it adds that -1 in the ID column and thus the program can't tell which doctor has it so it won't show in my program.[code]I'm only trying to get the ID column populated, the rest should be fine as they're all from textboxes.
View 8 RepliesI'm trying to execute a MySQLCommand like so[code]...
It seems to be something to do with the "size" parameter, but I don't see what is wrong with it.
How can i increment varchar in vb.net 2010?.
[code]...