Sometimes I want to use SqlDataSource returned data programmatically and here is how you can do this,In this example I will assume that SqlDataSource ID is SqlDataSource1 which is the default ID:DataSourceSelectArguments args = new DataSourceSelectArguments(); DataView view = SqlDataSource1.Select(args) as DataView; DataTable dt = view.ToTable();
The following method using sys. schema and views such as sys.databases and sys.tables.As we know that the old style sysobjects and sysdatabases and those catalog views have been deprecated since SQL Server.private static bool CheckDatabaseExists(string connectionString, string databaseName) { string sqlQuery; bool result = false; try ...
I will show you three different methods to remove HTML tags from string in C#:1. By using Regex:public static string RemoveHTMLTags(string html) { return Regex.Replace(html, "<.*?>", string.Empty); }2. By using Compiled Regex for better performance:static Regex htmlRegex = new Regex("<.*?>", RegexOptions.Compiled); public static string RemoveHTMLTagsCompiled(string html) { return htmlRegex.Replace(html, string.Empty); }3. By...
I faced a strange problem with Visual Studio 2005 and Visual Studio 2008 which is I have several ASP.NET Projects some of them using .NET 2.0 or Visual Studio 2005 and the others are using .NET 3.5 or Visual Studio 2008.The problem was when I try to run the Web...
I have faced a very strange issue with the .NET which was subtracting 2 Float digits "1.5 - 1.1" the result should be 0.4 but it was 0.39999999999999991 . This happens because floating point numbers can not be precisely represented in binary, such as 1/4 the result will be 0.To...
This class uses a symmetric key algorithm (Rijndael/AES) to encrypt and decrypt data. As long as encryption and decryption routines use the same parameters to generate the keys, the keys are guaranteed to be the same.In a real-life application, this may not be the most efficient way of handling encryption,...
What Captcha stand for?Completely Automated Public Turing test to tell Computers and Humans Apart. The Captcha technology help you to make sure your site is reasonably secure against automated attacks.Write the following code in a class named Captcha:public class Captcha { //make the captcha image for text public Bitmap MakeCaptchaImage(string txt,...
Sometimes we need to add a static item to the top of DropDownList web control, such as "-- Please select --" or any other text. This static item will be removed and replaced with the items that comes from the data source you are using after calling DataBind() method. To keep the...
As we all know that the default max file size that the FileUpload control is using is 4 MB.I was trying to upload a file using FileUpload control provided in ASP.NET but the file size was larger than 4 MB so I was not be able to upload the file.I...
Did you know that String functions StartsWith and EndsWith are case-sensitive even in VB.NET?You will need to make sure you are looking for the correct string, since 'abc' with case-sensitivity is different than 'ABC'. So, if your function is looking for 'abc', you must make sure that you make adjustments...
