Contents

Posts in microsoft.public.dotnet.framework.adonet

 

Batch updates on generated TableAdapters throws In ...  Replies (1) 18 December 2007
Hi, I'm trying to write a data layer for to persist regularly occuring stats to a database using ADO.NET by collecting a few records then updating the database in batches. I've got a Dataset t...

 

TextBox bound to a numeric value does not allow nu ...  Replies (2) 18 December 2007
Hi, I have a textbox bounded thru a bindingsource to a dataset. In the dataset the bounded column allows nulls, but if i try to delete the value from the textbox and move the focus, the focus does...

 

Aggregate column uses defaultview?  Replies (3) 18 December 2007
Hi, I have two tables related to eachother, and one table has an expression-based column that states "SUM(Child.Price)". Am I able to adjust the child table's default view, and expect that the ...

 

UPDATE Statement without WHERE  Replies (9) 18 December 2007
I want to store some application-wide data in my database. The table that stores this will store the different data in each field, and there will only need to be one record. Since there will on...

 

Select statement after the sqldataadapter Update s ...  Replies (6) 17 December 2007
How can I modify the Select statement after the Update statement in sqldataadapter ADO 2.0? (add columns) -- Igor...

 

darryl lalonde  Replies (1) 16 December 2007
kjhj33 michael lalonde mike lalonde sudbury wanderer tax solutions 3665 Arista Way These test messages are purposely filled with inaccurate and misleading http://www.freewebs.com/wanderer...

 

Export a Table to XML from SQL Server  Replies (3) 16 December 2007
Is there a way to Export a Table to XML from SQL Server express ? Thanks for help. Sam...

 

MI5-Persecution: Why do you think MI5 are responsi ...  Replies (1) 16 December 2007
Why do you think MI5 are responsible? The question of who is ultimately responsible for this eight-year harassment is one which is very difficult to answer, as the persecutors have never clearly ...

 

MI5-Persecution: MI5 are Afraid to Admit Theyre Be ...  Replies (1) 16 December 2007
MI5 are Afraid to Admit They're Behind the Persecution MI5 have issued a formal denial of any involvement in my life to the Security Service Tribunal, as you might expect them to; but, more impor...

 

Dataset questions, vs2008  Replies (2) 16 December 2007
Hi 1. I am filling the dataset in my form load method as; Me.MyTableAdapter.Fill(Me.MyDataSet.Clients). What about the records that other users add to the database? Do I need to run the fil...

 

custom column in VS2008 DataSet  Replies (1) 16 December 2007
I am working on my first VS2008 project and using DataSet's, which I am not super familar with. I have a user table in the data set that has a first name and last name, I would like to add a comput...

 

Schema-Typed Dataset doesn't preserve nested table ...  Replies (1) 16 December 2007
Hello, I'm having trouble with schema-bound XML output from a dataset, in .NET 2.0. Here's an example bit of XML I'm trying to create using a dataset: Mr. Foo Foo Inc. ...

 

Creating wizard  Replies (1) 15 December 2007
Hi I need to create a wizard in my application. Are there any third party controls that provide some sort of framework to help write one? I just want to save some time if I can. Thanks Re...

 

Would you stop for a moment?!  Replies (1) 15 December 2007
Excuse me!! Would you stop for a moment?! O...man...Haven't you thought-one day- about yourself ? Who has made it? Have you seen a design which hasn't a designer ?! Have you seen a wonderful,deli...

 

Multiuser Embedded Database Recommendations?  Replies (6) 15 December 2007
I've finally decided to port a Win32 application written in Delphi to C#. The program used an embedded database (DBISAM) that handled multiple users well through file locking, and I'm looking for ...

 

michael lalonde  Replies (1) 14 December 2007
Davey Simmons has bad teeth. Why doesn't he brush? Michael Lalonde saw a movie made by an axe murderer in Tokalue Michael Lalonde went swimming with a baby boy in an icy cave and got locked in pr...

 

Way OT: What is it?  Replies (8) 14 December 2007
Hi I have received below from someone. .- .-. . | -.-- --- ..- | .- -. | .. -.. .. --- - | This has nothing to do with dot net but I thought a lot of intelligent people come here and may be...

 

