Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
December 2007
January 2008
February 2008
March 2008
April 2008
all groups > dotnet datatools > december 2004

Primary Key not returning in dataset
Posted by JRLander at 12/30/2004 3:05:07 PM
I am populating a dataset with a simple SQL statement, I need to have the primary keys returned with the data. I am using the following code to get the data and the keys: dataAdapter.MissingSchemaAction = missingSchemaAction.AddWithKey dataAdapter.Fill(ds) When I use the following SQL st...more >>


Can no longer access data dynamically?
Posted by pearsons_11114 at 12/28/2004 1:49:01 PM
I can understand why MS decided to allow developers the option of making information known at design time (such as column info) available to the data access tools to improve performance. But in the process they seem to have removed the ability to access data dynamically. What if I don't know t...more >>

Database access tools suck!!
Posted by Relaxin at 12/28/2004 3:33:39 AM
It is just me or has MS created some of the worst ways to access and display data? You can use a DataSet, but if you want to sort or filter the data to must use a DataView which is created from a DataSet. But, if you sort by using the Grid (clicking the header) you can no longer use the ...more >>

Datagrid's row movement
Posted by Relaxin at 12/22/2004 9:55:35 PM
How can you get notification that the user has selected a different record within the grid, I don't see an event that will accomplish this? Thanks ...more >>

ASP Table doe not hold state
Posted by Fire-Dog at 12/22/2004 9:23:06 AM
I am trying to update an ASP table on a round trip or post back to the server. The problem is that the first time I post back to the server I add a row the table and the result is displayed to the client. On the second post back I am trying to add another row but that row only replaces the r...more >>

Paypal IPN
Posted by Nayana at 12/21/2004 4:16:06 PM
hai everyone, i'm working on a console based vb.net project where i have to post a bills to the costomers(buyers) via paypal. I read topics on paypal IPN, but it speaks of web to web transaction, but i want a console based transaction interacting with paypal IPN. If any one knows anything...more >>

DiffGrams equivalent for Oracle servers ??
Posted by lab at 12/16/2004 12:25:09 PM
Hi. I understand that the DiffGrams feature in ADO.Net allows you to specify an xml document and a mapping schema, and once these are declared, ADO.Net will update the required tables using the mapping schema to determine what field to update with the data that is contained in the XML docum...more >>

Controling the names of classes of typed DataSet
Posted by Paulo Morgado [MVP] at 12/12/2004 10:04:43 PM
Hi all Is it possible for this XSD: <?xml version="1.0" encoding="utf-8" ?> <xs:schema id="MyDataSet" elementFormDefault="qualified" attributeFormDefault="qualified" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:eleme...more >>



looking for a SQLSERVER class code generator
Posted by Andrew Baker at 12/7/2004 1:50:42 AM
I am loking for a class generator that will give me a vb.net class for accessing a sqlserver table. Something that gives an attribute for each column in the database, and insert and update ability. Does anyone have one they could recomend? TIA Andrew ...more >>

Problem with Microsoft Ole DB Provider for Oracle
Posted by jose.joao NO[at]SPAM cgd.pt at 12/7/2004 1:43:01 AM
Hi, I don't receive any error. What happens is when I try to open the connection in the "tree windown" to see the objects, appears the dialog box to ask the user/pass/SID(alias) and when I press the "connect" button nothing happens. The window don't disapear, it look like you wrong input, a...more >>

question about how to change query by sqlconnection
Posted by gary at 12/6/2004 7:38:03 PM
I made the following codes to get a table public static void GetTable(string sw) { SqlConnection con=new SqlConnection(connectionstring); con.Open(); SqlDataAdapter da=new SqlDataAdapter("select * from tablename where "+sw,con); DataSet ds=new DataSet(); da.Fill(ds,"new...more >>

Unicode Enabled
Posted by Sierra at 12/6/2004 6:59:22 PM
This is a multi-part message in MIME format. ------=_NextPart_000_002C_01C4DBC5.B2E726F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi guys=20 I want to know how to check if a particular database and its tables, = related scripts, stored ...more >>

Datagrid Question
Posted by ksedran at 12/6/2004 8:33:07 AM
Hello All, I am having a problem with a winform datagrid. I am trying to update an oracle table, but I need the original data from the "TID" cell if a user decides to change that cells data. Here's what I am currently trying: Dim cmd As New OracleCommand("UPDATE tablename SET TID = :TID W...more >>


DevelopmentNow Blog