| 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 Why can't open the second DataReader ? Posted by jiatiejun at 10/26/2003 11:31:00 PM our C# program:
SqlCommand cmd = new SqlCommand();
SqlCommand cmd2 = new SqlCommand();
cmd.Connection = this.sqlConnection1;
cmd2.Connection = this.sqlConnection1;
cmd.CommandText = "select * from table1";
dr = cmd.ExecuteReader();
while(dr.Read())
{
cm...more >>
loading datagrid with calculated column Posted by karl at 10/26/2003 7:56:30 PM Hi
I've figured out how to add a calculated column to a datagrid and update
that column when a specific cell in the row changes, however I cannot figure
out how to populate the calclated column when the form loads or moves from
record to record
any help appreciated
Thanks
...more >>
ASP.NET using ADO.NET connection runtime error Posted by Matt at 10/26/2003 7:37:58 PM I created a simple ASP.NET using ADO.NET application to connect to SQL
Server. However, it produces the following run-time error. I think ASPNET is
the ASP.NET machine account created by VS.NET, and I already added ASPNET in
IIS Manager in directory security tab, and disable the checkbox of anony...more >>
NewRow method changes values in a reference to another row?! Posted by dwainew NO[at]SPAM cox.net at 10/26/2003 7:17:26 PM Using .NET Framework 1.1.
I do a select for a row, assign a strongly typed var to
reference/change the row thuought the rest of the code(OrigRow).
After various responses from the user that change some column values
of OrigRow, I begin a transaction and select(By PK) for the row again
to bri...more >>
newbie: bindingcontext prb Posted by Dan at 10/26/2003 9:15:53 AM I have created a C# app which allows editing of some database tables in a
form. The form has several controls (text boxes, list boxes, etc), bound to
a dataset with some tables into it; whenever the user requests a specific
record from a list, the connection is opened and data are retrieved for t...more >>
Reading from DB2 and Writing to SQL Server Posted by Dan M at 10/26/2003 8:52:58 AM I need to be able to query a DB2 database and append the results to a
similarly structured table in SQL Server 2000. What would be the best
method to achieve this? Could someone provide some specifics?
...more >>
Selecting from DataGrid and passing to... Posted by Markus at 10/26/2003 7:04:26 AM Here's my situation.
I have a data reader and datacommand (ASP.NET and SQL
database).
I have a search form which gives me the results in a data
grid. Usually 2 or 3 results (persons) with various
information (Name, Surname, Address...)
What I want to do is to select a row in that data...more >>
dataform wizard problems Posted by dennist NO[at]SPAM zahav.net.il at 10/26/2003 6:00:52 AM I've used the dataform wizard any number of times, and it
works on all but one kind of microsoft access database.
The style I use is text boxes for each column, with all
the buttons.
I just used the wizard on the customers table in the
northwind.mdb that comes with office 11. Worked fin...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Error in INSERT INTO statement Posted by dennist NO[at]SPAM zahav.net.il at 10/26/2003 4:55:01 AM When I run the simple code below I get the following
error message:
Type = System.Data.OleDb.OleDbException
Message = Syntax error in INSERT INTO statement
I've tweaked the insert to statement every which way.
All the other ways create earlier error messages. I've
compared this insert...more >>
HLP: Using 2 Filters for a Query in a FILL Posted by Mr. B at 10/26/2003 1:31:06 AM I'm having difficulties in Filtering an OleDbDataAdaptor... Currently I've a
single query for it such as the following:
SELECT Employee, ID, Period_End_Date, Units, [Date] FROM tblTimeEntry WHERE
(Employee LIKE ? + '%')
Simple enough. And I can do my FILL via something like:
Dim strUse...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |