Answer / v

protected void Page_Load(object sender, EventArgs e)
{

_ControlId = Request["ControlId"];

CrystalDecisions.CrystalReports.Engine.Database
crDatabase;
CrystalDecisions.CrystalReports.Engine.Table
crTable;

TableLogOnInfo dbConn = new TableLogOnInfo();

_oRpt = new ReportDocument();

// loading the ItemReport in report document
_oRpt.Load(Server.MapPath("~\\reports") + "\\"
+ "RepsAndWar.rpt");

// getting the database, the table and the
LogOnInfo object which holds login information
crDatabase = _oRpt.Database;

// getting the table in an object array of one item
object[] arrTables = new object[1];
crDatabase.Tables.CopyTo(arrTables, 0);

// assigning the first item of array to crTable by
downcasting the object to Table
crTable =
(CrystalDecisions.CrystalReports.Engine.Table)arrTables[0];

dbConn = crTable.LogOnInfo;

// setting values
parseConnString(Settings.CnxBackShop);
dbConn.ConnectionInfo.ServerName = _ServerName;
dbConn.ConnectionInfo.DatabaseName =
_DatabaseName;
dbConn.ConnectionInfo.UserID = _UserID;
dbConn.ConnectionInfo.Password = _Password;



// applying login info to the table object
crTable.ApplyLogOnInfo(dbConn);

crTable.Location =
dbConn.ConnectionInfo.DatabaseName + ".dbo." +
crTable.Location.Substring(crTable.Location.LastIndexOf
(".") + 1);
crTable.LogOnInfo.ConnectionInfo.ServerName =
dbConn.ConnectionInfo.ServerName;


// defining report source
CrystalReportViewer1.ReportSource = _oRpt;

setReportParameters();


}

private void setReportParameters()
{
// all the parameter fields will be added to this
collection
ParameterFields paramFields = new ParameterFields();

// the parameter fields to be sent to the report
ParameterField pfControlId = new ParameterField();

// setting the name of parameter fields with wich
they will be recieved in report
pfControlId.ParameterFieldName = "@ControlId";

// the above declared parameter fields accept
values as discrete objects
// so declaring discrete objects
ParameterDiscreteValue dc_ControlId = new
ParameterDiscreteValue();

// setting the values of discrete objects
dc_ControlId.Value = _ControlId;

// now adding these discrete values to parameters
pfControlId.CurrentValues.Add(dc_ControlId);

// now adding all these parameter fields to the
parameter collection
paramFields.Add(pfControlId);

// finally add the parameter collection to the
crystal report viewer
CrystalReportViewer1.ParameterFieldInfo =
paramFields;
}

protected void btnExport_Click(object sender, EventArgs e)
{
MemoryStream oStream;
oStream = (MemoryStream)_oRpt.ExportToStream
(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat)
;
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/pdf";
Response.BinaryWrite(oStream.ToArray());
Response.End();

}

1.write a program in C# to find a given point which is inside in a circle. Given circle's radius and its center point? 2.Write a program in C# to generated 20 prime numbers greater than a given number? (It should be more efficient for large numbers also) 3. Write a Code to check whether a given point is inside a circle or not? given Circle's raduis and its center point. 4. using oops concept, design an elevator do not forget buttons on each floor..

2 Answers  

---

In C#, explain the difference between overloading and overriding.

0 Answers   Accenture,

---

What are generic types?

0 Answers  

---

Explain how do I convert a string to an int in c#?

0 Answers  

---

How do you name a variable in c#?

0 Answers  

---

Y go for Interface? What is use of interface?

3 Answers  

---

How do I calculate relative time?

0 Answers  

---

4. Describe the process when we send a request URL? And who is responsible for that?

0 Answers   Mphasis,

---

What is the use of console application in c#?

0 Answers  

---

Where’s global assembly cache located on the system?

0 Answers  

---

There are a class A. Another class B derived from it. Now if I do A a = new B(); and B b = new B(); What will happen in both the statements. And what is the difference between these two statements.

3 Answers   HCL,

---

What are the two uses of a ‘using’ statement in c#?

0 Answers  

---