ado.net

I'm a beginner in databases, and I'm developing a simple application. I'm using SQL Server in my shared server to hold all the database. Database is accessed by client app using an internet connection. My client application is for Windows Forms developed in VB.NET using ADO.NET. I have...

This is not really a question. More like a clarification. I wanna know As to why this is happening. This is an exercise from a tutorial which I did last year. I came across this today and thought of just trying it out. Its about using a DataSet and how you can make changes in it and update the...

Hello I am trying to display recordsets as HTML tables. So far I have succeeded in storing the recordset data in a string and writing it as HTML. For this i have used the GetString() method. I have used code from ADO GetString Method for this purpose. The code i am using is as follows...

Using a devExpress gridControl & gridView (don't think devExpress is to blame here, but i just mention it for accuracy), combined with a BindingNavigator and BindingSource. I have portion of a WinForms app that has several "admin" forms that each show a table - i.e. stuff that users can fill...

I am filling a datatable contained within a dataset from a datadapter in a separate thread. What I want to do is see if this datatable is still being "filled" so that I wait until its done before I call upon it from the primary thread. Is there a status in the datatable that shows that it is...

I'm writing an app in VB.Net 2008 that needs to transpose a list of values in a database. I found that the Join command will just do that. :D Only works on arrays though. The dataset only has one column. So I'm trying to find an elegant way of converting it to an array. I've got 18000 rows...

Hi, I am trying to understand copying of DataTables and processing changes. I have created a DataTable dt1 (with not rows) in a Dataset ds1 and persisted it into an XML file. And set Column 1 as a Primary Key and an Autoincrement Integer: Dim key(0) As DataColumn key(0)...

I keep getting the following error every time i run this script i cannot find any info why this is happening and how to fix it, any help would be great Dim plmExcelCon As New System.Data.OleDb.OleDbConnection Dim cmdLoadExcel As System.Data.OleDb.OleDbDataAdapter Dim...

I am trying to write data from an excel spread sheet to a SQL Database. I have been able to connect to the Excel Spreadsheet and read the data but I am unable to get the data to insert into the SQL DB table. the current code is as follows any help most appreciated. Dim plmExcelCon As...

Hi! My name is Willian. I'm brazilian and I've 15 of programming experience (6 with Delphi). I wanna migrate my knowledges do VB.NET but all books/samples/tutorials are to beginners (I don't wanna a book to learn "IF", "WHILE") or just use samples of codes: these samples are always with 2...

Hi, I made a class for access (read and write) to SQL database Tables. Each time, that mi class execute a command, this call to private method for "Refresh" a Internal DataTable that, this class have for access to info from the instance. The question is: had the .net any way for detect that...

i have trying to insert the record in the sql server 2000 table but it can't insert record and no exception error is showing. I confirmed with my coding, I read some post about VS.NET2008 Express can't support ADO.net object But I confused the finding my record is ok and works Correctly Pls...

I'm throwing this question out to the community for opinions. I have a large corporate website that is being ported from ASP to ASP.Net. We're adding a new feature: each page visit will be logged to a SQL Server 2000 database. My problem is that I don't want this logging to adversely affect...