| Groups | Blog | Home |
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 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 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 December 2007 January 2008 February 2008 March 2008 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Constraint Problem Posted by Jim Heavey at 10/8/2003 10:16:51 PM Hello, I have been told if I being down a SQL 2000 table, the constraints are
NOT automatically brought down when you use a DataAdapter. Is that true?
In reading about the method for the DataAdapter called "FillSchema", it
indicates that it will the primary key constraint are loaded if one of ...more >>
DataView.Find error: Expecting 2 value(s) for the key being indexed, but received 1 value(s). Posted by benj NO[at]SPAM theinsiders.com at 10/8/2003 6:36:25 PM Hello all,
I've searched the forum for this error, but there are only two posts
on the topic. We are seeing something very strange happening. We
have a DataView with a Sort property specified to a two column
expression:
DataView dv = new DataView( sourcetable );
dv.Sort = "ContentTypeId,...more >>
Single element in a DataSet Posted by Stephen at 10/8/2003 5:42:49 PM OK, I have filled a DataSet with an SqlDataAdapter and I just want the data
in one column of one row. How can I do this since the following gives me
the infamous 'Object reference not set to an instance of an object' error:
strng = datset.Tables("Users").Rows(0).Item("Users").ToString()
My tabl...more >>
DataSet connected to DataGrid crashes my app? Posted by John at 10/8/2003 5:21:56 PM Hi,
I have a strongly typed dataset that I put data into that I receive
asynchronously via a socket connection.
The app works fine until I set dataGrid.DataSource = myDataSet. The app
crashes will a NullException inside Application.Run().
Could I be adding data to the DataSet incorrectly?...more >>
using application role problem Posted by Alberto at 10/8/2003 4:44:30 PM This is my code:
Dim miacnn As New SqlClient.SqlConnection("data source=<name server>;initial
catalog=<database>;persist security info=False;user
id=<userid>;password=<pwd>r;workstation id=DENTE;packet size=4096")
Dim miacmd As New SqlClient.SqlCommand("", miacnn)
Dim miord As SqlClient.Sql...more >>
concurrency issues (on aspx page in vb) Posted by Brian Henry at 10/8/2003 4:43:51 PM I have a asp page which uses ado.net to access a access database, and when
two people try to retrieve information from a page that is generated from
the access database, i get the you cant do this the database's state=open
error page... how do i get around this? there will be a lot of users on th...more >>
RowFilter and Filtered Records Posted by Scott Carter at 10/8/2003 4:32:08 PM I have a DataTable that I'm applying a filter to using
DataTable.DefaultView.RowFilter. After this when I look at
DataTable.DefaultView.Count, I get the correct count for the filtered
records. The problem is when I start iterating through
DataTable.DefaultView.DataViewManager.DataSet.Tables[0], ...more >>
XML and Datagrids Posted by Kevin at 10/8/2003 4:30:13 PM I want to be able to load a xml file into a datagrid on a form. From this I
want a user to be able to edit any field in the datagrid and then write
those changes back to specific elements in another xml file.
I have been able to read an xml file into the datagrid...this is no problem.
I am ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
REF Cursor returned across db link? Posted by mhousema NO[at]SPAM ix.netcom.com at 10/8/2003 3:25:21 PM All,
I've created a synonym that points to a package over a database link
like so:
CREATE SYNONYM API_MYLINK FOR USER.CSAPI_V2@INSTANCE.DOMAIN.COM
I've granted execute like so:
grant execute on CSAPI_V2 to scott;
When I attach to the database in C# using ODP.NET and attempt to
dispatch ...more >>
Access db to ado.net data type conversions? Posted by Brian Henry at 10/8/2003 2:10:34 PM is there info about data type conversions between access to ado.net? I have
tried a lot of the ones that say oledb data types should work for and get a
lot of "data type mismatch" errors using them.. is there a sheet somewhere
or a refrence for them? all i really need to know is
Access ...more >>
OleDb Error Posted by Ann Marinas at 10/8/2003 1:16:19 PM Hi all!
I'm developing an application that imports a CSV file then stores the
imported data to an XML file through a dataset and an Access database. I've
used the connection and data adapter objects. I don't have any problems in
saving the imported data in a dataset and xml file, but whenever ...more >>
Connection String question Posted by jean_stax NO[at]SPAM hotmail.com at 10/8/2003 12:49:29 PM Hi !
I am trying to connect to sample Northwind MSDE database. I installed
it in default location (under Program Files/Microsoft SQL).
The following connection string works Ok:
String connString = "DATABASE=northwind;INTEGRATED
SECURITY=sspi;SERVER=(local)\\NetSDK;";
Whereas the followin...more >>
Juction tables Posted by Bob Day at 10/8/2003 12:37:45 PM Using VS 2003, VB.net, SQL MSDE
Doing my first junction table in Server Explorer, Database diagrams, and
having the following error message below on one of the relations. I am
following the instructions exactly, so I am not sure what the problem is.
3 tables in a telephony application:
Tab...more >>
SQLCE DataAdapter Update with Identity field Posted by PeterB at 10/8/2003 11:47:14 AM Hi!
I'm using SQLCE on a pocket pc and I have a database table with an =
identity field. I use a sqlcedataadapter to fill, insert, delete etc. a =
dataset datatable. I've read that I need to take some extra steps to =
retrieve the incremented identity value when performing an insert.
The ma...more >>
SQL Select/Update Concurrency Posted by Clement at 10/8/2003 11:30:03 AM Hi,
need urgent help from the expert out there. i was developing a asp.net using
vb code. i had create a web service that will use threading to process the
web request from the client and store the details into the sql database by
SELECT / UPDATE the running number in one of the tables (Number C...more >>
What's Inside a DataRelation? Posted by Mathew Weaver at 10/8/2003 10:42:59 AM Does anyone know what data structure and/or method a DataRelation provides
to implement DataRow.GetParentRow() and DataRow.GetChildRows()?
Doing some testing, the DataRow.GetParentRow() method is much faster than
using DataTable.Select() on the parent table to find the parent row. And
DataRow...more >>
How to Tell if a SqlConnection has a Open SqlDataReader Posted by Gary van der Merwe at 10/8/2003 9:44:30 AM Hi
How do I tell if a SqlConnection has a open datareader. If I try to do a new
ExecuteReader, a exception gets thrown if there is a open reader. I want to
be able to tell if there is an open datareader before I do the
executeReader.
If I break and do a watch on the SqlConnection , there is...more >>
Data Access Application Block for Oracle? Posted by Derrick Morin at 10/8/2003 9:38:49 AM Has anyone attempted to write a Data Access Application Block that uses
ODP.NET?
...more >>
Problem with null-value and Dataset Posted by Flare at 10/8/2003 9:33:12 AM Hey
Im selecting data from a view trough a dataadapter. I then Fill a Dataset
with the data. But when a field is null in the DB is just not represente in
my DataSet.! This is a huge problem, when i have to sned my updates in my
DataSet to the Database (a stored procedure).
Is there a way to...more >>
Problem with Updating Related Tables Posted by csim NO[at]SPAM irvingtool.com at 10/8/2003 9:21:37 AM I've got an app in C# using SQL as my data provider and I'm trying to
add information into 3 tables where the first is the parent, the
second is it's child and the third is a child to the second table. I
posted a while back asking how to update when they are related in SQL.
I was given three e...more >>
Command Parameters Posted by Jim Heavey at 10/8/2003 9:09:38 AM When calling a stored procedure and building the SqlParameter object, Is it
required to specify the data type of the parameter (String, Integer, etc.)?
When would in not be required?
...more >>
Simple SQL2000 update query w/ parameters not working with SqlCommand Posted by nadeemg NO[at]SPAM comcast.net at 10/8/2003 9:04:10 AM Hi,
I have a very simple SQL query I'm trying to run against SQL Server
2000. Here is the code:
Cmd.CommandText = "update Table set Field=@Field where RecID=@RecID";
Cmd.Parameters.Add("Field", SqlDbType.Bit);
Cmd.Parameters.Add("RecID", SqlDbType.Int);
Cmd.Parameters["Field"].Value = 0;
...more >>
Link table DataRelation Posted by Murray Foxcroft at 10/8/2003 8:18:08 AM Hi all,
This one has me stonked. I have 3 tables.
For simplification, I will abstract the table names.
I have tables A, B and AB
They ar related, AB having fk's to pkA and pkB.
How the heck do I populate a dataset with these tables and their data. At
the very best, I can get 2 of 3 the...more >>
DataFormatString Posted by Jim Heavey at 10/8/2003 6:38:01 AM Hello I am trying to use the "DataFormatString" property of the dataGrid
"BoundColumn".
I am attempting to format a date, I am using the following expression:
DataFormatString="{0: mm/dd/yyyy}"
The month field show "00" instead of "01", why?
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |