Pages

Tuesday, September 9, 2014

How to implement ASP.NET Membership into a new database

Scenarios

Almost of the systems created will have a function to login to manage all of its data, it called with a namely is Login function. So, Microsoft created a component as a template to do this work to save your time when building a new system.

You want to work with this function, then firstly you need to know how to integrate it into your SQL database.

  • Step 1: Do the easily work to create the new database in SQL server.
  • Step 2: Once your database has been created, then you will do the work to integrate the membership in to its.
  • Step 3: Open the .NET Framework folder putted inside window folder as the path:C:\Windows\Microsoft.NET\Framework\v4.0.30319 (depends on your .NET framework version then your path will different), then run the application namely aspnet_regsql.exe.

    img1

  • Step 4: It will show an ASP.NET SQL Server Setup Wizard dialog. Click the Next button to go to the next step. 

    img2

  • Step 5: Choose Configure SQL Server for application services if you want to apply this function to the new database. Otherwise, choose Remove application services information from an existing database if you want to remove this function from a database which is implementing it. In this guide I will chose option 1 is implementing it to the new one database.

    Select option 1 and clicking to Next button, it will show a dialog as in step 6.

  • Step 6: You need to put the information of your server and then choosing the database that you want to implement this function.

    img3

    Once you selected the database, then clicking to Next button. Click Next button one more time to confirm you exactly want to implement this function into selected database. Waiting some seconds before the work is done. Click Finish button to complete your work.

  • Step 7: Open your SQL server to check the result. If your work is successfully then your db will has some tables as the screenshot. 

    img4

Hope that helps.

Tuesday, April 22, 2014

How to save an image using the image URL

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO.MemoryStream;
using System.Drawing.Imaging;
using System.Net;
using System.IO.FileStream;
public partial class Default11 : System.Web.UI.Page
{
   protected void Page_Load(object sender, EventArgs e)
   {
        string urlToDownload = "http://www.google.co.in/images/srpr/nav_logo14.png";
        // May be you need to add some code to determine the type of the image
        string pathToSave = Server.MapPath("~/") + "/saved.png";
        // Download it
        WebClient client = new WebClient();
        client.DownloadFile(urlToDownload, pathToSave);
    }
)

Sunday, April 20, 2014

Validate ASP.Net CheckBoxList control using JavaScript (Select atleast one item)

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default11.aspx.cs" Inherits="Default11" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    
<script type = "text/javascript">
    var atLeast = 1
    function ValidateCheckBoxList() {
        var CHK = document.getElementById("<%=CheckBoxList1.ClientID%>");
        var checkbox = CHK.getElementsByTagName("input");
        var counter = 0;
        for (var i = 0; i < checkbox.length; i++) {
            if (checkbox[i].checked) {
                counter++;
            }
        }
        if (atLeast > counter) {
            alert("Please select atleast " + atLeast + " item(s)");
            return false;
        }
        return true;
    }
</script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    <asp:CheckBoxList ID="CheckBoxList1" runat="server">
<asp:ListItem Text = "Apple" Value = "1"></asp:ListItem>
    <asp:ListItem Text = "Mango" Value = "2"></asp:ListItem>
    <asp:ListItem Text = "Orange" Value = "3"></asp:ListItem>
</asp:CheckBoxList>
<asp:CustomValidator ID="CustomValidator2" runat="server" ErrorMessage="*Required"
ClientValidationFunction = "ValidateCheckBoxList"></asp:CustomValidator>
<asp:Button ID="Button1" runat="server" Text="Button" />
    </div>
    </form>
</body>
</html>

Validate ASP.Net ListBox control using JavaScript

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default11.aspx.cs" Inherits="Default11" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    
<script type = "text/javascript">
    function ValidateListBox(sender, args) {
        var options = document.getElementById("<%=ListBox1.ClientID%>").options;
        for (var i = 0; i < options.length; i++) {
            if (options[i].selected == true) {
                args.IsValid = true;
                return;
            }
        }
        args.IsValid = false;
    }
</script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
  
<asp:ListBox ID="ListBox1" runat="server" SelectionMode = "Multiple">
    <asp:ListItem Text = "Apple" Value = "1"></asp:ListItem>
    <asp:ListItem Text = "Mango" Value = "2"></asp:ListItem>
    <asp:ListItem Text = "Orange" Value = "3"></asp:ListItem>
</asp:ListBox>
<asp:CustomValidator ID="CustomValidator1" runat="server" ErrorMessage="*Required"
ClientValidationFunction = "ValidateListBox"></asp:CustomValidator>
<asp:Button ID="Button1" runat="server" Text="Button" />
    </div>
    </form>
</body>
</html>

Saturday, April 19, 2014

Date Range Validation in AJAX CalendarExtender Control using ASP.Net Range Validator

In this article I will explain how to implement Range Validation in ASP.Net AJAX Control Toolkit CalendarExtender Control.

 

<form id="form1" runat="server">

    <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
   
    <asp:TextBox ID="txtDate" runat="server" ReadOnly = "true"></asp:TextBox>
    <br />
    <asp:RangeValidator runat="server" ID="RangeValidator1" Type="Date" ControlToValidate="txtDate" MaximumValue='09/20/2011' MinimumValue="09/01/2011"
    ErrorMessage="Date should be between 09/01/2011 and 09/20/2011" Display="Dynamic" />
   
    <cc1:CalendarExtender ID = "Calender1" runat = "server" TargetControlID = "txtDate"></cc1:CalendarExtender>
    <br />
    <asp:Button ID="Button1" runat="server" Text="Submit" />
</form>


Above you will notice that I have an ASP.Net TextBox Control txtDate for which I have specified AJAX Control Toolkit CalendarExtender Control Calender1.



Also I have specified ASP.Net RangeValidator Control RangeValidator1 for the TextBox txtDate. This range validator will throw error when the selected date does not fit in the specified range.



In order to make the Range Validator work for the Dates. You need to specify the following paramaters



Type – Specifies that the range validations are for Dates.



MinimumValue – Specifies the minimum value of the range.



MaximumValue - Specifies the minimum value of the range.



 



Screenshot



Implement Range Validation in AJAX Control Toolkit CalendarExtender Control.

ASP.NET AJAX Calendar Extender – Tips and Tricks

ASP.NET AJAX Calendar Extender – Tips and Tricks

The CalendarExtender is an ASP.NET AJAX control that is associated with a TextBox control. When the user clicks on the TextBox, a client-side Calendar control pops up. The user can then set a date by clicking on a day, navigate months by clicking on the left and right arrow and perform other such actions without a postback. In this article, we will see some tips and tricks that can be applied to a CalendarExtender control. If you are new to the CalendarExtender control, you can check out some information about it over here.

I assume you have some basic experience developing ASP.NET Ajax applications and have installed theASP.NET Ajax Library and ASP.NET Control Toolkit. As of this writing, the toolkit version is Version 1.0.20229 (if you are targeting Framework 2.0, ASP.NET AJAX 1.0 and Visual Studio 2005) and Version 3.0.20229 (if targeting .NET Framework 3.5 and Visual Studio 2008).

All the tips shown below have been created using Version 3.0.20229 (targeting .NET Framework 3.5 and Visual Studio 2008).

Tip 1: How to display and hide a Calendar on the click of a Button

If you want to popup a Calendar on the click of a button, you can use set the PopupButtonID of the CalendarExtender to the ID of the button. In this case, we will be using an ImageButton as shown below:

<asp:ImageButton runat="Server" ID="ImageButton1" ImageUrl="~/Images/Icon1.jpg"AlternateText="Click here to display calendar" />

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<cc1:CalendarExtender ID="CalendarExtender1" runat="server"

TargetControlID="TextBox1" PopupButtonID="ImageButton1"/>

If you are using an earlier version of the toolkit, you may observe that the ImageButton causes a postback when you click on it again, to close the Calendar. To avoid the postback, use a HTML Image Control instead of the Server side Image Control as shown below:

