V-TECH

Questions Links

2019-11-21T10:25:00.000-08:00

https://career.guru99.com/top-50-asp-net-web-api-interview-questions-and-answers/

https://dotnettutorials.net/lesson/web-api-interview-questions/

https://www.dotnettricks.com/learn/webapi/top-20-web-api-interview-questions-answers

https://www.codeproject.com/Articles/769140/Top-ASP-NET-Web-API-Interview-Questions

MVC

https://www.codeproject.com/Articles/769140/Top-ASP-NET-Web-API-Interview-Questions

SOLID Principle in Programming

2019-11-14T22:21:00.000-08:00

This principle is an acronym of the five principles which is given below…

Single Responsibility Principle (SRP)
Open/Closed Principle
Liskov’s Substitution Principle (LSP)
Interface Segregation Principle (ISP)
Dependency Inversion Principle (DIP)

how to get the count of columns of tables in sql

2012-11-09T03:37:00.001-08:00

Get the number of columns in the table

Use [yourdatabaseName]

SELECT COUNT(*)
FROM information_schema.columns
WHERE table_name = 'yourtableName'

OR

SELECT COUNT(*)
FROM yourdatabaseName.sys.columns
WHERE object_id = OBJECT_ID('yourdatabaseName.dbo.yourtableName')

Boxing and Unboxing

2011-12-10T08:22:00.000-08:00

Boxing is the process of converting a value type to the type object.
e.g

int i = 123;
object o = (object)i; // boxing

Unboxing extracts the value type from the object.
o = 123;
i = (int)o; // unboxing

Login Code in ASP.Net using C#

2011-11-01T03:53:00.000-07:00

using DataReader :

Sqlconnection con = new sqlconnection("your conectionstring");

Sqlcommand cmd = new sqlcommand();

cmd.commandtext = "select * from table";

cmd.connection = con;

if (con.state==connectionstate.closed) con.open();

SqlDatareader dr = cmd.executereader();

while(dr.read)

{

       if ( dr["Username"] == textbox1.text.trim() && dr["Password"] == textbox2.text )

       {

                 response.redirect("Homepage.aspx");

               return;

        }

}

Repeater Data Binding

2011-10-13T07:16:00.000-07:00

C# Code

SqlConnection con = new SqlConnection("Data Source=VISHAL\\SQLEXPRESS;Initial Catalog=crystal_db;Persist Security Info=True;User ID=sa;Password=sa123");
con.Open();

SqlCommand cmd = new SqlCommand("Select * from demo", con);

cmd.CommandType = CommandType.Text;

SqlDataAdapter adp = new SqlDataAdapter(cmd );
DataSet dst = new DataSet();
adp.Fill(dst);

Repeater1.DataSource = dst;
Repeater1.DataBind();

.aspx code

<asp:Repeater ID="Repeater1" runat="server" >
<HeaderTemplate >
<table border ="1">
<tr>
<th>No</th>
<th>Name</th>

</tr>
</HeaderTemplate>
<ItemTemplate >
<tr>

<td>
<%#DataBinder .Eval (Container .DataItem ,"No") %>
</td>
<td>
<%#DataBinder .Eval (Container .DataItem ,"Name")%>
</td>
</ItemTemplate>
<FooterTemplate >
</table>
</FooterTemplate>
</asp:Repeater>

My First Blog

2011-10-13T03:14:00.001-07:00

Hello world.....