I've got several datatables in a dataset that I've filled programattically. The structure of the datatables match the structure of tables in an access database. What is an easy, programmatic way to insert all those datatable records into the tables in Access without manually generating param...more >>

I am using the editItem templates of the datalist control. I have a problem as to transferring the changes made by the user to the dataset. As I am reading the results form a database to a dataset then using the dataset to fill the datalist. The problem is I am not sure how to transfer change...more >>

Hi There. I have a complicated application that I'm seeing issues with where my various connections to my sql server are not getting released. Rather then delve into that, I created the following very simple asp.net application that executes the following code: private void Button1_Cli...more >>

I'd like to use both the XmlDataDocument and an ADO strongly-typed = dataset to access my application's XML data store. However, I can't seem to get the two access mechanisms to be compatible = with my namespace prefix declaration. At this point, if the XML input = file contains a namespace p...more >>

Hi All, Here's what I'm trying to do. I want to use a DataSet with 2 tables(Clients, Contacts) to bind to DropDownLists. When a Client is selected I execute a subroutine to create a DataView of Contacts filtered with the ClientID that was selected from the 1st DropDownList. I'm getting the ...more >>

Please see this error below. This code runs fine in v1.0, but I just compiled it and ran it in v1.1. The first time the page loads, everything is OK, but if you hit refresh or navigate away and come back to the page, the following error occurs: A column named 'ORG' already belongs to this Data...more >>

Environment : Visual Studio 2003 v 7.1.3088 (French) Development of a Windows application with SQL Server 2000 I get the following compile error message in the .xsd module : C:\Documents and Settings\TORDEUR.FRYORKF\Mes documents\Visual Studio Projects\Annuaire\ClasseDsGeneral.vb(117): 'Public...more >>

A stored procedure returns the following string - > Note that there can be one or many "PlatformActivity" and within it "AffectedServers" can contain one or more "AffectedServer" element. <?xml version="1.0" encoding="utf-8" ?> <PlatformActivities> <PlatformActivity xmlns:xsd=\"http://www.w3....more >>

Can anyone give me an example of the proper way to run an update query using the OracleDataAdapter? Please include the Imports, and everything from creating the connection through closing the connection. I have tried to figure it out from the MS documentation and several tutorials and I can't ...more >>

Hello, I have a SQL Server stored procedure which will return several recordsets back to the caller (multiple SELECT statements). By default when you call this stored proc from ADO.NET, you get back the tables in the DataSet as Table, Table1, Table2, etc.... Is there anyway in the sproc tha...more >>

(using vb.net) Hi, Is it possible to get notified when a DataGrid has changed? I've tried the MyDataTable.ColumnChanging/RowChanging, but they are only triggered when the focus leaves the cell. I want to get notified when the cell data is changing. That is when the first key is pressed...more >>

Hi, Can I define connection's timeout in SqlConnection's connection string ? Thanks, Alan ...more >>

Am working on a system that processes lots of records. Each record requires maybe a dozen lookups into different SQL Server tables, some containing 100,000 records. Since there are a lot of records to process, I need these lookups to be as quick as possible. Which option do you think would be...more >>

I'm executing the .ExecuteNonQuery method of a SQLCommand object, with the following SQL: UPDATE BUDGET_ACCOUNT SET Deleted = 1, DATE_DELETED = GetDate(), MODIFIED_BY_ID_FK = 1 WHERE ID = 951956 If I copy this SQL code to Query Analyzer, it returns 1 record affected. However, if I run it...more >>

Hi eveyone, I am fairly new to .NET. I have read couple of Csharp articles for creating a data access layer. One of them has been provided by Mcrosoft. Can some one please clarify the logical structure of the data access layer? What is the pattern that should be followed? Also, what are th...more >>

Hello, I am trying to insert data into a database on the other end of a web service. The primary key in my DataTable is an identity column. I first get a copy of my dataset with only the changes in it by calling DataSet.GetChanges. I then pass this little DataSet across the wire where my...more >>

