Click here to Skip to main content
15,916,293 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Posting + asp.net 2.0 +c# Pin
Sandeep Akhare6-Mar-07 0:43
Sandeep Akhare6-Mar-07 0:43 
GeneralRe: Posting + asp.net 2.0 +c# Pin
ritu43216-Mar-07 0:54
ritu43216-Mar-07 0:54 
GeneralRe: Posting + asp.net 2.0 +c# Pin
Sandeep Akhare6-Mar-07 1:07
Sandeep Akhare6-Mar-07 1:07 
GeneralRe: Posting + asp.net 2.0 +c# Pin
ritu43216-Mar-07 1:19
ritu43216-Mar-07 1:19 
GeneralRe: Posting + asp.net 2.0 +c# Pin
Sandeep Akhare6-Mar-07 1:35
Sandeep Akhare6-Mar-07 1:35 
Questionhow to set many datasets to a single datable using data adapter in asp.net 1.1 version Pin
puthu6-Mar-07 0:16
puthu6-Mar-07 0:16 
AnswerRe: how to set many datasets to a single datable using data adapter in asp.net 1.1 version Pin
Vsree6-Mar-07 1:32
Vsree6-Mar-07 1:32 
GeneralRe: how to set many datasets to a single datable using data adapter in asp.net 1.1 version Pin
puthu6-Mar-07 17:14
puthu6-Mar-07 17:14 
<code>SqlCommand cmdDesign = new SqlCommand();
cmdDesign.Connection = Cn;
cmdDesign.CommandType = CommandType.StoredProcedure;
cmdDesign.CommandText = "EIS_spGetEmployeeCategory";
cmdDesign.Parameters.Add("@User_Id", SqlDbType.Int).Value = intUserId;

SqlDataAdapter daDesign = new SqlDataAdapter();
daDesign.SelectCommand = cmdDesign;
daDesign.Fill(ds, "EmpCat");

SqlCommand cmdEdu = new SqlCommand();
cmdEdu.Connection = Cn;
cmdEdu.CommandType = CommandType.StoredProcedure;
cmdEdu.CommandText = "EIS_spGetEmployeeBasicQualificationList";
cmdEdu.Parameters.Add("@Id", SqlDbType.Int).Value = intUserId;

SqlDataAdapter daEdu = new SqlDataAdapter();
daEdu.SelectCommand = cmdEdu;
daEdu.Fill(ds, "EmpEdu");
string fileName = Server.MapPath(".");
fileName = fileName + "\\Templates\\Resume_Template2.xml";
XmlDocument xmlTemplateDoc = new XmlDocument();
xmlTemplateDoc.Load(fileName);


CExWordMLFiller wfiller = new CExWordMLFiller(ds, xmlTemplateDoc.OuterXml);
wfiller.Transform();
string copyFileName = Path.GetTempFileName() + ".xml";
wfiller.WordMLDocument.Save(copyFileName);
Response.Clear();
Response.ContentType = "application/msword";
Response.Charset = "";
Response.AddHeader("Content-disposition", "inline: filename=" + copyFileName + "");
Response.WriteFile(copyFileName);
Response.Flush();
Response.Close();

</code>

This was the code i used earlier.But i want to split this code so that each dataset in separate functions in class.There comes the trouble. CExWordMLFiller wfiller = new CExWordMLFiller(ds, xmlTemplateDoc.OuterXml);
This 'ds' comprises all datasets..

This is the new code..:
<code> public DataSet GetEmployeeCategory (int userId)
{

DataView dvTemplate = null;
int templateId=0;
string SP = DBObjectName.spGetEmployeeCategory;

Hashtable htParameters = new Hashtable();

htParameters.Add("@User_Id",MISUtility.CheckNull(templateId));
DataSet EmpCat = new DataSet();
try
{
OpenConnection();
dvTemplate = Connection.ExecuteProcedure(SP,htParameters);

DataTable dtTmp = dvTemplate.Table;
EmpCat.Tables.Add(dtTmp);


}
catch(Exception e)
{
throw new MISException("AdvancedReport.GetEmployeeCategory() failed",e);
}
finally
{
CloseConnection();
}
return EmpCat;
}