<img alt="Icon" src="/Images/Icon1.jpg" id="Image1" />

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<cc1:CalendarExtender ID="CalendarExtender1" runat="server"

TargetControlID="TextBox1" PopupButtonID="Image1"/>

Note: In case you are clicking on the textbox to open the calendar, then in earlier versions of the toolkit, the calendar would not hide automatically when the user clicked anywhere outside the Calendar control. However this was fixed in the later versions. In fact, in the latest version, the Calendar hides automatically when a date is selected.

If for some reason you are facing issues with the Calendar not hiding automatically, make sure that you have the latest version of the AJAX Control Toolkit.

Tip 2: How to Add a CalendarExtender to a GridView

If you want to add a CalendarExtender to a GridView, use a template field with a TextBox and CalendarExtender as shown below:

<form id="form1" runat="server">

<asp:ScriptManager ID="ScriptManager1" runat="server" />

<div>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"DataKeyNames="CategoryID"

DataSourceID="SqlDataSource1" ShowFooter="true" AllowPaging="True"AllowSorting="True">

<Columns>

<asp:BoundField DataField="CategoryID" HeaderText="CategoryID"

SortExpression="CategoryID" />

<asp:BoundField DataField="CategoryName" HeaderText="CategoryName"

SortExpression="CategoryName" />

<asp:TemplateField>

<ItemTemplate>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<cc1:CalendarExtender ID="CalendarExtender1" runat="server"TargetControlID="TextBox1"/>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=SUPROTIM;Initial Catalog=Northwind;Integrated Security=True"

SelectCommand="SELECT [CategoryID], [CategoryName] FROM [Categories]" >

</asp:SqlDataSource>

</div>

</form>

Tip 3: Enable Year Navigation in CalendarExtender

When the calendar appears, click on the title of the calendar to change the view to Months in the current year. Clicking it again, switches the view to Years, showing 10 years at a time.

If you plan to do this programmatically, here’s some code for you. Use the OnClientShown event and switch the mode using javascript. This tip was shared by one of the Microsoft® support person at the asp.net forums.

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<cc1:CalendarExtender ID="CalendarExtender1"

runat="server" TargetControlID="TextBox1" OnClientShown="ChangeCalendarView" />

Then add this to the <head> section

<head runat="server">

<title>CalendarExtender</title>

<script type="text/javascript">

function ChangeCalendarView(sender,args)

{

   sender._switchMode("years", true);          

}

</script>

</head>

Tip 4: Display only the day and month in the CalendarExtender

To select only the day and month without the year, use the Format property of the CalendarExtender and set it to “dd/MM” as shown below:

<cc1:CalendarExtender ID="CalendarExtender1" runat="server" Format="dd/MM"TargetControlID="TextBox1" />

Tip 5: How to Set Culture to work with CalendarExtender

Make sure that the ScriptManager has EnableScriptGlobalization="true" and EnableScriptLocalization="true".

<asp:ScriptManager ID="ScriptManager1" runat="server"

EnableScriptGlobalization="true" EnableScriptLocalization="true" />

Tip 6: How to make sure user does not select a date earlier than today or greater than today

There could be instances where you do not want the user to select a day earlier than the current date. For example: when you are providing the user a form to book tickets, you would not like him to choose an earlier date. To achieve this requirement, use the following javascript code.

Prevent the User from selecting a Date Earlier than today

<head runat="server">

<title>Calendar Extender</title>

<script type="text/javascript">

function checkDate(sender,args)

{

if (sender._selectedDate < new Date())

            {

                alert("You cannot select a day earlier than today!");

                sender._selectedDate = new Date();

// set the date back to the current date

sender._textbox.set_Value(sender._selectedDate.format(sender._format))

            }

}

</script>

</head>

Call the code:

<form id="form1" runat="server">

<asp:ScriptManager ID="ScriptManager1" runat="server" />

<div>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<cc1:CalendarExtender ID="CalendarExtender1"

runat="server"OnClientDateSelectionChanged="checkDate" TargetControlID="TextBox1" />

</div>

</form>

