how to convert the database data into pdf or excel format

Do you want to export data in Excel
if yes,
try
export data from sql database into excel spreadsheet
http://support.microsoft.com/kb/319951[^]
Export SQL Server Data into Excel

The code which I used in asp.net for downloading the data as excel format:

first store all the values into a dataset. Then take one string builder and append all the values of dataset in a table format. Then pass that string builder to the stringwriter as below and follow the overall code below:

Here below "sb" means stringbuilder object as example

// Save the format as MsExcel file in a folder(.xls)
StringWriter sw = new StringWriter(sb);

File.WriteAllText(HttpContext.Current.Request.ServerVariables["APPL_PHYSICAL_PATH"].ToString() + "\\folder path\\" + filename + ".xls", sb.ToString());
sw.Flush();
sw.Close();
sw.Dispose();

//To DownLoad the excel file. Set the appropriate ContentType.
Response.ContentType = "Application/vnd.ms-excel";
//Get the physical path to the file.
string filePath = HttpContext.Current.Request.ServerVariables["APPL_PHYSICAL_PATH"].ToString() + "\\folderpath\\" + currYear + ".xls";
Response.AppendHeader("content-disposition", "attachment; filename= " + filename + ".xls");
//Write the file directly to the HTTP content output stream.
Response.WriteFile(filePath);
Response.End();

Now first the file will be stored in your folderpath and automatically it will ask to download..

If u want how to write dataset into a stringbuilder means ask. I will give small example..

I want to upload pdf data(What ever details in pdf document sya roll number student name marks..etc) in aql server database using asp.net...