Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score OdbcConnection - parameter problem
David Thielen - 17 Feb 2007 10:22 PM - 5 messages
Hi; I have an OdbcConnection (ADO.NET) to Sql Server (I know I can use the SqlConnection - I'm testing our code when it uses ODBC) with: protected DbProviderFactory provider; protected DbCommand cmd; .... cmd.CommandText = "select lastname  from employees where (employeeid < 8) ...
Score sql server return parameter size.
Chuck P - 17 Feb 2007 10:09 PM - 6 messages
I have a sproc that returns xml data in an output parameters and I get an error. It works fine within the SQL05 environment but barfs in VS05. Are their any fixes or work arounds? SqlCommand cmd = new SqlCommand("web.SurveyAndTransform", conn); ...
Score Simple way of finding whether a certain value is in a DataSet column
nvx - 17 Feb 2007 7:39 PM - 9 messages
Hi, is there a simple and elegant way of finding whether a given string value is already present in DataSet column? Although I may do this using a For statement or something similar, I'd like to avoid using cycles. I'm looking for a method of DataSet, DataSet.Table etc., if ...
Score Data Sources window and data access library
Flomo Togba Kwele - 17 Feb 2007 5:31 PM - 15 messages
I am trying to create datasets in a data access class library and use them in the presentation layer. To create the dataset, I select the data access class library project in the Solution Explorer, right-click, Add New and drag a table from the ...
Score linking MS-Acess query to a public function in a module
NoviceProgramer - 17 Feb 2007 8:53 AM - 3 messages
Hi Every body I want to use VB.net2005 environmment  with access database I loaded the tabels and queries only to VB2005 The code and parameters' queries did not load I have no problem to rewrite code in VB.net syntax ...
Score BindingSource AddingNew method with DataSets
Flomo Togba Kwele - 17 Feb 2007 12:16 AM - 4 messages
I am using a BindingSource whose DataSource is a typed DataSet. The data is displayed in a DataGridView. Not all of the columns in the Datatable are visible. When a new row is inserted, I need to use the AddingNew method of the ...
Score ORACLE DEVELOPERS (GC/CITIZENS)
Tejal - 16 Feb 2007 11:42 PM - 2 messages
Hello, Given below is a direct client requirement for an Oracle Pl/sql developer. Kindly send me your resume along with your contact details. There will be only one face to face interview. ORACLE PL/SQL DEVELOPERS(GC/CITIZENS) Location Dallas TX ...
Score Disable a text box when it's not adding new row?
Nick nkw - 16 Feb 2007 10:10 PM - 7 messages
I want to enable a text box only when it's in "add new" status. The BindingSource.Position just return a number. Any good way to do it? Thanks, ...
Score Enforcing Constraints different in .NET 1.1 and 2.0?
ieg999 - 16 Feb 2007 9:56 PM - 1 message
When I fill a DataSet in .NET 1.1 that has a two records that have the same primary key, it allows the fill to occur without any errors. EnforceConstraints is set to true.  Running the same code in .NET 2.0 ...
Score Install rights required to install ADOMD.NET
Del - 16 Feb 2007 8:47 PM - 1 message
I have built a click once .NET 2.0 application that uses ADOMD.NET for MDX queries on a SQL2005 Data cube. When originally starting this project I used SQl2000 AS and the Pivot table lite executable for the communication with the ...
Score Output Parameter Returns Nothing
Sergey Zuyev - 16 Feb 2007 5:40 PM - 2 messages
Hello! I'm using SQL Server 2005. I have Stored Procedure that returns Table Records and RowCount as output parameter: CREATE PROCEDURE [dbo].[GetListByPage] @RecordCount bigint OUTPUT AS BEGIN -- get record count SELECT @RecordCount = (SELECT COUNT(ProductId) FROM [StoreProducts]) -- get table ...
Score The record cannot be deleted or changed because table
nkw - 16 Feb 2007 3:47 PM - 6 messages
I have two tables in Access obligor and Collateral, and collateral has foreign key reference to obligor. I created a winform to edit obligor. i tried to modify a none primary key column and got the following error.                 this.obligorBindingSource.EndEdit(); ...
Score Binding accessdatasource to "normal" controls
musosdev - 16 Feb 2007 12:01 PM - 3 messages
Hi I'm trying to use my AccessDataSource which retrieves 1 record based on a querystring, and display the various fields as Label controls on my page. At the moment, the code compiles, but nothing appears on the page. Can some ...
Score HOWTO: generate update/delete command using data adapter wizzard?
olympus_mons - 16 Feb 2007 8:42 AM - 3 messages
Hi, I'm just beginning my VS.NET 2005 adventure in C#, so maybe I'm missing something obvious... I created a dataset containing 3 tables, one "main" table and two lookup tables connected by a relation to the main table. Only for one ...
Score CLR stored procedures in TableAdapter: no fields are populated?
Steven Spits - 16 Feb 2007 8:33 AM - 7 messages
Hi, While experimenting with CLR stored procedure, I discovered it won't populate the fields in the TableAdapter, like a normal stored procedure. Why is this? GetClientList = normal stored procedure GetClientListTest = CLR stored procedure Both contain the same SQL, "SELECT * FROM Clients" and no parameters were ...
Score Critique My SQL
Jonathan Wood - 15 Feb 2007 10:52 PM - 8 messages
I'm writing a Website that contains the following code: // Query article data SqlDataAdapter adap = new SqlDataAdapter("Select art_name, art_date, art_desc, auth_name," + " '" + ResolveUrl("~/") + "Articles/' + grp_folder + '/' + cat_folder + '/' + art_filename + '.aspx' AS art_path" + " FROM Articles, Authors, Categories, Groups" + " WHERE cat_id = '" + id.ToString() + "' AND art_auth_id = auth_id AND ...
Score DataView to return x number of rows?
retroman80s - 15 Feb 2007 9:09 PM - 3 messages
Is there a way to set a dataview to return x number of rows? If not, what is the best solution to accomplish this? retroman80s [link] ...
Score Format propierty
JCaubin - 15 Feb 2007 6:16 PM - 2 messages
Hi How could I chage the format propierty from native to multidimensional or tabular in the OLAP petition?? I´m sorry for my bad english. I hope you can understand me. Thank you in advance. Julio. ...
Score [C#] Connect to IBM DB2 database
Gandalf - 15 Feb 2007 4:29 PM - 4 messages
Hi, I'm working on a C# project and want to connect to a IBM DB2 database in order to retrieve a DataSet. I'm using the ODBC driver. The code is the following: ----------------------------------------------------------------------------------- .... OdbcConnection odbcConn = new OdbcConnection("Driver={IBM DB2 ODBC ...
Score C# and tableadapter
Chris - 15 Feb 2007 3:40 PM - 1 message
Can someone help me figuere out how to get the returned data frm the code beow. How do I get each column of data returned into a variable. I basically get the selcted value in a datagrid view, then I want to run a query on that ...
Score Can't read records with '' in varchar from SQL server into xml
Solje - 15 Feb 2007 10:43 AM - 1 message
I have a table with a column named machinedata of type varchar that not are allowed to be null. Some of the records are '' because they not have any data at the moment. I try to read all records from that ...
Score Hi From Nilesh
Nilesh Joshi - 15 Feb 2007 10:30 AM - 1 message
Hi All Its Nilesh ...
Score SqlCommand Question - Programatically Set Value?
Rangy - 15 Feb 2007 2:48 AM - 4 messages
Say you have the following in your code. SqlCommand objCommand = new SqlCommand("StoredProcedure1", objConnection); Is there a way to replace the "StoredProcedure1" value at runtime based on a selection in a list or textbox entry. Thanks! ...
Score Oracle access without client tools?
Jesper - 14 Feb 2007 11:03 PM - 6 messages
Using ADO.Net, is there any way to connect to an Oracle database without having the 'Oracle client tools' installed on the client PC? I can see that if you connect using Oracle.DataAccess.Client or System.Data.OracleClient, you will need the client tools installed, but what ...
Score Datagrid does not update datasource efficiently
bidalah - 14 Feb 2007 9:35 PM - 7 messages
Hello all, I have a Windows form datagrid which is bound to a datatable in a dataset.  I want changes that the user performs on the information in the datagrid to be automatically reflected in the the underlying datatable. ...
Score Using a Variable within a Connection String
pooba53 - 14 Feb 2007 5:14 PM - 7 messages
Take a gander: Me.OleDbConnection1.ConnectionString = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database L" & _         "ocking Mode=1;Data Source=""AppBase"";Jet OLEDB:Engine Type=5;Provider=""Mic" & _ ...
Score NumberOfActiveConnectionPools
Hicky - 14 Feb 2007 4:26 PM - 5 messages
On one of our test servers I've just seen this counter spike to almost 1 billion then drop down to zero. Has anyone seen this behaviour? Is it a consequence of something in the code or a bug in the counter? ...
Score Excel 2003 - problem using from .Net
Peter A - 14 Feb 2007 1:16 PM - 3 messages
Visual Studio 2005. The following code was working OK with Excel 2007: Dim xlApp As New Excel.Application Dim wb As Excel.Workbook If Not File.Exists(AnionSpreadsheetName) Then     MsgBox("File not found: " & AnionSpreadsheetName)     Exit Sub ...
Score ADO.NET - Problem with Insert-, Delete- and UpdateCommand
fiaolle - 14 Feb 2007 9:17 AM - 4 messages
Hi I'm new to ADO in Visual Basic.Net and have problems with updating the DataSet after I have done ExecuteNonQuery. I'm using the code below Private Sub cmdDel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdDel.Click ...
Score Get Primary Key from Table.
_MC_ - 14 Feb 2007 8:05 AM - 4 messages
Hi, I want to request if an Colum is Primary Key or Not via Ole (C# Code). Following Part of Code descripes my ideas. However the function returns always false, no matter what Database System (e. g. MS SQL, Paradox, ...). This also appears if i request the Attribute ...
Score Subquery in SqlDataSource failing
Morris Neuman - 14 Feb 2007 6:04 AM - 6 messages
Hi, I have a query in SqlDataSource that has a subquery.  I have it working in AccessDataSource but get error when running it in SqlDataSource.  Since I was told that the .net query builder only allows simple queries, I have ignored ...
Score Problem with ADO.Net and Excel
Bill Gower - 13 Feb 2007 9:54 PM - 2 messages
I am reading an Excel spreadsheet into a C# program and am having the following problem.  Here is my code and then I will explain the problem.              DataTable dt; ...
Score SqlDependency connection failure (using Sceppa sample)
Earl - 13 Feb 2007 7:38 PM - 6 messages
Still working with this SqlDependency idea, but have not been able to successfully muddle through it. I'm using David Sceppa's sample from Ch. 14 (ADO.Net 2.0) to set up a sample DB with SqlDependency working. The script ...
Score Update table with changes to dataset via Insert statement
staspe - 13 Feb 2007 5:09 PM - 1 message
vb.net 2003 access 2003 I need to insert records into a new table and accept changes.. But It will not update correctly..         With dbDataSet.Tables("tblData")             Dim i As Integer ...
Score Possible help for Newbie
Not Bright - 13 Feb 2007 3:37 PM - 4 messages
Hi All, Hope everyone is well and wouldn`t mind helping a very frustrated newbie out? Im fairly new to VB 2005. I have made a fair very simple Database Projects which have all worked. Im now writing a very simple project which ...
Score SQL Server 2005 causes problems with second connection
Oldman - 13 Feb 2007 3:04 PM - 3 messages
I have a scenario where I am making an update using multiple calls to the database and all the calls are within the same transaction.  However, before I commit I have need to query some additional data.  So I created a NEW ...
Score dbase III, IV, 5 files and ADO 2.0
ray well - 13 Feb 2007 2:17 PM - 2 messages
hi, how can i access a dBase *.dbf database in CODE only, in Visual Basic .Net 2005 and Ado 2.0 ? this is for a off site machine where i have to access the data thru code. how do i make the connection and which provider do i use? all the code i saw ...
Score SQL Server: get column's default value
Andrea Caldarone - 13 Feb 2007 2:11 PM - 1 message
Hi all, whena I fill a DataTable with the .FillSchema method of the sqlDataAdapter class, I lose column's default value. Is there a simple way to get them or have I to query the SQL Server database and manually set them? ...
Score Using User-defined Functions in VB.net 2005
NoviceProgramer - 13 Feb 2007 1:28 PM - 1 message
Hi Every body I used access succefully for years and I created many scientefic databases with it Now I want to use VB.net2005 environmment  with access database I succesfuly loaded my database BUT all the custom functions in the ...
Score Cannot remove a detached row from a DataTable
Hamed - 13 Feb 2007 11:34 AM - 4 messages
Hello I have a DataTable bound to a DataGrid. During working with the grid, some detached rows are created internally by the grid. I want to remove the detached rows from the DataTable but calling myDataTable.Rows.Remove(myRow) have no effect on it. What am I missing? ...
Score convert to pdf
nil - 13 Feb 2007 11:28 AM - 5 messages
hello everyone can any one tell me how can i convert my grid data in to pdf?pls provide some code snippet or some link that contains the related topic.. Thanks & Regards, Nil ...
Score updating database views via tableadapter?
Darren Sim - 13 Feb 2007 10:06 AM - 15 messages
Hi there, I am developing a database application in c#.net 2005 and I've came across a bit of a problem.  I am using a dataset to hold the application data, but one of my tables has been built from a database view.  All the other tables ...
Score Extract string from field in 1 table
staspe - 13 Feb 2007 1:40 AM - 4 messages
vb.net 2003 Access 2003 The following code is using a Criteria Table "tblVendNameFindReplace" with 2 fields  txtFind   txtReplace and a data table  "tblData"  Using   "fldDescription" What I'am trying to do: Find the   Value  "txtFind" inside  the  fldDescription string and use ...
Score 2 Table search...Output excel
staspe - 13 Feb 2007 1:35 AM - 2 messages
vb.net 2003 access 2003 excel 2003 If 150 records exist in tblData, there will 150 results in Excel... It will loop starting at row(record) 1 in tblData and loop to record 150... So actually the sql for tblData could just read: ...
Score Why Won't This Work?
pooba53 - 13 Feb 2007 12:08 AM - 3 messages
Take a peek at this connection string to an Access db from VB .NET 2003: 'OleDbConnection1         '         Dim AppBase As String         AppBase = AppDomain.CurrentDomain.BaseDirectory & "data.mdb" ...
Score RECORD COMPARISON
Bmack500 - 12 Feb 2007 9:33 PM - 7 messages
I need to rapidly compare an old record with it's newest version, in order to general alerts. My code is in vb.net (.net 2.0). The record has many related tables; what is going to be the quickest ...
Score Locking during ADO .net transaction
Darren - 12 Feb 2007 8:27 PM - 2 messages
This is an ado .net transaction in C# with a SQL Server 2000 database. Have 1000 or more inserts/updates/deletes to do in a transaction.  All or none must be committed.  Each stored proc operates on the same ...
Score Referencing a common instance of a Dataset
bidalah - 12 Feb 2007 7:50 PM - 7 messages
Hello all, I am sure there is a simple answer to this question.  There just isn't a simple way to describe it for a search engine. I have a vb.net program consisting of several windows forms, miscellanenous classes, and modules.  I want all of these classes to ...
Score Max pool size reached exception when trying to open a new connection
ramneekm - 12 Feb 2007 3:38 PM - 6 messages
hi all, i am working on a asp.net web app and using ado.net 's SqlClient Data Provider to connect to sqlserver 2005. I am getting the exception "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred ...
Score Calling an Oracle store procedure using C#
C#_Beginner - 12 Feb 2007 3:19 PM - 3 messages
I was wondering if someone can help me out. I'm getting the following error: Message: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'GET_RIGHTS2' ORA-06550: line 1, column 7: ...
Score Using two databases in a select statement
T McDonald - 12 Feb 2007 2:44 PM - 2 messages
I am trying to use two different databases, both using different authentication credentials. My question is, can I use these two databases in the same select statement? If so how would I set it up so that I can join the ...
Score BindingSource Problem
Christopher - 12 Feb 2007 1:20 PM - 1 message
Hello, I have a problem with the BindingSource and the BindingSource.Filter. I want to display a set of Rows filtered by some IDs which are stored in my database as a varchar 16 with bitdata (bytearray). In my application they are used as Guid-values. ...
Next »