|
|
|
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 |
How to clear old data from a DataGridView and a DataSet? Posted by David Mayerovitch at 12/31/2006 12:59:30 AM As an exercise in learning Visual Basic 2005, I am putting together a simple
XML editor.
I place on the form the objects DataGridView1 and DataSet1.
' Read an XML file into DataSet1:
DataSet1.ReadXml("BIRDS.XML")
' Bind the DataGridView to the DataSet:
DataGridView1.DataSource = DataSet1...more >>
Problem while running vb.net application on vista Posted by sonali_reddy123 NO[at]SPAM yahoo.com at 12/20/2006 3:01:32 AM Hi all,
I have encountered a problem on running my vb.net application on vista.
The problem occcurs while writing the data to xml which I create in my
application path.
It fails to modify the xml and gives error as failed to write the data
to xml.
Same scenario works on other PC's who are ...more >>
Updating database in a loop Posted by fniles at 12/13/2006 4:21:04 PM I am using VB.NET 2003, SQL 2000, and SqlDataAdapter.
For every record in tblA where colB = 'abc', I want to update the value in
colA.
In VB6, using ADO I can loop thru the recordset,set the values of colA and
call the Update method.
How can I do this in VB.NET and SqlDataAdapter ? Thank you....more >>
Read Method Posted by fniles at 12/13/2006 2:53:29 PM For OLEDBDataAdapter and SQLDataAdapter, is there a Read method like in
OleDbDataReader or SQLDataReader, so that I can loop like the following:
DO WHILE RS.READ
:
LOOP
Thanks.
...more >>
DataGrid: New Row is not inserted into the database Posted by bestage at 12/13/2006 2:14:26 PM I am still a beginner on VB.NET programming.
Following scenario: I am writing a data centric windows application.
The forms contains DataGridView:
1) Products table - all data comes from one table - all the
modifications are updated and the new rows are inserted. (For this
purpose I program...more >>
There is already an open DataReader associated with this Connection which must be closed first Posted by fniles at 12/13/2006 11:57:06 AM I am using VB.NET 2003, SQL 2000, and SqlDataReader.
As I read data from tblA, I want to populate tblB. I use SQLDataReader for
both tables. I do not use thread.
When I ExecuteReader on tblB, I get the error "There is already an open
DataReader associated with this Connection which must be clo...more >>
Creating Select query for TableADapter not working Posted by mike11d11 at 12/12/2006 8:49:50 PM Right now I'm filling my dataset by adding a query to my tableadapter
and filling by a specific field value. I would also like to come up
with some way to replace the Specific Field "Desk" in my code and place
a variable in there that can be replaced with anything.
Select * from DataTable Whe...more >>
Need help with creating an Array Posted by mike11d11 at 12/11/2006 5:55:54 PM Can someone tell me what is wrong with this code. I'm trying to add
values to my array with data from a dataset that matches the criteria
that I want.
Dim actarray() As String 'Dim actarray(Me.DataSet.WorkList.Rows.Count -
1) As String
Dim i As Integer
Dim n As Integer
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Has anyone had any luck in creating a strongly typed dataset in visual basic 2005 express? Posted by C a r l o s A n t o n i o at 12/11/2006 2:17:11 PM Hello all,
I've seen this ASP.NET tutorial: "Creating a data access layer". It worked
prefectly well in asp.net and vb.net 2005. Now, i want to do the same with
VB 2005 Express Edition, but connected to an Oracle Database.
Can this be done?
Thanks a lot.
...more >>
Connecting to SQL Server from VB.NET 2005 Express Posted by Mirko Vucicevic at 12/10/2006 12:00:00 AM VB.NET 2005 Express is letting me create a connection string via selecting
an .mdf file.
I can't find a way to specify a server name / database that I want to
connect to.
Any help?
...more >>
dumb question- getting datagrid contents of current row Posted by Keith R at 12/9/2006 8:48:34 PM VB.net express, SQL express...
When I want to change the value of Clip_Exclude, the following works:
Me.MonkeyMainDataGridView.CurrentRow.Cells.Item("Clip_Exclude").Value = 1
However, when I want to retrieve the value from another column, the
following returns a "Column named Clip_FilePath ...more >>
Newbie needs help- parent and child datagrid views Posted by Keith R at 12/9/2006 7:01:39 PM Ok, I've been looking at all the properties (property window) and reading
the help file, and playing with different settings, but either I'm missing
something easy, or this isn't just a simple setting...
I have two datagridviews on my winform (vb.net 2005 express, SQL express).
They represe...more >>
Some Dataset advice please Posted by Vayse at 12/8/2006 5:14:27 PM Hi
I have a report in a report viewer control, based on Clients dataset. The
fields are like this
ClientName
ClientID
LastYearPremium
RenewalDate
My report would display all renewals due in a particulat month, say Jan
2007. Works fine.
These clients pay an annual premium, and some pay i...more >>
Max Pool Size question Posted by fniles at 12/5/2006 10:12:21 AM When using connection pooling, I understand the default Max Pool Size = 100.
What happens when to the 101 or more connection ? I mean, if 101st tries to
use the connection pooling, what happen to it ?
Will it get an error ?
Thank you.
...more >>
Mergin two tables where the primary key from both match? Posted by mike11d11 at 12/1/2006 3:56:56 PM I have a dataset with a account table and another table that contains
transactions for accounts in the account table. I create a crystal
report based off an inner join query of the two tables but takes way
too long to generate. I was told if I can get them into one table that
would fix my spee...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |