Welcome to Sign in | Help

Re: SQL Server 2005 FROM

  •  11-23-2008, 12:50 PM

    Re: SQL Server 2005 FROM

    alta solutie ar fi sa foloseasca "executing multiple sql statement' using a DataReader cu ado.dot net framework

    using(SqlConection sqlcon=new SqlConnection("your connection string)

    {

    SqlCommand comanda=New SqlCommand(sqlcon);

    comanda.CommndText="select * from tabela1;...select * from tabelan";

    SqlDataReaderreader =comanda.ExecuteReader();

    bool MoreResult=false;

    StringBuilder results=New StringBuilder();

    do

    {

    while(reader.read())

    {

    for (int i=0;i++;i<reader.FiledCount)

    result.append(readerIdea.toString()+"\n");//aici preiei datele tabelei i

    MoreResults=reader.nextResult();

    }

    while(Moreresults)

    }

    }


    Secolul XXI ori va fi religios ori nu va fi deloc
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems