Database

do {
    bool more=false;
    if (line1==empty && line2!=empty) {line1=line2; line2=empty; more=true;}
    if (line2==empty && line3!=empty) {line2=line3; line3=empty; more=true;}
    if (line3==empty && line4!=empty) {line3=line4; line4=empty; more=true;}
while(more);

byte[] content = (byte[]) ds [ 1 ].Rows [ i ]  [ "FileContent" ] ;

fs.Write ( content , 0 , content.Length ) ; 

fs.Close() ;

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