Many of times we requires to get list of all name of files and folder which exists on remote server.
To get list of File and Folder names from Remote Directory / Remote Server public void getDirList()
{
FtpWebRequest _lsDirFtp;
_lsDirFtp = (FtpWebRequest)FtpWebRequest.Create("ftp://myFTPIPorName//MyDirecoty/");
_lsDirFtp.KeepAlive = false;
_lsDirFtp.Credentials = new NetworkCredential("username",...
Friday, December 10, 2010
The remote server returned an error: (503) Bad sequence of commands.
While working with FTP some times you gets this error "The remote server returned an error: (503) Bad sequence of commands." to resolve it just do set
_request.KeepAlive = false;
actually by default it keeps your ftp request connection open even your work is done.but when we will set its KeepAlive to false so now it will not give you the error again.
Solution By: Rajesh Rol...
Thursday, December 9, 2010
How to upload / download / delete file using FTP in asp.net / vb.net
We can easily upload or download files from FTP using asp.net/vb.net:
To Upload file to FTP/Remote Server using VB.NET Protected Sub btnUploadFile_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim myFtpWebRequest As FtpWebRequest
Dim myFtpWebResponse As FtpWebResponse
Dim myStreamWriter As StreamWriter
myFtpWebRequest = WebRequest.Create("ftp://ftp_server_name/filename.ext")
'myFtpWebRequest.Credentials = New...
Wednesday, December 8, 2010
How to show immediate window.
Some times in visual studio the immediate window gets disappeared.
to get it just press: ctrl+alt+I and its done..
Solution by Rajesh Rol...
Friday, December 3, 2010
How to set PopUp Window size of current Page
To change height and width of current window we can use resizeTo function like:
window.resizeTo(iWidth, iHeight)
Solution By Rajesh Rol...
Thursday, December 2, 2010
Send file on FTP using .net
To send a file over FTP using asp.net / c#.net / vb.net :
using System.Net;
public void ftpfile(string ftpfilepath, string inputfilepath)
{
string ftphost = "122.22.1.1"; // destination IP address
string ftpfullpath = "ftp://" + ftphost + ftpfilepath;
FtpWebRequest ftp = (FtpWebRequest)FtpWebRequest.Create(ftpfullpath);
ftp.Credentials = new NetworkCredential("userid", "password");
...
Friday, November 26, 2010
Rebuild index of complete database
for maintaining performance of queries we need to rebuild indexes so below is the way we can use to rebuild all indexes of complete database so we need not to rebuild indexes of all tables one by one.DECLARE @TableName varchar(255)DECLARE TableCursor CURSOR FORSELECT table_name FROM information_schema.tablesWHERE table_type = 'base table'OPEN TableCursorFETCH NEXT FROM TableCursor INTO @TableNameWHILE @@FETCH_STATUS = 0BEGINDBCC...
Remove Scripts from database/ Remove Sql Injections
USE [DBFORUMSNEW]GO/****** Object: StoredProcedure [dbo].[sp_sqlinjection] Script Date: 11/26/2010 19:46:09 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER Procedure [dbo].[sp_sqlinjection] @DBName varchar(100) as Begin declare @DB_Name varchar(40), @Table_Name varchar(40),@Column_Name varchar(40) declare @sql1 varchar(1000), @sql2 varchar(1000)Set @DB_Name = @DBName begin exec ('use ' + @Db_Name) DECLARE...
Friday, November 12, 2010
What is Bookmarklet / what is use of Bookmarklet
Each bookmarklet is a tiny program (a JavaScript application) contained in a bookmark (the URL is a "javascript:" URL) which can be saved and used the same way you use normal bookmarks. The idea was suggested in the Netscape JavaScript Guide.JavaScript has been used by page authors on millions of webpages; Bookmarklets allow anybody to use JavaScript - on whatever page you choose (not just your own page). so A bookmarklet is...
FileUploader in asp.net MVC2
as we all know ASP.NET MVC sits on top of ASP.NET. That means ASP.NET MVC didn't do any special work for File Upload support. It uses whatever stuff is built into ASP.NET itself. So the core process is still same for file upload:below is code for viewCode for how to Upload file in ASP.NET MVC2< %@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage" % > < asp:Content...
Wednesday, November 10, 2010
difference between exec and sp_executeSql
both are used for executing dynamic sql in sql server.both are not preferred because, If we are using dynamic sql in stored procedure, SQL Server may not use the execution plan. It will recreate the execution plan every time with different string of SQL.So, we have to think about the performance while using dynamic sql.Main Difference:Exec is non parametrizedsp_executeSql is parametrizedthe main difference between above two is...
what is cls compliant code
cls compliant is mostly used when we wants our dll or any other code to be used by other language which are supported by .net.lets say we wants to create a library in c# which we wants to be use in c# , vb.net , visual c++ or any other such languages. so for that we will have to create it as a cls compliant so that it can be consumed by all other .net supported language.You can apply the CLSCompliant attribute on a class, an...
How to refresh view when table structure got changed
Lets we have got a table named tblstudent which contains following fieldsstudentRNo, studentName, StudentAddressnow we have create a view on it like:create view viewNameasselect * from tblstudentnow when we will perform select operation on view then it will show us columns:select * from viewNameoutput:studentRNo, studentName, StudentAddressnow we have added a new column to tblstudent named 'studentFee' alter table tblstudent...
Monday, November 1, 2010
Gridview with master-slave data
some times we wants to show gridview with master-child data. so that on click of master the details should be shown in child.To do so here is a very good article:http://www.progtalk.com/viewarticle.aspx?articleid=...
Sunday, October 31, 2010
How to add attributes with controls in MVC2
this is how we can add attributes with HTML controls in MVC2 :< %: Html.TextBox("txtfind", null, new { @maxlength = "5", @class = "findInput" })% >in above sample we are setting max length property of textbox to 5 and adding its css class name "findinput".Solutions By:Rajesh Rol...
Friday, October 29, 2010
Disable Trigger
To disable the trigger use this syntex:DISABLE TRIGGER triggerName ON TableName;To disable all triggers of available server:DISABLE Trigger ALL ON ALL SERVERSolutions By:Rajesh Rol...
Rebuild index while insert/update is also available
Some times we face such a situation that we have data in GB of size and we want to rebuild our index which is applied on that table. but in previous editions from MS-Sql server2005 this was not possible to provide insert/update facility while performing rebuild index operation.but from sql server2005 we have got this very good facility to make insert/update available (working) while rebuild index is under progress.to do so the...
Remove interger values from string variable
To remove integer values from string you can use regular expression like this: string result = Regex.Replace(stringValue, @"\d", "");Solutions by: Rajesh Rol...
Thursday, October 28, 2010
Import data from .csv to sql
to import data from .csv file to sql server you can use below query.BULK INSERT ZIPCodes FROM 'e:\yourCSVFileName.csv' WITH ( FIRSTROW = 2 , FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ...
Extract url from string
To extract URL from a string you can use below javascript functions:function parseUrl1(data) {var e=/^((http|ftp):\/)?\/?([^:\/\s]+)((\/\w+)*\/)([\w\-\.]+\.[^#?\s]+)(#[\w\-]+)?$/;if (data.match(e)) { return {url: RegExp['$&'], protocol: RegExp.$2, host:RegExp.$3, path:RegExp.$4, file:RegExp.$6, hash:RegExp.$7};}else { return {url:"", protocol:"",host:"",path:"",file:"",hash:""};}}function...
Wednesday, October 27, 2010
get All child controls/div using jquery
lets assume i have got a div and i want all its child div.you can do it using jquery:$("#ParentDivID > div").each(function(){//your operation on div}Solution by:Rajesh Rolen...
Tuesday, October 26, 2010
Partial Update in MVC2 (like update panel in classic asp.net)
function showAjaxMessage(targetDiv, ajaxMessage) { var ajaxLoader = ""; $(targetDiv).html("" + ajaxLoader + " " + ajaxMessage + ""); } function submitme() { submitForm("MyFunction", "#dvdamageAreaMid", "Submitting...", "#BodyWork", function () { alert('Submitted!'); }); } ...
Tuesday, October 12, 2010
Trigger Ordering in Sql Server
Many of times we face such issue that we have two triggers defined on same table which are set to fire on the same table actions (i.e. an INSERT, DELETE, UPDATE transaction). The second trigger that fires is dependent on the first fired trigger. So how can we make sure that they fire in the correct order to enforce my business logic.By default, multiple triggers on a SQL Server table for the same action are not fired in a guaranteed...
What is Link Server and what are its advantages in SQL Server/ How to write Queries on tables and database which are on seperate sql server instance
Basically it provides us facility of Distributed transactions.Some times we want to retrieve data from a sever and insert it in table of another server.or Some times we want to run sql queries and perform joins on tables of different database whose database are on different computer.Link server provides us all above facilityLinked Servers allow you to submit a TSQL statement on one SQL Server instance, which retrieves data from...
Monday, October 11, 2010
Invoke a Method when method name is in string format or stored in variable
Below is the code that will do the trick, wrapped in the method InvokeStringMethod. As you see, it takes only two lines to call another method given its name as a string, and its class name also as a string. Read the comments in the code to see how it works.public static string InvokeStringMethod(string typeName, string methodName){ // Get the Type for the class Type calledType = Type.GetType(typeName); // Invoke the...
Tuesday, October 5, 2010
Fulltext search in sql server
To set fulltext search in sql server follow below steps:EXEC sp_fulltext_database 'enable'goCREATE FULLTEXT CATALOG mycatalogNamegoCREATE NONCLUSTERED INDEX primaryKeyIndexName ON FAQ (pkColumnName);CREATE FULLTEXT INDEX ON dbo.TableName(QuestionLanguage 0X0)KEY INDEX PK_TableName ON mycatalogNameWITH CHANGE_TRACKING AUTO Solution By:Rajesh Rol...
Read config file using XML reader
The best way is to use System.Configuration.ConfigurationManager.AppSettings; to retrive values of webconfig but from xml reader you can also do that:private void loadConfig() { XmlDocument xdoc = new XmlDocument(); xdoc.Load( Server.MapPath("~/") + "web.config"); XmlNode xnodes = xdoc.SelectSingleNode ("/configuration/appSettings"); foreach (XmlNode xnn in xnodes .ChildNodes)...
What is use of “??”.
It's the null-coalescing operator. Essentially it evaluates the left-hand operand, and if the result is null (either a null reference or the null value for a nullable value type) then it evaluates the right operand.works something like this:Instead of doing:int? number = null;int result = number == null ? 0 : number;You can now just do:int result = number ?? 0;The result of the expression a ?? b is a if that's not null, or b...
Monday, October 4, 2010
Do Enum Supports Inharitence
Enums do not supports inheritance since they are value type and therefor are seale...
Value type polymorphism
.NET value types are objects descending from Object; but, they cannot inherit from other types. They can implement interfaces. Thus, primitives—such as Int32— can implement the IComparable interface, for example, making them comparabl...
How to detect browser using javascript
we can use navigator.userAgent to detect the type/name of current browser and perform compatibility operations according to it:below is javascript code so put it in script tagfunction DetectBrowser() { var val = navigator.userAgent.toLowerCase(); if(val.indexOf("firefox") > -1) { isFF = true; } else if(val.indexOf("opera") > -1) { isOP = true; }...
How to Detect the browser using asp.net and c#.net
Many of times we need to detect browser type/name and its capability in asp.netto do so below code can help you:These properties are exposed by the HttpBrowserCapabilities object indicate inherent capabilities of the browser, *but do not necessarily reflect current browser settings.so using Request.Browser.Browser we can find the name of browser and using if-else/switch-case we can perform desired operation for specific browser...
Wednesday, September 29, 2010
call function in javascript before window close
if you want to ask user before closing popup window or you want to perform certain operation before window gets closed, you can use below code for that:window.onbeforeunload = function (evt) { var message = 'Are you sure you want to leave?'; if (typeof evt == 'undefined') { evt = window.event; } if (evt) { evt.returnValue = message; } return message;} Solution by:Rajesh Rol...
Thursday, September 23, 2010
Load XML using javascript [works with all browser]
When ever we wants to load and parse xml using javascript. we face a issue most of time is that the script works with one browser but not works with other.Below script will work on all browsers including [safari,mizila firefox, crome]:function loadxml() { var xmlFeed = "xmldata/wfc20100915.xml"; if (window.ActiveXObject) { var errorHappendHere = "Check Browser and security settings"; xmlDoc...
Sunday, September 19, 2010
Timer in javascript
With JavaScript, it is possible to execute some code after a specified time-interval. This is called timing events.It's very easy to time events in JavaScript. The two key methods that are used are: * setTimeout() - executes a code some time in the future * clearTimeout() - cancels the setTimeout()Note: The setTimeout() and clearTimeout() are both methods of the HTML DOM Window object.The setTimeout() MethodSyntaxvar t=setTimeout("javascript...
Friday, September 17, 2010
How to: add 'Tweet This' button to Asp.net Webpage/website
You can add your own ‘Tweet This’ buttons to you webpage/website so that your visitors can post to twitter (complete with URL shortening using Bit.ly) is really easy.step 1:go to solution exproler and add a webpage (i have given it name:MyTwitterPage).step 2:remove all the HTML from the page.step 3:Add below code in code behind file:Imports System.NetPartial Public Class MyTwitterPage Inherits System.Web.UI.Page Protected...
Determine which columns have been modified as a result of an UPDATE operation
we can Determine which columns have been modified as a result of an UPDATE operation using CLR Triggers, this is its one of unique capabilities.Unique Capabilities of CLR TriggersTriggers written in Transact-SQL have the capability of determining which columns from the firing view or table have been updated by using the UPDATE(column) and COLUMNS_UPDATED() functions.Triggers written in a CLR language differ from other CLR integration...
error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
when you creates sql server clr project in visual studio and then when you wants to run stored procedure created using that clr project in sql server then you will get below error because by default sql server's CLR is not enabled:error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option.By default .NET Framwork is disabled in SQL2005.How to fix:1. Explore "SQL Server 2005/Configuration...
Crystal Reports .NET Error - "Access to report file denied. Another program may be using it."
Crystal Reports .NET Error - "Access to report file denied. Another program may be using it."From the been there, done that, beat my head against the wall until I figured it out file:This is a very misleading error message, and usually has nothing to do with another program. The actual filename will differ based on your configuration, but the entire error message will be the same, similar to what's shown below. Error in File...
Thursday, September 16, 2010
Convert String to Date
To convert string to date You either specify a culture that uses that specific format :like we want to convert string date "dd/MM/yyyy" to Date..datetime mydate = Convert.ToDateTime( txtdate.Text, CultureInfo.GetCulture("en-GB"));or use the ParseExact method:datetime mydate = DateTime.ParseExact( txtdate.Text, "dd/MM/yyyy", CultureInfo.Invariant);The ParseExact method only accepts that specific format, while the Convert.ToDateTime...
Tuesday, September 14, 2010
how to provide functionality to a Windows user based on the user rights that have been granted to the Windows user account.
You can design the Windows Form to accept the user name and password at runtime by using TextBox controls. Then, you can make the application verify the Windows user's user rights when the Windows user clicks a Button control. To do this, follow these steps: 1. Open form 2. from Toolbox,add two textbox to you form. 3. Add a button on form. 4. add a form2 in application 5. Add a Button control to the Form2 form. 6....
Free Download IP latitude longitude database
For various projects we need database of IP , latitude , longitude to locate city and country... here you can find it.the best one :http://ipinfodb.com/ip_database.phpthis is also good:http://www.maxmind.com/app/geolitecitySolutions by:Rajesh Rol...
Sunday, September 12, 2010
What is difference between Abstract and virtual keywords
Abstract differs from virtual in that a virtual method can have an overridable implementation whereas an abstract method has no implementation at all and, as such, abstract methods must be implemented in any derived classes but with virtual keyword its not essential to override that function in derived class but it allow derived class to override that function.Solution by:Rajesh Rol...
Friday, September 10, 2010
Get list of variables names in class
Sometimes we have lots of fields in a class and we want the field names.. in that situation we can get list of all field names using below code:in below code "YourType" will be your class name of which fields name list you want.for vs2008:var fields = typeof(YourType).GetFields( BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance);var names = Array.ConvertAll(fields, field => field.Name);for vs2005:FieldInfo[]...
Memory Allocation and Disposal
Memory AllocationThe Common Language Runtime allocates memory for objects in two places: the stack and the heap. The stack is a simple first-in last-out memory structure, and is highly efficient. When a method is invoked, the CLR bookmarks the top of the stack. The method then pushes data onto the stack as it executes. When the method completes, the CLR just resets the stack to its previous bookmark—“popping” all the method’s...
What is difference between interface and abstract class
In C# there is no multiple inheritance. You can only inherit from one baseclass, however you can implement multiple interfaces. An abstract base classcan't be directly instantiated, but it can implement code an interface canonly define it. A class that inherits from an abstract base class can chooseto override members or not (unless they are abstract themselves). Allmembers of an interface must be implemented.Much of the time...
What is difference between Singleton pattern and static class
Both can be invoked without instantiation, both provide only with one "instance" and neither of them is threadsafe.Usually both should be implemented to be thread-safe.The big difference between a singleton and a bunch of static methods is that singletons can implement interfaces (or derive from useful base classes, although that's less common IME), so you can pass around the singleton as if it were "just another" implementation.Advantages...
What are the benefits of MVC architecture over N-Tier architecture
15 down vote accepted N-tier architecture usually has each layer separated by the network. I.E. the presentation layer is on some web servers, then that talks to backend app servers over the network for business logic, then that talks to a database server, again over the network, and maybe the app server also calls out to some remote services (say Authorize.net for payment processing).MVC is a programming design pattern where...
Can we use virtual keyword with functions in interface
This is no need to use virtual keyword with functions of interface as it is by default made to overrid...
What is difference between Custom Controls and User Controls
Difference between user controls and custom controls in .net (vb, c# net with asp.net)User controls:It is newly concept in .net it same like as inheritance concept in oopsIn asp.net the base class is system.web.ui.page objectWhen ever creating user control that will be converting as a class, and this class becomeSubclasses of System.web.ui.page class at compile timeUser control extension with .ascxLet us see program how build...
What is XHTML? what is its advantages
XHTML Elements Must Be Properly NestedIn HTML, some elements can be improperly nested within each other, like this:< b >< i >This text is bold and italic< /b >< /i >In XHTML, all elements must be properly nested within each other, like this:< b >< i >This text is bold and italic< /i >< /b >Note: A common mistake with nested lists, is to forget that the inside list must be within...
What is procedure to host WCF webservices
WCF is a flagship product from Microsoft for developing distributed application using SOA. Prior to WCF traditional ASMX Web services were hosted only on Internet Information Services (IIS). The hosting options for WCF services are significantly enhanced from Microsoft .NET Framework 3.0 onwards. In WCF there are three main parts: Service, Endpoints and Hosting Environment. Multiple services can be hosted using a single host...
Subscribe to:
Posts (Atom)