public DataSet GetEmployeeBasicQualification(int userId)
{

DataView dvTemplate = null;
int templateId=0;
string SP = DBObjectName.spGetEmployeeBasicQualificationList;

Hashtable htParameters = new Hashtable();

htParameters.Add("@User_Id",MISUtility.CheckNull(templateId));
DataSet EmpEdu = new DataSet();
try
{
OpenConnection();
dvTemplate = Connection.ExecuteProcedure(SP,htParameters);

DataTable dtTmp = dvTemplate.Table;
EmpEdu.Tables.Add(dtTmp);


}
catch(Exception e)
{
throw new MISException("AdvancedReport.GetEmployeeBasicQualification() failed",e);
}
finally
{
CloseConnection();
}
return EmpEdu;
}
</code>
<code>private void GetResumeMergeFields()
{
try
{
ResumeTemplate obj = new ResumeTemplate();
//DataSet EmpCat = obj.GetEmployeeCategory();

string fileName = Server.MapPath(".");
fileName = fileName + "\\Templates\\Resume_Template2.xml";
XmlDocument xmlTemplateDoc = new XmlDocument();
xmlTemplateDoc.Load(fileName);


CExWordMLFiller wfiller = new CExWordMLFiller(ds, xmlTemplateDoc.OuterXml);
wfiller.Transform();
string copyFileName = Path.GetTempFileName() + ".xml";
wfiller.WordMLDocument.Save(copyFileName);
Response.Clear();
Response.ContentType = "application/msword";
Response.Charset = "";
Response.AddHeader("Content-disposition", "inline: filename=" + copyFileName + "");
Response.WriteFile(copyFileName);
Response.Flush();
Response.Close();
}
catch(Exception ex)
{
throw new MISLogException(this.MISRecordFetchErrorMessage,ex);
}

}</code>

ds in GetResumeMergeFields() in getting error...

Please help...Rose | [Rose]

AnswerRe: how to set many datasets to a single datable using data adapter in asp.net 1.1 version Pin
gauthee6-Mar-07 1:38
gauthee6-Mar-07 1:38 
GeneralRe: how to set many datasets to a single datable using data adapter in asp.net 1.1 version Pin
puthu6-Mar-07 16:54
puthu6-Mar-07 16:54 
Questionjavascript Pin
kmanisha6-Mar-07 0:12
kmanisha6-Mar-07 0:12 
AnswerRe: javascript Pin
Sandeep Akhare6-Mar-07 0:21
Sandeep Akhare6-Mar-07 0:21 
AnswerRe: javascript Pin
Sandeep Akhare6-Mar-07 0:31
Sandeep Akhare6-Mar-07 0:31 
AnswerRe: javascript Pin
Guffa6-Mar-07 0:48
Guffa6-Mar-07 0:48 
Questiondisplay in the listbox Pin
Oga M6-Mar-07 0:04
Oga M6-Mar-07 0:04 
AnswerRe: display in the listbox Pin
NanaAM6-Mar-07 0:22
NanaAM6-Mar-07 0:22 
AnswerRe: display in the listbox Pin
Member 38798816-Mar-07 0:39
Member 38798816-Mar-07 0:39 
AnswerRe: display in the listbox Pin
Irshad Sulaimani6-Mar-07 0:41
Irshad Sulaimani6-Mar-07 0:41 
Questionbutton to submit the form to the mananger by e-mail Pin
Oga M5-Mar-07 23:59
Oga M5-Mar-07 23:59 
AnswerRe: button to submit the form to the mananger by e-mail Pin
NanaAM6-Mar-07 0:25
NanaAM6-Mar-07 0:25 
AnswerRe: button to submit the form to the mananger by e-mail Pin
Vasudevan Deepak Kumar6-Mar-07 9:24
Vasudevan Deepak Kumar6-Mar-07 9:24 
QuestionDoubt in ASP.Net User Interface Creation Pin
amrajeev5-Mar-07 23:48
amrajeev5-Mar-07 23:48 
AnswerRe: Doubt in ASP.Net User Interface Creation Pin
Paddy Boyd6-Mar-07 0:33
Paddy Boyd6-Mar-07 0:33 
QuestionDTS login Faild Pin
kirthikirthi5-Mar-07 23:44
kirthikirthi5-Mar-07 23:44 
AnswerRe: DTS login Faild Pin
Paddy Boyd6-Mar-07 0:34
Paddy Boyd6-Mar-07 0: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.