I am using the datatable adapter of VS2005. How can I add a new row to a typed datatable? ...more >>

Hi there, I've created a strongly-typed "DataSet" using VS. If I save the data via "DataSet.WriteXml()" and later prompt my users for the name of the file in order to read it back in again (using "DataSet.ReadXml()"), how do I validate that the file they enter is valid. That is, while "Da...more >>

The Microsoft online help is full of TableAdapter examples like customersTableAdapter1.Fill(northwindDataSet1.Customers); I would expect the next line to be something like customersTableAdapter1.Connection.Close(); But I haven't seen that in the code samples, and VS doesn't gener...more >>

Hi all, in my program I initialize a lot of datatable (member of the same dataset) with the .FillSchema method of the adapter at the startup. After when a user trough the guy requests a such data, I populate the datatable with the .Fill method. If I have a such datatable (I'me sure it have...more >>

..Net v1.1 Can someone tell me if I have ReadRepeatable IsolationLevel right? Say I begin a transaction with ReadRepeatable. I select a row from table FRUIT. Another user tries to UPDATE the same row in table FRUIT... Are they blocked until I end the transaction? Or their update goes thru, ...more >>

Hi I am trying to copy data from one db into another. Thanks for everyone who suggested ways to do that. After some more research I have come up with the below simple looking way. My question in, is it supposed to work this way and will it work? LocalConn.Open() Dim DBCommand As New ...more >>

Hi I have open connection to two separate databases. I now need to insert records from a table in one db into a table in second db. How can I go about doing it? Thanks Regards ...more >>

Hello, I have a VS2005 framework and ado.net. I have an access db with two tables: 1) Patients; 2) Doctors. The 'Patients table is already filled by a long list of records (coming from an old access db) in 3 columns: ID, Name, Doctorname (for that patient); The Doctors table is filled by ...more >>

I recently got into a discussion with a coworker about just how long to leave a connection open. I have always opened as late as I can and closed at the earliest possible point in time. using (SqlConnection cn = new SqlConnection(DataConnection)) using (SqlCommand cm = new SqlCommand(InsertC...more >>

Hi All, I'm deriving the AutoIncrement, AutoIncrementSeed and AutoIncrementStep properties of DataColumn objects by inspecting the underlying properties of the source tables in Sql-Server. When I create and empty row of that table, ado.net generates a new identity value with the apropiate ...more >>

I previously posted about a problem where it seemed that changing the case of the word "BY" in a SELECT query was causing it to run much much faster. Now I've hit the same thing again, where basically almost any change I make to how the query is executed (so that it still performs the same fu...more >>

Greetings, I wrote a wrapper for the ado.net using oledb to make connection to the database. At the time the purpose of this class was so that I could use it against any kind of database type. However, I was told recently that SqlConnection is better to use against sql server. So I was w...more >>

I set up a dataset from Add New Data Source ... on the Data Sources tab. I selected two tables with a parent/child relationship. The wizard created the .xsd file. I then dragged the parent datasource over to the forms designer, where it created a bindingsource, bindingnavigator and GridView. ...more >>

Hi, I have recently installed asp.net v1.1.4322 on a Windows Server 2000 so I could place my new asp.net website on our server. The server is a production server and has several websites already on it (before the install of asp.net). I installed asp.net using aspnet_regiis -i. The new as...more >>

Detach sql files on closing? a)I have App that connect directly to SQL files (*.mdf). I realize that this connection Attach the files to SQL server. How I can force Detach mdf on closing program? b)also I try add to project SQL DataBase but I got error that I not have SQL Express. but I hav...more >>

I have a small Visual basic.net 2005 application that needs to get data from SQL servers How can I make the dataset that uses My.setting.connection, use differant servers ie My Setting.Connection="Data Source=SRV1;Initial Catalog=DB1;Integrated Security=True but when used on another site ...more >>

