I'm trying to figure out how best to solve the following problem: I have a database with two tables, Projects and Steps, that I want to read into a dataset. Projects contain Steps, so I will create a data relation between the two tables. Here's the twist: When I fill the dataset, I don't want ...more >>

How would I do the following for a datagrid? I want a Union Query to be my DataSet for a datagrid: 1) The Union Query qBenefitsUnion ============ SELECT * FROM qIN UNION SELECT * FROM qOUT 2) The Pieces that make up the Union qIN === SELECT "Inpatient" AS Type, qMembershipSele...more >>

I just received my new report server for the company. It is running Server 2003 with SQL Server 2000 and Oracle. Report server is running great. Now I want to design reports and post them. I downloaded the Eval version of the Report Services and tried to install them on my local box. I co...more >>

In Microsoft Access, it is possible to create a query and then refer to it inside another query... how would I do this in ADO.NET? I'd like to create a simple select query and call it something like: qMemberSelect then refer to qMemberSelect as though it were a table inside another quer...more >>

hello, we have a strage error message here: I've written a small detail sample page, where I can update one reocrd with an objectdatasource control and the detailsview control. the objectdatasource.confictdetection is set to 'CompareAllValues'. The Updatemethod is UpdateXY and I've set two ...more >>

I need to pull data from two separate DBs in SQL Server with the ability to store a value (id) from db as a foreign key in the second db and display a name associated with that id. I don't want to duplicate the Customer table from the second db in the first db. Is there any way to do this? --...more >>

Dear All, We have developed a WinForm application where a user enters some free text if the free text contains Hexadecimal value ('-') ['Alt + 0150'], then after saving and getting back the value, the =BF is shown in its place. I am using .net 1.1 sp1 and using OracleOLEDB... Do I need to s...more >>

I am trying to develop a form in which I will have a listview, in which there will be all the records of a table. The user will be able to double click on a record, and a form will appear in order to change the records information. The user will be able to click on a button in order to display a...more >>

Hi, I'm trying to use a typed DataSet based on an XML schema file. Here is a sample XML schema file for a "Location" with four typed-defined elements: <xs:element name="Document1"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="Locatio...more >>

I created an application that makes use of a typed DataSet for holding its data. This DataSet is saved out with simple XML serialization. Now, after having deploying the application to a number of people, I'd like to add a new DataColumn to one of the tables. I added the new column to the D...more >>

Hi, Is there any effect of Enlist attribute in the connection string if there is not DTS environment, No COm+ or MTS. I am facing a problem where the connections I receive from a connection pool has pending transaction. is this anyway possible? Regards, Bhupesh ...more >>

hey guys, any idea(s) why this code would only export the first page? it works perfectly - just if the report has multiple pages, it only exports one. thanks for any help ive been all over the web and this seems to be the code everyone is using. rik Private Sub ExportPdf() Dim oStrea...more >>

Hi, I originally posted this on public.data.ado, and someone nicely informed me that this group is probably better suited to my question, so here goes: I have an mdb that I open using asp.net. I edit these pages and code using FrontPage. Everything works fine, but sometimes I make a mist...more >>

Instead of button columns, I need to add a column of dropdownlists to my datagrid, with options such as ADD, EDIT, and DELETE to each row of data. How can I do that? Thanks, Richard ...more >>

Hello I am displaying into a GridView the ASPNETDB content (that was created with the login control of ASP.NET 2.0) why doesn't the SQLDataSource let me use the UPDATE method.. When i click Advanced on the SQLDataSource configuration those options are greyed.. Any suggestion? i really nee...more >>

TableAdapter is a new feature of VS2005, is it good to use TableAdapter to replace Object-Relation mapping model? ...more >>

I am using a DataGrid with a dataset and the OracleDataAdapter.Fill(dataset,"Tablename") method. All is fine: a table is created and mapped to the dataset and data is shown in the datagrid. When I clear the table, dispose it and remove it from the dataset, and then reload the same table wi...more >>

Hi, I'm trying to insert a new record in a Table (the field ID is numeric, counter and primary key) and get the value of the field ID, using ADO.NET. Accessing recordset (rst below) by ADO I can do: rst.addnew rst("Name")="Joe" rst("Surname")="Smith" rst.update myID = rst("ID") Then I ...more >>

Anyone have code that generates a DataSet and DataTable from scratch using code with a given connection, to MSAccess. Does this disconnected DataTable track changes??? Can I turn off the "Tracking". Help would be appreciated...more >>

In my application, it reads several tables from database when loading the form. Many users feel the application hang. How can I improve the performance of this application. The application load data table by table. I known ADO.NET can read all resultsets one pass. But my case, each user...more >>

Hi all, Anyone face this problem on oracle 10g and Visual Studio.Net 2003 ? The following code works fine if using the mysql4.1 with the library of the MySQL.Data. But error occured while using the library of System.Data.OracleClient :- Error message:- 'p5': No size set for variable...more >>

Ho can I get user permissions on a certain table to see if the user is allowed to delete or update or insert records on a table. It would be helpful to have this Information this before trying to make updates. Thanks Ferdinand...more >>

Ok please somone correct me if im wrong. I think a lot of the changes to the underlying structure to ado.net in version 2.0 are for controls. The new features make it much easier to bind controls to the database with almost no code at all. If your not binding data to the controls though you sh...more >>

When filling multiple tables with DataAdapters, I explicity open the connection object that is passed to the DataAdapter before and close it after the tables are filled. Now, in 2.0, I'm filling multiple tables with TableAdapters and making use of the extended query capacity. It looks like...more >>

Hi, I'm using a connection string what has this DataSource : "PCNAME\INSTANCENAME,1884". In my application if I don't use name instance and port, it works fine, but if I use instancename and port don't work. SQL Server is configured correctly, and Delphi applications works fine with it....more >>

Hi there, I want to create some DataColumns using the following approach: string datatype = "int"; DataColumn intCol = new DataCoulmn(); intCol.DataType = typeof(datatype); string datatype = "string"; DataColumn strCol = new DataCoulmn(); strCol.DataType = typeof(datatype); I kno...more >>

Everyone, I am trying to load a bunch of records into a Sql Server 2005 Database using (TransactionScope ts = new TransactionScope()). I keep getting an error message saying MSDTC on server 'SOHO/SQLEXPRESS' is unavailable. my SOHO server is a Win2K3 Server with SQL Server 2000 using the ...more >>

I am currently making the jump from VB6 to C#. We have a login prompt that returns an ADO connection. Eventually I will have to re-write this login prompt in C#, but for now I have to use it for a C# program that needs to be finished soon. Basically, I call the prompt, get the ADO connection, cr...more >>

Environment: VB.Net, SQL Server 2000. I've used both data readers and also datasets with tables in them. I would like to use a data reader (because of its speed) to retrieve using a stored procedure with TWO selects in the stored proc (two result sets), then go thru the data reader and put ...more >>

Hi all, I have a database that contains almost 10,000 records. It's an Access DB that's only being used on a single computer (no access from multiple users at the same time). The front-end is a windows form app. It has a search textbox, that updates the query whenever the text in that textbox...more >>

I'm open to suggestions on how to accomplish this easily (VB.net... MS Access): I've an MS Access db. It has a column indicating if the row has been Exported or not (the Column is a Boolean). What I'm trying to figure out is how to toggle the Boolean flag for several rows at a time. For...more >>

Hi everybody, I like to asked anyone who is very good at sql to help me display this data in a table format that duplicate headings, subheadings or other columns won't appear twice or more. Can anyone help me? I need to sort them and load them in a Datatable. Loop thorugh all records and d...more >>

How to convert a datareader to datatable? ...more >>

How can gather a table's schema from SQL Server 2005? ...more >>

I want to store the objects that i create in run time in database. In a way that, for a product a create an object from a class written with C#, define its properties and functions that it has, and want to store it in a database (SQL Server 2K). I want the columns to be created and filled dyna...more >>

