Dear all, When I try to add SqlDataAdapter..After I select the server, input user name and password, select database on the server. And then I click confirm...It ask me to input password once again... after that..It prompt error message as the following Unbale to connect to database. It...more >>

Hi, Is there any recommended way / best practice to implement custom fields with over a RDBMS? I mean, I'm defining an Application DB and I'd like my app to support custom fields. Is there any recommended way to manage this feature with SQL Server? Thanks a lot LucasC ...more >>

Does anyone know how to read an .ini file. I need to read the "FILEPATH" from the .ini file. File is in the same folder as the executable. thank you ...more >>

Hi all, I have a excel file ..inside have 3 sheet.. I would like to write a program to get data from excel file and then put it in sqlserver...But I'm really no idea how to do that.. Any one give me some hints to do.. Thanks Edmond ...more >>

I need to get the width and height of a GIF image through code. I need this info so that I can set the width and height properties of Image and ImageButton objects. System.IO.File.GetAttributes(imagelocation) only seem to return properties that all files have, which does not include width and ...more >>

Using Vb.net in Vs2003 with ADO.net and sqlConnections. I am using a dynamically created SQL statement to create a new record in a SQL 2000 table but after I execute the command I need to retrieve the newly created record's Primary Key and store it in a variable for later use. The PK of the newl...more >>

WHY ? Help this poor non .net guy I create a table in SQL Server as shown below. I start a new VB Windows Application - called whatever I add a Windows Data Form (Wizard) It's kept as SIMPLE as possible. The connection is fine. I want to display the records for one table in controls (one ...more >>

I've been doing ASP.NET and PPC apps for years now. I've gone back to revive an old application that used Access. I'm witing it in VB.NET in VS2003 as a WinForms app. What's the local DB of choice to use with this type of app. Is it still Access? I'm really spoiled by SQL Server and SQL...more >>

hi all, i have a form with a tabcontrol with 4 pages. on the first page are many controls bound to a database. now i bound the controls of page two (two multiline textboxes, four SelectedValues) to the db. the program compiles without an error and runs fine, until i click on tabpage 2. then...more >>

My company produces VB.Net code and to date we have been using Access Databases. All the functionality we need can be packaged together in the distribution file which makes it small enough to be downloaded from the Web. I understand that Access isn't the hotest in performance but it isn't bad ...more >>

Hi all, Let me explain why i posted. I am currently working on a project where i need to do some basic WAV manipulation. I am able to cut wav's now, based on the example i will show later. The only problem is, this only works with the most basic of WAV files. I want to know how to detect the ...more >>

i'm checking the logged on user at start of my program. if the user is not in my database (e.g. he uses his private notebook instead of the company desktop), i want to show a login screen where he can enter his windows username and password. can i somehow send this to the logon server to check...more >>

Hi, I'm trying to create a new record on a dataset using the following code: Me.BindingContext(DSProducts1,"products").AddNew() But for some reason this code isn't adding any new row. In order to debug it I watched the DSProducts1.PRODUCTS.Count property (I even MsgBox'ed that property b...more >>

(Note: I am just figuring out how this ADO.Net stuff works after years of ADO.) I have a learning SQL server database set up with a single table (tblAction) tied to a datagrid on a form. My form has a SQLConnection, SQLDataAdapter and a typed dataset. The datagrid is bound to the form an...more >>

Hi, all! Using VB Code-behind on ASP.Net pages... I'm getting an error telling me: "There is already an open DataReader associated with this Connection which must be closed first" But there ISN'T an open DataReader!! The code hasn't even been executed to create the object!! What the he...more >>

hey, i made a windows form where i created a datagrid with a datatable as it's datasource. now i want to supplie a save button to my users so the datagrid can be exported to excel. how can i do this? thxs ...more >>

Hello, I want make a database connection to an Oracle db (8i) with Visual Basic 2005 express BETA 2. I already installed Oracle Data Provider for .NET (http://www.oracle.com/technolo=ADgy/tech/windows/odpnet/index.h=ADtml) And .NET Managed Provider for Oracle (http://www.microsoft.com/down...more >>

i want to check, if a specific value of a DataRowView has been changed. i can check the whole DataRowView by the RowState property but not a single value of it. is there a possibility to check this or to access the original value/row? thx a while netracer ...more >>

Hi All I am working on a project in which i have to upload files to an remote server via HTTPS. For that i have written the following lines of code,but when i execute it I am getting an HTTP:500 Internal Server Error.Please let me know where went wrong in it. 1.The client has given the cr...more >>

Hello, I would like to overwrite existing Datefield with an empty value. In Access it could be done with: MyDateField.Value= vbEmpty, for SQL server it goes with: MyDateField.Value=DBNULL.Value with ADO.NET in VB.NET. How to achieve this for an access table? DBNull.Value gives me error messag...more >>

Hello, In the IDE of microsoft visual studio .NET 2003 : How can I use simple database using a connectionString, and a data-grid that linked to a database table (i.e mdb - only within the IDE environment of the Microsot Visual Studio .NET 2003, and link some of the fields to a database t...more >>

Hello Can't overcome this problem. I'm linking to Access (Jet 4) db table with numeric fields. When empty, they display as (null) in datagrid (.NET desktop app). How can I ensure db grid cells are displayed blank rather than '(null)'? Thx Graeme ...more >>

I'm defining the following: Dim cmd As New OleDbCommand Dim drDoors As OleDbDataReader cmd.CommandText = "SELECT * from Doors" drDoors = cmd.ExecuteReader While drDoors.Read ....code ...more code End While My problem is that in the ..code bits above, I wish to insert records in an...more >>

I have a DataTable that is now disconnected (connection closed). I want the DataTable to be "refreshed" with data from the source (in this case a MS SQL Server) -- the problem is the DataTable doesn't appear to have a "refresh" method?? I looked into GetChanges method, but this seems to ON...more >>

How can I bind a disconnected ADO recordset to a grid Dim rs As New ADODB.Recordset With rs ..Fields.Append("Status", DataTypeEnum.adBSTR) ..Fields.Append("Device", DataTypeEnum.adBSTR) ..Open() ..AddNew() ..Fields("Status").Value = "AAAAAAA'" ..Fields("Device").Value = "BBB...more >>

Hi What techniques are available for ensuring 2 or more users don't try to update same database record please? In past I've set 1 or 0 on a small textfile and read this in VB (ie: if set 1 by first user, second user can't run write code; loops until first user releases and resets to 0). ...more >>