How to do this in MS Access 2000 Select Companyname,Counter = IDENTITY(int, 1, 1) into Custmoers2 from customers ...more >>

Hi everyone! As stated in subject I have problem with accessing deleted rows within dataset, that is, deleted rows within table contained in dataset. Dataset is strongly typed (generated by designer). I need to say that I've done this by following tips in MSDN. First I create dataset, then ...more >>

I have a VB .NET application that is communicating properly with an Access DB. I have a slew of textbox controls bound to a dataset and when the application launches, the fields are correctly populated. If someone changes a value in one of the text boxes, I need to have a button capture the ch...more >>

a)I have App that connect directly to SQL files (*.mdf). I realize that this connection Attach the files to SQL server. How I can force Detach mdf on closing program? b)also I try add to project SQL DataBase but I got error that I not have SQL Express. but I have Developer SQL 2005!? ...more >>

Hi people, I've been struggling over the past weeks to get rid of my old VB6 habits of using error handling everywhere and I think I'm catching up quite fast! I have a question though... I have read many Best Practices topics about error handling and I trie not to create derived Exception er...more >>

PLS-00221: PLS-00221: is not a procedure or is undefined FUNCTIONS VS. STORED PROCEDURES - ADO.NET TO ORACLE FUNCTION I have a very simple oracle function I'm trying to call from ado.net. The code works fine for a stored procedure but I get the error PLS-00221: is not a procedure or is und...more >>

Hi all, I wonder if anyone can explain what is happening here? I have a dataadapter that I am using to correlate the changes in an SQL Table to a DataTable. I create a new DataRow then call .Update and acceptchanges, all works fine. The problem I have is when I try to amend some of the d...more >>

I've just installed Windows Vista with Visual Studio.Net 2005 and SQL Server Express Advanced Edition. When installation of vs.net and sql server was finished I tried to run one of my sites right away. This is the error I got: CREATE DATABASE permission denied in database 'master'. An atte...more >>

I have two tables. First table is like this: TABLE PrimaryTable ----Guid PrimaryID (Primary Key) ----string PrimaryName ----int PrimaryValue Second table is like this: TABLE SecondaryTable ----Guid SecondaryID ----Guid PrimaryID There is a relationship defined between PrimaryTab...more >>

Hi all, I'me using VB 2003 with framework 1.1, and SQL Server 2005 Express as data provider. Is there a way to get notification from SQL Server 2005? I try to explain better, let's consider a canonical client - server scenario: one client changes a data into the SQL 2005 database, this one ...more >>

Hi What is the significance of net framework 3.0 for vs 2005 users? Thanks Regards ...more >>

Hello, I'm trying to connect to Database.mdf from an asp.net file and I get the following error message: Could not attach file 'App_Data\Database.mdf' as database 'Database'. CREATE DATABASE permission denied in database 'master' The coonection string I use is: Provider=SQLNCLI...more >>

I'm having a problem with one of my forms (using .Net 03 EE, SQL 2K Standard, XP client and Windows Server03). After editing and deleting a few records, the form starts timing out, giving me the message; "Timeout expired. The timeout period elapsed prior to obtaining a connection from the...more >>

I am trying to connect to as400 using oledbconnection the connection is opened but when i try to retreive data i get an error message cn = New OleDb.OleDbConnection(StrAS400) cn.Open() cmd = New OleDb.OleDbCommand(StrSql, cn) dr = cmd.ExecuteReader(Com...more >>

Hi all, I have a general question about typed datased and transaction. Do you anybody know the best way how to manage transaction typed dataset? Generaly, when I create dataset and INSERT/UPDATE/DELETE command in a table adapter, there are connections on commands which are not in transactio...more >>

Hi Everybody! I am looking for some good, free and *simple* xml/xhtml editor I could recommend my students. Yes, I know about Visual Web Developer 2005 Express Edition, but I mean *simple*. I teach an introductory class and most of my students would be overwhelmed. Thanks for any hints, ...more >>