Developer Newsgroups: ADO.NET

Storing Connection String

John Stivenson - 30 Dec 2006 9:44 PM - 10 messages

I have Users table in my database which stores usernames, passwords and other information about users. When starting the application the user logs in providing username and password. This is why I want the connection string (including database username and ...

Connection string problems using hexadecimal characters

Stephen K - 28 Dec 2006 3:22 PM - 4 messages

I am using the SQL server client to connect from a Vb .net windows forms application to a SQL server 2000 database. The user passwords are scrambled usign an XOR function and they are converted to hex characters. Using VB 6 ...

Strongly typed datased (it's datatable) as singleton

Jirí Neuzil - 28 Dec 2006 3:04 PM - 2 messages

Hi, I have problem with implementing strongly typed dataset (with tableadapter) as singleton (A very large amount of data loaded at startup of winforms app, I need this data at numbers of forms, and I need to bind this dataset/datatable at designtime) . At first I realized implementing dataset ...

Connection TimeOut

Henrry Pires - 28 Dec 2006 11:21 AM - 5 messages

Good Day to all. I have a store procedure that makes many queries, use cursors and some other complicated calculations. If I run it on Management Studio it takes around 3 minutes and work fine. But when I run it from VB.Net it gives me connection ...

I need an advice...

Fabrizio Romano - 28 Dec 2006 10:28 AM - 27 messages

Hello, maybe I'm OT, but I don't know where else I can put this question. Say you have to write a program for a very small company (5 pc). They just need to store some data in a database which is on a server and they need to ...

SqlBulkCopy

Jitendra kumar - 28 Dec 2006 8:34 AM - 2 messages

what will happend if SqlBulkCopy violate constraints. and how i can solve this problem. ...

Tips for improving efficiency?

Ben R. - 28 Dec 2006 1:57 AM - 4 messages

Hi all, I'm soon to overhaul my asp.net 2.0's backend data source. My plans: -To implement a data access layer -To move from access to SQL Server 2005. I'm going to be implementing just about every provider that microsoft ships ...

Binding DateTimePicker

John Stivenson - 27 Dec 2006 10:06 AM - 5 messages

A DateTimePicker control on my form is bound to a datetime field in a DataTable. When inserting a new record the default value for DateTimePicker is today's date. However, unless the user changes this date it is not saved to database (NULL ...

Retrieving Schema info for connection

Terry Olsen - 27 Dec 2006 5:21 AM - 2 messages

I'm building a program to navigate through a database. The user chooses either ODBC or OleDb and provides a connection string. With OleDb I can get the database names from the connection. Is there a way I can do this with an ...

retrieving just one row based on the primary key

Fred Exley - 27 Dec 2006 3:15 AM - 9 messages

Is there a preferred way to obtain one row of data based on the PK? I can retrieve the record onto my C# app using a dataset or datareader, but then I have to loop thru this result set even though I know there will always be ...

Re: Datagrid Column Width

Evdokia - 27 Dec 2006 12:48 AM - 1 message

Who know smth more aboute 'alprazalam' ([link]) ...

DataSet.ReadXml(Stream, XmlReadMode) Issue

Todd - 26 Dec 2006 8:52 PM - 1 message

Hello, I have a dilemma it seems I cannot read a stream to a DataSet using DataSet.XmlRead(Stream, XmlReadMode.ReadSchema) everytime I try I get a {Root element is missing.} error. But if I save it to file same stream it ...

sql where question

MarkAurit - 26 Dec 2006 6:28 PM - 3 messages

Ive a char(1) column (lets call it Admin) that can be 'Y' or 'N'. In one of my queries I need to treat non-admins is those with Admin='N', and admins as those with (Admin='Y' or Admin='N'). Easy ...

SqlCommand.ExecuteReader returning nothing?

Dan A - 26 Dec 2006 5:20 PM - 6 messages

In a web application we have, we are doing a simple query (requesting 3 fields from a inner joing b/t 2 tables). This code is executed constantly, but once a week, the sqlcommand.ExecuteDataReader returns nothing. We return ...

Saving from a DataGrid on a DataTable.RowChanged Event

Thomas Corcoran - 25 Dec 2006 10:32 PM - 1 message

In Framework version 1.0, which my client is constrained for budgetary reasons to use, is it possible to save to an Access database a row in a DataGrid when the user navigates to the next row--as Access itself behaves? ...

Preparing test data with SQLCE - latest release RC1

Garry - 25 Dec 2006 3:26 PM - 2 messages

I want to prepare test data in SQLCE where the dataTables in the database are predefined. A VB.NET app I tried to use the DataSources facility in vs2005 IDE but cannot see how to input new datarows or edit existing rows. (The existing rows were from a ...

Adding rows to table from DataGridView

Adel Khalil - 25 Dec 2006 2:52 PM - 9 messages

hello, am in a bit of a problem.. wonder if anyone can help? I got two tables one is tblOrders and the other is tblDeletedOrders I'm handling the UserDeletingRow to insert the deleted row (order) into the tblDeletedOrders to sort out some kind archive or log. ...

Detecting Table Locks?

jfer - 24 Dec 2006 9:25 PM - 14 messages

Hi everyone, I'm creating a ASP.NET 2.0 web application utilizing sql server 2000 as a database. My problem revolves around multiuser acces with long running processes. Some of the pages in the application have long running processes against large tables in the database, lets say ...

Web Service max out at 20 SQL connections

Erin Loy - 24 Dec 2006 7:13 PM - 13 messages

I have been tasked with load testing our .NET 2.0 web service, which is really just wraps 1 or 2 very simple and light weight SQL queries. Under light load (less than 20 requests per second), everything works fine. Each ...

dataTable.Clear()

goldie11 - 24 Dec 2006 8:26 AM - 8 messages

Hi, I would like to remove all the rows of a DataTable - but not by using a loop through all the DataRows - but by using a single command. I tried - dataTable.Clear() which is supposed to remove all rows of the ...