Okay... I'm using VB.net (2003) and I am accessing an MS Access DB file. I have two DataAdapters that I use to search for specific info. The two of them are similar except one is a Date, the other is a String. Currently they both work as I like and I can get my data as I want. What I'm int...more >>

My ASP.net 1.1 online cinema reservation system is Developed in 3 Tiers: 1-DataAccessTier "Data Repository Class" 2-Business Tier "Set of Business Classes" 3-Presentation Tier "set of WebUserControls & aspx pages" if i want to make a WebService that enables its users to interact with the syst...more >>

hi.. i'm trying to connect to oracle 8.1.7 in asp.net using integrated security but i'm always getting a ora 01017 invalid username/password. logon denied message. my web application is running on iis on windows xp professional. This is my connection string: data Source=bankiby;integrated se...more >>

Hello, I need to delete thousands of records from two SQL tables, but the rows are not contiguous. There is a unique numeric id for each row (clustered index), and my input is a file containing at least a hundred thousand of these ids to be deleted. The numbers, however, are all over the ma...more >>

Hi all, I am building a VB application which uses quite a few data adapters. All was going fine, then suddenly for one of them the wizard refused to generate some of the SQL statements for manipulating the data. Anyone know why it might not be able to do this? There doesn't seem to be an...more >>

I have confirmed that the following SQL string works in Access: SELECT[MRN],[MemNAME],[DOB],[SEX],[SSN],[GROUP],[SGR],[FROM-DT],[THRU-DT]FROM MEMBERSHIP WHERE [MemName] like 'duld*'; I have also confirmed that it is successfully passed as a Public String into strMemberSQL So why won't it suc...more >>

I have a view, it is create by one primary table and two detail tables, like SELECT St.GuyID, WH.Weight,WH.Height, Sight.SightL, Sight.SightR FROM St,WH, Sight where WH.GuyID = St.GuyID and Sight.GuyID = St.GuyID I was use this select statement in a SqlDataSource. How can I write the upd...more >>

Hello, I have created a class that accepts a text file as input. The file is parsed and a data table is returned. I then take the data table, load it into SQL, and create a local reportviewer instance from a query on the SQL table. I would like to do away with the requirement to load the data...more >>

What happened??? I just upgraded one of my 2003 projects to VS 2005 and now, when I call the Fill method of an OleDbDataAdapter passing a DataTable as a parameter it takes a heck of a lot longer that it used to. Before, it used to take 1 second to fill up the DataTable but now it takes arou...more >>

Hi All, I think I am mis-understanding something about the DataSet's Merge method. I am getting changes from my DataSet and storing them in another DataSet called changes. I then pass those changes to the UpdateDataset method of the Data Access Application Block. Any new rows in the changes...more >>

Hi All, Does anyone know how to do this or give an idea how can I achieve this using DataSet and ADO.NET For example I have 2 table relationships. Table1 -> Customer Table2 -> CustomerOrder The name should be pretty much self explanatory. I want to create a stored proc that returns the ...more >>

I don't know id this is ADO but the SQLServer.clr newgroup is not in the managed groups list so sorry if I have misposted I have an one clr stored procedure that would like to call from another another. public static void ParentSproc(SqlInt64 id, SqlString userName, out SqlInt32 re...more >>

Creating a new dataset from an existing one using ImportRow works just fine but when I want to modify the DataColumn of the imported rows inside the new dataset I always get an error saying that the column is read-only ?!?!?! "System.Data.ReadOnlyException: Column 'start' is read only. at...more >>

"Transaction (Process ID 83) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Source = .Net SqlClient Data ProviderSource" Sometimes I get the above mentioned server error while doing a transaction in my application. W...more >>

Hi, For this to work, does the SQL server 2000 also needs Framework 2.0 runtime installed? I'm getting the "Network DTC is disabled" exception even the setting is enabled on the SQL Server. Thanks Michael ...more >>

I'm creating a simple search for Members, with possible 4 search parameters: Name, SSN, DOB, SEX, but (just beginning ASP.NET/VB.NET) I'm fearing that I will need to create a dataadapter for every possible combination of fields entered to eliminate a blank parameter. Does a parameterized Dat...more >>

Dear All, We have created a WinForm application that uses OLEDB to connect to Oracle DB. The Oracle client version is 8.1.6 and the Oracle DB version is 10g...sometimes we randomly get errors like <Object reference error> <Unable to retrieve error text for [0]> The following are the stack st...more >>

Hi, I use the new datasource and gridview controls to present data - without writing a single line of code...But what about error handling? If there is access denied to the SQL server, if the stored procedure that is called does not exist, etc. - the need for error handling is indisputable....more >>

I save changes from a dataset and get them with tempDataSet = myDataSet.GetChanges() I validate the changed rows and if I find an error, I mark the row with tempDataSet.DataTable.Row[..].SetColumnError(...) coming back from validation, tempDataSet.HasErrors is true, that's ok. Then I ...more >>

Hi, I'm trying to use the XmlDataDocument to allow Xpath queries of relational data I've loaded from a SQL database (in VC#2005 / SQL2005). I have loaded a DataSet with the proper tables, created their relationships, and set them to Nested=true. But the resulting XDD is "inside out" from wh...more >>

I have a problem connecting to an Oracle database. On my own desktop I run Windows XP SP2, Visual Studio 2005 and Oracle client 8.1.7 with the 8.1.7.1.5 patch. I can connect to the database using SQLPlus (username ownmgr, password mypwd, service upp.sotsa which corresponds to a tnsnames.ora ...more >>

(perhaps the wrong NG -) the DB tools in VWD dont pick up on the autonumber key field in Access (they edit fine) - the key field is not displayed, but neither is it updated and so of course "add" bombs - ...more >>

Hi, I am querying the database and sticking the results into a datatable. It would be helpful though if I could determine programmatically which column in that datatable is the identity column (if there is one). Is there a way to do this? ...more >>

Hi, I need some search system, that will return me the records with in indicator of probability. This is for a VB.NET 2005 application with a SQL Server 2000 DataBase. I have a table with different columns in which the user needs to search. In case the search-routine finds the exact match ...more >>

Hi, TableAdapter is a new feature of VS2005. When I design the DataSet (named MyDataSet) in WinForm Application, it will generate 4 file: MyDataSet.xsd, MyDataSet..xss, MyDataSet.xsc, MyDataSet.Desginer.cs. But if I desgin the DataSet in Web Applicaiton, it only generate two file: MyDataSe...more >>

Hi, I have got a problem with creating new tables using ADOX. If I want to append a single table to the db then it works fine. But how can I append more then one table? thx juvi...more >>

Hi, After running the code: SqlConnection conn = new SqlConnection("server=.;database=Northwind;uid=sa"); SqlCommand cmd = new SqlCommand("select * from Customers", conn); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); dr.Read(); dr.Close(); conn.Close(); c...more >>

I've run into this problem twice now and haven't quite figured out how to approach it properly. I'm using ASP.NET 1.1 and C# to develop a reporting package. Some of these reports are showing a daily total amount. There has been a request to add a running total next to the daily amount. For...more >>

I designed a DataSet in a WinForm Applicaiton in VS2005. I use the new feature of TableAdapter of VS2005. The name of that DataSet is WH, and the files create by VS2005 are WH.xsd, WH.desginer.cs, WH.xsc, WH.xss. Now I want to use the WH DataSet in WebApplicaiton. Can I use this DataWet ...more >>

Hi, I have inherited some legacy code with performance issues: I ran perfmon on the problematic use case, with a counter on .NET CLR Data / Current # Pooled connections (amongst others) I noticed that while performing a set of tasks in the use case, pooled connections increased systematic...more >>

Hi guys, I met a issue that is about the lenght of the parameter name. I'm using Oracle as back-end database, though I'm not familiar with oracle. I'm using the following code to pass a parameter: Dim objOracleParameter As New OracleParameter(parametername, value), where the length of p...more >>