Grrr... I've spent the last several hours trying to learn ADO.NET. Specifically, the database connection stuff. I finally managed to create a database and enter some data within the VS IDE. I have several ADO.NET books but not one could tell me how to set up my password. To make a lon...more >>

Hi, I've written a VB .Net program (written in Visual Studio .Net 2003) which scrapes data from a web site and stores it in an Access database. The database has 1 table with 11 columns, one of which is the primary key (not an auto-increment field). The program first calls OleDbDataAdapt...more >>

Hi When is next vs due? Many Thanks Regards ...more >>

I'm using typed datasets and in my application I, for the most part, keep local copies of everything in the database in DataTables. So at any given time my local tables always have at least as much (usually more) information than the actual database, and occasionally I use the adapters to Updat...more >>

Hi, I'm new to all this OleDb stuff. I'm using VB in Visual Studio .Net 2003. The Data Adapter wizard for the OleDbDataAdapter control generates the following OleDbUpdateCommand object for the query "SELECT Reference, Status, DateCreated FROM Questions": Me.OleDbUpdateCommand1.C...more >>

I'm trying to get Identity back from a stored procedure in SQL Server. When I execute the SP in Management Studio @NewID is returned in the first row/first columm. but when I run the code below, executescaler returns null. I have pasted both the code and the SP below. anyone know what is g...more >>

It's fascinating the amount of parameters that are now generated by the drag-drop SqlDataAdapters. Doesn't this trouble anyone the amount of data being sent back and forth for a simple insert/update/delete? And that this is apparently the recommended Microsoft approach? ...more >>

Hi, I have installed sql server in my system.I have developed a program which have to access the data. I want to run this program on other sytem.How can I to connect to sql server on my sytem and store the data entered on that system.please send how to ...more >>

I perform a query on a MySQL database and return a dataset. the data looks like: TaskID TaskName 201 Orca 205 Jaws 223 Orca 224 Orca What I need from the dataset is the Orca with the larger TaskID and the Jaws. S...more >>

I have a dataset which contains two tables, one is master and another is child table with a relation join between tables. When I use DataSet.WriteXML, it shows as: <aDataSet> <MasterTable ID="1" ............... /> <ChildTable ID="1" .................. /> ... </aDataSet> It...more >>

I created a connection, adapter, and a dataset using a .mdb, then filling in at runtime; OleDbDataAdapter1.Fill(DataSet11) I also created a DataGrid and bound it by changing the DataSource property to 'DataSet11.MainTable'. My Goal is to modify the data in the rows and also ...more >>

Hi, I have a datagrid that has as it's datasource a filtered datview of the underlying datatable. The datagrid is set to read only. When the row header column is clicked it fills a series of textboxes, datapickers etc positioned below the datagrid on the same form for ease of editing. Once ed...more >>

I come from an Oracle background, where one can, in addition to having stored procedures in the db, load and run text files containing sql DDL or DML commands. But I can't seem to find an equivalent in VS2005. I can create and run an ad-hoc query in the SQL Pane, provided I have already op...more >>

I recently ran across the "Failover Partner" attribute that can be assigned in the connection string and I was wondering if it worked with SQL 2000 servers, as well as SQL 2005. I was reading this article (http://msdn2.microsoft.com/en-us/library/5h52hef8.aspx) and there is no reference to ...more >>

I have a GridView with a a checkbox as below. <asp:TemplateField> <ItemTemplate> <asp:CheckBox ID="CheckBox1" runat="server" AutoPostBack="true" checked='<%# Eval("BooleanField1") %>' OnCheckedChanged="CheckBox1_CheckedChanged" /> </ItemTemplate> </asp:TemplateField> <asp:TemplateField...more >>

Hello everyone, I am either missing something, or it is actually not so straight forward. How do I add batch of records through single Webservice call? - Important requirement, newly added records have ids and some other values assigned on the server side, so they have to be reconciled (me...more >>

Best practice Multiuser Program - locking I have to develop an application with Visual Studio .NET 2005 and SQL Server 2005 (ADO.NET). There is a sql-server table called "Orders" with primary key ordernr. If a user calls "Edit Order Nr XY" in the program the datarow xy should be locked. ...more >>

I used the Designer to generate Typed Dataset classes for every table in a database I'm using. In one particular table, I use a numeric Autonumber column as the primary key, 1 text column specifying a friendly name, and some other miscellaneous columns. Given a string representing a friendly n...more >>

When the following subroutine executes I get a concurrency violation. I'm not sure why. Can someone help provide a clue for me? (drvZones is a DataRowView) > Private Sub SplitMultipageTIFsWithThisZoneToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ...more >>

I have an issue that is totally baffling me. When I use a program I've written to connect to SQLExpress (and a given database), all works well on my development system and on a laptop that I tested with. However, I have two users that I sent the SAME database files and program files to and at ...more >>

Hi there, Can anyone comment on the performance issues of "DataTable.Select()" vs "DataView.Find()" (or "DataView.FindRows()"). I have to conduct repeated searches using the same index and I'm not sure which to rely on. From what I've read, "DataTable.Select()" doesn't rely on indexes so us...more >>

Hi, I have two tables. One table contains the information about the object, and then the other table contains the objects ID and then the ID of where this object is allocated to. table one Object: ObjectID, ObjectName. table two Allocated: siteID, ObjectID. now the ObjectID in table two ...more >>

Is there any sort of check that can be done to see if a particular instance of SQL Server is present? I already call a method to check for connection -- if no connection, I have the user re-enter server settings (server name and database name). But the connection check is made by calling for ...more >>

Hi I have to insert dates into some Access and SQL Databases. I need to be general as the target computer might be in any country. -------- - For access I wrote the follow: Function Date_ACCESS(ByVal Data As Date) As String Return "#" & Data.Year & "-" & Data.Month & "-" & D...more >>

Is it possible to invoke this wizard at runtime, using c#, if so how?...more >>

Hi, I have a row in a dataset table which is nullable ( and also on the sql backend ), but how can I set it to a null. if I try Myrow.myDate = nothing when I test the row, I get "#12:00AM" why ?? ?? IDEAS ?? -- Goofy ...more >>

I need help! Here is what i have going. I have a cobal database that i connect with using a DSN/ODBC (the source data) and i have a Sql 2000 database that i am trying to copy the data to. I have a DTS package setup doing this task just fine but i need to do this process using ado.net/vb.net, not...more >>

I'm having problems updating a dataset. I call the following method to add a new record: Me.drvZone = Me.ZonesBindingSource.AddNew() Then when I'm done filling in the form, I call: Me.ZonesBindingSource.EndEdit() Me.ZonesTableAdapter.Update(Me.DsZones) Me.DsZones.AcceptChanges() The ...more >>

Hi everyone... can anyone tell me how to fire textchange event of textbox that is in datagrid...as on the basis of that i wana fetch data from the database.if you can provide code snippet or any link than i'll be thankful to you... Thanks & Regards, Nil "Problem is just the distance between...more >>

I am attempting to retrieve records from an .mdb file. But can only retrieve the first entries of the table using the code below. How would I code to get any entry I desired (2nd entry, 4th entry, etc.) ? Code: Try cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source...more >>

I am probably missing something obvious, but I cant seem to get this to work. I have been reading several posts and trying different combinations, but the gist is that the server database never gets updated with the changed dataset. The Clinic Table does have a primary key. If i make a call to...more >>