Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score TableAdapter filtering problem
Zsolt - 10 Jun 2006 3:16 PM - 3 messages
Hi! I need a custom filter on a TableAdapter query, which has to fill a DataTable (VS-2005, C#). Data should be editable. select integerfld, others from Nap where integerfld in (@param) this.napTableAdapter.FillBy(this.int2006DataSet.Nap, "20,30,40,55"); ...
Score Looking up a record in a table
BobRoyAce - 10 Jun 2006 5:37 AM - 4 messages
I am new to VB.NET and am currently using Visual Studio 2005. Let's say that I have a Users table that has User information, including LoginName and Password. I have a login form where the user types in a ...
Score connection to access file fails
fanor - 10 Jun 2006 12:26 AM - 3 messages
Hi guys, I added to a form an oldbconnection  to connect to an Access file  (access 2000), using the wizard I select the  MDB file but when i test  it i got  an error  "Invalid authorization specification". ...
Score Connection Strings
Vi - 9 Jun 2006 10:51 PM - 8 messages
Hi, I'm creating an application that has to connect sequentially to different tadabases. I added all the connection strings to app.config and I'm itterating through them in the following manner: foreach (ConnectionStringSettings connStringSettings in ConfigurationManager.ConnectionStrings) {    ........ ...
Score Update an Access Query from Vb.net (Help!!)
rguarnieri - 9 Jun 2006 8:39 PM - 2 messages
Hi, I need to update an access sql sentence in my access database from vb.net, I have a query saved in my database, for example "MyQuery1" This "MyQuery1" have inside an sql sentence, for example "select * from MyTable", in my vb.net I need to update this query by another one, for ...
Score VB 2005 The record cannot be deleted or changed because table YYY includes related records
Craig Grell - 9 Jun 2006 6:31 PM - 3 messages
I have a simple parent child table setup using MS Access I keep getting this error The record cannot be deleted or changed because table YYY includes related records I am not updating the primary key or changing it. I looked at the code in the Dataset.Designer.vb ...
Score concatenate two columns in a DataTable
Julia - 9 Jun 2006 1:43 PM - 4 messages
Hi I have a DataTable and I would lika to concatenate two columns so that can dispaly this new column in a DropDown box. (Firstname and Lastname). How can I do this? Thanks Julia ...
Score VS 2005 Connection String Problems
Duane - 9 Jun 2006 1:03 PM - 5 messages
I created datasets and tableadapters using drag and drop and am using a mdb that is included in the project for development of a C# application.  However, the release version of the software must be able to point to ...
Score With DataDirectory Keyword: CrystalReports.Load, CrystalReports.SetDataSource Yields Password Prompt
clusardi2k - 9 Jun 2006 12:51 PM - 2 messages
Hello, the steps that I did to get to my current question are:    I began to use the keyword DataDirectory and the next line of code. When I ran the application, I would be asked for a Login ID and ...
Score Diffference between DataSet and DataTable
Creative Designers - 9 Jun 2006 9:08 AM - 3 messages
Hi Friends, Can you tell the difference between Dataset and Datatable.... Dayaa ...
Score XSD File and Database View
Lucky - 9 Jun 2006 8:09 AM - 2 messages
hi Guys! i've faced very very strange problem. i don't know whether it is a problem or its the feature of the .net 2.0. I'd made some Dataset using XSD file. in this XSD files i've created 3 tables and defined some ...
Score Please help with some code.
Adrian - 9 Jun 2006 7:43 AM - 5 messages
There is an error in the line marked XXX Could someone put it right for me? Many thanks, Adrian. using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Data.SqlClient; ...
Score how to check the value of a field on each row?
phil - 9 Jun 2006 7:38 AM - 3 messages
Hi, The aspx file contains a datasource and a gridview. The (only) field is a boolean type (true/false). Now, when the value of the field is 'true' something must happen (e.g. Response.Write("this is true") ). So i used the server-event 'GridView1_RowCreated' but how can i check the ...
Score ODP.Net Connection String
nitinvraj@gmail.com - 9 Jun 2006 4:11 AM - 2 messages
Hi all, As I understand when using ODP.Net we have to provide in connection string Data Source as the Net Service Name. Is there any way I can connect without specifying the Data Source as I dont want to install ...
Score Reading - Parsing Records From An LDAP LDIF File In .Net?
jeangv - 8 Jun 2006 10:02 PM - 1 message
Reading - Parsing Records From An LDAP LDIF File In .Net? I am in need of a .Net class that will allow for the parsing of a LDAP LDIF file.  An LDIF file is the standard format for representing LDAP ...
Score timeout question
eric.goforth - 8 Jun 2006 8:13 PM - 2 messages
Hello, I have a connection string that looks like: "SERVER=MyServer;DATABASE=MyDatabase;UID=Myuser;Connect Timeout=900;" However, when I try to run the following, it times out after MUCH less than 15 minutes:     Private Sub RunUpdateTransaction(ByVal UpdateSQL As String, ByVal ...
Score Using SMO with Oracle?
Scott - 8 Jun 2006 8:01 PM - 4 messages
All, Microsoft has Sql Server Management Object (SMO) for use with Sql Server databasess. Is there something simliar for using ADO.NET with an Oracle database? Thanks in advance. ...
Score SQL Parameterized insert Problem (variable already declared)
Bmack500 - 8 Jun 2006 6:41 PM - 2 messages
Hello, I have the following code (vb.net) below. I'm just taking an array and pushing it into an sql (MS) database. However, it keeps giving me the following error: "InsertFileRecords: The variable name '@cn' has already been declared. ...
Score The variable name has already been declared error - SQL parameter insert
Bmack500 - 8 Jun 2006 6:35 PM - 6 messages
Hello, I have the following code (vb.net) below. I'm just taking an array and pushing it into an sql (MS) database. However, it keeps giving me the following error: "InsertFileRecords: The variable name '@cn' has already been declared. ...
Score Transaction limitations
nashak - 8 Jun 2006 6:27 PM - 3 messages
I am updating a table of a few million records with a update file i.e based on the data in the update file, I am updating my records. My code throws an error everytime it reaches a particular record. The ...
Score Where to Lock when updating a DataTable
paul - 8 Jun 2006 4:24 PM - 4 messages
Hi, I have an C# app which uses a Dataset which contains multiple DataTables as an in memory database. (Currently the dataset is not connected to a database.) The app is multi threaded and adds/update rows in the various tables. ...
Score How to filter by Month using Dataview.RowFilter
Dr_Franz - 8 Jun 2006 3:12 PM - 1 message
Hello, My Code: dvM1.RowFilter = "DATEPART(Month, Datum) = " + Monat.Month + " AND DATEPART(Year, Datum) = " + Monat.Year; But DATEPART is not a ADO Functions? Can someone help me? ...
Score Run SQL against DataView Object
acoles - 8 Jun 2006 3:11 PM - 2 messages
Hi, I have a requirement in a current project to show the effect of a particular SQL Statement on a given database table. The statement will only effect one row but could be an UPDATE, DELETE or an INSERT command.  The user should see the table row before and ...
Score Simple Multiple Row Insert Question
Simon Harvey - 8 Jun 2006 1:52 PM - 2 messages
Hi everyone, I have a pretty simple situation and I'm hoping that someone could give me some advice on the best way to handle it. I need to insert a whole load of rows into SQL Server 2005 using ado.net. ...
Score SqlBulkCopy with SQL2005 Column encryption
Andy Tather - 8 Jun 2006 12:14 PM - 1 message
Hi, Can the SqlBulkCopy class in .NET 2.0 be used in conjunction with SQL Server 2005's native column encryption? Many Thanks, Andy ...
Score Programatically unique
Jon Vaughan - 8 Jun 2006 9:48 AM - 5 messages
Hi, I have have dataset on the client side and I would like to set it up so that it cant take data entered that isnt unique on two columns. There is obviously the unique property of each column , but they work indepedant, im ...
Score Issue with Command Timed out with data adapter
Ajith Francis - 8 Jun 2006 6:40 AM - 1 message
When i try to fill a dataset with a adapter am setting the command timed out to 15 seconds. but the querry is not timing out after 15 seconds. what may be the issue? Code i am using ------------------ SqlConnection objConn = new SqlConnection("Connection string"); ...
Score ADO.Net- Anyone know of a way to find all databases on my computer?
JimC - 8 Jun 2006 5:09 AM - 2 messages
I'd like to find all the databases on my computer.  In other words, would like to find information similar to the info shown in Server Explorer in Visual Studio .Net. Anyone know of a way of doing this? ...
Score Created Dataset with two tables - How do I populate at runtime?
dchman - 7 Jun 2006 10:00 PM - 4 messages
In VS 2005, I created a dataset with the dataset designer that has two tables that have a parent-child relationship (which I also added in the designer).  Each table gets data from a stored procedure.  I want to populate the dataset ...
Score Programatically call extended stored procedure?
TJ - 7 Jun 2006 9:47 PM - 3 messages
Hi, C# / .NET Framework 1.1 I would like to query extended stored procedure like stored procedure... However, I found that CommandType property does not have Extended Stored Procedure value..... I tried something like.. SqlConnection con = new SqlConnection(....); SqlCommand command = new SqlCommand('xp_blahblahblah", con); ...
Score How do I compare 2 UniqueIdentifier Guids?
Bmack500 - 7 Jun 2006 8:16 PM - 4 messages
Hello. I have two databases, both of which store an objectGUID (from a contact object) in a UniqueIdentifier Column. How can I search a value picked up in one (using sqlreader) to a value in the other table? For example, using the following: ...
Score newbie question
PJ6 - 7 Jun 2006 7:59 PM - 6 messages
I have a collection of objects that can be bound directly as a data source into a DataViewGrid... works great, but now I can't figure out how to get the columns sorted in the order that I want, or how to hide certain columns. ...
Score number of recs from select
Carlos - 7 Jun 2006 7:58 PM - 3 messages
Hi all, I am trying to figure out how to retrieve the number of records resulting from a select. I tried executereader but the object does not contain the number iof records retrieved. Any suggestions? Thanks,                 Carlos ...
Score question about client callback and gridview
Chris - 7 Jun 2006 6:58 PM - 4 messages
Hi, I read about client callback and i have a question. Assume the option "sorting" is set in a gridview. Each time the user clicks on a fieldname, the data are sorted. My question is: are the data on each click fetched from the server, or are ...
Score SP w/ parameter using a DAL
kuhrty - 7 Jun 2006 6:31 PM - 2 messages
Hi, I am using the enterprise DAL that I downloaded from Microsoft. I am trying to create a data table based SP with a passed parameter but I keep getting a null exception error. I thought it was set-up correctly ...
Score Informix Drivers
MasterChief - 7 Jun 2006 4:32 PM - 2 messages
I am using Informix ODBC to connect to my POS database. It works fine and shows all the tables in Excel but when I connect to the ODBC in Visual Web Developer it says Test Successed but doesn't show any tables ...
Score SQLTransaction IsolationLevel questions
eric.goforth - 7 Jun 2006 4:24 PM - 2 messages
Hello, Sorry for posting this in more than one place, I meant to put it in this newsgroup, not m.p.d.f.aspnet... I have a VB.NET subroutine similar to the following:     Private Sub RunUpdateTransaction(ByVal UpdateSQL As String, ByVal ...
Score Need help with Case-sensitive queries in SQLServer 2000
Mori - 7 Jun 2006 3:44 PM - 2 messages
I need to retrieve records just as they are and enforce case-sensitivy.  For example, my query return 'E1234' in place of 'e1234'.  I want to return exactly what is in the table. How do I do that? ...
Score Bindingsource c#
Mark Huisinga - 7 Jun 2006 2:54 PM - 3 messages
Hi there, are there any good reference examples for using a bindingsource object ? I new to ado.net and trying to create a simple maintenance app on an sql mobile database. I created a datasource and then dragged a table onto my form (Detail mode). ...
Score Great time in France
Holiday101france - 7 Jun 2006 2:10 PM - 1 message
<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>Hello</P> <P>I had a fantastic time in France, hope to visit again soon.</P> ...
Score New to ASP.Net, Cascading DropDown List in Detail View...Please help
Sam - 7 Jun 2006 1:48 PM - 3 messages
A) Destination Table with 4 Fields. 1) Last Name 2) First Name 3) State 4) Zip Code. B) Look up table State/Zip Code with 2 Fields 1) State 2) Zip Code. I created a DetailView Form in Asp.net to Insert/Update Destination ...
Score Validating Data using Typed Dataset
Baren - 7 Jun 2006 1:28 PM - 4 messages
Hi! All, How can i validate data filling into a typed dataset? e.g. Say I am importing data from a flat file into a typed dataset. I want to validate that each data entering into the dataset are in match with the ...
Score Datasets fundamental
shyamspandey - 7 Jun 2006 10:56 AM - 6 messages
Hi there! I'm very new to dot net envirnoment and have little bit understanding. Due to some reason, I need to work straight forward on datasets and webservices and xml. I don't have much hold on the same but would ...
Score PLEASE tell me how to handle RowUpdated with/against a typed dataset
Scott F. - 7 Jun 2006 12:05 AM - 6 messages
I have searched and searched and searched and sear.. anyway, you get the idea. I am trying desperately to figure out how, in "C++/CLI" (Managed C++/2005) to handle the RowUpdated event in my code but can not find an ...
Score Open DataReader associated with this Command which must be closed first.
eric.goforth - 6 Jun 2006 6:04 PM - 3 messages
Hello, I'm getting the a  "There is already an open DataReader associated with this Command which must be closed first" error message in the following scenario.  The message seems misleading, since the command isn't associated with the datareader, but the connection is.  Is there any ...
Score Generating a collection from a data set table
Vi - 6 Jun 2006 5:59 PM - 3 messages
Hi, I have a strongly typed dataset with 2 tables: Orders and OrdersDetails, that have a parent-child relationship by OrderId. I want to be able to work sequentually on each row in Orders and in OrderDetails in the following manner: ...
Score Good way to do lookups
BobRoyAce - 6 Jun 2006 5:42 PM - 5 messages
I want to have a a set of "records" (i.e. would have used a Recordset in the VB6 world) that contains a list of say 500 short string values to lookup and then 500 short strings to replace them with when found. ...
Score merge not working
NewsgroupCNHS - 6 Jun 2006 5:42 PM - 1 message
I'm trying to handle concurrency updating errors in my app - vb.net 2003, ado.net 1.1. I have a datatable with the data the user pulled and then changed ("dtMain") and another that I filled after the updates failed, with the most current ...
Score AutoIncrement and MultiStep OLE DB
MattHHDE - 6 Jun 2006 3:36 PM - 1 message
Hello   this error starts to really go o nmy nerves. I Searched the i net but found no solution for it. Maybe you can help.   My problem is, that i want to convert an Access-DB into a SQL-Server DB (i ...
Score Migration from ADO to ADO.Net with SqlClient
John Austin - 6 Jun 2006 3:34 PM - 2 messages
I am trying to get to terms with the use of updating through a data adaptor in VS 2005. The application allows the user to create forms and add fields and tables to the database and so the code has to be generic. ...
Score Oracle- and ODBC Provider missing in Visual Studio Express 2005
Sascha - 6 Jun 2006 9:59 AM - 2 messages
Hello, I have Visual C# Express 2005 and Oracle 10g installed. After some problems with different versions of Oracle including a restoring of a system restore-point I now have the following problem: When I try to add a data source to my project I can only select Access-File via OLEDB or ...
Score SQL Migration - Varchar 8000 in SQL 2005
samnospam@nospam.nospam - 6 Jun 2006 6:26 AM - 2 messages
Hello, We have migrated a sql server 2000 database to sql server 2005, this was done through scripts (table, stored procedures and data). To access this database we are using an ASP.Net 2.0 application which uses the sqlhelper Aplication Block to connect to the database. ...
Score How to change encoding for XML Column
John - 5 Jun 2006 10:29 PM - 3 messages
I am updating an xml column in SQLServer 2005, but it always gives me an error "XML parsing: line 1, character 38, unable to switch the encoding" my csharp is like the following         cmd.Parameters.Add("@xml", SqlDbType.Xml); ...
Score Connection Pool Time Out
ed - 5 Jun 2006 9:48 PM - 5 messages
Hi all, I have the following scenario: App1: Asp.Net Application that shows reports from some SQL DB App2: Asp.Net WebService with two services exposed for clients, and a single “Checker” in the Application object that checks every some time (normally 2 ...
Score txn isolation level
Vikram Vamshi - 5 Jun 2006 9:21 PM - 1 message
Hi, Should the transaction isolation level persist across the reuse of a connection from the connection pool? From my experiment it does persist and I was not expecting it. I was under the impression that "sp_reset_connection" will tear down all the ...
Score VB.NET and SQL Server 2005 - Data locked when they should be. LOOK
Dominic Belley - 5 Jun 2006 8:25 PM - 2 messages
Hi, I have 2 ways of selecting data from my table "Membre". 1- By permit number (memNoPermis) 2- By lastname, firstname (memNom AND memPrenom) SAMPLE DATA: memNoPermis: 1 memNom: Walter memPrenom: Gregory memNoPermis: 2 memNom: Wick memPrenom: Timothee memNoPermis: 3 ...
Score How To Use Keyword DataDirectory For Database In Same Folder As Executable
clusardi2k - 5 Jun 2006 7:00 PM - 5 messages
Hello, With a fairly complete and detailed example, how do I use the DataDirectory keyword? What I ultimately want to do is place my database in the same folder as the executable and have my application find it there. Thank you, ...
Score DBTransaction question
chaz - 5 Jun 2006 7:00 PM - 4 messages
Hi, I have some code like this  :   DBTransaction =  DBConnection.BeginTransaction()   Assuming I don't book keep the return from this call , How do I 1)  determine if  there is a DBTransaction  pending on this DBConnection and ...
Score ExecuteNonQuery with error checking (or continue on error equiv)
Fiddelm3742 - 5 Jun 2006 2:40 PM - 4 messages
First off I'll explain why I need something similar to ContinueUpdateOnError feature that a data adapter has, and why I can't just use a data adapter.  Basically I'm updating a Large amount of data using BCP to copy the data to a ...
Score Tabeladapter with row_number() over...
yogee - 5 Jun 2006 9:34 AM - 7 messages
Hi Friends, I have created a tableadapter (using wizard of VS2005) with some SQL query statement. But I want to write SQL query such a way that it returns table with one more fields, i.e. Row number. I have tried this SQL query in SQL server 2005: ...
Score Binding to object datasource
Mule - 5 Jun 2006 9:30 AM - 1 message
I have created a project that contains a typed dataset. I have extended this dataset through partial classes an daab 2.0. I have created a datasource out of this project through the datasources wizard in a new winforms project , I have a dropped a binding source ...
Score OleDbCommand.Parameters.Add and 'IN' Comparator and MSAccess
mosscliffe - 5 Jun 2006 7:27 AM - 6 messages
I am using Visual Studio with a MS Access Database I just can not work out how to create my parameter for the following Select Fld1, Fld2 from myTable where Fld1 in (?) The value I wish to add to the parameter collection for Fld1 is '2, 3, ...
Score About Load-on-Demand ADO.NET skill.
ABC - 5 Jun 2006 6:15 AM - 1 message
I want to improve my C# ADO.NET skills.  I want to study how to handle Load-On-Demand and Paging Skills in C#.  Is there any information to study? ...
Score Two DataViews of the Same database Table but different columns
S Lemen - 5 Jun 2006 12:14 AM - 2 messages
Hi,    I'm new to ADO.Net and I want to DataViews containing different columns of the same database table.  Is it possible without creating 2 dataadpaters? Thank you, Scott ...
Score sql server 2005 crashes by sqlbulkcopy when the column size does not match
kamal - 4 Jun 2006 10:59 AM - 1 message
dear all, i am having this strange problem. What i have done is i load a datatable to the sql server 2005 using the sqlbulkcopy. when the column size of the destination table is less than the value of the mapped column of the datatable instead of ...
Next »