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

C#

 
AnswerRe: How to sort arraylist ? Pin
Christian Graus4-Apr-07 1:00
protectorChristian Graus4-Apr-07 1:00 
GeneralRe: How to sort arraylist ? Pin
DavidNohejl4-Apr-07 1:57
DavidNohejl4-Apr-07 1:57 
GeneralRe: How to sort arraylist ? Pin
Martin#4-Apr-07 1:09
Martin#4-Apr-07 1:09 
AnswerRe: How to sort arraylist ? Pin
DavidNohejl4-Apr-07 1:52
DavidNohejl4-Apr-07 1:52 
GeneralRe: How to sort arraylist ? Pin
Martin#4-Apr-07 2:11
Martin#4-Apr-07 2:11 
GeneralRe: How to sort arraylist ? Pin
DavidNohejl4-Apr-07 21:44
DavidNohejl4-Apr-07 21:44 
GeneralRe: How to sort arraylist ? Pin
Martin#4-Apr-07 22:12
Martin#4-Apr-07 22:12 
GeneralRe: How to sort arraylist ? Pin
DavidNohejl4-Apr-07 23:06
DavidNohejl4-Apr-07 23:06 
GeneralRe: How to sort arraylist ? Pin
Martin#4-Apr-07 23:09
Martin#4-Apr-07 23:09 
QuestionSoftware live update help needed Pin
pashitech4-Apr-07 0:35
pashitech4-Apr-07 0:35 
AnswerRe: Software live update help needed Pin
Christian Graus4-Apr-07 0:54
protectorChristian Graus4-Apr-07 0:54 
GeneralRe: Software live update help needed [modified] Pin
pashitech4-Apr-07 1:02
pashitech4-Apr-07 1:02 
GeneralRe: Software live update help needed Pin
Not Active4-Apr-07 3:23
mentorNot Active4-Apr-07 3:23 
QuestionHow ToExecute DTS using C#.Net Code behind ?[modified] Pin
SrinivasanPrabakaran4-Apr-07 0:35
SrinivasanPrabakaran4-Apr-07 0:35 
Questionproblem. Pin
amaneet4-Apr-07 0:27
amaneet4-Apr-07 0:27 
AnswerRe: problem. Pin
Christian Graus4-Apr-07 0:38
protectorChristian Graus4-Apr-07 0:38 
GeneralDifference between protected and internal protected Pin
amaneet4-Apr-07 0:45
amaneet4-Apr-07 0:45 
GeneralRe: Difference between protected and internal protected Pin
Sathesh Sakthivel4-Apr-07 1:00
Sathesh Sakthivel4-Apr-07 1:00 
AnswerRe: problem. Pin
Hayder Marzouk4-Apr-07 2:52
Hayder Marzouk4-Apr-07 2:52 
QuestionAdding .dll file to C#.NET 2005 application ? Pin
Software_Specialist4-Apr-07 0:17
Software_Specialist4-Apr-07 0:17 
AnswerRe: Adding .dll file to C#.NET 2005 application ? Pin
Christian Graus4-Apr-07 0:37
protectorChristian Graus4-Apr-07 0:37 
QuestionDataset Pin
yaminilatha4-Apr-07 0:00
yaminilatha4-Apr-07 0:00 
I have to add multiples into a dataset. Using this dataset i am creating a crystalreport. How to add the tables into a dataset. I am getting error in the report.

the code is as follows...



string strConn = "data source=HP10503715219;persist security info=False;initial catalog=MOHAM;pwd=sa;user id=sa";
SqlConnection sqlConn = new SqlConnection(strConn);
DataSet ds = new DataSet();
strCmd = select cm.name, om.oclientref, pm.productname, om.orcvddatetime, od.opastatecode, cu.countyname, om.ordercost, om.additionalcost,om.total,om.subclient from ordermain om, orderdetail od, clientmaster cm, countyusa cu, productmaster pm where cm.clientid = om.oclientid and pm.productid = om.oproductid and cu.countycode = od.opacountycode and om.oslno = od.oslno and (om.ostatus='Completed' or om.ostatus='sent to client');

SqlDataAdapter da = new SqlDataAdapter(strCmd, sqlConn);
da.Fill(ds);
ds.Tables[0].TableName = "ordermain";
ds.Tables[1].TableName = "productmaster";
ds.Tables[2].TableName = "clientmaster";
ds.Tables[3].TableName = "countyusa";
ds.Tables[4].TableName = "orderdetail";


sqlConn.Close();
CrystalReportViewer1.DisplayGroupTree = false;
CrystalReportViewer1.HasCrystalLogo = false;
myReportDocument.Load(Server.MapPath("Total.rpt"));
myReportDocument.SetDataSource(ds);
CrystalReportViewer1.ReportSource = myReportDocument;
CrystalReportViewer1.DataBind();

ERROR: System.IndexOutOfRangeException: Cannot find table1

thanx in advance

yamini
AnswerRe: Dataset Pin
rah_sin4-Apr-07 0:39
professionalrah_sin4-Apr-07 0:39 
GeneralRe: Dataset Pin
yaminilatha4-Apr-07 1:48
yaminilatha4-Apr-07 1:48 
GeneralRe: Dataset Pin
rah_sin4-Apr-07 2:05
professionalrah_sin4-Apr-07 2:05 

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.