ASP.NET Regular Expression For Replacing Invalid Characters
Method 1
Names = Regex.Replace(txtName.Text, "[^A-Za-z0-9]+", "");
Method 2
Names = Regex.Replace(txtName.Text, "[\w", "");
These Regular Expressions can be used for Replacing Invalid Characters in a string.
SQL Query examples Date-Time Difference
SQL example 1:
select checkindate, isnull(sum(lessthan2), 0) as lessthan2, isnull(sum(Gt2Lt5), 0) as Gt2Lt5, isnull(sum(Gt5Lt10), 0) as Gt5Lt10, isnull(sum(Gt10Lt15), 0) as Gt10Lt15, isnull(sum(Gt15), 0) as Gt15, sum(mins),sum(mins)/(isnull(sum(lessthan2), 0)+isnull(sum(Gt2Lt5), 0)+isnull(sum(Gt5Lt10), 0)+isnull(sum(Gt10Lt15), 0)+isnull(sum(Gt15), 0)) as Mins
from
(
select checkindate, mins,
'lessthan2'=
CASE
WHEN mins >= 0 and mins <>= 2 and mins <>= 5 and mins <>= 10 and mins <>= 15 THEN gt15+1
END
from
(
select lt2=0,lt5=0,lt10=0,lt15=0,gt15=0,checkindate,mins = cast(replace(datediff(mi,logintime,checkintime)%60,'-','') as Int) from tblactivity where (logintime<>'' and checkintime<>'' and checkindate between cast('01/01/2006' as datetime) and cast('07/01/2006' as datetime))
)a
)b group by checkindate
SQL example 2: Time difference calculation
select cast(datediff(mi,'11:00 AM','7:10 PM')/60 as varchar(10))+':'+cast(datediff(mi,'11:00 AM','7:10 PM')%60 as varchar(10))+':00'
SQL example 3: Time difference calculation
select CT,ST,
Mins =cast(replace(datediff(mi,CT,ST)%60,'-','') as varchar(10)),'Hours'=
CASE
WHEN cast(replace(datediff(mi,CT,ST)/60,'-','')as int) < st="substring(flags,charindex('calledforservicetime_flag'," ct="checkintime">''
More SQL Server Examples @: http://silvernight.wordpress.com/
Calling Javascript from C#, Calling Javascript from Codebehind
We can use the following two methods to access Java Script from C#
Page.ClientScript.RegisterStartupScript() Method
Page.ClientScript.RegisterClientScriptBlock() Method
Eg:
string script = "< LANGUAGE='JavaScript'> ";
script += "ApptConfirm()";
script += "</SCRIPT>";
// We use RegisterStartupScript, so that this script is executed after all form elements are rendered.
Page.RegisterStartupScript("ClientScript", script);
loading csv file to SQL Server
CREATE TABLE CSVTest
(FirstName VARCHAR(40),
No1 INT,No2 INT,No3 INT,No4 INT)
GO
select * from CSVTest
BULK
INSERT CSVTest
FROM 'd:\Tesing.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO
select * from CSVTest
If there is a error in a particular row that row will not be added.
rest of the rows will be loaded into sql server.
.csv file
vijay,20,19999,90000,8
Jagadeesh,9,111,60000,9
<script language="javascript" src="script/ReasonForVisit.js">
or in aspx page
function setmessage()
{
if(language=='english'){
document.getElementById('header1').innerHTML="No Records found.";
document.getElementById('span1').innerHTML="We are unable to find
your records.";
}
else{
document.getElementById('header1').innerHTML="No Records found.";
document.getElementById('span1').innerHTML="We are unable to find
your records.";
}
}
.aspx pages
<table style="width: 100%;" border="0" cellpadding="0" cellspacing="0" id="Table1">
<tr align="center">
<td id="header1">
</td>
</tr>
<tr align="center">
<td id="span1">
</td>
</tr>
</table>
Using Session Variables in JavaScript - ASP.NET, C#
var apptMultiple ='<%= Session["multipleAppointments"]%>';
function SetRelationOnForm(){
var relation = '<%=Session["consentrelationshipToPatient"] %>';
var isPat = '<%=Session["consentSelIsPatient"] %>';
var isPatRep = '<%=Session["consentIsPatientRepresentative"] %>';
}
Getting Client Host name using Java Script
function GetComputerName()
{
try
{
var WshNetwork = new ActiveXObject("WScript.Network");
var hostname = WshNetwork.ComputerName.toLowerCase(); document.getElementById('HdnMachineId').value = hostname;
}
catch(err)
{ }
}
Getting Client Host name using C#
private string getClientHostName()
{
// Get HostName of client computer
string hostname = HttpContext.Current.Request.ServerVariables["REMOTE_HOST"].ToString().ToLower();
try
{
System.Net.IPHostEntry host = System.Net.Dns.GetHostByAddress(hostname);
hostname = host.HostName;
}
catch(Exception exp)
{
}
return hostname;
}
Previewing image while opening
We can use the following code to preview an image while opening it using ASP.NET, C#, Java script.
<SCRIPT>
var lastfieldname = ''
function preview(i)
{
var file = i.value
if (file.length<=0) return;
var ipreview = document.all('ipreview')
ipreview.src ='file://' + file
}
img id="ipreview" border="1" height="120" src="images/spacer.gif" /><br />
adjust image:
<input id="fotofp" runat="server" name="file1" onchange="preview(this)" onfocus="preview(this)" size="25" type="file" />
Firefox 3.0 Sets Guinness World Record for Most Software Downloaded in 24 Hours
Today 17 June, 2008 the most popular web browser Firefox Version 3 is released.
At present Firefox share in web browsing is 15% of Internet users. The release of Firefox 3.0 would further boost its market share.
New features in Firefox Version 3 include automatic warnings when users stray onto webpages booby-trapped with malicious code.
Also in Firefox 3.0 will be "Smart Location Bar" that lets people return to places they have visited even if they have not bookmarked them or cannot remember the full web address.
Firefox 3.0 will work with Windows 2000, XP and Vista and some non-Windows operating systems including Linux.
Updating Access Database using Asp.Net Gridview - AccessDataSource, UpdateCommand
We can use the following code to update Access Database using Asp.Net Gridview...
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
DataKeyNames="ID" DataSourceID="AccessDataSource1" AutoGenerateDeleteButton="true" AutoGenerateEditButton="true" ForeColor="#333333" GridLines="None">
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" />
<asp:BoundField DataField="Country" HeaderText="Country" SortExpression="Country" />
</Columns>
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/mReachTV_DB.mdb"
SelectCommand="SELECT [ID], [Country] FROM [TV_Streams]"
UpdateCommand="UPDATE [TV_Streams] SET [Country] = @Country WHERE [ID] = @ID">
</asp:AccessDataSource>
Is it Looking similar to the code you had written??
Thats where the trick is... The number of parameters in Select and Update command should be equal.
{
StringBuilder sb = new StringBuilder();
sb.Append("<script type='text/javascript'>");
sb.Append("alert('New Password is Create');");
if (Session["flag"].ToString() == "L")
{
sb.Append("window.location = 'loginpage.aspx';");
}
sb.Append("");
Page.RegisterClientScriptBlock("mes", sb.ToString());
}----------------------------------------------------------------------------------------Page.ClientScript.RegisterStartupScript(this.GetType(), "myAlertBox", "alert('New Password is Created'); window.location = 'loginpage.aspx';", true);
or
ClientScript.RegisterClientScriptBlock(this.GetType(), "myAlertBox", "alert('New Password is Created'); window.location = 'loginpage.aspx';", true);
----------------------------------------------------------------------------------------
For POP Ups:
We can use Javascript function window.Open or target="_blank" for popups.
If we want to open a popup in form another popup window? we can use Java script function window.location.
------------------------------------------------------------------------
Another Method to Display Message boxes in ASP.NET
protected void btnSubmit_Click(object sender, EventArgs e) {
string script = "alert('Are U sure? ');";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Test", script, true);}
------------------------------------------------------------------------ Another Method to Display Message boxes in ASP.NET
<asp:Button ID="button1" OnClientClick="return confirm('Are you sure?');" runat="server" />
or
<asp:LinkButton
ID="ibtnDelete"
runat="server"
Text="Delete"
CommandName="Delete"
OnClientClick="javascript:return confirm('Are you sure you want to delete this class?');">
</asp:LinkButton>
We can use the following code to restrict the File upload size using Asp.Net, C#.
protected void btnUpload_Click(object sender, System.EventArgs e)
{
string fileName = FileSelector.PostedFile.FileName;
int fN = fileName.LastIndexOf("\\");
string newFileName = fileName.Substring(fN).ToLower();
if (newFileName.EndsWith(".m4v") || newFileName.EndsWith(".mp3") || newFileName.EndsWith(".mp4") || newFileName.EndsWith(".mov"))
{
if (this.FileSelector.PostedFile.ContentLength < 210000)
{
FileSelector.PostedFile.SaveAs(
Server.MapPath("../audioFiles/") + newFileName);
lblWarn.Text = "File uploaded";
lblWarn.ForeColor = System.Drawing.Color.Green;
lblWarn.Visible = true;
}
else
{
lblWarn.Text = "File cannot exceed 350MB";
lblWarn.Visible = true;
lblWarn.ForeColor = System.Drawing.Color.Red;
}
}
else
{
lblWarn.Text = "Only extensions .m4v, .mp4, mp3, or .mov";
lblWarn.Visible = true;
lblWarn.ForeColor = System.Drawing.Color.Red;
}
}
Also default upload limit is 4MB in asp.net. You can change this value in ur web.config file.
<httpRuntime maxRequestLength="210000"/> Include this in your webconfig file in the system.web section You can also use FileUpload1.PostedFile.ContentLength to calculate the length of the file after it is uploaded to server.
protected void Button1_Click(object sender, EventArgs e)
{
string fileFullname = this.File1.PostedFile.FileName;
if (File1.PostedFile.ContentType.ToUpper().IndexOf("IMAGE") > -1)
{
System.Drawing.Image img = System.Drawing.Image.FromStream(File1.PostedFile.InputStream);
int Width = img.Width;
int Height = img.Height;
if (Width > 200 || Height > 200 || File1.PostedFile.ContentLength > 1024 * 1024 * 200)
{
Response.Write("<script language='javascript'>alert('your image don not confirm the with and height.!');</script>");
}
else
{
if (type == "jpg" || type == "gif" || type == "bmp" || type == "JPG" || type == "GIF")
{
string sPath = Server.MapPath("images/") + dataName + fileName;
string imgPath = "pic/" + dataName + fileName;
this.File1.PostedFile.SaveAs(sPath);
Response.Write("<script language='javascript'>alert('suceed!!!');</script>");
this.Image1.ImageUrl = imgPath;
this.Button1.Enabled = false;
this.Button1.Text = "suceed!";
this.Button1.Enabled = true;
}
else
{
Response.Write("<script language='javascript'>alert('your file type wrong!');</script>");
}
}
}
else
{
Response.Write("<script language='javascript'>alert('please choice the image to upload!');</script>");
}
}
Here is a FREE web service that will give you Country information from IP address.
http://www.webservicex.net/WS/WSDetails.aspx?WSID=64&CATID=12
You can use the following three ways to get the client IP address using C#
string test = Request.UserHostAddress.ToString();
string test2 = Request.ServerVariables["REMOTE_ADDR"].ToString();
string test3 = Context.Request.UserHostAddress.ToString();
<form id="form1" runat="server">
<asp:Menu
ID="Menu1"
Width="168px"
runat="server"
Orientation="Horizontal"
StaticEnableDefaultPopOutImage="False"
OnMenuItemClick="Menu1_MenuItemClick">
<Items>
<asp:MenuItem ImageUrl="~/selectedtab.gif"
Text=" " Value="0"></asp:MenuItem>
<asp:MenuItem ImageUrl="~/unselectedtab.gif"
Text=" " Value="1"></asp:MenuItem>
<asp:MenuItem ImageUrl="~/unselectedtab.gif"
Text=" " Value="2"></asp:MenuItem>
</Items>
</asp:Menu>
<div><PRE lang=html id=pre1 style="MARGIN-TOP: 0px" nd="35">
<asp:MultiView
ID="MultiView1"
runat="server"
ActiveViewIndex="0" ><asp:View ID="Tab1" runat="server" ><table width="600" height="400" cellpadding=0 cellspacing=0><tr valign="top"><td class="TabArea" style="width: 600px"><br /><br />TAB VIEW 1 INSERT YOUR CONENT IN HERE CHANGE SELECTED IMAGE URL AS NECESSARY </td></tr></table></asp:View> <asp:View ID="Tab2" runat="server">
<table width="600px" height="400px" cellpadding=0 cellspacing=0>
<tr valign="top">
<td class="TabArea" style="width: 600px">
<br />
<br />
TAB VIEW 2
INSERT YOUR CONENT IN HERE
CHANGE SELECTED IMAGE URL AS NECESSARY
</td>
</tr>
</table>
</asp:View> <asp:View ID="Tab3" runat="server">
<table width="600px" height="400px" cellpadding=0 cellspacing=0>
<tr valign="top">
<td class="TabArea" style="width: 600px">
<br />
<br />
<asp:Menu
ID="Menu2"
Width="168px"
runat="server"
Orientation="Horizontal"
StaticEnableDefaultPopOutImage="False"
OnMenuItemClick="Menu2_MenuItemClick">
<Items>
<asp:MenuItem ImageUrl="~/selectedtab.gif"
Text=" " Value="0"></asp:MenuItem>
<asp:MenuItem ImageUrl="~/unselectedtab.gif"
Text=" " Value="1"></asp:MenuItem>
<asp:MenuItem ImageUrl="~/unselectedtab.gif"
Text=" " Value="2"></asp:MenuItem>
</Items>
</asp:Menu>
<div><PRE lang=html id=pre2 style="MARGIN-TOP: 0px" nd="35"><asp:MultiView
ID="MultiView2"
runat="server"
ActiveViewIndex="0" >
<asp:View ID="View1" runat="server" >
<table width="600" height="400" cellpadding=0 cellspacing=0>
<tr valign="top">
<td class="TabArea" style="width: 600px">
<br />
<br />
TAB VIEW 1
INSERT YOUR CONENT IN HERE
CHANGE SELECTED IMAGE URL AS NECESSARY
</td>
</tr>
</table>
</asp:View>
<asp:View ID="View2" runat="server">
<table width="600px" height="400px" cellpadding=0 cellspacing=0>
<tr valign="top">
<td class="TabArea" style="width: 600px">
<br />
<br />
TAB VIEW 2
INSERT YOUR CONENT IN HERE
CHANGE SELECTED IMAGE URL AS NECESSARY
</td>
</tr>
</table>
</asp:View>
<asp:View ID="View3" runat="server">
<table width="600px" height="400px" cellpadding=0 cellspacing=0>
<tr valign="top">
<td class="TabArea" style="width: 600px">
<br />
<br />
TAB VIEW 3
INSERT YOUR CONENT IN HERE
CHANGE SELECTED IMAGE URL AS NECESSARY
</td>
</tr>
</table>
</asp:View>
</asp:MultiView>
</td>
</tr>
</table>
</asp:View></asp:MultiView></PRE></div>
</form>
In C#
protected void Menu1_MenuItemClick(object sender, MenuEventArgs e)
{
MultiView1.ActiveViewIndex = Int32.Parse(e.Item.Value);
int i;
// Make the selected menu item reflect the correct imageurl
for (i = 0; (i <= (Menu1.Items.Count - 1)); i++)
{
if (e.Item.Value.Equals(i+""))
{
Menu1.Items[i].ImageUrl = "selectedtab.gif";
}
else
{
Menu1.Items[i].ImageUrl = "unselectedtab.gif";
}
}
}
protected void Menu2_MenuItemClick(object sender, MenuEventArgs e)
{
MultiView2.ActiveViewIndex = Int32.Parse(e.Item.Value);
int i;
// Make the selected menu item reflect the correct imageurl
for (i = 0; (i <= (Menu1.Items.Count - 1)); i++)
{
if (e.Item.Value.Equals(i + ""))
{
Menu2.Items[i].ImageUrl = "selectedtab.gif";
}
else
{
Menu2.Items[i].ImageUrl = "unselectedtab.gif";
}
}
Here is the code for that in VB.NET:
On the page load or button click or whatever you want to run the report on you need to add the following: configureCRYSTALREPORT()
Private Sub configureCRYSTALREPORT()
Dim myConnectionInfo As New ConnectionInfo()
myConnectionInfo.DatabaseName = "DatabserName"
myConnectionInfo.UserID = "UID"
myConnectionInfo.Password = "PWD"
setDBLOGONforREPORT(myConnectionInfo)
End Sub
Private Sub setDBLOGONforREPORT(ByVal myconnectioninfo As ConnectionInfo)
Dim mytableloginfos As New TableLogOnInfos()
mytableloginfos = CrystalReportViewer1.LogOnInfo
For Each myTableLogOnInfo As TableLogOnInfo In mytableloginfos
myTableLogOnInfo.ConnectionInfo = myconnectioninfo
Next
End Sub
-------------------------------------------------------------------------------------------------------------------------------------------------
Here is the code for that in C#:
private void setDBLOGONforREPORT(ConnectionInfo myconnectioninfo)
{
TableLogOnInfos mytableloginfos = new TableLogOnInfos();
mytableloginfos = CrystalReportViewer1.LogOnInfo;
foreach (TableLogOnInfo myTableLogOnInfo in mytableloginfos)
{
myTableLogOnInfo.ConnectionInfo = myconnectioninfo;
}
}
In Page Load....
ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.ServerName = "serverName";
myConnectionInfo.DatabaseName = "DatabaseName";
myConnectionInfo.UserID = "sa";
myConnectionInfo.Password = "pwd";
setDBLOGONforREPORT(myConnectionInfo);
We can use client-side script (JS) for this purpose...<input type="button" value="Click here to go back" onclick="javascript: return history.back();" />
or
<input type="button" value="Click here to go back" onclick="javascript: return history.go(-1);" />
javascript: return history.go(-1);
or
http://www.aspdotnetfaq.com/Faq/How-to-make-Cross-Page-Postback-in-ASP-Net.aspx
Its simple to use HTML tags in Code behind and display in ASP.NET web pages....
Method 1:
in .cs page
string t = txtBody.Text;
MyEmailBody.InnerHtml = Server.HtmlDecode(t);
in .aspx page
<div id="MyEmailBody" runat="server"></div>
It may some times require to change the ValidateRequest="false".
Method 2:
we can use Literal controls, to view HTML tags in .aspx pages from code behind.
in . aspx page
<asp:Literal runat="server"></asp:Literal>
in .cs page
this.Controls.Add(new LiteralControl("<b>This is Bold</b>"));
Hope this helps you in using HTML tags in codebehind.
Today I found these useful links that helps us to embed the images in the HTML emails we are sending using ASP.NET & C#. You can download the example code of sending HTML emails using ASP.NET here... http://www.asp101.com/Samples/email_html_aspx.asp http://download.microsoft.com/download/d/f/c/dfc7a022-3426-4868-b23c-3818a6e54305/HtmlEmail.zip
Simple HTML Format emails::
private void SendClick() {
MailMessage mailMsg = new MailMessage();
try {
mailMsg.To = "
mailMsg.From = "
mailMsg.BodyFormat = MailFormat.Html;
mailMsg.Subject = "Statistics Report";
mailMsg.Body ="content";
SmtpMail.SmtpServer ="serverHost";
SmtpMail.Send(mailMsg);
}
catch (Exception ex) {
Response.Write(ex.Message);
}
}
To have a basic idea of mailing with an embedded image or object from ASP.NET 2.0 using SMTP Client. You can visit the following links...
http://aspalliance.com/1354_Sending_HTML_Mail_with_Embedded_Image_in_NET.8
http://www.codeproject.com/kb/IP/EmailByjebarson.aspx
http://www.codeproject.com/KB/aspnet/inkrajesh.aspx
For sending mails from asp.net, C# Using System.Web.Mail name space.
using System.Web.Mail;
public static string SendMail(int pintUserID, string pstrMailTo, string pstrMailBcc,string pstrMailCc,string pstrMailSubject,string pstrMailBody,string pstrAttachFilePath){
try
{
MailMessage objMail = new MailMessage();objMail.From = System.Configuration.ConfigurationSettings.AppSettings["FromEmailID"];
//objMail.From =System.Web.HttpContext.Current.Session["OfficeEmailID"].ToString() ;
objMail.To = pstrMailTo;
objMail.Bcc = pstrMailBcc;
objMail.Cc = pstrMailCc;
objMail.Subject = pstrMailSubject;
MailAttachment Attachment = null;if (File.Exists(pstrAttachFilePath)){
Attachment = new MailAttachment(pstrAttachFilePath);}
objMail.Attachments.Add(Attachment);
SmtpMail.SmtpServer = "localhost";//System.Configuration.ConfigurationSettings.AppSettings["SMTPServerIP"];
SmtpMail.Send(objMail);return "TRUE";}
catch(Exception Ex){
return Ex.Message;}
}
In Config file
<add key="SMTPServerIP" value="192.168.1.11"> </add>
Call this function SendMail & enable your system SMTP server.
Useful links for sending email
http://www.asp101.com/Samples/email_html_aspx.asp
http://download.microsoft.com/download/d/f/c/dfc7a022-3426-4868-b23c-3818a6e54305/HtmlEmail.ziphttp://www.codeproject.com/KB/aspnet/Email_Sending_Programme.aspx
To embed flash and videos we can use simple HTML embed tag for this purpose.
For example.
<embed src="images/flash02.swf" quality="high" bgcolor="#ffffff" width="775" height="24" name="flash" align="middle" allowScriptAccess="sameDomain" allowFullScreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />
enables us to display flash files in Asp.net web pages.
Using JavaScript to display flash in Webpages.
1. <script type="text/javascript" src="FlashSwfObject.js"></script>
Use div tag where you want to display the SWF, use a unique id:
We can instantiate the FlashSwfObject using below code.
<div id="flashbanner">Your SWF will display here!!.</div>
<script type="text/javascript">
var so = new SWFObject('MyMedia.swf','mpl','300','250','7');
so.addParam('allowfullscreen','true');
so.addVariable('file','playlist.xml');
so.addVariable('backcolor','0x000000');
so.addVariable('autostart','true');
so.write('flashbanner');
</script>
The following code helps us to Resize images and display them as thumbnails dynamically using ASP.NET C#.
protected void Page_Load(object sender, EventArgs e)
{
string BasePath = Server.MapPath(".");
Bitmap Img, ImgTemp;
ImgTemp = new Bitmap(BasePath + "\\images\\Balaji.jpg");
Img = new Bitmap(ImgTemp, 200, 300);
Graphics Graph;
Graph = Graphics.FromImage(Img);
Img.Save(Response.OutputStream, ImageFormat.Jpeg);
Graph.DrawImage(Img, 0, 0);
ImgTemp.Dispose();
Img.Dispose();
}
This function helps us to set the height and width of the new image Bitmap(ImgTemp, 200, 300);
Localization/Globalization
XML
Project Management
UML
SQL SERVER
ADO.NET
.NET Architecture
ASP.NET Interview questions and Answers
