Asp dotnet 2 yr. exp Interview Questions

Please visit this link for 2 yr. exp. interview questions.

http://www.dotnetcurry.com/ShowArticle.aspx?ID=63

http://dotnetprojectninterviewquestions.blogspot.com/

Insert from one database table to another similar table

insert into database1.dbo.Table1
select * from database2.dbo.Table1

How to backup and restore database in mysql

Backup and restore database from mysql:
From Dos Command Prompt(First Go Inside-C:\Program Files\MySQL\MySQL Server 5.0\bin)
Then Fire command as like--
mysqldump -u root -psa1234 databasename > c:/databasename.sql

REstore:
mysql -u [uname] -p[pass] [db_to_restore] < c:/databasename.sql
mysql -u root -pSa1234 -D photochat < c:/photochat.sql

Implementing Paging In Repater or Datalist

aspx Page

Page:

<%# Container.DataItem %> 
C# File

public int PageNumber
{
get
{
if (ViewState["PageNumber"] != null)
return Convert.ToInt32(ViewState["PageNumber"]);
else
return 0;
}
set
{
ViewState["PageNumber"] = value;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
LoadData();
}
protected void rptPages_ItemCommand(object source, RepeaterCommandEventArgs e)
{
PageNumber = Convert.ToInt32(e.CommandArgument) - 1;
LoadData();
}
private void LoadData()
{
DataTable dt = YatraGuruBL.Interface.Methods.Help.Get();

PagedDataSource pgitems = new PagedDataSource();
DataView dv = new DataView(dt);
pgitems.DataSource = dv;
pgitems.AllowPaging = true;
pgitems.PageSize = 3;
pgitems.CurrentPageIndex = PageNumber;
if (pgitems.PageCount > 1)
{
rptPages.Visible = true;
ArrayList pages = new ArrayList();
for (int i = 0; i < pgitems.PageCount; i++)
pages.Add((i + 1).ToString());
rptPages.DataSource = pages;
rptPages.DataBind();
}
else
rptPages.Visible = false;
rptItems.DataSource = pgitems;
rptItems.DataBind();
}

Jquery Tutorial Easy way to learn jquery

Learn Jquery in a very easy manner by go to this link.You can learn it in maximum a week.

http://docs.jquery.com/Tutorials:Getting_Started_with_jQuery#Next_steps

Validate start date and end date

//.aspx page code
button1.attributes.add("onclick","return Myfunction;")

For Different date time Formats

For Different Date time Formats Please Visit the link
http://msdn.microsoft.com/en-us/library/az4se3k1.aspx