Database

Luc Pattyn wrote:

File.WriteAllBytes().

Luc Pattyn wrote:

the ds[1] part

Select * from MyTable where IDField = 0

Select * from MyTable where 1=1

Select * from MyTable where 1=1

Select * from MyTable where 1=2

Select top 0 * from MyTable

strSQL_subform = "SELECT [Lable] AS field1, [Label] AS field2, "
strSQL_subform = strSQL_subform + "[Label] AS field-N, "
...
strSQL_subform = strSQL_subform + "FROM [tbl_MyHandyTable] "
strSQL_subform = strSQL_subform + "WHERE 1=2;"

'initialize the record source with the empty table of EmptyStrings
Me.RecordSource = strSQL_subform

SqlCommand cmd = new SqlCommand("SELECT * FROM MyTable");
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly);

CREATE PROCEDURE My_SP
 @Para1 AS INTEGER,
 @Para2 AS INTEGER,
 @Para3 AS INTEGER,
 @RecordCount AS INTEGER OUTPUT
AS
 SET @RecordCount = (SELECT COUNT(*) FROM MYTABLE)
GO

DECLARE @RecordCount AS INTEGER
EXEC My_SP 1, 1, 1, RecordCount OUTPUT