Hi all, I have a huge SQL script(generated through SQL server enterprise manager) which creates tables, users and procedures. I am using a command object to run it. It works all fine except for the procedures. The error it gives is : " Must declare the variable @vchProperty" The cod...more >>

Hi, I created a stored proc in SQL Server 2000 that returns the result of a left outer join. For example: CREATE PROCEDURE MyProc ... AS BEGIN SELECT ... FROM TableA AS A LEFT OUTER JOIN TableB AS B ON A.KeyA = B.KeyB WHERE ... END When I call the stored procedure in the query analyser,...more >>

Hi there, I'm posting this message again cause my lat message was totally wrong. What I'm looking for is how do I authenticate SQL users from a VB.NET application using VB.NET language? I know there is a sp_addlogin stored procedure in the master database, but do I call it from my applicatio...more >>

Hi there, How could I retreive the users and their corresponding passwords from SQL Server 2000? I'm using VS 2003 and VB.NET language. Thanks, Manuel ...more >>

I am losing lots of hair over this issue. We are trying to implement windows authentication from a web server to a database server. The web server is on a domain; the db server is not... does this matter? the IUSR_machinename user from the web server has been added as an account on the db server...more >>

Hi, How can I see if the Data is changed by the user in my DataGrid so I can ask him to save the changes or not? Thanks, Pieter ...more >>

Hi, I'm reading XML into a dataset and now I want to insert into Sql Server the data from the XML file. I haven't been able to figure out any other way than to do this than to walk through the dataset and insert each record one at a time. If anyone can help, I'd appreciate it. Ben ...more >>

I have a comma-delimited text file that I am reading via a connection string: junk = "Provider=Microsoft.Jet.OLEDB.4.0;" junk &= "Data Source=\inware\data\df;" junk &= "Extended Properties=""text;HDR=No;FMT=Delimited""" And ... strSQL = "SELECT * FROM " & Trim(in_file) & ".TXT" Dim da A...more >>

...more >>

Hello, not even sure if this is the right forum for this question but here goes.. :) I'm writing a NET Data Provider for our DBMS and got everything working except one thing. Populating a DataGrid.. All other parts of the Data Provider framework are all interface-based and therefore rather ...more >>

Below is my first Oracle ref cursor proc call from a code-behind page. The proc is located in a package, and the package specification defines the ref cursor. The proc takes 1 param in (Oracle 'number' type). And returns ref cursor. Unfort. it fails on ExecuteReader( ), and I get this red...more >>

Is is possible to bind a datagrid to an empty dataset? Initially, I would like the datagrid to be empty to allow users to insert new rows. I have the code to add new rows to the datagrid and to update the DB. However, I'm not sure how to add empty rows to the dataset, and if it is possib...more >>

can someone help me, please? I have the following set on asp with VB code. Dim dstProducts As DataSet Dim dadProducts As SqlDataAdapter dadProducts = New SqlDataAdapter( "SELECT ComputerName, IPAddress, SerialNo FROM Computer WHERE ID = " & TextBox1.Text, conPubs) It works fine up ...more >>

Hi all, I'm dealing with a buggy-like behaviour when I call ReadXml method of DataSet. Here the scene: I have myCustomDset.xsd and its associated/generated myCustomDset.cs; now my data is stored in an xml file, say data.xml. If I try to fill the DataSet without calling ReadXmlScheme, i...more >>

Dim index As Integer index = e.Item.ItemIndex DsSchedule1.Monday_Schedule.Rows(index).Delete() OleDbDataAdapter2.Update(DsSchedule1, "Monday_Schedule") dgMonday.DataBind() now everytime i run this say in a datagrid with three items everytime time i refresh after deleting say teh...more >>

Help! Ive been searching google, msdn, trying every which way i can and cannot get this to work. I am new to SQL Svr, coming from an Oracle background. I have a stored proc which given an input param of state returns the records in that state. I know the proc works, because if i run it from ...more >>

Help! Ive been searching google, msdn, trying every which way i can and cannot get this to work. I am new to SQL Svr, coming from an Oracle background. I have a stored proc which given an input param of state returns the count of records in that state. I know the proc works, because if i run...more >>

Hi, On my application, i'm using this : dataSet1.ReadXml(textBox1.Text, XmlReadMode.Auto); This works fine the first time but the second time, if i changed the value of textBox1.Text, dataSet1 is not reading the XML file which is in textBox1.Text, but it's reading the XML file i've use...more >>

Ok so i've added a ddl to a datagrid in vs.net using the template controls provide in the ide. How then do I bind that ddl to a field in an access database. Incidently, by binding the control, that means it should drop-down all values stored in each record or can I limit the values say by a vali...more >>

Hello, I've created a DataGrid (C#) and populated it with data. Here's the code: private void PopulateButton_Click(object sender, System.EventArgs e) { OleDbConnection MyConnection = new OleDbConnection (Connection String is here); OleDbCommand MyCommand = new OleDbComm...more >>

I have a winform datagrid where a user can modify more than one row at a time. A button calls theDatapter.Update() to persist changes to db. I wrap the Update in a client-side transaction and commit-on-success/rolllback-on-failure. In addition, exception-handler code invokes RejectChanges ...more >>

I've installed MDAC 2.6 on client machines running programs I've built with ..NET framework 1.0. I've started doing some database applications with 1.1--is it true that client machines with these applications need MDAC 2.8? If so, what's the difference? ...more >>

Hello. I'm trying to make a queries and I'm having problems. This one works: SELECT SUM(code) as total FROM table. It returns a Decimal value that I get with ExecuteScalar(). Now I need to use something like: SELECT SUM(code) as total FROM table WHERE date = '28/08/2004'. If I try to exec...more >>

Hi, With every click on Button1 i want to change (increase) number written on it, and i try to do it with this simple code: private void Button1_Click(object sender, System.EventArgs e) { string a=u.ToString(); Button1.Text=a; u=u+1; } With first click i get initial value "0" wr...more >>

Hi, I would like a datetime field in my dataset to always be set to the current Date & time when a new row is added. I tried setting the default value to DateTime.Now but that dosen't work since the function is called only once (and not everytime a new row is added). I am using a winforms app...more >>

Hi Is possible to know how much data (kB,Mb) SQL Server is intended to send as result of query? To analize before realizing of transfer for tuning purposes. Thanks Konrad ...more >>

I am attempting to create a asp.net page that will show ten records of an Access databse at a time and the on another page be able to update, add, delete them. I could really use some step by step instructions on this. Thank you, -------------------------------- From: Nicholas Hauser ------...more >>

Hi, I am having some problems inserting floats using C#. I have a field in the database that is a type float. I have a stored procedure that takes a type float and inserts it into the database. However, when it gets int he database, the numbers are inaccurate. For instance, when i am adding ...more >>

Could someone help me with a query? I have a table with the fields actor1,actor2,actor3 and i like to have a list of all actors starting 'nicola%' from those fields with no duplicate names. How can i do it with an sql query? ...more >>

I need to write own insert, delete and update command. I have to getchanges first. I am wondeering if there are some sample codes I can find Thanks ...more >>

I have the AllowNew set to true is a DataView bound DataGrid. When i leave the Datagrid and return to the same Grid by clicking directly on the last row, (the *New Row) the grid sometimes removes the asterisk and the row does not function properly. I tried a dataGrid.Enter event to check ...more >>

I have a web service that creates several reports, rather than exposing a method for every report I used something similar to the builder pattern, I pass in an object that inherits from a base class that holds the parameters for the report and the method calls a custom report builder that buil...more >>

Here is the situation: I have a web service that creates several reports, rather than exposing a method for every report I used something similar to the builder pattern, I pass in an object that inherits from a base class that holds the parameters for the report and the method calls a custo...more >>

I have what was supposed to be a simple program to pull data from one Oracle server and stuff it into a table on another Oracle server. Filling the DataSet works on the first server but on the second it fails. I'm using a seperate class for each database. I am totally stumped! The error Oracle...more >>