Click here to Skip to main content
15,887,683 members
Home / Discussions / C#
   

C#

 
GeneralRe: C# trackBar Control is losing Color (Hue) when adjusting Brightness Pin
Member 1154317321-Mar-15 11:16
Member 1154317321-Mar-15 11:16 
GeneralRe: C# trackBar Control is losing Color (Hue) when adjusting Brightness Pin
manchanx21-Mar-15 14:00
professionalmanchanx21-Mar-15 14:00 
GeneralRe: C# trackBar Control is losing Color (Hue) when adjusting Brightness Pin
Member 1154317322-Mar-15 11:01
Member 1154317322-Mar-15 11:01 
GeneralRe: C# trackBar Control is losing Color (Hue) when adjusting Brightness Pin
manchanx22-Mar-15 11:04
professionalmanchanx22-Mar-15 11:04 
GeneralRe: C# trackBar Control is losing Color (Hue) when adjusting Brightness Pin
Member 1154317325-Mar-15 11:02
Member 1154317325-Mar-15 11:02 
QuestionTic Tac Toe - Multiplayer Pin
Googooli8620-Mar-15 9:42
Googooli8620-Mar-15 9:42 
AnswerRe: Tic Tac Toe - Multiplayer Pin
Gerry Schmitz20-Mar-15 13:14
mveGerry Schmitz20-Mar-15 13:14 
QuestionCan some one help me how to download 2 PDF files in WEB API. Here is the code, Only one file returning and next file not returning where as my Query showing 2 results Pin
Ramalingeswar Akkireddy20-Mar-15 5:05
Ramalingeswar Akkireddy20-Mar-15 5:05 
using System;
using System.Collections.Generic;
using System.Configuration;
using System.IO;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Web;
using System.Web.Http;

using System.Data;
using System.Data.SqlClient;

namespace Fabco_WebApi.Controllers
{
public class DownloadPDFController : ApiController
{

public static string ConnectionString = Convert.ToString(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
FabcoDBDataContext _ObjDb = new FabcoDBDataContext(ConnectionString);

[HttpGet]
public HttpResponseMessage Get()
{
string[] FN = Directory.GetFiles(@"C:\XXX");
SqlConnection connection = new SqlConnection(ConnectionString);
connection.Open();
string query = "select * from XXX where convert(datetime,convert(varchar(10),last_update,101))=convert(datetime,convert(varchar(10),'2015-03-19',101))";
SqlCommand Command = new SqlCommand(query, connection);
SqlDataAdapter da = new SqlDataAdapter(Command);
DataSet ds = new DataSet();
da.Fill(ds);
while (true)
{
if (ds.Tables[0].Rows.Count > 0)
{
MemoryStream responseStream = new MemoryStream();
bool fullContent = true;
var fName = string.Empty;
for (int i = 0; i <=ds.Tables[0].Rows.Count; i++)
{

fName = ds.Tables[0].Rows[i][1].ToString();
var DataFlag = ds.Tables[0].Rows[i][7].ToString();
string aa = "C:\\Fabco";
//string fName = "jQueryNotes.pdf";
var filepath = aa + "/" + fName;

//MemoryStream responseStream = new MemoryStream();
Stream fileStream = File.Open(filepath, FileMode.Open);
//bool fullContent = true;
fileStream.CopyTo(responseStream);
fileStream.Flush();
fileStream.Close();

}
responseStream.Position = 0;
HttpResponseMessage response = new HttpResponseMessage();
response.StatusCode = fullContent ? HttpStatusCode.OK : HttpStatusCode.PartialContent;
response.Content = new StreamContent(responseStream);
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment") { FileName = fName.ToString() };
return response;
}
}
}


}

}
AnswerRe: Can some one help me how to download 2 PDF files in WEB API. Here is the code, Only one file returning and next file not returning where as my Query showing 2 results Pin
Richard Deeming20-Mar-15 8:18
mveRichard Deeming20-Mar-15 8:18 
AnswerRe: Can some one help me how to download 2 PDF files in WEB API. Here is the code, Only one file returning and next file not returning where as my Query showing 2 results Pin
F-ES Sitecore21-Mar-15 2:23
professionalF-ES Sitecore21-Mar-15 2:23 
QuestionHow to manage timeexeption with GET and POST requests in C# Pin
KimToredo19-Mar-15 23:31
KimToredo19-Mar-15 23:31 
AnswerRe: How to manage timeexeption with GET and POST requests in C# Pin
Afzaal Ahmad Zeeshan20-Mar-15 1:17
professionalAfzaal Ahmad Zeeshan20-Mar-15 1:17 
GeneralRe: How to manage timeexeption with GET and POST requests in C# Pin
KimToredo20-Mar-15 13:59
KimToredo20-Mar-15 13:59 
Question[EDIT] Implmenting Tree Node MouseDoubleClick Event Properly Pin
Django_Untaken19-Mar-15 21:39
Django_Untaken19-Mar-15 21:39 
AnswerRe: [EDIT] Implmenting Tree Node MouseDoubleClick Event Properly Pin
Eddy Vluggen20-Mar-15 1:26
professionalEddy Vluggen20-Mar-15 1:26 
QuestionIssue with outllok addin file generation Pin
sma123#19-Mar-15 20:57
sma123#19-Mar-15 20:57 
QuestionRe: Issue with outllok addin file generation Pin
Eddy Vluggen20-Mar-15 8:23
professionalEddy Vluggen20-Mar-15 8:23 
QuestionSQLDependency not firing any notification on Hyper V machines Pin
Rakesh Kumar Sah19-Mar-15 18:25
Rakesh Kumar Sah19-Mar-15 18:25 
QuestionExe Pin
Member 1133602719-Mar-15 8:21
Member 1133602719-Mar-15 8:21 
AnswerRe: Exe Pin
OriginalGriff19-Mar-15 9:04
mveOriginalGriff19-Mar-15 9:04 
GeneralRe: Exe Pin
Member 1133602719-Mar-15 9:46
Member 1133602719-Mar-15 9:46 
GeneralRe: Exe Pin
OriginalGriff19-Mar-15 10:13
mveOriginalGriff19-Mar-15 10:13 
GeneralRe: Exe Pin
Member 1133602719-Mar-15 10:47
Member 1133602719-Mar-15 10:47 
AnswerRe: Exe Pin
Dave Kreskowiak19-Mar-15 9:30
mveDave Kreskowiak19-Mar-15 9:30 
AnswerRe: Exe Pin
Eddy Vluggen19-Mar-15 10:34
professionalEddy Vluggen19-Mar-15 10:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.