|
|
|
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 |
Saving a checkbox value from a gridview into a sqlserver 2005 database Posted by BenCoo at 2/28/2007 8:25:58 PM Hello,
In a gridview I've a checkbox (indicating a flag that is set or not). I fill
the gridview via the wizard from ado.net 2.0 that generates automaticly the
Insert, Update and Delete commands. I've also added the button Edit to the
grid that activate the Update- and cancelbuttons. When a...more >>
SqlDataReader SizeOf Posted by Kevin Humphreys at 2/26/2007 5:17:07 PM Hi,
Is it possible and if so how can I get the size of a Data Reader when it is
populated?
Thanks,
Kevin.
...more >>
VS2003 versus VS2005 data adapters: Auto-generated update commands generate parameter errors? Posted by DDon at 2/25/2007 3:18:36 PM Gents,
Been using 2003 for 4 years, and have several large Windows Forms based
project that I need to continue to develop with VS2005. I have imported one
of these projects, fixed some newly detected errors, and it appears to work
great in VS2005.
The problem I am having is updating Dat...more >>
Exception when updating/inserting to Access DB Posted by Mike at 2/24/2007 3:36:49 AM Hi all,
I have a form in VB.net (2005), which has a dataset, datasource,
bindingnavigator and an Access .mdb database.
I have a single table which contains a variety of data.
I have the dataset designed with the DataSet Designer, and I can preview and
add data perfectly through this.
...more >>
vb.net Posted by bose at 2/23/2007 12:01:33 AM can you send examle with datatable using datarow ...more >>
Replace in access queries Posted by Vayse at 2/20/2007 12:47:50 PM I wish to run a Replace against an Access database.
Here is a sample query, qryReplace, that works in Access:
UPDATE Clients SET Clients.TestText = Replace([ClientName],"i",2);
I try to run this through code:
Dim oleCommand As New OleDbCommand(stSQL, oleConnection)
ole...more >>
Reports advice needed Posted by Ivan Jericevich at 2/19/2007 12:52:36 AM I am using Visual Basic 2005 Express Edition and would like to print and
email reports. Does someone have any suggestions what I should best be
using, plain english please.
I've tried downloading Visual Studio 2005 Tools for Office 2003 but can only
find for Office 2007. Possibly this might ...more >>
Beginner question re. Configuring a data source Posted by Arlin at 2/17/2007 7:16:02 PM I'm a beginning programmer trying to learn my way around visual basic express
and ADO.Net. I'm currently working my way through Microsoft Press's ADO.NET
2.0 Step by Step book. I have using visual studio express and SQL server
express.
The first exercise in the book involves connecting to ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
VS2005: using IN ( list ) SQL construct in queries Posted by Steve Marshall at 2/15/2007 6:59:30 PM I have a situation where the user can select a variable number of
values, and I need to find records that match any of the values. It's
a perfect situation to use an SQL construct like
SELECT * FROM Table WHERE Column IN ( value1, value2, value3.... )
I would like to be able to build the li...more >>
sp_ expects parameter which was not supplied Posted by Usarian at 2/12/2007 3:53:17 PM Morning!
I keep getting Stored Procedure Expects Parameter which was not supplied.
I can execute the SP fine from a query tool and from another SP.
What am I doing wrong?
Dim conEPICS As IDbConnection = _EPICSconnection
conEPICS.Open()
Dim cmdExecuteSproc As IDbCommand = conEPICS.Cre...more >>
DataAdaptor with Query -> Table -> DBgridview -> Update Original Data ? Posted by Screaming Eagles 101 at 2/12/2007 10:34:20 AM Howdy,
using a query as "Select * from Mytable", then using a data adaptor in
GetDataTbl = New DataTable
Dim da As OdbcDataAdapter
da = New OdbcDataAdapter(strQuery, ConnectionString)
da.Fill(GetDataTbl)
I attach GetDataTbl to a DBGridView in the DataSource property.
(dbgv.Data...more >>
Password encryption and binding Posted by Earl at 2/10/2007 2:03:15 AM I'm adding password encryption to the Employees form. I have a
strongly-typed dataset being used as the datasource for the
EmployeesBindingSource, and the Employees table set as the datamember. All
controls on the form are bound to the EmployeesBindingSource. Except for the
password ...
I...more >>
Datareader and SQL server Help Posted by Patrick Hill at 2/8/2007 9:36:45 AM I'm new to Dot net and I have this little program that executes a stored
procedure using a datareader. I populated a combobox with some of the data
from the SP(a person's name). Now when the user selects something from the
combo box I want the rest of the data for that record to get populate...more >>
Connection Strings And Application Settings Nightmares Posted by Johnny Liner at 2/4/2007 8:10:39 PM Hello,
This problem is so complicated I dont even know were to begin to
explain it ... but here it goes.
Ilike using the databinding features that are built into VS 2005. It
saves me a ton of typing manually performing the same thing. However,
in order to use those features (the auto bindi...more >>
Simple SQL Server Insert Question Posted by Materialised at 2/1/2007 8:57:47 PM Hi Folks,
Just a quickie, I am inserting some records (individually) into a SQL
Server Table. I am wondering how can I detect primary key violations on
this data which I am inserting into the table.
My Insert code is as follows (VB.Net):
Public Function InsertNewUser(ByVal _ConnString A...more >>
Connecting to SQL Server with VB.NET 2003 Standard Posted by RG at 2/1/2007 10:28:02 AM Hello. I’ve been using VB.NET 2003 Standard Edition for over a year,
developing applications using Access databases.
I’ve a new requirement to build a system using SQL Server 2000 (which I’ve
used a lot in the past, but not with VB).
When I go into Server Explorer and right-click on...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |