Comments by Vaishali P. Patil (Top 22 by date)

I don't understand this code.

hi,i bind answers to gridview but problem is i compair one by one attempt..so i got line but only first page..i goto next page line removed..i think this is page refresh problem..plz tell me..

ok

can we identify in programe that user is using the IE or which browser

ok. Thanks

Can we give message to user that for IE there is need to change the setting if user is using the IE

Thanks.

string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='"+fileLocation+"';Extended Properties= 'Excel 12.0;HDR=Yes;IMEX=1'";

in this i am using fileLocation is for where my file is stored

using ICSharpCode.SharpZipLib.Zip;
using System.IO.Compression;

thank you. i have tried this :

if (ds.Tables[0].Rows.Count > 0)
{
// Create the ZIP file that will be downloaded. Need to name the file something unique ...
string strNow = String.Format("{0:MMM-dd-yyyy_hh-mm-ss}", System.DateTime.Now);
ZipOutputStream zipOS = new ZipOutputStream(File.Create(Server.MapPath("1/") + strNow + ".zip"));
zipOS.SetLevel(5); // ranges 0 to 9 ... 0 = no compression : 9 = max compression

// Loop through the dataset to fill the zip file
foreach (DataRow dr in ds.Tables[0].Rows)
{
byte[] files = (byte[])(dr["Files"]);
//FileStream strim = new FileStream(Server.MapPath("~/TempFile/" + dr["FileName"]), FileMode.Create);
//strim.Write(files, 0, files.Length);
//strim.Close();
//strim.Dispose();
ZipEntry zipEntry = new ZipEntry(dr["Files"].ToString());
zipOS.PutNextEntry(zipEntry);
zipOS.Write(files, 0, files.Length);
}
zipOS.Finish();
zipOS.Close();

FileInfo file = new FileInfo(Server.MapPath("1/") + strNow + ".zip");
if (file.Exists)
{
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name);
Response.AddHeader("Content-Length", file.Length.ToString());
Response.ContentType = "application/zip";
Response.WriteFile(file.FullName);
Response.Flush();
file.Delete();
Response.End();
}
}


it gives me error at this line

byte[] files = (byte[])(dr["Files"]); that "Unable to cast object of type 'System.String' to type 'System.Byte[]'."

thanks.i used your code as

if (ds.Tables[0].Rows.Count > 0)
{



byte[] buffer = new byte[4096];

// the path on the server where the temp file will be created!
string tempFileName = Server.MapPath(@"1/" + Guid.NewGuid().ToString() + ".zip");

ZipOutputStream zipOutputStream = new ZipOutputStream(File.Create(tempFileName));
string filePath = String.Empty;
string fileName = String.Empty;
int readBytes = 0;

foreach (DataRow dr in ds.Tables[0].Rows)
{
//var isChecked = (row.FindControl("chkSelect") as CheckBox).Checked;
//if (!isChecked) continue;
filePath = Convert.ToString(dr["EvidencePath"]);
//filePath = (row.FindControl("lblFilePath") as Label).Text;
//fileName = (row.FindControl("lblFileName") as Label).Text;
fileName = Convert.ToString(dr["FilesName"]);


ZipEntry zipEntry = new ZipEntry(fileName);

zipOutputStream.PutNextEntry(zipEntry);

using (File fs = File.OpenRead(filePath))
{
do
{
readBytes = fs.Read(buffer, 0, buffer.Length);
zipOutputStream.Write(buffer, 0, readBytes);

} while (readBytes > 0);
}
}

if (zipOutputStream.Length == 0)
{
//lblMessage.Text = "Please select at least one file!";
return;
}


zipOutputStream.Finish();
zipOutputStream.Close();

Response.ContentType = "application/x-zip-compressed";
Response.AppendHeader("Content-Disposition", "attachment; filename=YourFile.zip");
Response.WriteFile(tempFileName);

Response.Flush();
Response.Close();

// delete the temp file
if (File.Exists(tempFileName))
File.Delete(tempFileName);
//}

}

it shows me error: Cannot declare a variable of static type 'System.IO.File'

i am trying bellow code
if (ds.Tables[0].Rows.Count > 0)
{
// Create the ZIP file that will be downloaded. Need to name the file something unique ...
string strNow = String.Format("{0:MMM-dd-yyyy_hh-mm-ss}", System.DateTime.Now);
ZipOutputStream zipOS = new ZipOutputStream(File.Create(Server.MapPath("1/") + strNow + ".zip"));
zipOS.SetLevel(5); // ranges 0 to 9 ... 0 = no compression : 9 = max compression

// Loop through the dataset to fill the zip file
foreach (DataRow dr in ds.Tables[0].Rows)
{


ZipEntry zipEntry = new ZipEntry(dr["filename"].ToString());
zipOS.PutNextEntry(zipEntry);


}

zipOS.Finish();
zipOS.Close();

FileInfo file = new FileInfo(Server.MapPath("1/") + strNow + ".zip");
if (file.Exists)
{
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name);
Response.AddHeader("Content-Length", file.Length.ToString());
Response.ContentType = "application/zip";
Response.WriteFile(file.FullName);
Response.Flush();
file.Delete();
Response.End();
}
}


but it only creates zip folder

if suppose i have one movie's all song and bellow is the link download all above then how can we do this functionality

by using this it shows formatt as 2012-06-27 16:24:39.000 i want to show 2012-06-27 4:28 PM

thanks it works

thanks. it works

Thanks, i used this but sets cursor at the start of the text not end and i also used bellow <script type="text/javascript">
function SetCursorToTextEnd(textControlID)
{
var text = document.getElementById(textControlID);
if (text != null && text.value.length > 0)
{
if (text.createTextRange)
{
var FieldRange = text.createTextRange();
FieldRange.moveStart('character', text.value.length);
FieldRange.collapse();
FieldRange.select();
}
}
}
</script>


but it shows me error textControlID does not exist in the current context