Hi
All of you
I m developing project of lab management system in windows application plateform..
All the thing is done but A module is for uploading Downloading file is there thats make me try ..
Coz it takes my one weak but not solved yet..
Please help me
Thank uuuuuu
Advance..
[edit]SHOUTING removed - OriginalGriff[/edit]
[edit2]Additional information moved from non-solution below - Nelek[/edit2]
if (txtDesc.Text == "" || cbxBatch.Text == "" || cbxSubjectCode.Text == "" || dtPicker.Text == "")
{
MessageBox.Show("PLEASE FILL ALL FIELD", "ERROR");
return;
}
byte[] FileData;
XMLDOCUMENTATION objXMLDOCUMENTATION = new XMLDOCUMENTATION();
if (openFileDialog1.FileName != "openFileDialog1")
FileData = File.ReadAllBytes(lblFilePath.Text);
else
{
MessageBox.Show("PLEASE SELECT FILE TO UPLOAD", "ERROR");
return;
}
BUSINESSLAYER objBUSINESSLAYER = new BUSINESSLAYER();
Hashtable ht = new Hashtable();
ht.Add("@BATCH", cbxBatch.Text);
ht.Add("@SUBJECT_CODE", Int32.Parse(cbxSubjectCode.Text));
ht.Add("@PAPERNAME", txtDesc.Text);
ht.Add("@CONTENTTYPE", lblContentType.Text);
ht.Add("@ACTUALFILENAME", lblFileName.Text);
ht.Add("@FILEDATA", FileData);
ht.Add("@LASTDATE", dtPicker.Text.ToString());
String Output = objBUSINESSLAYER.ExecuteSetProcedure("PAPERDETAILADDUPDATE", ht);
if (Output == "SUCCESS")
{
MessageBox.Show("YOUR PAPER IS SUCCESSFULLY SUBMITTED", "SUCCESSFULL");
openFileDialog1.Reset();
BindCombo(cbxBatch.Text, 0, "");
}
else
MessageBox.Show(Output, "ERROR");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "ERROR");
}
this is the code for inserting data in sql server and
try
{
int Row = e.RowIndex;
if (e.ColumnIndex == 0)
{
BUSINESSLAYER objBUSINESSLAYER = new BUSINESSLAYER();
dt = objBUSINESSLAYER.SqlDataAdapterQuery("SELECT ACTUALFILENAME,CONTENTTYPE,FILEDATA FROM PAPERDETAIL WHERE BATCH = '" + GrdPaperDetail.Rows[Row].Cells[1].Value.ToString() + "' AND SUBJECT_CODE = " + Int32.Parse(GrdPaperDetail.Rows[Row].Cells[2].Value.ToString()) + " AND ACTUALFILENAME = '" + GrdPaperDetail.Rows[Row].Cells[4].Value.ToString() + "'");
dr = objBUSINESSLAYER.ExecuteDataReader("SELECT ACTUALFILENAME,CONTENTTYPE,FILEDATA FROM PAPERDETAIL WHERE BATCH = '" + GrdPaperDetail.Rows[Row].Cells[1].Value.ToString() + "' AND SUBJECT_CODE = " + Int32.Parse(GrdPaperDetail.Rows[Row].Cells[2].Value.ToString()) + " AND ACTUALFILENAME = '" + GrdPaperDetail.Rows[Row].Cells[4].Value.ToString() + "'");
if (dr.Read())
{
File.WriteAllBytes(@"C:\" + dr["ACTUALFILENAME"], (byte[])dr["FILEDATA"]);
MessageBox.Show(@"FILE SAVE SUCCESSFULLY AT C:\" + dr["ACTUALFILENAME"], "SUCCESSFULL");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "ERROR");
}
this is code for retreiving and i can not get the actual output .means output data is not same as inserted data ..