Developer Newsgroups: ADO.NET

SQL Server Application Roles

Jonathan Allen - 19 Nov 2005 10:12 PM - 6 messages

Is this the correct way to use application roles? Public Function GetDBConnection() As SqlConnection Dim oCon As New SqlConnection(myConnectionString) oCon.Open() Using oCmd As SqlCommand = oCon.CreateCommand oCmd.CommandText = "IF NOT User_NAME() = 'app_name' Exec ...

Problem Reading Image Data from SQL Server using ADO.NET

Chucker - 19 Nov 2005 8:16 PM - 3 messages

Hi Community, I think I can store Binary Data in SQL Server but when I try to retrieve it, I always only get one byte. I think I stored my Binary Data in SQL Server in a Colum of Type Image. At ...

DataBase Centric Applications - Best Approach

Mr Newbie - 19 Nov 2005 5:55 PM - 3 messages

I've just spent some considerable time putting together an application which works pretty much OK. The issue I have around design is mainly concerned with the Data Access layer. Yes, we can pull data modify it etc, but the code required to do so is not ...

Accept/Reject Cascading - DataSet

Mr Newbie - 19 Nov 2005 3:31 PM - 10 messages

DataSet Parent/Child + Relation. When you update the parent table, then after each row is updated in the db, the adapter will call AcceptChanges on that row, marking that row as unchanged. When AcceptRejectRule is set the Cascade, then AcceptChanges is ...

modify created connection string

Ian Burton - 19 Nov 2005 7:43 AM - 3 messages

apologies if this issue has been dealt with previously. I have tried to look for it, but no luck. In visual studio, the application takes care of the connection and most of the code, which I can go into and look at, but cannot change, because if I ...

Insert record using parameters

pjcraig - 19 Nov 2005 6:21 AM - 2 messages

This is driving me crazy! I have a form that a user will access from another form by selecting the item that they wish to view. When they open the new form, I pass through the id of the item they selected so ...

Transactions and Typed DataSets, Adapters (Visual Studio 2005)

Mike Smith - 19 Nov 2005 3:44 AM - 2 messages

I've seen several posts related to using transactions and typed datasets/adapters. Visual Studio 2005 has an excellent code generator for data adapters but at first glance it appears that there is no way to access the necessary properties for transaction management. ...

Copying DataRows to another DataTable

Nathan Sokalski - 19 Nov 2005 1:33 AM - 6 messages

I am writing an ASP.NET application in which I need to copy DataRows from one DataTable to another. When I use code such as the following: temprows = nodes.Select("state='PA'") temptable.Clear() For Each row As DataRow In temprows ...

INSERT from one database to another?

Vagabond Software - 18 Nov 2005 9:24 PM - 3 messages

INSERT INTO db2.dbo.myTable (id, person) SELECT id, person FROM db1.dbo.myTable WHERE id = 1 I'm trying to do this using an SqlTransaction. I am assigning the above SQL statement to the CommandText property of the SqlCommand object associated ...

Concurrency Checking - SQL Server Rowversion - Stored Procedures ASP.NET Command

Bari Allen - 18 Nov 2005 8:45 PM - 6 messages

I'm trying to test for concurrency, using a SQL Stored Procedure on a RowVersion (timestamp) Field. The vb code I'm using is as follows Dim cmd As New SqlCommand("ConcurrencyCheck", cn) Dim intID as integer = MyDataset.Tables("MyTable").Rows(0).Item("ID") ...

OLE DB Conection Dialog

Luis Arvayo - 18 Nov 2005 8:09 PM - 4 messages

Hi, In my app, I need to allow to end user to choose the conection parameters for a SQL Database or Access database, then I need to show the same OLE DB conection dialog used by Microsoft. How to do that ? ...

Problem with wrong data in dataset using SQLDataAdapter.fill

loralea - 18 Nov 2005 5:53 PM - 1 message

We are experiencing an intermittent problem with our ASP.NET application. When using the SQLDataAdapter to fill a dataset, the dataset is sometimes being filled with the wrong data. It appears to be data from different threads. For example, when retrieving a product ...

RowState applied to whole table?!

rossu - 18 Nov 2005 5:16 PM - 3 messages

I have a datagrid and a bunch of validation routines that fire on column and row changing events. I was amazed to discover that when I added a new row the rowstate for every row in the table had changed to "Added". This caused ...

Referencing field value in a dataset

Phenom - 18 Nov 2005 5:12 PM - 4 messages

I'm trying to pull a specific piece of data from a dataset. In old asp, it would have been something like: rst("fieldname") - rst being the name of my recordset. How can I do this with a dataset? I've tried several things and can't find a way to check the value of a ...

How to copy an Access database using ADO.NET and C#???

Jon S via DotNetMonster.com - 18 Nov 2005 4:54 PM - 2 messages

Hi all, I have an Access '97 database called "dbHLS", inside this database I have a table called "tbHLS". I would like to copy the table tbHLS from within the dbHLS.mdb to an Access 2002 database called "dbTarget". Obviously as I'm ...

Adding checkbox to datagrid headers

Victor Heijke - 18 Nov 2005 4:34 PM - 4 messages

Can anyone help me with this. I have a datagrid on a page which is used to show different views from SQL-Server. With autogenerate columns, this works fine for me. But now I want a checkbox before every caption in the header. With this checkbox I'm goint to determine ...

enforcing constraints

rossu - 18 Nov 2005 4:21 PM - 2 messages

As far as I can tell constraints like uniqueness are only enforced at the update event. It seems more sensible to enforce them at the row or column change event, i.e. as soon as the person inputing the info makes the mistake. ...

How to control root node name for the DataTable.WriteXML method ca

Yitzhak - 18 Nov 2005 4:18 PM - 3 messages

I am trying to leverage ADO.NET 2.0 DataTable WriteXML method and serialize datatable as an XML file.. dataTable.WriteXml(xmlFile) Unfortunately, root node of the output file is always DocumentElement. Is there way to control the name of the root node for the XML output? ...

How to control root node name for the DataTable.WriteXML method

Yitzhak - 18 Nov 2005 2:31 PM - 1 message

I am trying to leverage ADO.NET 2.0 DataTable WriteXML method and serialize datatable as an XML file.. dataTable.WriteXml(xmlFile) Unfortunately, root node of the output file is always DocumentElement. Is there way to control the name of the root node for the XML output? ...

Using the column of a datatable as a paramter for a command object

Ian Frawley - 18 Nov 2005 10:14 AM - 1 message

Hi everyone, I have a Strongly typed DataSet one of the datatables within it has data in it. I have a stored procedure that expects a parameter that returns data that also has got to go into the same datatable. Is it possible to bind one ...

How to Fill Dataset with results from sproc with multiple selects

DJ - 18 Nov 2005 9:46 AM - 5 messages

Heres the situation: 1 stored procedure 2 select statements into 1 Dataset I can load the first set of results into a table, but how do I push to the results of the second select statement and load it into the dataset as well ...

Get return values from a stored proc inside a stored proc

Calvin KD - 18 Nov 2005 6:37 AM - 3 messages

Hi everyone, Can someone show me how to obtain values returned from a called stored proc inside a calling stored proc. For example: StoredProc1 ======== CREATE PROCEDURE StoredProc1(@keyID Int) AS SELECT value1, value2, value3 FROM Table1 WHERE id = @keyID ...

ADO.NET 2.0 TransactionScope object question: across business obje

BF - 17 Nov 2005 11:15 PM - 9 messages

I am new to .NET Framework 2.0. I need to make my application transactional on the business objects level. Which means, I have a controler class to create and call several business objects. These business objects will call data access objects and update some database tables. I need to make the whole ...

cannot connect to oracle with VS 2003 and oracle Plugin

Elhanan - 17 Nov 2005 6:58 PM - 4 messages

hi.. i downloaded oracle's Dotnet Developer pack for dotnet studio not i get add connection window, i specify in the datasource my database name,and in the user/password, etc.. when i try to connect i get ora-12154, what am i missing? ...

how to obtain rowversion columns from a table

Thierry - 17 Nov 2005 6:17 PM - 2 messages

hi is anyone know how can test if a datacolumn is a rowversion column ? is ther anything same as primarykey property ? thanks Thierry ...

DataTable.PrimaryKeys returns nothing from Oracle

sanchisudhir - 17 Nov 2005 6:06 PM - 1 message

Hi, I am not sure if this is the right place to post this. But here i go. I am trying to fill a datatable from oracle with the primary key & constraints info. But what ever i try the PrimaryKeys array is always ...

Passing connection or dataset to a User Control

Paul - 17 Nov 2005 2:58 PM - 4 messages

Could anyone provide a code example of passing an open oledbconnection or a dataset to a User Control? ...

Uploading images in SQL

B - 17 Nov 2005 10:18 AM - 5 messages

Hi, How can I store images into my DB using VWD Express 2005 in VB.NET ? Users can update/insert/delete text, but I would like to give the possibility to update/insert/delete images as well. Can someone help me? ...

DataColumnChanging Combobox

Giovanni - 17 Nov 2005 6:38 AM - 2 messages

Hi All, I have a problem with the ColumnChanging event: (VS 2005 BETA 2) The ColumnChanging event seems to fire correctly for textbox controls, but for some reason, a databound combobox does not raise the event properly. ...

Slow form load when Databinding a Winform

Vincent Dalton - 17 Nov 2005 3:23 AM - 3 messages

Hi all, I am using ODP for .Net to build a multi-table dataset. The problem I am running into is when I load the ZIP code table (42,741 records) into the dataset and databind it to a combobox. ...

SQL tables question

Neo Geshel - 17 Nov 2005 1:00 AM - 12 messages

I am looking to improve redundancy in a database. If I have several different tables having identical child tables (design, not data) for holding images, is it possible to have all these different tables reference a single common child table to hold their images? If so, how ...

InRowChangingEventException from DataSet.AcceptChanges

Michael Freidgeim - 17 Nov 2005 12:21 AM - 1 message

One of my customers received a few InRowChangingEventExceptions : System.Data.InRowChangingEventException: Cannot call EndEdit inside an OnRowChanging event. at System.Data.DataRow.EndEdit() at System.Data.DataTable.AcceptChanges() at System.Data.DataSet.AcceptChanges() This is not reproducible error - it is reported only one day for this ...

Alternative to using DSN to connect to database

MDFS - 16 Nov 2005 10:40 PM - 14 messages

VS 2003 question I know that this question has been asked alot but I have seen no direct answer to it as yet. From control panel it is possible to specify the connection parameters for a database. Then from code simply request the DSN and the connection manager ...

concurrent transactions

Trapulo - 16 Nov 2005 10:09 PM - 7 messages

I need to define a transaction that: 1 - read a value from a row (a number) 2 - updates this value (decrease or increase it) I've a lot of concurrent thread that run this transaction. What is the right ADO transaction settings/pattern to have this goal with best scalability? ...

removing a connection to a sql server database.

Chris - 16 Nov 2005 9:53 PM - 2 messages

Hi, I posted this in the sql forum but I think this place is more appropriate. I've written a vb.net windows appication that allows a user to run DTS packages on a remote SQL 2000 Server. The program runs the DTS packages in a sequence. ...

Connecting to SQL 7 using Visual Studio 2005

YourBeliefs - 16 Nov 2005 9:41 PM - 2 messages

I'm writing a C# Form Application that returns sets of data from SQL Servers. I want to use the cool data connection interfaces that VS 2005 has, but I get the message that I need to use 2000 or 2005 server instead. Is there another ...

OdbcConnection problems

Maileen - 16 Nov 2005 9:11 PM - 1 message

Hi, I use OdbcConnection component under VB.net 2005. When i do a simple test connection, everything works perfect under debug mode. But when i try to create database via this OdbcConnection component. VB informs freezes and after a time period (quite similar as timeout), my ...

ConnectionString for comma-delimited file

FireStarter - 16 Nov 2005 7:28 PM - 5 messages

Is there a way to connect through an OleDBConnection to a comma-delimited file? Then I could read records through a DataReader. I was thinking it could be done through the ExtendedProperties, but I cannot find the right value for it (I would probably need to specify ...

Avoiding errors due to bad email addresses

Nathan Sokalski - 16 Nov 2005 7:26 PM - 2 messages

I am making an application that will be used to send an email message to all members in a certain group (such as maybe all exec board, or all IT, or all secretaries, etc.). However, as we all know the may occasionally be a ...

.Net CLR Data - Performance Counter Problem

albertly - 16 Nov 2005 7:21 PM - 2 messages

I want to check connection pooling by using ".NET CLR Data->SQLClient: Current # pooled..." But I see <No Instances>. Sure I have open instance of SQLConnection. I run Framework 2.0 on Win 2003 PDC. Thanks in advance. ...

Books?

roy_ware - 16 Nov 2005 5:27 PM - 1 message

I want to use VB.Net (2003, I think) to connect to an Access 2000 database that includes several tables, queries, etc. Some of it can be handled through DataGrids, but a great portion has to be handled programmatically, ...

kerberos logon failure from large query

Lyners - 16 Nov 2005 4:41 PM - 1 message

We have an ASP.NET application that builds a query based on user criteria/choices. We are experiencing a problem on our server, when we submit a query that takes a short amount of time, the query works, if the query ...

DataBinding problem - CurrencyManager Position is always equals to -1

John Yung - 16 Nov 2005 3:51 PM - 3 messages

Hi, My program binds several controls on a WinForm to a Data Table via CurrencyManager. Example: txtComment.DataBindings.Add("Text", _currentDS.WithholdingTax, "Comment"); txtComment.DataBindings[0].Parse += new ConvertEventHandler(frmMain_Parse); .... _cmCurrentRecord = (CurrencyManager)this.BindingContext[_currentDS.WithholdingTax]; ...

Invalid Parameter when retreiving image

Glen - 16 Nov 2005 3:23 PM - 5 messages

I have a datatable in SQL2005 that stores images. I am able to write the image data to the row (image type) and it looks correct (afaik). My problem comes when trying to retreive the image and display it as a ...

Need Store Procedure Help in ADO.NET 2.0 badly!

David Hearn - 16 Nov 2005 3:03 PM - 3 messages

I have two stored procs that I need to call in an ASP.NET 2.0 application that I am writing. One has two input parameters that need to be sent and it will return another. The other one also has two inout parameters and I need ...

insertion and retrieval of NTEXT string into database using c#.net

kiran.karanam - 16 Nov 2005 2:39 PM - 1 message

Hi , I have a problem in writing a string into data base which has ntext data. it is not giving any errors as well as not inserting the string. it is working fine , if the string length is withing 898 characters.. ...

easy way to manipulate data for view?

Cen - 16 Nov 2005 10:18 AM - 2 messages

Hi, say i have 3 columns in a table in my dB: Col 1: somenumber (int) Col 2: id (int) Col 3: description (varchar(30)) i want to retrieve rows from the dB, bind it to a control but want to ...