Showing messagebox like yes , no in vb.net and proceed if yes else exit ..
Dim button As DialogResult
button = MessageBox.Show _
("Are you sure you want to exit this application?", _
"Message", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1)
If button = Windows.Forms.DialogResult.Yes Then
Me.Close()
Else
'Do Nothing
End If
Here the number of way to show the date ie: extract from the SQL query
select convert(varchar,getdate(),101) OutPut:- 06/18/2008 select convert(varchar,getdate(),102) OutPut:- 2008.06.18 select convert(varchar,getdate(),103) OutPut:- 18/06/2008 select convert(varchar,getdate(),104) OutPut:- 18.06.2008 select convert(varchar,getdate(),105) OutPut:- 18-06-2008 select convert(varchar,getdate(),106) OutPut:- 18 Jun 2008 select convert(varchar,getdate(),107) OutPut:- Jun 18, 2008 select convert(varchar,getdate(),108) OutPut:- 10:53:20 select convert(varchar,getdate(),109) OutPut:- Jun 18 2008 10:53:30:507AM select convert(varchar,getdate(),110) OutPut:- 06-18-2008 select convert(varchar,getdate(),111) OutPut:- 2008/06/18 select convert(varchar,getdate(),112) OutPut:- 20080618 select convert(varchar,getdate(),113) OutPut:- 18 Jun 2008 10:54:01:253 select convert(varchar,getdate(),114) OutPut:- 10:54:08:473 select convert(varchar,getdate(),120)) OutPut:- 2008-06-18 10:54:15For Further Reference : http://www.sql-server-helper.com/tips/date-formats.aspx
Hi, if you got error like this..Could not load file or Assembly for While you adding AjaxToolkit.dll
You have update your ajaxtoolkit from Codeplex.com
Here the link
http://www.codeplex.com/AjaxControlToolkit/Release/ProjectReleases.aspx?ReleaseId=8513
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
If Not IsPostBack Then
Session("CheckRefresh") = Server.UrlDecode(System.DateTime.Now.ToString())
End If
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs)
If Session("CheckRefresh").ToString() = ViewState("CheckRefresh").ToString() Then
Label1.Text = "Hello"
Session("CheckRefresh") = Server.UrlDecode(System.DateTime.Now.ToString())
Else
Label1.Text = "Page Refreshed"
End If
End Sub
Protected Sub Page_PreRender(ByVal sender As Object, ByVal e As EventArgs)
ViewState("CheckRefresh") = Session("CheckRefresh")
End Sub
This is code for C#.NETprotected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Session["CheckRefresh"] = Server.UrlDecode(System.DateTime.Now.ToString());
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Session["CheckRefresh"].ToString() == ViewState["CheckRefresh"].ToString())
{
Label1.Text = "Hello";
Session["CheckRefresh"] = Server.UrlDecode(System.DateTime.Now.ToString());
}
else
{
Label1.Text = "Page Refreshed";
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
ViewState["CheckRefresh"] = Session["CheckRefresh"];
}
Posts
All Comments
