I Tried.., I Failed.., I Succeeded.., I Learnt!!!
SELECT DISTINCT Constraint_Name AS [Constraint], Table_Schema AS [Schema], Table_Name AS [TableName] FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint, SCHEMA_NAME(schema_id) AS SchemaName, OBJECT_NAME(parent_object_id) AS TableName, type_desc AS ConstraintType FROM sys.objects WHERE type_desc IN ('FOREIGN_KEY_CONSTRAINT','PRIMARY_KEY_CONSTRAINT')
SELECT TOP 100 PERCENT WITH TIES c.TABLE_NAME , COUNT(*) NumColumns FROM INFORMATION_SCHEMA.[COLUMNS ] c inner join INFORMATION_SCHEMA.[TABLES] t ON C.TABLE_SCHEMA = t.TABLE_SCHEMA and c.TABLE_NAME = T.TABLE_NAME GROUP BY c.TABLE_NAME ORDER BY c.TABLE_NAME
SELECT p.Name, v.Name FROM Production.Product p JOIN Purchasing.ProductVendor pv ON p.ProductID = pv.ProductID JOIN Purchasing.Vendor v ON pv.BusinessEntityID = v.BusinessEntityID WHERE ProductSubcategoryID = 15 ORDER BY v.Name;
GridView gv = new GridView(); gv.RowDataBound += new GridViewRowEventHandler(gv_RowDataBound);
Then We could handle the events like this:
protected void gv_RowDataBound(object sender, GridViewRowEventArgs e) { // your code }
For More Details refer these links:
http://forums.asp.net/t/1276555.aspx/1?Dynamic+Gridview+Event+Handler+not+fire+RowCommand+RowDeleting+SelectedindexChanging+
<script language="Javascript"> function checkDuplicate(objID) { //after gridbind put total row count in hidden field iRowCnt = new Number(document.getElementById("hdnRowCount").value); var iCheckedIndex; var dropDownVal; //get selectedvalue in variable var szSelVal = objID.value; for(i = 1; i <= iRowCnt; i++) { dropDownVal = document.getElementById("gvPack_ctl0" + (i + 1) + "_ddl1").value; //compare values if (szSelVal == dropDownVal) { alert("Please, given value alreay selected"); return false; } } </script>
<%@ Page Language="C#" ValidateRequest="true" AutoEventWireup="true" CodeFile="Default1.aspx.cs" Inherits="Default1" %>
function checkHTMLtags(sender, args) { var trgtId = document.getElementById("<%=txt1.ClientID%>"); var str=trgtId.value //convert to lowercase str=str.toLowerCase() //split the string by taking <br> as reference var strArray=str.split('<br>'); if (strArray.length > 0) { for(k=0;k<strArray.length;k++) { for(i=0;i<strArray[k].length;i++) { //check for the presence of < and if available check the following char //condition added to include > symbol as well if((strArray[k].charAt(i)=='<') || (strArray[k].charAt(i)=='>')) { var j=i+1; var str1=strArray[k].charAt(j); var myRegxp=/^[0-9]*$/ ; if(myRegxp.test(str1) == false) { //alert("No HTML Tags allowed in the textarea"); trgtId.focus(); args.IsValid = false; return; } } } } } args.IsValid = true; return; }
Refer This link for more Details:
http://msdn.microsoft.com/en-us/library/ff649310.aspx
<html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Google Iframe</title> </head> <body> <form id="form1" runat="server"> <td valign="top"> <div id="google_translate_element" style="text-align: left"> </div> <script> function googleTranslateElementInit() { new google.translate.TranslateElement({pageLanguage: 'en'},'google_translate_element'); } </script> <script src="http://translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"> </script> </td> Hello World. </form> </body> </html>
using java.util; using java.util.zip; using java.io;
public string ZipFile(string savePath, string[] attachFiles) { string sFlag = "Error"; try { FileOutputStream fileOutput = new FileOutputStream(savePath); ZipOutputStream zipOutput = new ZipOutputStream(fileOutput); FileInputStream fileInput = null; foreach (string file in attachFiles) { fileInput = new FileInputStream(file); ZipEntry zipEntry = new ZipEntry(Path.GetFileName(file)); zipOutput.putNextEntry(zipEntry); sbyte[] buffer = new sbyte[1024]; int len = 0; while ((len = fileInput.read(buffer)) >= 0) { zipOutput.write(buffer, 0, len); } } zipOutput.closeEntry(); fileInput.close(); zipOutput.close(); fileOutput.close(); return sFlag = "Success"; } catch (Exception) { return sFlag; } } private List<zipentry> GetZipFiles(ZipFile zipfill) { List listZip = new List(); Enumeration zipEnum = zipfill.entries(); while (zipEnum.hasMoreElements()) { ZipEntry zipEntry = (ZipEntry)zipEnum.nextElement(); listZip.Add(zipEntry); } return listZip; } public string UnZipFile(string zippedFile, string destPath) { string sFlag = "Error"; try { ZipFile zipfile = new ZipFile(zippedFile); List zipFiles = GetZipFiles(zipfile); foreach (ZipEntry zipFile in zipFiles) { if (!zipFile.isDirectory()) { InputStream s = zipfile.getInputStream(zipFile); try { Directory.CreateDirectory(destPath + "\\" + Path.GetDirectoryName(zipFile.getName())); FileOutputStream dest = new FileOutputStream(Path.Combine(destPath + "\\" + Path.GetDirectoryName(zipFile.getName()), Path.GetFileName(zipFile.getName()))); try { int len = 0; sbyte[] buffer = new sbyte[7168]; while ((len = s.read(buffer)) >= 0) { dest.write(buffer, 0, len); } } finally { dest.close(); } } finally { s.close(); } } sFlag = "Success"; } return sFlag; } catch (Exception) { return sFlag; } }
System.Uri url = Context.Request.UrlReferrer;
string RefURL = url.AbsoluteUri.ToString();
lblURL.Text = RefURL;
string url= Request.Url.GetLeftPart(UriPartial.Authority)+Request.RawUrl;
lblURL.Text =url;
private bool SearchPage(string URL, string StrToLocate) { StreamReader SR; WebResponse Resp ; WebRequest MyWebRequest; string PageStr; MyWebRequest = WebRequest.Create(URL) ; MyWebRequest.Timeout = 10000 ; try { Resp = MyWebRequest.GetResponse() ; SR = new StreamReader(Resp.GetResponseStream()) ; PageStr = SR.ReadToEnd() ; SR.Close() ; PageStr = PageStr.ToUpper(); if ( PageStr.IndexOf(StrToLocate.ToUpper(), 0, PageStr.Length) != -1 ) return true; else return false; } catch ( WebException wex ) { if (wex.Status == WebExceptionStatus.Timeout) Response.Write("The request has timed out!") ; else Response.Write("There was some exception: " + wex.Message) ; return false; } }
private string ExtractNumbers(string Expression) { string result = null; char Letter; for (int i = 0; i < Expression.Length; i++) { Letter = Convert.ToChar(Expression.Substring(i, 1)); if (Char.IsNumber(Letter)) { result += Letter.ToString(); } } lblNum.Text=result; }
DirectoryInfo dir1= new DirectoryInfo("F:\Folder1"); DirectoryInfo dir2 = new DirectoryInfo("F:\Folder2"); FileInfo[] Folder1Files = dir1.GetFiles(); if(Folder1Files.Length > 0) { foreach(FileInfo aFile in Folder1Files) { if(File.Exists("F:\Folder2" + aFile.Name)) { File.Delete("F:\Folder2" + aFile.Name); } aFile.MoveTo("F:\Folder2" + aFile.Name); } }
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.IO; public partial class Sample : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { DirectoryInfo sourcedinfo = new DirectoryInfo(@”E:\Copy”); DirectoryInfo destinfo = new DirectoryInfo(@”E:\Paste”); CopyAll(sourcedinfo, destinfo); Console.Read(); } public void CopyAll(DirectoryInfo source, DirectoryInfo target) { try { //check if the target directory exists if (Directory.Exists(target.FullName) == false) { Directory.CreateDirectory(target.FullName); } //copy all the files into the new directory foreach (FileInfo fi in source.GetFiles()) { Console.WriteLine(@”Copying {0}\{1}”, target.FullName, fi.Name); fi.CopyTo(Path.Combine(target.ToString(), fi.Name), true); } //copy all the sub directories using recursion foreach (DirectoryInfo diSourceDir in source.GetDirectories()) { DirectoryInfo nextTargetDir = target.CreateSubdirectory(diSourceDir.Name); CopyAll(diSourceDir, nextTargetDir); } Console.WriteLine(“Success”); } catch (IOException ie) { Console.WriteLine(ie.Message); } } }
void Application_Start(object Sender, EventArgs E) { // Set our user count to 0 when we start the server Application["ActiveUsers"] = 0; } void Session_Start(object Sender, EventArgs E) { Session["Start"] = DateTime.Now; Session.Timeout = 1; Application.Lock(); Application["ActiveUsers"] = (int)Application["ActiveUsers"] + 1; Application.UnLock(); } void Session_End(object Sender, EventArgs E) { Application.Lock(); Application["ActiveUsers"] = (int)Application["ActiveUsers"] - 1; Application.UnLock(); Session.Clear(); Session.Remove("Start"); }
lblCount.Text=Application["ActiveUsers"].ToString();
string[] files = GetFileList(); foreach (string file in files) { Download(file); } public string[] GetFileList() { string[] downloadFiles; StringBuilder result = new StringBuilder(); WebResponse response = null; StreamReader reader = null; try { FtpWebRequest reqFTP; reqFTP = (FtpWebRequest)FtpWebRequest.Create(new Uri("ftp://" + ftpServerIP + "/")); reqFTP.UseBinary = true; reqFTP.Credentials = new NetworkCredential(ftpUserID, ftpPassword); reqFTP.Method = WebRequestMethods.Ftp.ListDirectory; reqFTP.Proxy = null; reqFTP.KeepAlive = false; reqFTP.UsePassive = false; response = reqFTP.GetResponse(); reader = new StreamReader(response.GetResponseStream()); string line = reader.ReadLine(); while (line != null) { result.Append(line); result.Append("\n"); line = reader.ReadLine(); } // to remove the trailing '\n' result.Remove(result.ToString().LastIndexOf('\n'), 1); return result.ToString().Split('\n'); } catch (Exception ex) { if (reader != null) { reader.Close(); } if (response != null) { response.Close(); } downloadFiles = null; return downloadFiles; } }
private void Download(string file) { try { string uri = "ftp://" + ftpServerIP + "/" + remoteDir + "/" + file; Uri serverUri = new Uri(uri); if (serverUri.Scheme != Uri.UriSchemeFtp) { return; } FtpWebRequest reqFTP; reqFTP = (FtpWebRequest)FtpWebRequest.Create(new Uri("ftp://" + ftpServerIP + "/" + remoteDir + "/" + file)); reqFTP.Credentials = new NetworkCredential(ftpUserID, ftpPassword); reqFTP.KeepAlive = false; reqFTP.Method = WebRequestMethods.Ftp.DownloadFile; reqFTP.UseBinary = true; reqFTP.Proxy = null; reqFTP.UsePassive = false; FtpWebResponse response = (FtpWebResponse)reqFTP.GetResponse(); Stream responseStream = response.GetResponseStream(); FileStream writeStream = new FileStream(localDestnDir + "\" + file, FileMode.Create); int Length = 2048; Byte[] buffer = new Byte[Length]; int bytesRead = responseStream.Read(buffer, 0, Length); while (bytesRead > 0) { writeStream.Write(buffer, 0, bytesRead); bytesRead = responseStream.Read(buffer, 0, Length); } writeStream.Close(); response.Close(); } catch (WebException wEx) { MessageBox.Show(wEx.Message, "Download Error"); } catch (Exception ex) { MessageBox.Show(ex.Message, "Download Error"); } }
using System; using System.IO; using System.Net; using System.Text; namespace Examples.System.Net { public class WebRequestGetExample { public static void Main () { // Get the object used to communicate with the server. FtpWebRequest request = (FtpWebRequest)WebRequest.Create("ftp://www.contoso.com/"); request.Method = WebRequestMethods.Ftp.ListDirectoryDetails; // This example assumes the FTP site uses anonymous logon. request.Credentials = new NetworkCredential ("anonymous","janeDoe@contoso.com"); FtpWebResponse response = (FtpWebResponse)request.GetResponse(); Stream responseStream = response.GetResponseStream(); StreamReader reader = new StreamReader(responseStream); Console.WriteLine(reader.ReadToEnd()); Console.WriteLine("Directory List Complete, status {0}", response.StatusDescription); reader.Close(); response.Close(); } } }
document.forms[0].Textbox1.focus();
document.getElementById("Textbox1").focus();
Page.RegisterStartupScript("SetFocus", "<script language=""Jscript"" > document.getElementById(""Textbox1"").focus(); </Script>");
< script > function closeMe() { var win = window.open("","_self"); /* url = "" or "about:blank"; target="_self" */ win.close(); } < /script > < input type="button" name="CloseMe" value="Close Me" onclick="closeMe()" />
btnNew.Attributes.Add("onclick", " this.disabled = true; " + ClientScript.GetPostBackEventReference(btnNew, null) + ";");
btnNew.Attributes.Add("onclick", " this.disabled = true; " + ClientScript.GetPostBackEventReference(btnNew, Nothing) + ";")
string str_Path = Server.MapPath(".") + "\\execute.bat";
string str_Path = Server.MapPath(".") + "\\execute.bat";
ProcessStartInfo processInfo = new ProcessStartInfo(str_Path);
processInfo.UseShellExecute = false;
Process batchProcess = new Process();
batchProcess.StartInfo = processInfo;
batchProcess.Start();
public static void emas(string text) { const string MatchEmailPattern = @"(([\w-]+\.)+[\w-]+|([a-zA-Z]{1}|[\w-]{2,}))@" + @"((([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])\. ([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])\." + @"([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])\. ([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])){1}|" + @"([a-zA-Z]+[\w-]+\.)+[a-zA-Z]{2,4})"; Regex rx = new Regex(MatchEmailPattern, RegexOptions.Compiled |RegexOptions.IgnoreCase); // Find matches. MatchCollection matches = rx.Matches(text); // Report the number of matches found. int noOfMatches = matches.Count; // Report on each match. foreach (Match match in matches) { Console.WriteLine(match.Value.ToString()); } }
Alternatively,You can Use this fuction as well: using System.IO; using System.Text.RegularExpressions; using System.Text; class MailExtracter { public static void ExtractEmails(string inFilePath, string outFilePath) { string data = File.ReadAllText(inFilePath); //read File //instantiate with this pattern Regex emailRegex = new Regex(@"\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*", RegexOptions.IgnoreCase); //find items that matches with our pattern MatchCollection emailMatches = emailRegex.Matches(data); StringBuilder sb = new StringBuilder(); foreach (Match emailMatch in emailMatches) { sb.AppendLine(emailMatch.Value); } //store to file File.WriteAllText(outFilePath, sb.ToString()); } }
<script language="javascript"> function RefreshParent() { window.parent.location.href = window.parent.location.href; } </script>
Page.RegisterStartupScript("RefreshParent","<script language='javascript'>RefreshParent()</script>");
