sql rows to columns comma separated values

We can convert rows to column using following querys.

 

in case we have more rows then we can use following query.( only 500000000 characters)

 

 

--Sql rows to column

--only 500000000 characters--If you want more rows,then you can use the following query

 

select SUBSTRING((SELECT(', ' + CAST(Columname AS varchar(1000)) ) FROM

tablename FOR XML PATH('')),3,500000000)

 

in case we have less rows then we can use following query.( only 8000 characters)

 

--If you want less rows , then you can use the following query--only8000 characters

DECLARE @retstr varchar(MAX) SELECT @retstr =

COALESCE(@retstr + ',','') + [Columname] FROM tablename

select @retstr

 Happy coding......

Download remote file using asp.net and C#.net

 

 

Download remote file using C#.net in windows application.

 

Following code will help for downloading remote file.

private static int DownloadFile(String remoteFilename, String localFilename)

{

int bytesProcessed = 0;

Stream remoteStream = null;

Stream localStream = null;

WebResponse response = null;

try

{

WebRequest request = WebRequest.Create(remoteFilename);

if (request != null)

{

response = request.GetResponse();

if (response != null)

{

remoteStream = response.GetResponseStream();

localStream = File.Create(localFilename);

 

byte[] buffer = new byte[1024];

int bytesRead;

do

{

bytesRead = remoteStream.Read(buffer, 0, buffer.Length);

localStream.Write(buffer, 0, bytesRead);

bytesProcessed += bytesRead;

} while (bytesRead > 0);

}

}

}

catch (Exception ex)

{

string strMsg = ex.Message;

}

finally

{

if (response != null) response.Close();

if (remoteStream != null) remoteStream.Close();

if (localStream != null) localStream.Close();

}

return bytesProcessed;

}

}

 

For web application following method code will help

 

private Void DownloadFile()

{

string remoteImageUrl = "http://www.toptechreviews.net/wp-content/uploads/2011/06/Microsoft.png";

string strRealname = Path.GetFileName(remoteImageUrl);

string exts = Path.GetExtension(remoteImageUrl);

WebClient webClient = new WebClient();

webClient.DownloadFile(remoteImageUrl,

Server.MapPath("~/im/") + strRealname + exts);

}

in web.config we need set following configuration

  <system.net>

    <defaultProxy enabled="true" useDefaultCredentials="true"></defaultProxy>

  </system.net>

 

 

 

sql server reset identity column value

Following sql query will help for reset identity coloumn.

DBCC CHECKIDENT('tablename', RESEED, 0)

"tablename" -- which table you want to reset identity coloumn.

Happy coding...