| 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 DataColumn Size for Numbers?? Posted by john NO[at]SPAM likeamugg.com at 2/23/2004 9:22:11 PM Is there a way to test the size restriction of a number (int or decm)
on a dataset? I know that the DataColumn.MaxLength Property only
supports text fields. Is there anything that can be used just like
this property but applies to numbers?
Using Oracle 9i & ODP...more >>
Calling a stored procedure / package from Crystal Reports.NET Posted by james NO[at]SPAM roadhouse.com.au at 2/23/2004 9:10:03 PM Hello,
Does anyone have any experience or knowledge regarding calling a
stored procedure / package from Crystal Reports.NET? This damn
product is killing me!
Regards,
James Kent...more >>
sqldataadpater wizard code Posted by Mark Kurten at 2/23/2004 3:52:48 PM i used the sqldataadapter wizard to generate the following insert statement
"
("INSERT INTO Company(Code, Name, Address1, Address2, Address3, Address4,
BEGINDT, " & _
"BegCheck#, EndCheck#, CancelDate, InsType, STATE) VALUES (@Code, @Name,
@Address" & _
"1, @Address2, @Address3, @Address4,...more >>
ADO.NET a big resource eater! Posted by X-Men at 2/23/2004 3:49:20 PM I am new to ADO.NET and I used to progrram with ADO.
I just did a program which updates leadtime information. I just found out,
for every new row I added into the datatable, there will be 500k more memory
consumed by the program after I used sqlDataAdapter.Fill method to refresh
the dataset. Her...more >>
ADO.NET and Word XP (2002) Posted by Todd at 2/23/2004 2:51:08 PM Hi
Can anyone give me an example of setting a MS Word Mail Merge datasource to a DataTable. Is this even possible in 2002 or do I need to upgrade to 2003. Any assistance is very much appreciated
Todd...more >>
What is the simplest way to set up parameters? Posted by Rob Richardson at 2/23/2004 2:00:22 PM Greetings!
I am trying to figure out the easiest way to set up parameters for an insert
query. There are lots of overloads for the OleDbCommand.Parameters.Add()
method and lots more of them for the OleDbParameter constructor, and I'm
suffering from overload overload. I will be adding simple ...more >>
sqlint32 to integer... really? Posted by Paul S at 2/23/2004 12:39:32 PM I'm returning an integer from a sp in a SQL 2K database. The working VB.NET
code is:
Dim sequence As Integer = 0
' ADO.Net code
sequence = SqlInt32.op_Explicit(dr.GetSqlInt32(1)
'
Is there another way to convert an integer from the database to an integer
in .NET? Thanks.
...more >>
New Snapshot Isolation Level on Yukon Posted by carl.bruneau NO[at]SPAM giro-dot-ca.no-spam.invalid at 2/23/2004 11:34:27 AM Hello Everyone,
We want to take advantage of the new SNAPSHOT ISOLATION LEVEL that SQL
Server Yukon offers. This will allow readers not bloking
"modificators" and "modificators" not blocking readers. Just like
Oracle offers for a long time with their rollback segments.
The problem is that I...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Schema creation for BULK INSERT Posted by wisecoyote at 2/23/2004 11:21:06 AM I'm using WriteXmlSchema to create a schema from a dataset. The next step is to do a BULK INSERT into SQL SERVER 2000, but the XSD file needs the changes listed below to work correctly. Is there a better way to create a XSD for BULK INSERT? Or what is the best way to change and remove elements in th...more >>
Unique Value from a DataTable/DataSet Posted by Nevyn Twyll at 2/23/2004 11:18:52 AM If I'm working on C#/VB for ASP.NET, is there an easy way to get a list of
UNIQUE values from a particular column.
For example, I have a list of books, and I want to get a unique list of the
AuthorCode column for some other work, without going to the database. Is
there a way I can do that wit...more >>
ADOX Index Creation Problem Posted by localhost at 2/23/2004 10:59:13 AM
I am using ADOX to create databases and tables. I can create tables
and columns fine. I am having a problem with making indexes. I am
using MDAC 2.8 with ADOX and ADODB type libraries added as references
to my Visual Studio 2003 C# console app project.
ADOX.IndexClass newIndex = new ADOX....more >>
Data Adapter problems on nullable columns Posted by JezB at 2/23/2004 10:41:29 AM I have a dataset that I'm passing down to a data adapter which invokes
stored procedures to handle the inserts/updates/deletes. On an insert I have
some columns which are nullable, and on invoking the Insert procedure I'm
getting error
Procedure 'FlavourInsert' expects parameter '@UserID',...more >>
Joining 2 Tables from 2 Different Databases Posted by John Smith at 2/23/2004 10:40:31 AM How do I create a join between these two tables and populate it into a
datagrid? I am a newbie to ASP.NET and I need to figure out how to create a
JOIN between two tables which belong in 2 different databases. I am using
MS Access 2000 for both databases and my development application is Visual...more >>
ADO.Net JOIN Posted by Cliff Harris at 2/23/2004 10:22:30 AM I have two DataTables that I need to join together. I know that I can use a
datarelation to set up the relationship between the two tables and then use
GetChildRows() or GetParentRows() or GetParentRow() to get the related
row(s) based on the datarelation that I set up, but that sure seems like ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |