How is the best way to determine if you are in the middle of an ADO.NET transaction (in my case an ODP.NET transaction, but it should all be the same)? Right now I am using something like this (where txn is a transaction I declared previously): If Not txn Is Nothing OrElse Not txn.Connection I...more >>

Hi I am getting error "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." when using merge to update the changed rows in a datagarid. Here is the code I am using; Public Sub UpdateDataSet() Dim objDataSetChan...more >>

What I want to do is send an email and then save the mailItem. ie mailItem.Send(); mailItem.SaveAs(fileName, Outlook.OlSaveAsType.olMSG); However, this does not work because the item has been deleted If I save then send, all works fine except the message is shown as not being sent. ...more >>

Can anyone show me an example on how to do databindings, with currency Manager for a group of radio buttons. ...more >>

Hi I have a simple data entry form with a single datagrid. Records are = added and delete just fine. The problem is that when I try to modify an = existing row and press the update button, I get this error;=20 "An unhandled exception of type 'System.Data.ConstraintException' = occurred i...more >>

Is there a way to to retrieve Directory Property information? I am trying to develop a way to monitor total Directory size say any directory over 200 meg. I have the logic to enumerate the directories but I can't seem to figure out how to extract the directory size. ...more >>

Can any one pls help me, How to connect SQL Server database thru vb.net. But it gives an error. I tried to connect thru SQLDataAdapter. General network error. Check your network documentation. Thanks Mathew...more >>

I have a question about SQL 2000 - can I use data from a SQL database to fill an array and if so, what would I use to fill the array? Some sort of fill method?...more >>

Hi Is there a simple asp.net site with MS Access backend that I can use as a learning example? Thanks Regards ...more >>

Is there a simple way to set border style on all forms, textboxes and listviews in every form I have, at the load event Even backcolor /Kenneth ...more >>

Hiya I have a strongly-typed DataSet that I am using in my form. The ID's for the tables in the dataset are of an Int data type and are the Primary Keys. They are automatically generated by the server when the record is saved. When I add a new record to the dataset I get an error 'Column UserI...more >>

I have written a VB.NET 2003 application to front-end a MS Access DB. I want to build into this the ability for users to change their passwords. I have written some code for users to be able to do this based on code taken from Rick Dobson's 'Programming Microsoft Access 2000'. This code is also ...more >>

Hello! I need to know when Microsoft ActiveX Data Objects 2.6 Library is installed on a Windows system. How can I check if ADO components exist on a system and what version is provided. Is there a redistributable package for ADO that I could include in my Application (written in VB.NET 2003) ...more >>

Hello: Firebird .NET Data Provider 1.5 available for download. Thanks very much to all the people that has been helping during the development stage. --------------------------------------------------- You can read the Changelog at: https://sourceforge.net/project/shownot...more >>

Hello All What is the correct way of changing databound controls in code ? I have tried several and used the currencymanager.endcurrentedit method also, but each time i have to employ some workaround or other. Is there a consistent way, where in it can be defined as to how you can change ...more >>

The MS WebMatrix Project has a code generator which returns IDataReaders, but I need to work with an SQL DataReader. Where can I find a sample function which would create and return an SQL DataReader?...more >>

Hi I need to increment the sequence number in a sequence number table as part of a larger transaction taking care that no other process can access the table during the course of the transaction. I plan on using a Holdlock against the table in a stored proc when I get the next sequence n...more >>

Hi there I want to delvelop a larger project and it should include some function as follow: 1. Using SQL for the Center database 2. 1000 stores can retrive information from web server (web service) 3. When the internet connection broken, the store can still working with their local data and ...more >>

When I get a datarow from a dataset like so: dim dr as datarow dr = dataset.tables(0).rows(0) and then modify the datarow dr.item(0) = "blah" Does the information I add get updated into the dataset automatically? I get the error that the row already belongs to the dataset and just wa...more >>

Hi all I have just started a new project that includes Data Binding. I have bound the textboxes on my form to a table in my DataSet. My questions are: 1. In the table that I am binding the controls to, there is an ID field. This field relates to another table (also in the DataSet) which cont...more >>

