| 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 Datasets keep dissappearing from my WinForms Posted by David Hearn at 12/31/2003 11:48:17 PM I am dragging my SQL Server table onto my Windows form to create my
connection and adapter. I then go an generate my dataset and save
everything. When I build, I keep getting compile errors and if I
switch to code view and come back into design view or if I close the
form and re-open it, my data...more >>
Encoding problem Posted by Calvin Lai at 12/31/2003 9:28:31 PM If my data in SQL server was stored from a web application with
requestEncoding set as iso8859-1. And now I want to change the data encoding
to big5, (or anything else), how could I do that? Thanks for all advice and
input.
Calvin
...more >>
Crystal reports on client? Posted by grawsha2000 NO[at]SPAM yahoo.com at 12/31/2003 9:27:49 PM Hi,
If I use (in development) connection object from design tools in
ToolBox to get data from db to crystal reports, how can I make
changes to server name and security options in runtime. That is, is
there an option during "packaging and deployment" where I can make
connection setting as pe...more >>
Interesting Problem with System.Data.SqlClient.SqlCommand.ExecuteXmlReader() Posted by Dylan Phillips at 12/31/2003 8:51:50 PM A strang error is occurring when I run the following code:
SqlConnection c =3D new SqlConnection();
c.ConnectionString =3D "Initial Catalog=3DNorthwind;user =
id=3Dsa;password=3Dkat1ie;Data Source=3Dserver";
c.Open();
SqlCommand command =3D c.CreateCommand();
command.CommandType =3D CommandT...more >>
Select Max value from DataTable Posted by John Xavier Smith at 12/31/2003 7:50:02 PM Is there a more optimal way than creating a new column as an expression? The
following code snippet works, I was hoping for a better alternative:
<DataTable>.Columns.Add("MaxIndentation", typeof(string),
"Max(indentation)");
MessageBox.Show(<DataTable>.Rows[0]["MaxIndentation"].ToString());
...more >>
OracleDateTime Posted by Cowboy (Gregory A. Beamer) at 12/31/2003 6:24:17 PM Anyone have any clue why invalid date casts fine into OracleDateTime.
DateTime dt = new DateTime(20004,14,45); // this
bombs
SqlDateTime dt = new SqlDateTime(20004,14,45); // this
bombs
OracleDateTime dt = new OracleDateTime (20004,14,45); // ...more >>
Why use Input Parameters? Posted by Michael at 12/31/2003 3:43:33 PM Coming from an ADO Background, I got by ok without using Parameters when I
executed SQL Statements. I would just dynamically create the sql statement,
inserting text between single quotes here and there, and send her off to the
server, and voila, It worked.
Now I'm learning ado.net, and many ...more >>
CDaoDatabase Class// get ref Posted by Julien at 12/31/2003 1:56:29 PM How do I set reference to a Foundation Class Library from
VB.net?
I'd like to get access to the CDaoDatabase Class...
Dose anyone know if I can even do it with VB.net
Small code snip would be cool... Remember VB code not C
Thanks
..
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Need Ado.Net XML C# Book Posted by Trey at 12/31/2003 1:39:35 PM Can someone recommend the best book that covers ADO.NET. I want good
coverage of XML use in ADO.NET and I would like the examples to be in C# (if
possible).
Thanks
...more >>
Returning Oracle Data Reader Posted by Anon at 12/31/2003 12:55:21 PM I have a method that returns OracleDataReader type. I am
having problems calling the method from Web Services.
Can the Oracle Data Provider for .NET be serialized? if
not what are my alternatives....more >>
GetChildRows() and DataRelation problem Posted by Claudiu Tomescu at 12/31/2003 12:49:27 PM Hi,
After hours of frustration digging for an answer I decided to post this
message concerning my GetChildRows and DataRelation problem.
What I'm trying to do is to use a DataSet to fetch data from 3 tables and
then using relations to navigate parent-child records.
First I created an XSD fi...more >>
Static Data Functions Posted by Nick P. at 12/31/2003 12:44:31 PM We use a Class that contains all static data calls to retrieve and
update our SQL Server. the retrieval methods have been very fast, but
sometimes the update functions get Verrrrrrrrrrrrrrrrry slow. We use a
Mutex to synch the calls so that only one user at a time has access to
the data that is ...more >>
DataGrid: Suspend/ResumeLayout (DataView manipulations)? Posted by alex n at 12/31/2003 11:22:32 AM hello.
i manipulate a dataview
(updating and thus filtering a large amount of rows)
and the datagrid bound to the dataview
slows down this process much by adjusting its scroll bars
and maybe trying to redraw itself.
ok, Suspend/ResumeLayout doesn't help.
grd.DataSource = null;
// updat...more >>
Confused about the DataRow object Posted by duane NO[at]SPAM roelands.org at 12/31/2003 10:35:02 AM I'm having a frustrating problem with some simple code. Isn't that
always the case? :)
Here's the code in question...
Public Sub GetAllEmployees()
Dim tbl As DataTable = EmpDataSet.Tables(0)
Dim Row As DataRow
Dim MyString As String
For Each Row In tbl.Rows
...more >>
continuous SqlCommand ExcuteNonQuery good idea? Posted by Daniel Bass at 12/31/2003 10:11:34 AM In the scenario where I have multiple entries (a couple of thousand on a
worst case) I'd like to add to a database via Stored Procedures, is it
proper procedure to:
- create a SqlCommand object for the insert
- add parameters etc to this sqlcom obj
- create a SqlConnection object to connect t...more >>
Understanding CommandBehavior.CloseConnection Posted by Michael at 12/31/2003 8:47:10 AM I'm trying to understand CommandBehavior.CloseConnection, used in this
context
conn.Open()
cmd = New SqlCommand(sql, conn)
rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
Is that the exact same as if I had done this?
conn.Open()
cmd = New SqlCommand(sql, conn)
rdr = cmd.Execut...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |