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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|