|
How do you get records number from 5 to 15 in a dataset of 100 records? Write code.
.NET Database ,COM interop,and .NET deployment questions and answers
(Continued from previous question...)
How do you get records number from 5 to 15 in a dataset of 100 records? Write code.
Answer1
DataSet ds1=new DataSet();
String strCon=”data source=IBM-6BC8A0DACEF;initial catalog=pubs;integrated security=SSPI;persist” +” security info=False;user
id=sa;workstation id=IBM-6BC8A0DACEF;packet size=4096?;
String strCom1=”SELECT * FROM employee”;
SqlDataAdapter sqlDa1=new SqlDataAdapter(strCom1,strCon);
ds1.Tables.Add(”employee”);
sqlDa1.Fill(ds1,40,50,ds1.Tables[”employee”].TableName);
DataGrid dg1.DataSource=ds1.Tables[”employee”].DefaultView;
dg1.DataBind();
Answer2
OleDbConnection1.Open()
OleDbDataAdapter1.Fill(DataSet21, 5, 15, “tab”)
This will fill the dataset with the records starting at 5 to 15
(Continued on next question...)
Other Interview Questions
- To test a Web Service you must create a windows application or web application to consume this service? It is True/False?
- How many classes can a single.NET DLL contain?
- What are good ADO.NET object(s) to replace the ADO Recordset object?
- On order to get assembly info which namespace we should import?
- How do you declare a static variable and what is its lifetime? Give an example.
- How do you get records number from 5 to 15 in a dataset of 100 records? Write code.
- How do you call and execute a Stored Procedure in.NET? Give an example.
- What is the maximum length of a varchar in SQL Server?
- How do you define an integer in SQL Server?
- How do you separate business logic while creating an ASP.NET application?
- If there is a calendar control to be included in each page of your application, and and we do not intend to use the Microsoft-provided calendar control, how do you develop it? Do you copy and paste the code into each and every page of your application?
- How can you deploy an asp.net application ?
- Explain similarities and differences between Java and.NET?
- What are the XML files that are important in developing an ASP.NET application?
- Specify the best ways to store variables so that we can access them in various pages of ASP.NET application?
- How many objects are there in ASP?
- Which DLL file is needed to be registered for ASP?
- Is there any inbuilt paging (for example shoping cart, which will show next 10 records without refreshing) in ASP? How will you do pating?
- What does Server.MapPath do?
- Name atleast three methods of response object other than Redirect.
- Name atleast two methods of response object other than Transfer.
- What is State?
- Explain differences between ADO and DAO.
- How many types of cookies are there?
- Tell few steps for optimizing (for speed and resource) ASP page/application.
- Which command using Query Analyzer will give you the version of SQL Server and Operating System?
- How to find the SQL server version from Query Analyser
- Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table.
- What is the purpose of using COLLATE in a query?
- What is one of the first things you would do to increase performance of a query? For example, a boss tells you that “a query that ran yesterday took 30 seconds, but today it takes 6 minutes”?
- What is an execution plan? When would you use it? How would you view the execution plan?
- What is the STUFF function and how does it differ from the REPLACE function?
- What does it mean to have quoted_identifier on? What are the implications of having it off?
- What is the difference between a Local temporary table and a Global temporary table? How is each one used?
- What are cursors? Name four type of cursors and when each one would be applied?
- What is the purpose of UPDATE STATISTICS?
- How do you use DBCC statements to monitor various ASPects of a SQL Server installation?
- What is referential integrity and how can we achieve it?
- What is indexing?
- Explain differences between server.transfer and server.execute method?
- What is de-normalization? When do you do it and how?
- Explain features of SQL Server like Scalibility, Availability, Integration with Internet.
- What is DataWarehousing?
- What is OLAP?
- How do we upgrade SQL Server 7.0 to 2000?
- What is job?
- What is Task?
- How do you find the error, how can you know the number of rows affected by last SQL Statement?
- What are the advantages/disadvantages of viewstate?
- Describe session handling in webform. How does it work and what are the limits?
- Explain differences between framework 1.0 and framework 1.1
- If we write any code for dataGrid methods, what is the access specifier used for that methods in the code behind file and why and how? Give an example.
- What is the use of trace utility?
- What are the differences between User control and Web control and Custom control?
- If I have more than one version of one assemblies, then how will I use old version in my application? Give an example.
- How does you handle this COM components developed in other programming languages in.NET?
- How will you register COM+ services?
- How do u call and execute a stored procedure in .NET?
- What are the different types of replication? How are they used?
- How do SQL Server 2000 and XML linked? What is SQL Server agent?
- How do you create thread in.NET?
- Describe the advantages of writing a managed code application instead of unmanaged one. What’s involved in certain piece of code being managed?
- Are COM objects managed or unmanaged?
- So can a COM object talk to a .NET object?
- How do you generate an RCW from a COM object?
- I can’t import the COM object that I have on my machine. Did you write that object?
- How do you call unmanaged methods from your .NET code through PInvoke?
- Can you retrieve complex data types like structs from the PInvoke calls?
- I want to expose my .NET objects to COM objects. Is that possible?
- Can you inherit a COM class in a .NET application?
- Suppose I call a COM object from a .NET applicaiton, but COM object throws an error. What happens on the .NET end?
- What do you know about .NET assemblies?
- What’s the difference between private and shared assembly?
- What’s a strong name?
- How can you tell the application to look for assemblies at the locations other than its own install?
- How can you debug failed assembly binds?
- Where are shared assemblies stored?
- How can you create a strong name for a .NET assembly?
- Where’s global assembly cache located on the system?
- Can you have two files with the same file name in GAC?
- How do I tell the client applications that are already installed to start using this new MyApp.dll?
- What is delay signing?
| 