Strongly Typed Dataset accessing query using 'IN'
Thu, 8 May 2008 06:58:07 -0700
This problem touches both SQL/Server and ADO.NET, and its solution could be
in either. A round of applause if you can provide the solution.
The goal:
Produce a stored procedure which accepts a string of options to be used in a
SELECT WHERE <a field> IN (<the string> ) statement, AND make the resulting
set ...
|
Excel 200 undo key
Wed, 7 May 2008 13:04:01 -0700
I've had to reload my micosoft 2000. I am unable to use the undo key or the
control x key to undo an error I posted. I've tried reloading it and it
still is not there. It works in Word. Any ideas
--
Jack ...
|
Excel and OleDbDataAdapter. How can i ignore blank columns.
Tue, 22 Apr 2008 01:07:26 -0700 (PDT)
Hi,
I have an application, that needs to import excel spreadsheets into a
database.
I am using an OleDBDataAdapter to load (fill) the data into a Dataset.
Occasionally, person sending us the file, will put the data starting
in column B, not column A. This fails our checks on column count.
(Also occasi ...
|
Dont read
Tue, 25 Mar 2008 11:55:22 +0100
Vendo coche de segunda mano, Seat ibiza, a? 2001 km
35000, Solo por 4500 euros.
[URL=http://www.anunciosgratis.de]Anuncios Gratis[/URL]
www.AnunciosGratis.de http://www.AnunciosGratis.de Anuncios
Gratis. ...
|
Running stored procedure - input parameter cannot be converted
Sun, 23 Mar 2008 19:37:17 -0700 (PDT)
Hello,
VS2005 - SQL Server 2005.
Running an SP from the server explorer window. The SP accepts two
parameters:
@s varchar(128) = NULL,
@b bit = 0
I cannot seem to set the bit value. I receive the error "Input
parameter cannot be converted". Ideas anyone? Can run it from SQL
Server without problem ...
|
DAO references / Access 2007
Wed, 27 Feb 2008 11:58:04 -0800
while using an Access 2007 .accdb file I can access the dao. object very
easily.
the following code in VBA works well :
Function getrecordcount(strTableName As String) As Long
Dim dbCurrent As DAO.Database
Set db = CurrentDb
Dim rstRecords As DAO.Recordset
Dim rstRecords2 As DAO.Recordset2
...
|
Table adapter timeout problme
Tue, 26 Feb 2008 11:57:48 -0800 (PST)
I have a table adapter with the following query
SELECT viewCoreCheckIn.TonerTypeKey, viewCoreCheckIn.PartNumber,
viewCoreCheckIn.MinCheckInQty, viewCoreCheckIn.MaxCheckInQty,
viewCoreCheckIn.StagingCurrentQty,
viewCoreCheckIn.PreInventoryQty,
COALESCE (- (viewCore ...
|
|
|
Creating own short cuts
Mon, 25 Feb 2008 07:04:01 -0800
Hi
How do I create an own short cuts? E.g. A short cut for my email adress.
Frida ...
|
TableAdapter.Fill Method
Thu, 21 Feb 2008 14:55:02 -0800
I was successfully calling a TableAdapter.Fill command in code which was tied
to an SQL stored procedure. I altered the stored procedure in SQL Server to
include two additional parameters and it stopped working in code. The stored
procedure works when previewing it in the dataset designer. But the line of
...
|
Visual Studio 2005 Standard Installation Errors for .Net Compact F
Tue, 19 Feb 2008 08:25:05 -0800
I get the following errors when attempting to install Visual Studio 2005 SE.
[02/16/08,12:31:36] Microsoft .NET Framework 2.0: [2] Error code 1603 for
this component means "Fatal error during installation.
"
[02/16/08,12:31:36] Microsoft .NET Framework 2.0: [2] Setup Failed on
component Microsoft .NET Frame ...
|