Retreiving a DataItem in the GridView's RowCommand ...  Replies (1) 14 December 2007
I have a GridView with a ButtonField. In the RowCommand I need to use the value of one of the fields used in that row. I am having trouble doing this, so I would appreciate it if someone could hel...

 

Bug with namespaces in XSD.EXE /dataset (C#)  Replies (4) 13 December 2007
I have come across an issue with XSD.exe code generation (in /dataset mode, version 2.0.50727.1432), relating to namespaces. Specifically, certain types are not always consistently prefixed with glo...

 

How gets SQL-code from MS Accesss  Replies (1) 13 December 2007
How gets SQL-code from MS Accesss? http://www.alvas.net - Audio tools for C# and VB.Net developers + Christmas discount...

 

auto translate=false in ADO.NET 2.0  Replies (1) 13 December 2007
Hi All, I have a database with [SQL_Latin1_General_CP1_CI_AS] collation on Sql Server 2005, for this collation i have to use SQLOLEDB provider in my C# application because of character problems....

 

Switching Fill methods  Replies (1) 13 December 2007
Hello, I have a question: I have 2 dropdownlists and I'd like to cascade them. In the begining they show 2 different columns of the same table. Once one of them is picked I'd like to restrict the...

 

EDI Consultant -- REQUIREMENT !!!  Replies (1) 12 December 2007
Greetings, Hope u r in the best of Health and Spirits!!!!!!!!!! This is Naveen from CSI Consulting with regards to Job Opportunity for you. Position: EDI Consultant Location: San Diego, CA...

 

LDAP Administrator -- REQUIREMENT !!!!  Replies (2) 12 December 2007
Greetings, Hope u r in the best of Health and Spirits!!!!!!!!!! This is Naveen from CSI Consulting with regards to Job Opportunity for you. Position: Ldap Administrator Location: San Diego...

 

Automated execution of script from file  Replies (1) 12 December 2007
Is there a built-in method in ADO.NET for reading a T-SQL script from a file and executing it step-by-step as though it were in a stored procedure?...

 

Transform After WriteXml?  Replies (5) 12 December 2007
I have a DataTable with many rows. I use WriteXml to emit to an XmlWriter with an underlying StringWriter to put the final output into a string. I need to massage the XML output now. I don't know...

 

How to use Display Member and Value Member [ropert ...  Replies (1) 12 December 2007
Dear All I have department table which contain dept_id and dept_Name. On employee form in combo box i wont to select dept_Name in the combo box but i want dept_id should be saved to employees table...

 

Asynchronous Programming Model & ADO.NET  Replies (3) 11 December 2007
I'm trying to execute two queries on a database asynchronously by using the .NET 2.0 APM. I've created a test harness which executes two queries which take at least ten seconds each. Using the APM...

 

SQLDataAdapter Update method?  Replies (8) 11 December 2007
Hi, I have let's say, about 10,000 rows in a DataTable. I am looping with foreach on each row and need to update each and every row with new data. After updating, for each row I am calling My...

 

% wildcart problem  Replies (6) 11 December 2007
I am new to C# and using VS2008 and SQL 2005. For doing some exercises I have made the following code: string name = tstxtName.Text + "%"; this.taCountry.FillByN...

 

¤â¾÷²M³f¦U´Ú¦U«¬¸¹  Replies (1) 11 December 2007
¹q62893103°Ý»ù©ÎµoªÅ¥Õ¹q¶l¥h 3d@humaneyes.com »ù³æ....

 

Which books on 3.5 recommend?  Replies (1) 10 December 2007
Which books on 3.5 recommend? http://www.alvas.net - Audio tools for C# and VB.Net developers + Christmas discount...

 

SQL reference card  Replies (1) 9 December 2007
I am looking for a SQL reference quick card that a allow in one page to know the function list of the langage. Does anyone know that ? sam...

 

ReadXml() on typed dataset causes InvalidCastExcep ...  Replies (1) 7 December 2007
Using Microsoft Development Environment 2002 v7.0.9466. In a C# ASP .Net project, we have some typed datasets defined. (inherit from System.Data.DataSet) We call the ReadXml method of our type...

 

Simple Adapter.Update problem  Replies (6) 6 December 2007
Hi, I have a typed dataset that is based on a SQL view, so I have added a stored procedure to save the data (that the TableAdapater found and populated). However when I execute "Adapter.Update...

 

STOP CHINA OLYMPIC!!!!!!!!!!!!!!!!!!  Replies (1) 6 December 2007
http://stopnow100.webng.com/...

 

many to many relationship  Replies (7) 6 December 2007
Hi I am developing a Sql Server 2005 database and using ADO.Net to access it in VC++ 2005. Is there some way of defining many-to-many relationship between two tables(e.g. Experiment and SampPr...

 

How to identify invalid eecords when performing up ...  Replies (1) 6 December 2007
I added some rows in Data table say 1000 rows from which 10 rows are invalid and to perform update in batch, set UpdateBatchSize property of DataAdapter to 100 means 1000 rows will be updated in 1...

 

ReadXml() method: standard DataSet vs. typed Data ...  Replies (1) 6 December 2007
Using .Net Framework v1.1. I have found a couple of XML strings that cause an InvalidCastException when passed to the ReadXml() method of a typed dataset (XmlReadMode = InferSchema). If I pass t...

 

Getting the data bound to a Repeater  Replies (2) 6 December 2007
I am attempting to get the data that was bound to an item in a Repeater control for use in the ItemDataBound event. Here is the code I am using to attempt to retrieve the data: CType(e.Item.Dat...

 

Check if table has LOB columns  Replies (1) 6 December 2007
I need to check if a table in SQLServer 2005 is made up of one of the LOB columns :image, ntext, text, varchar(max), nvarchar(max), varbinary(max), and xml Currently I'm using SMO with code like ...

 

Checking if remote app is working  Replies (1) 6 December 2007
Hi I have an app installed at a client side which is critical and needs to run all the time. What is the mechanism I can use to check that the app is always working? Can I "ping" it someway perio...

 

Using a DataSet  Replies (1) 6 December 2007
Okay, so based on previous discussions, I got the message I'm better off using a DataSet over a DataReader object when I want a method to return that object to a caller. Now what? DataReader is...

 

Enumerate providers on System / Understanding prov ...  Replies (1) 6 December 2007
Hi ng, when I use ADO.NET 2.0 System.Data.Common.DbProviderFactories-Class to enumerate the providers it get: Odbc Data Provider OleDb Data Provider OracleClient Data Provider SqlClient Data Prov...

 

How to add new row to dataset's table feilds are b ...  Replies (3) 5 December 2007
I have written a small programm using vb.net. i used a dataset wich contain only one table. fields are bounded to table of dataset. I want to add new row in such a way that i call newrow function fi...

 

command timeout - SQL 2005 express - critical cust ...  Replies (4) 5 December 2007
we have a VB application that we updated on a customer's machine. The customer has SQL 2005 Express (they had MSDE and we had the same error so we upgraded to express ohpeing that would fix the issu...

 

URGENT: ConnectionString for SQLServer db  Replies (4) 5 December 2007
I developed my ASP.NET 2.0 web app using SQL Express. Now I'm moving it to production. On my web server I attached the SQL Express mdf database to a new SQL Server database. The (example) SQL...

 

empty dataSet  Replies (1) 4 December 2007
hello,when i try to insert a dataSet record into another database table, what i see in the table is null values. i have test this dataset and it contains 1 Row of record but when in perform insert...

 

How to read a BLOB from Oracle  Replies (2) 4 December 2007
Hello ng, I try to read a BLOB (HugeBlob) field from oracle 10g database. (dotnet-framework 1.1, 2.0) 1.) I have no chances to install / register third party DLLs because I don't have local adm...

 

Get back uniqueid?  Replies (10) 4 December 2007
Hi, I'm using VS2008, and the dataset designer to access my SQL Server 2005 DB. I can insert a row into a table and then call the adapter to update. No problem, except I want to get back the ID...