Select Date Greater than today

In the javascript, just change this line

sender._selectedDate > new Date()

Note: You may argue that the user can still change the date by typing into the textbox or entering an invalid date. Well that can be easily handled using a ValidationControl and is covered in the next tip.

Tip 7: Add validation to the CalendarExtender Control

A simple way to add validation to the Calendar is to add a ValidationControl to the textbox associated with a CalendarExtender. You have two choices:

A. Add an ‘Extender’ to the ValidationControl. To do so, drag and drop a ValidationControl > click on the smart tag of the ValidationControl > choose ‘Add Extender’. From the Extender Wizard, choose ValidatorCalloutExtender. Using this approach makes it extremely easy to discover and attach control extenders to your controls. In VS 2005, you had to do this process manually, by wiring up control extenders.

B. You can choose not to add the Extender.

We will go ahead with option A. We will be adding two ValidationControls to the textbox. The first, a CompareValidator to check if the user does not enter an invalid date (Eg: May 32) and second, a RangeValidator to keep the date range as desired.

Adding CompareValidator

<asp:CompareValidator ID="CompareValidator1" runat="server"

ControlToValidate="TextBox1" Display="Dynamic" ErrorMessage="Invalid Date"

Operator="DataTypeCheck" Type="Date">

</asp:CompareValidator>

<cc1:ValidatorCalloutExtender ID="CompareValidator1_ValidatorCalloutExtender"

runat="server" Enabled="True" TargetControlID="CompareValidator1">

</cc1:ValidatorCalloutExtender>

Adding RangeValidator – We will restrict the user to select a date range starting from today to 15 days from now.

<asp:RangeValidator ID="RangeValidator1" runat="server"

ControlToValidate="TextBox1" ErrorMessage="RangeValidator"

Type="Date">

</asp:RangeValidator>

<cc1:ValidatorCalloutExtender ID="RangeValidator1_ValidatorCalloutExtender"

runat="server" Enabled="True" TargetControlID="RangeValidator1">

</cc1:ValidatorCalloutExtender>

In the code behind of your page, add this code

C#

protected void Page_Load(object sender, EventArgs e)

    {

        RangeValidator1.MinimumValue = System.DateTime.Now.ToShortDateString();

        RangeValidator1.MaximumValue = System.DateTime.Now.AddDays(15).ToShortDateString();

    }

VB.NET

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)

            RangeValidator1.MinimumValue = System.DateTime.Now.ToShortDateString()

            RangeValidator1.MaximumValue = System.DateTime.Now.AddDays(15).ToShortDateString()

End Sub

Well those were some tips associated with the CalendarExtender. As future versions of the toolkit are released, we should be hopeful that there will exist easier ways, of achieving the functionality discussed in this article. I hope this article was useful and I thank you for viewing it.

Saturday, April 5, 2014

Read a Text file line by line in C# .NET

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default7.aspx.cs" Inherits="Default7" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <h2>Read txt file</h2>
    <asp:Label ID="Label1" runat="server"></asp:Label>
    </div>
    </form>
</body>
</html>


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 Default7 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        ReadLineByLine();
        ReadTextFileAndSplit();
    }
    void ReadLineByLine()
    {
        string inputString;
        using (StreamReader streamReader = File.OpenText(Server.MapPath("~") + @"\test.txt"))
        {
            inputString = streamReader.ReadLine();
            while (inputString != null)
            {
                Label1.Text += inputString + "<br \\>";
                inputString = streamReader.ReadLine();
            }
        }
    }
    void ReadTextFileAndSplit()
    {
        string inputString;
        using (StreamReader streamReader = File.OpenText(Server.MapPath("~") + @"\test.txt"))
        {
            inputString = streamReader.ReadLine();
            while (inputString != null)
            {
                string[] spilt = inputString.Split(' ');
                string Name = spilt[0];
                string Location = spilt[1];
                string Id = spilt[2];
                inputString = streamReader.ReadLine();
            }
        }
    }
}


test.txt
Rakesh NY 101
Ram Canada 102
Suresh India 103