This depends on the datatype of the "Sex" column and what data is in it. What you have will work, so long as the column is one of the character types and only contains F or M. If there are spaces in the data or other garbage that shouldn't be there, your query is going to have a difficult time picking out the correct rows. Provided the table was setup correctly and the data was validated before it was written to the table, something like this should work: SELECT COUNT(Sex) FROM Pupils WHERE Sex='F' A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

thank you

select secondValue from myTable where firstValue=value ? Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Problem could be that you're trying to use a data reader object to do the update when a data reader provides forward-only, read-only access. You may find this[^] helpful when it comes to using data readers. For updating a database you should rather use a DataAdapter[^]. Seems like you're using .NET 1.1, right? Also, why are you initializing & opening your connection object twice? If it's not giving you errors it's at least incurring unnecessary overheads. Try refining your code to be a bit simpler, you'll feel the benefit in time :)

I'm not sure, but it looks like you're inserting a new record into a table called Accounts. Shouldn't this be an UPDATE statement that changes as field in the record in question? Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

ChandraRam wrote: and this will work, provided that PIN is a text type field. And so long as the user doesn't type anything dodgy in to the PIN TextBox because as soon as that happens all hell breaks loose and the company finds that their database is compromised. Upcoming events: * Glasgow: Introduction to AJAX (2nd May), SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website

The way I work with connection strings is I store them in the app.config file then I have a function to retrieve it like this: Public Shared Function GetConnectionString(ByVal strConnection As String) As String Dim strReturn As New String("") If Not String.IsNullOrEmpty(strConnection) Then strReturn = ConfigurationManager.ConnectionStrings(strConnection).ConnectionString Else strReturn = ConfigurationManager.ConnectionStrings("YourConnectionStringName").ConnectionString End If Return strReturn End Function I do it this way that way I can have multiple connection strings and just pass the name of the connection string, otherwise it defaults to the default connection. SELECT * FROM Users WHERE Clue > 0 ERROR: 0 Rows Returned

But that solution still exposes him to SQL Injection Attacks. See SQL Injection Attacks and Tips on How to Prevent Them[^] Upcoming events: * Glasgow: Introduction to AJAX (2nd May), SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website

you can use this code also: Public Function Query(ByVal SQL As String, ByVal OLEDBCon As OleDb.OleDbConnection, ByRef DS As DataSet) As Integer Dim DA As New OleDb.OleDbDataAdapter(SQL, OLEDBCon) Query = DA.Fill(DS) DA = Nothing End Function Public Function Execute(ByVal SQL As String, ByVal OLEDBCon As OleDb.OleDbConnection) As Integer Dim com As New OleDb.OleDbCommand(SQL, OLEDBCon) com.ExecuteNonQuery() com = Nothing End Function this is your connection string: Dim con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " & _ "Data Source=sample.mdb") code of your button save: dim strInsert as string try strInsert="Insert into table1 (field1,fields2...) Values('" & txt1 & "','" & txt2 & "'...)" con.open Execute(strInsert,con) MsgBox("Record Saved") con.close end try my code is simple.:) Don't block the drive way of all the newbies in programming. :))

Imports System.Data.Oledb Dim con as new Oledb.OledbConnection("Provider=Microsoft.Jet.Oledb.4.0; " & _ "Data Source=dbase.mdb") NOTE: Put this code under the Public Class Form1 CODE OF BUTTON SAVE: Dim objDataAdapter As New OleDb.OleDbDataAdapter Dim objCommand As New OleDb.OleDbCommand Dim objDataTable As New DataTable Dim objDataSet As New DataSet Dim objOleCon As New OleDb.OleDbConnection Dim strInsert As String Dim strSelect As String Try strSelect = "Select * from Table1" strInsert = "Insert into Table1 (name,address) Values('" & tname.text & "','" & taddress.text & "')" objOleCon = New OleDb.OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0; " & _ "Data Source=dbase.mdb") objDataAdapter.SelectCommand = New OleDb.OleDbCommand(strInsert, objOleCon) objDataAdapter.Fill(objDataSet) objDataTable = objDataSet.Tables(0) With objCommand .Connection = objOleCon .Connection.Open() .CommandText = strInsert .CommandType = CommandType.Text .ExecuteNonQuery() .Connection.Close() End With MsgBox("Record Saved") Catch ex As Exception MsgBox(ex.Message) End Try Don't block the drive way of all the newbies in programming. :))

I might have the answer you seek, but I haven't looked in any depth at this problem. It may be something to do with the insert statement and/or the customer table. Does the table only have 3 columns: an id, a surname and a forename? Is the id column auto-generated (or whatever the term is in MS Access)? Try naming the columns in your insert statement. I don't know what columns your customer table has but it might be something like this: insert into customer (id, surname, forename) values (99, 'Rogers', 'Dave') Dave

See MSDN for ADO.NET. If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.

Then read related documentation, for instance, see the following example [^]. If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.

:confused:I have have not look at this in detail but does not msaccess require you use "*" as a wild card instead of the SQL "%"/ jhoga

oh i think i understand, you want the selected item on button press to have the same value as the next or previous item. If that is the case: Make sure your listbox selectionmode = selectionmode.multiextended Select all: ListBox1().SelectionMode = SelectionMode.MultiExtended For i As Integer = 0 To Me.ListBox1.Items.Count - 1 Me.ListBox1.SetSelected(i, True) Next Change current to same as previous: ListBox1().SelectionMode = SelectionMode.One Dim Selected As Integer = Me.ListBox1.SelectedIndex Dim newItem As String If Me.ListBox1.SelectedIndex > 0 Then newItem = Me.ListBox1.Items.Item(Selected - 1) Me.ListBox1.Items.RemoveAt(Selected) Me.ListBox1.Items.Insert(Selected, newItem) Me.ListBox1.SelectedIndex = Selected End If Change current to same as next: ListBox1().SelectionMode = SelectionMode.One Dim Selected As Integer = Me.ListBox1.SelectedIndex Dim newItem As String If Me.ListBox1.SelectedIndex < Me.ListBox1.Items.Count - 1 Then newItem = Me.ListBox1.Items.Item(Selected + 1) Me.ListBox1.Items.RemoveAt(Selected) Me.ListBox1.Items.Insert(Selected, newItem) Me.ListBox1.SelectedIndex = Selected End If Posted by The ANZAC

Continue in the same thread instead of creating a new one. --- It's amazing to see how much work some people will go through just to avoid a little bit of work.

Replace Me.Text = name with Me.Text = OpenFileDialog1.FileName. Actually, you would be better writing this section like this: Dim fileName As String If OpenFileDialog1.ShowDialog = Windows.Forms.DialogResult.OK Then fileName = OpenFileDialog1.FileName End If If fileName <> String.Empty Then rtb1.LoadFile(fileName) Me.Text = fileName End If Don't tell somebody that there was an unknown error just because they clicked Cancel in a dialog box. It is bad form. the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer Deja View - the feeling that you've seen this post before.

thanks alot matey thats a great help to my cause. much apreciation

thanks matey you'll be pleased to know i figured that out not too many seconds after i posted that message, stupid me. if your not to busy i could do with a bit more help on a couple of things. how can i assign a command to select all items in the list and how do i move up and down the list