EAD Quiz 1
Total Marks: 100 Time: 1:10 Minutes Marks Obtained:
Name: _____________________________________ Roll Number: ____________
Question(1) MCQs
Select one option only.
1. repository of shared assemblies maintained by the .NET runtime is called
a. assembly line
b. Assembly contents
c. Assembly manifest
d. Global Assembly cache
2. Which key is used for step into in debugging
a. F7
b. F12
c. F11
d. F10
3. Which command is used to create exe file using csc command a csc File.cs b csc /out:My.exe File.cs c none d both (a,b)
4. --------namespace is used for ado.net with data adapter a. System.io; b. System.SqlAdapter 3. System.Data 4. System.SqlDb

5. To convert reference type variable into simple type (value) is
a. Unboxing
b. Boxing

Question(2) ( 5 Marks each)
Short Answers: 1. Write differences between CLS and CLR CLS specifies a set of rules that needs to be adhered or satisfied by all language compilers targeting CLR. It helps in cross language inheritance and cross language debugging.
.Net Framework provides runtime environment called Common Language Runtime (CLR).It provides an environment to run all the .Net Programs. 2. Write a function that takes any number of strings and an integer. Write only prototype and call this function using named argument
Public void myFunc(int num, params string[] args); myFunc(1,”Ali”,”Ahmad”);
3. What is return type of following methods? ExecuteNonQuery() | int | ExecuteScalar() | object | ExecuteReader | SqlDataReader |

4. fill in the following table for n-tier architecture only write yes or not Scalability | Yes | Better security | Yes | Fault tolerance | Yes | Performance | No | Maintenance | Yes |

5) suppose a data table student(id,name,email) exist in memory. Write code to fetch the student who have name asad and email address is of gmail.
Student.Select(“name=asad and email like %gmail% ”);
6. Consider table as mentioned in above question. Write code to get student with primary key value as 11. Student.Rows.Find(11); Question 03: 10 a) Write output of following code static void Method(ref int i) { . i =5; } static void Main() { int val; Method(ref val); Console.WriteLine(val); }

Answer: Error: when you pass a variable by reference then it must be initialized before calling b) Define object initializer in C#. Write code to initialize an object called sttudentinfo with anonymous type having attributes name, age;
Object initializers let you assign values to any accessible fields or properties of an object at creation time without having to invoke a constructor followed by lines of assignment statements.
Var studentinfo=new {age=11, name=”Ali”};

Question(3) (20)
Suppose You have a file program.cs. You have to write a function that takes name of file as argument and an old string and new string. Replace all occurrences of old string by new strings and display total number of replacements per line
Public static Replace(string filename, string old, string new)
{
StreamReader sr=new StreamReader(filename); String line=sr.ReadLine(); List<string> list=new List<string>(); String newline=””;
While (line!=null) { Count=0; String[] items=line.Splite(‘ ’); for (int index = 0; index < items.Length; index++) { if (items[index] == old) { items[index] = new; count++; } newline+=items[index]+” ”; } List.Add(newline); Console.WriteLine(“Total replacements in line are ”+ count); line=sr.ReadLine(); }
Sr.Close();
StreamWriter sw=new StreamWriter(filename); foreach (var line in list)
{
Sw.WriteLine(line); }
}

Question 04) Suppose you have two tables Student (id, name, rollno, contactid,cgpa) and Contacts(id, email, phone, address)
Write following functions (20) 1) LoadTables() //load data from tables in memory datasets using data adapter and build relations 2) GetStudentName(string email); // return the producer name using parent-child relation 3) Update email of students whose name is ALI 4) Calculate the average cgpa of all students

Public void LoadTable()
{
DataSet ds=new DataSet(); string connectionString = @”whatever"; SqlConnection connection = new SqlConnection(connectionString); string query = "select * from Student;"; SqlCommand cmd = new SqlCommand(query, connection);
SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds,”student”); da.SelectCommand.Text=”select * from Contacts ” da.Fill(ds,”Contacts”); DataRelation std = new DataRelation("std", Ds.Tables[1].Columns["Id"],ds.Tables[0].Columns["ContactidId"]); ds.Relations.Add(std); }
Void GetStudentName(string email)
{
Var row=ds.Tables[1].Select(“email=”+email) DataRow[] childRows = row[0].GetChildRows("std"); // write a loop and display names
}
Void UpdateEmail(string name)
{
Var row=ds.Tables[0].Select(“name=”+name) DataRow r = row[0].GetParentRow("std"); r[“Email”]=’abc@yahoo.com’;
}
CalculateCGPA()
{
Var avg=ds.Tables[0].Compute(“Avg(cgpa)”,””);
}