In VB6 we could use a Set statement to create a 'handle' to an existing DAO object. This was done to programmatically set the tables needing to be updated using an array of dataobjects created in the code. ' --- build array of all possible tables needing update ------------- Set dat...more >>

Hi I am using the following string for a dataview expression; dv.RowFilter = "Company like '*" & Me.txtCompany.Text & "*' " The problem comes when txtcompany field contains an apostrophe such as "O'Neil Associates", and the app crashes. How can I get round this problem i.e. be able to fil...more >>

Hi, I am new to vb.net. In Access, I can populate a combobox using a 'SELECT ....'. In VB.NET under combobox property, I have to type the value one by one. Is there any way to populate the VB.NET combo box? SF ...more >>

Hello everyone, I have a question for everyone who knows about SQL Server. I have a Windows form in which a user types in their name, password, and some data (like a homework assignment) and after the username and password is validated, a specific database (one labeled exactly like their us...more >>

Hi, We are storing any kind of files "Excel, Word, etc." into a SQL database. We then retrieve the file from the DB to a binary stream and at this point, I would like to know how I could retrieve the file format without storing additional information (file extension, etc.) into another col...more >>

HI all, any1 know an idea of makeing a good reminder system. i mean, it will store on the DB. and it will jump when it should and u can postphone or decline it. is there any known method to do this ? (i have implemented own method that load if from the db, it seem to me that now it works fine...more >>

hi all. i use mysql as the db. i use .net ado to run a select query to return a datatable: something like this: dim x as new dbdataadapter(".... select ...", cnn) dim dt as new datatable x.fill(dt) return dt ' ** the probolem is, when i run this query on the db tool (i use control cente...more >>

Is there a way to modify the CommandTimeout when using the Data Access Application Blocks SqlHelper functions? Some commands that I try to execute using SqlHelper never get a chance to complete. ----- Tim Thornton College Station, Texas, USA ...more >>

I'm trying to do this, where 'dt' is a DataTable: dt.Columns(2).MaxLength += 3 Someone else's code hard-sets the MaxLength while reading an import file, and now I have to resize it. I know the column is not ReadOnly, but it's not changing the property value. It's not throwing any exception...more >>

Hi, Firstly how do I detect if Access is installed on a PC. Secondly how do I create a blank Database using VB.Net code. Finally what is the best was to manage the database using code, i.e. add tables, columns keys etc. Is it SQL statements, or ADOX or other, any ideas. Regards Tim ...more >>

Hi I am looking for some information on how to do an app that can work off-line like when the user disconnect the laptop from the network. Thanks Regards ...more >>

Hi I wanna shown all my Data from SQL server to Visual Basic.net. could someone guide me on that ? is there any object enable to do that. SQL Server 2000 Database - contacts 2 tables - supplies and customers now, i wanna to shown two folder on the screen. name and numbers of the folders ba...more >>

Hi there, how can I set a DateTime variable to Null using VB.Net? Thank's Reinhard ...more >>

Hi guys, I'm new to .net & i've got a problem with regards to datasets & data binding. Here goes, I've got a data grid & the active row (position) is the 3 row. Now, i take this data set, & pass it to a seperate form, where i want to be able to edit the details of this row. So, in the load ...more >>

I have a routine which assigns object member variables from an SQLDataReader object. If the column is empty (i.e. DBNull is returned), I want to ignore the column. It seems awfully cumbersome to include every read statement in an If Not IsDBNull(Reader("field")) Then....block. My fallback po...more >>

Hi, I am a new user to Visual Basic. I wish to ask how to enable user to key in their value into textbox in hexadecimal. For example: If user key in 'A' into textbox, the program will intepret the 'A' as a binary bit = 1010 instead of intepret it as the ascii code. Thanks for solving my problem...more >>

hello ! I need to get the id (PK) of the just inserted row in a table. I am used to use T-SQL so I always used the @identity. but now I am using another DB and I want to chek it but I do not have stored procedures or anything. can smbdy tell me if I can make it using ado.net instead ? I am us...more >>