SQL DEFAULT Constraint on ALTER TABLE

 ALTER TABLE Persons

ADD CONSTRAINT dfCity
DEFAULT 'Sangli' FOR City;

Adding a column name and value in sql select command

 select name,rollno, class, 'No' as vacationing from stutable;

Adding Datatble column at specific Index in C#

  DataColumn Col = dt.Columns.Add("ColName", System.Type.GetType("System.Boolean"));

                Col.SetOrdinal(0);// to put the column in position 0;

Showing Limited TExt in grid view

  <ItemTemplate>
                                        <asp:Label ID="Label14" runat="server" ToolTip='<%# Eval("Remarks") %>' Text='  <%# Eval("Remarks").ToString().Length>25 ? (Eval("Remarks") as string).Substring(0,25) : Eval("Remarks")  %>'></asp:Label>

                                    </ItemTemplate>

.NET Interview Questions

ASP.NET Questions: ---

1. Difference between Server. Transfer and Response. Redirect.
2. Page Life Cycle.
3. Which Control you will use to display data using Repeater Control.
4. Reflection.
5. Deployment
6. Binding Controls.
7. What will happen if I will delete web.config file.
8. How to create Permanent cookies?
9. What is view state?
10. What is hidden Field?

C# Questions: ---

1. What is Static keyword?
2. Abstract Class
3. Difference between Overloading and Overriding.
4. Interfaces.
5. Can we inherit multiple interfaces?
6. What does virtual keyword do?
7. Inheritance.
8. How would you Sort an array in descending order?
9. Delegates and Events.
10. Can we create object of Abstract Class?
11. Sealed Class.
12. Difference between ReadOnly and Constant?

Basic Questions:-

1. .Net Framework.
2. CLR
3. Assembly
4. DLL
5. Is .Net platform independent?
6. It works on Linux?
7. What is dot in .Net?
8. Satellite Assembly.
9. Difference between n tier architecture and 3-tier architecture.

Database Questions:--

1. Give Examples of RDBMS.
2. What is RDBMS?
3. Difference between Oracle and SQLServer.
4. What is Primary Key.
5. Give Difference between Primary key,unique key.
6. What are constraints?
7. Difference between delete and truncate.
8. Group by clause
9. Search ‘mis’ from table values.
10. Date functions
11. Multitable Queries
12. Normalization
13. 2NF
14. 3NF
15. Stored Procedures
16. Triggers
17. Can we create triggers in Stored Procedures?
18. Having Clause
19. Can us rollback deleted items from dataset.
20. Where is connection String Stored.
21. Difference between where and having clause.
22. Difference between Dataset and DataReader.
23. Difference between RecordSet and DataSet.
24. How to create ConnectionString?