Tips & Tricks

ASP.NET Cookies Overview

2013-05-17T11:19:05.577-04:00

A cookie is a small bit of text that accompanies requests and pages as they go between the Web server and browser. The cookie contains information the Web application can read whenever the user visits the site.

Interesting about Asp.Net MVC

2013-05-15T13:33:08.15-04:00

As we all know that MVC has been a life-saver for Asp.Net , giving the power to do more . Now solution to

a complex application has been made easier due to the available MVC semantics. I am already amazed about

the following features which MVC provides :

Test driven development (TDD)
Routing Infrastructure
Loosely coupled architecture
Code Re-usability
No Viewstate
Full control over rendered HTML
Enhanced support for dependency injection providing resilience to app.
Support for javascript & ouptout caching

So let's focus on some of the other revolutionary facets which has made development tasks simple .

First let's talk about MVC jQuery validation which is done on the front end (client side), without submitting

data to the controller (Server side). So it can save you some bandwidth/processing. If you have a slow or

overloaded server, users will get a quicker response to validation errors this way as well. Server side validation is

essential/required since it makes sure you are getting good data before you save it. The client side is nice to

have, but shouldn't be all you have since its possible to bypass. For jquery validation add the scripts

"jquery.validate.min.js" & "jquery.validate.unobtrusive.min.js" to your view .

Also add the following in App-Settings of web-config :

<add key="ClientValidationEnabled" value="true"/>
<add key="UnobtrusiveJavaScriptEnabled" value="true"/>

We even have Remote Validation which fires for the custom validation logic developed, so when client

presses submit button it shows the error fabricated . For eg : We set the remote attribute in model for property

[Remote("RegisterClientUser", "Registration", ErrorMessage = "User name is already taken!")]

public String UserName { get; set; }

Then we declare it's respective action in controller .

public class RegistrationController : Controller

{

// GET: /Registration/

private UserEntities userDB;

public RegistrationController()

{

userDB = new UserEntities();

}

public ViewResult RegisterClientUser()

{

return View(new UserModel());

}

[HttpPost]

public ActionResult RegisterClientUser(UserModel um)

{

try

{

clientuser user = new clientuser();

return Json(!um.UserName.Equals(userDB.clientuser.Find(um.UserName))

, JsonRequestBehavior.AllowGet);

if (ModelState.IsValid)

{

// your code

}

return RedirectToAction("Index", "Home");

}

catch

{

ViewBag.updateError = "Unable to register";

return View(um);

}

Next I would like to speak about is Adaptive Rendering which allows your website is aware of the

browser’s proportions and corresponds to them, so it can present its content as user-friendly as possible.That

means even if you resize , the content is clipped. The meta-tag "Viewport " is helpful indeed. For eg:

Appending <meta name="viewport" content="width=device-width"/> would help us scale the complete

page properly even on mobile.

Then we have Bundling and Minification which are more useful in production than in development as

well can significantly improve your first page hit download time.

Bundling reduces the number of individual HTTP requests to server by combining multiple CSS filesand Javascript files into single CSS file and javascript file. We have to register bundles function in Application_Start() of Global Asax . Now to bundle js scripts together as one we add them into 1 bundle.

bundles.Add(new ScriptBundle("~/bundles/jqueryval").Include(

"~/Scripts/jquery.unobtrusive*",

"~/Scripts/jquery.validate*"));

Similarly we do for stylesheets as follows

bundles.Add(newStyleBundle("~/Content/Styles/css").Include(

"~/Content/Styles/css/style.css"));

Minification reduces the file download size of CSS and javascript files by removing whitespace, comments and other unnecessary characters. Here we have to zip or minify the css & js files in order to reduce load.

For eg: we can use gzip to minify the files so "smaller files, less kb on the wire, faster page load".

Hope I could do justice to this blog by providing you all adequate detail on the above mentioned features of

MVC . I would even be posting more on my development experiences & issues faced periodically . In the

meanwhile if you get stuck @ any phase in development, you guys can mail me so that I can help you .

So STAY TUNED !

Find More tutorials and articles here

Regards,

Shalin Jirawla

shalinitengg10@gmail.com

How to Add/Remove DataRow from DataTable in Memory

2013-04-26T19:52:43.74-04:00

I thought I would post this as I spent several days getting it to work. All the posts I found were incomplete in one way or another.

I welcome any comments on improving its efficiency.

First add your DataTable variable to you class, but outside of any method

public partial class YourClassName: System.Web.UI.UserControl
{
    DataTable dt;
}

Next add this to Page_Load

protected void Page_Load(object sender, EventArgs e)
{
    if (GridView1.Rows.Count == 0)
    {
	//  Create new DataTable instance
	dt = new DataTable("YourTableName");
	//  Add columns to new DataTable
	dt.Columns.Add(new DataColumn("Column_Name_1", Type.GetType("System.Int32")));
	dt.Columns.Add(new DataColumn("Column_Name_2", Type.GetType("System.String")));
	//  Add the new DataTable to Session
	//  I add this to session before adding a ghost row because when real data is added, it will not be needed.
	//  The ghost row is used so that GridView will show the FooterTemplate when no data is actually present.
	Session.Add("YourTableName", dt);

	//  Create a DataRow for the new DataTable
	DataRow dr = dt.NewRow();
	//  Add data to the new DataRows' 2 columns.
	//  This is a ghost row (that will be hidden on RowDataBound), so the GridView will show the FooterTemplate
	dr[0] = Convert.ToInt32("0");
	dr[2] = null;
	//  Add new DataRow to the DataTable
	dt.Rows.Add(dr);
	//  Bind DataTable to GridView
	GridView1.DataSource = dt;
	GridView1.DataBind();
    }
}

Your GridView should now show you only the HeaderTemplate and FooterTemplate,

This last part adds or removes values on the RowCommand event

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
	int Column_1_Value;
	string Column_2_Value = string.Empty;
	DataRow dr;

	switch (e.CommandName)
	{
		case "Add":
			Column_1_Value = ((TextBox)((GridView)sender).FooterRow.FindControl("TextBox1")).Text
			Column_2_Value = ((TextBox)((GridView)sender).FooterRow.FindControl("TextBox2")).Text

			//  Get the DataTable from Session
			dt = (DataTable)Session["YourTableName"];
			//  Create a new DataRow
			dr = dt.NewRow();
			dr[0] = Convert.ToInt32(Column_1_Value);
			dr[1] = Column_2_Value;
			//  Add DataRow to DataTable
			dt.Rows.Add(dr);

			//  Clear out old DataTable from Session
			//  (not sure if this is needed as I dont know if just adding it back will overwrite or update exisiting Session value)
			Session.Remove("YourTableName");
			//  Add  DataTable to Session
			Session.Add("YourTableName", dt);
			//  Bind DataTable to GridView
			GridView2.DataSource = dt;
			GridView2.DataBind();
			break;
			
		case "Remove":
		GridViewRow gvr = (GridViewRow)(((Button)e.CommandSource).NamingContainer);

		Column_1_Value = ((Label)gvr.FindControl("Label1")).Text;
		Column_2_Value = ((Label)gvr.FindControl("Label2")).Text;
		//  Get the DataTable from Session
		dt = (DataTable)Session["YourTableName"];
		//  Set what DataRow in the DataTable will be removed
		dr = dt.Rows[gvr.RowIndex];
		//  Remove DataRow
		dt.Rows.Remove(dr);
		//  Clear out old DataTable from Session
		Session.Remove("YourTableName");
		//  Add  DataTable to Session
		Session.Add("YourTableName", dt);
		//  Bind DataTable to GridView
		GridView2.DataSource = dt;
		GridView2.DataBind();
		break;
	}
}

I hope is makes sense to anyone that has been trying to slay this dragon.

Hope I can save you some time.

Http Web Request Helper Class

2012-08-23T19:48:32.613-04:00

Hi Every one,

I just wana share this class with MVC developers that can really help them with posting and getting the contents from other sites, same like the form post/get. Before we have implemented this class it was a nightmare to post data from code/service classes either it is the text or the xml to external sites and same when we want to get the response from web service or any external web page.

You can add this class in your project and can call the static methods from anywhere service classes, views or controller.

public static class HttpWebRequestHelper
    {
        private static string FormContentType = "application/x-www-form-urlencoded";
        private static string XMLContentType = "text/xml";
        private static string POST = "POST";

        private static string FormatPostParameters(NameValueCollection nameValueCollection)
        {
            StringBuilder sb = new StringBuilder();
            foreach (string key in nameValueCollection)
            {
                sb.Append(key + "=" + HttpUtility.UrlEncode(nameValueCollection[key]) + "&");
            }
            sb.Length = sb.Length - 1;
            return sb.ToString();
        }

        private static string FormatPostParameters(Dictionary<string,string> parameters)
        {
            StringBuilder sb = new StringBuilder();
            foreach (string key in parameters.Keys)
            {
                sb.Append(HttpUtility.UrlEncode(key) + "=" + HttpUtility.UrlEncode(parameters[key]) + "&");
            }
            sb.Length = sb.Length - 1;
            return sb.ToString();
        }

        public static HttpWebResponse SendFormPostRequest(string url, Dictionary<string,string> parameters)
        {
            HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create(url);
            httpWebRequest.ContentType = FormContentType;
            httpWebRequest.Method = POST;

            string postData = FormatPostParameters(parameters);

            byte[] requestBytes = Encoding.UTF8.GetBytes(postData);

            httpWebRequest.ContentLength = requestBytes.Length;

            using (Stream requestStream = httpWebRequest.GetRequestStream())
            {
                requestStream.Write(requestBytes, 0, requestBytes.Length);
                requestStream.Close();
            }

            Task<WebResponse> responseTask = Task.Factory.FromAsync<WebResponse>(httpWebRequest.BeginGetResponse, httpWeb            Request.EndGetResponse, null);

            return (HttpWebResponse)responseTask.Result;
        }
        public static HttpWebResponse SendNonFormPostRequest(string data, string url)
        {
            HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create(url);
            httpWebRequest.ContentType = XMLContentType;
            httpWebRequest.Method = POST;
            httpWebRequest.KeepAlive = false;
            httpWebRequest.Timeout = 500000;

            StreamWriter sw = new StreamWriter(httpWebRequest.GetRequestStream());
            sw.WriteLine(data);
            sw.Close();

            Task<WebResponse> responseTask = Task.Factory.FromAsync<WebResponse>(httpWebRequest.BeginGetResponse, httpWeb           Request.EndGetResponse, null);

            return (HttpWebResponse)responseTask.Result;
        
        }

        public static string GetHttpWebResponseData(HttpWebResponse response)
        {
             string data = string.Empty;
             if (response != null)
             {
                 StreamReader incomingStreamReader = new StreamReader(response.GetResponseStream());
                 data = incomingStreamReader.ReadToEnd();
                 incomingStreamReader.Close();
                 response.GetResponseStream().Close();
             }
             return data;
        }

    }

TreeView - Collapse All Nodes Except SelectedNode's Parent Nodes

2010-10-19T09:32:27.19-04:00

Control Markup

protected void tv_Menu_DataBound(object sender, EventArgs e) {
tv_Menu.CollapseAll();
if (tv_Menu.SelectedNode != null) {
	TreeNode tn = tv_Menu.SelectedNode;
	switch (tn.Depth) {
		case 5:
		tn.Parent.Parent.Parent.Parent.Parent.Expand();
		tn.Parent.Parent.Parent.Parent.Expand();
		tn.Parent.Parent.Parent.Expand();
		tn.Parent.Parent.Expand();
		tn.Parent.Expand();
		break;


		case 4:
		tn.Parent.Parent.Parent.Parent.Expand();
		tn.Parent.Parent.Parent.Expand();
		tn.Parent.Parent.Expand();
		tn.Parent.Expand();
		break;


		case 3:
		tn.Parent.Parent.Parent.Expand();
		tn.Parent.Parent.Expand();
		tn.Parent.Expand();
		break;


		case 2:
		tn.Parent.Parent.Expand();
		tn.Parent.Expand();
		break;


		case 1:
		tn.Parent.Expand();
		break;
	}
}
}

HTML5 placeholder on old browsers

2013-04-20T13:51:15.16-04:00

Let me start by mention that I'm not related in any way with the author of this plugin so the main purpose of this post is to share something I have found and not advertise anything.

I found it and I think I must share with the community because I think is very usefull.

I wanted to use the html5 placeholder on my textboxes but, when I open my html on old browsers, the placeholder text was not showed.

I found this jquery plugin that solves this problem.

You can find it on https://github.com/mathiasbynens/jquery-placeholder

If you know any other way to solve this problem please share it.

examples of Checkboxes and Radio Buttons in WebPages

2012-07-20T22:00:30.053-04:00

For what it's worth, I have put together a sample web page (razor/c#) illustrating some of the more common use cases involving checkboxes and radio buttons.

Perhaps this can help those who, like me, may have struggled with how to work these html controls.

There are three cases of checkboxes:

(1) Simple checkbox with no return value specified. When unchecked, nothing is returned; when checked, "on" is returned. The checked state of the checkbox is preserved.

(2) Checkbox where a return value is specified. When unchecked, nothing is returned; when checked, the string in the value attribute is returned. The checked state of the checkbox is preserved.

(3) A group of checkboxes, all sharing the same name attribute and each having a specified return value. If any one or more of the checkboxes are checked, the value(s) will be returned in a (comma-separated) string containing the value attribute string(s) corresponding to the checked checkbox. If none are checked, no value is returned. This use case illustrates the use of the .Split method to convert the comma-separated values string into an array of strings, which can be evaluated in a for loop. The checked state of each checkbox is preserved.

There is one use case for radio buttons, showing buttons for yes and no (with the no button being checked by default. The checked state of the radio button is preserved.

Run the page and play with the checkboxes/radio buttons, clicking the "Submit" button to see the results.

Hopefully this can be useful to beginners like me.

@{
    //illustrates usage of radio buttons and check boxes
    Page.title = "Checkboxes/Radio Butttons Use Cases";
    Layout = "~/_SiteLayout.cshtml";
    var cbox1 = Request["cbox1"];
    var cbox2 = Request["cbox2"];
    var cbox3 = Request["cbox3"].As<string>("");//defaults to empty string
    
    var rad1=Request["rad1"];
    
    

}


<form method="post" action="">
 
    <fieldset class="useCase">
        <h4>Checkbox with persistent return value of "on" or null:
        <input type="checkbox" name="cbox1"
            @(Request["cbox1"] == "on" ? " checked" : "") /></h4>
        Value in Cbox1 (should be "on" when checked): @cbox1<br />
        <input type="submit" value="submit" />
    </fieldset>
 

    <fieldset class="useCase">
        <h4>Checkbox with persistent return value of "XYZ"
        XYZ: <input type="checkbox" name="cbox2" value="XYZ"
            @(Request["cbox2"] == "XYZ" ? " checked" : "") /></h4>
        Value in Cbox2 (should be "XYZ" when checked): @cbox2
        <input type="submit" value="submit" />
    </fieldset>

    <fieldset class="useCase">
        <h4>Multiple Checkboxes, returning 0, one,or more persistent values
        Dogs:<input type="checkbox" name="cbox3"  value="Dogs"
            @(cbox3.Contains("Dogs") ? " checked" : "") />
        Cats:<input type="checkbox" name="cbox3"  value="Cats"
            @(cbox3.Contains("Cats") ? " checked" : "") />
        Birds:<input type="checkbox" name="cbox3"  value="Birds"
            @(cbox3.Contains("Birds") ? " checked" : "") />
        Snakes:<input type="checkbox" name="cbox3"  value="Snakes"
            @(cbox3.Contains("Snakes") ? " checked" : "") /></h4>
        <p>Value in Cbox3 (should be comma-separated string when any is checked): @cbox3<br />
        Here are the values from the checkedboxes:<br />
        @foreach (var cbox in cbox3.Split(','))
        {
            @cbox<br />
        }
        
        </p>
        <input type="submit" value="submit" />
    </fieldset>

    <br /><br />
    <fieldset class="useCase">
        <h4>radio Buttons to yield either "y" or"n" (default="n"):
        <input type="radio" name="rad1" value="y" @(rad1=="y"?" checked":"")/>Yes
        <input type="radio" name="rad1" value="n" @(rad1=="n"||rad1.IsEmpty()?" checked":"") />No
        </h4>
        <p>Here is the value: @rad1</p>
        <input type="submit" value="submit" />
    </fieldset>
</form>

Character Counter for Multiline Textbox

2008-06-02T15:01:51.777-04:00

Best one I found:

http://javascript.internet.com/forms/character-counter.html

Also works with a regular textbox, of course. Although this is a javascript widget, I used it with an ASP.NET textbox using this markup:

<asp:TextBox ID="tbx_EntryDescription" runat="server"
                            Height="180px" Width="220px" TextMode="MultiLine"
                            OnKeyUp="toCount('tbx_EntryDescription','chr_EntryBanner','{CHAR} characters left',350);">
                            </asp:TextBox><br />
                            <span id="chr_EntryBanner">350 characters left.</span>

Don't forget to put this code in the <head> section of your page:

And then put the "charcount.js" (or whatever you name the .js file) in the same directory as your page. HTH someone...

Simple captcha code

2012-11-11T07:30:00.553-05:00

The handler:

<%@ WebHandler Language="VB" Class="textimg" %>

Imports System
Imports System.Web
Imports System.Drawing
Imports System.Drawing.Text


Public Class textimg : Implements IHttpHandler, IReadOnlySessionState
    
    Public Sub ProcessRequest(ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest
      
        Dim s As String = HttpContext.Current.Session("RandomImgText")
        
        context.Response.ContentType = "image/gif"
        CreateImage(s).Save(context.Response.OutputStream,
                     System.Drawing.Imaging.ImageFormat.Gif)
        
        
        
    End Sub
    Private Shared Function CreateImage(sImageText As String) As Bitmap
        
        Dim bmpImage As New Bitmap(1, 1)

        Dim iWidth As Integer = 0
        Dim iHeight As Integer = 0

        Dim MyFont As New Font("Arial", 18, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Pixel)
        Dim MyGraphics As Graphics = Graphics.FromImage(bmpImage)
        iWidth = CInt(MyGraphics.MeasureString(sImageText, MyFont).Width) + 20
        iHeight = CInt(MyGraphics.MeasureString(sImageText, MyFont).Height) + 4
        bmpImage = New Bitmap(bmpImage, New Size(iWidth, iHeight))
        MyGraphics = Graphics.FromImage(bmpImage)
        MyGraphics.Clear(Color.Beige)
        MyGraphics.TextRenderingHint = TextRenderingHint.AntiAlias
        MyGraphics.DrawString(sImageText, MyFont, New SolidBrush(Color.Brown), 10, 4)
        MyGraphics.Flush()
        Return (bmpImage)
    End Function
 
    Public ReadOnly Property IsReusable() As Boolean Implements IHttpHandler.IsReusable
        Get
            Return True
        End Get
    End Property

End Class

Usage:

    Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
        
        If Not IsPostBack Then
            Dim s As String = CreateRandomString(6)
            Session("RandomImgText") = s
        End If


    End Sub

        Public Shared Function CreateRandomString(ByVal lenght As Integer) As String

            Dim guidResult As String = System.Guid.NewGuid().ToString()
            guidResult = guidResult.Replace("-", String.Empty)
            Return guidResult.Substring(0, lenght)

        End Function

    Protected Function ValidateForm() As Boolean

        Dim IsValid As Boolean = True
        If Not txtImg.Text = Session("RandomImgText") Then IsValid = False
        Return IsValid

    End Function

URL Shortening

2013-03-16T01:28:18.267-04:00

I come across these in my search of a URL Shrinker. This is not an advertisment scheme just wanting to do my part.

Import system.io
import system.net

AdFly pays you for shrinking urls

Dim Link As String = "$URL_to_shrink$"

Dim API_KEY As String = "$ADFLY_API_KEY$" 'change this with your api key.
Dim ID As String = "$ADFLY_ID$" 'change this with your id.
Dim wr As HttpWebRequest = WebRequest.Create("http://api.adf.ly/api.php?key=" & API_KEY & "&uid=" & ID & "&advert_type=int&domain=q.gs&url=" & Link)
Dim ws As HttpWebResponse = wr.GetResponse
Dim read As StreamReader = New StreamReader(ws.GetResponseStream)
Dim responeString As String = read.ReadToEnd

here is another for google url shrinking

Public Shared Function Shorten(url As String) As String
        Dim key As String = "$MYGOOGLEAPIKEY$"
        Dim post As String = "{""longUrl"": """ & url & """}"
        Dim shortUrl As String = url
        Dim request As HttpWebRequest = DirectCast(WebRequest.Create("https://www.googleapis.com/urlshortener/v1/url?key=" & key), HttpWebRequest)
        Try
            request.ServicePoint.Expect100Continue = False
            request.Method = "POST"
            request.ContentLength = post.Length
            request.ContentType = "application/json"
            request.Headers.Add("Cache-Control", "no-cache")
            Using requestStream As Stream = request.GetRequestStream()
                Dim postBuffer As Byte() = Encoding.ASCII.GetBytes(post)
                requestStream.Write(postBuffer, 0, postBuffer.Length)
            End Using
            Using response As HttpWebResponse = DirectCast(request.GetResponse(), HttpWebResponse)
                Using responseStream As Stream = response.GetResponseStream()
                    Using responseReader As New StreamReader(responseStream)
                        Dim json As String = responseReader.ReadToEnd()
                        shortUrl = Regex.Match(json, """id"": ?""(?<id>.+)""").Groups("id").Value
                    End Using
                End Using
            End Using
        Catch ex As Exception
            ' if Google's URL Shortner is down...
            System.Diagnostics.Debug.WriteLine(ex.Message)
            System.Diagnostics.Debug.WriteLine(ex.StackTrace)
        End Try
        Return shortUrl
    End Function

Shorten(yourlink.com)

Hope this helps some

When "Publish" goes away on your project

2013-03-21T14:57:58.733-04:00

This may be off topic (winforms/console) but I figure it was worth posting anyway to save someone else countless hours troubleshooting. Say you have a .net windows service that you've built and suddenly when you go to do Publish, the link is not there. You go to Build > Publish and it is grayed out. What's probably happened is your Application setting Output type is no longer an application but more likely a Class. When you flip it back to either Windows or Console, your publish button will come back.

Dynamic Themes in MVC Razor

2013-03-22T06:14:11.207-04:00

Hi,

I struggled for the whole day to apply themes dynamically in MVC and found a solution by combining few googling results

and the solution follows

I done it by swapping CSS only. If you are looking for HTML, then it's not appropriate solution.

Step 1: Create Dummy CSS Redmond.css ( Copy of Site.css with colors and bg colors changed)

Step 2: From Layout Change the Styles Reference as following

Step 3: In Index Method(Startup Method of application), set Theme value as follows

        public ActionResult Index()
        {
            if (HttpContext.Application["Theme"] == null)
                HttpContext.Application["Theme"] = LoadTheme();
            ViewBag.Message = "Modify this template to jump-start your ASP.NET MVC application.";
            return View();
        }

where LoadTheme is a common Method

public string LoadTheme(string Theme = null)
        {
            string sLocation = "/Content/";
            if (Theme == null)
            {
                sLocation += "themes/" + "Site.css";
            }
            else if (Theme == "RedMond")
            {
                sLocation += "themes/" + "RedMond.css";
            }
            HttpContext.Application["Theme"] = sLocation;
            return HttpContext.Application["Theme"] as string;
        }

Step 4: Declare 2 buttons as follows to allow user to change themes

Step 5 : Fire JQuery Event to call common Method LoadTheme on button click

That's It. Hope this helps.

Easy in memory image processing(grayscale, sepia, negative, resize, brightness and contrast)

2005-09-27T07:40:43.237-04:00

Howdie y'all,

Here's the image processor i created and use with pleasure. So maybe you'll enjoy it as much a I do!

It converts to: Grayscale, sepia and negative,
It resizes with high quality,
and sets brightness and contrast,

ALL ON THE FLY!

You can also call all these sweet functions from your code so you can, for example, resize and grayscale an uploaded image bij just 2 lines of code!

And it's ten times faster then looping thru al you pixels.

So how does it work???

First:
Create this class and compile it into a dll:

<code>
using System;
using System.Drawing;
using System.Drawing.Drawing2D;
using System.Drawing.Imaging;
using System.IO;
using System.Web;

namespace YourNamespace
{
    public class ImageProcessor : IHttpHandler
    {
        public void ProcessRequest(HttpContext context)
        {
            string src = (context.Request.QueryString["src"] == null) ? string.Empty : context.Server.MapPath(context.Server.UrlDecode(context.Request.QueryString["src"]));

            context.Response.Clear();

            if (File.Exists(src))
            {
                context.Response.ContentType = "image/jpeg";
                int wi = (context.Request.QueryString["w"] == null) ? 0 : Convert.ToInt32(context.Request.QueryString["w"]);
                int hi = (context.Request.QueryString["h"] == null) ? 0 : Convert.ToInt32(context.Request.QueryString["h"]);
                bool gb = (context.Request.QueryString["g"] == null) ? false : Convert.ToBoolean(context.Request.QueryString["g"]);
                bool nb = (context.Request.QueryString["n"] == null) ? false : Convert.ToBoolean(context.Request.QueryString["n"]);
                bool sb = (context.Request.QueryString["s"] == null) ? false : Convert.ToBoolean(context.Request.QueryString["s"]);
                float bf = (context.Request.QueryString["b"] == null) ? 0 : Convert.ToSingle(context.Request.QueryString["b"]);
                float cf = (context.Request.QueryString["c"] == null) ? 0 : Convert.ToSingle(context.Request.QueryString["c"]);

                using (Stream imgStream = File.OpenRead(src))
                {
                    using (Bitmap b = Resize(imgStream, wi, hi))
                    {
                        if (gb)
                            ToGrayscale(b);

if (nb)
ToNegative(b);

if (sb)
ToSepia(b);

if (bf != 0)
SetBrightness(b, bf);

if (cf != 1)
SetContrast(b, cf);

                        b.Save(context.Response.OutputStream, ImageFormat.Jpeg);
                    }
                }
            }

context.Response.End();
}

        public bool IsReusable
        {
            get { return true; }
        }

        public static Bitmap Resize(Stream SourceImage, int MaxWidth, int MaxHeight)
        {
            Bitmap b = null;

            using (System.Drawing.Image i = System.Drawing.Image.FromStream(SourceImage))
            {
                int _maxWidth = (MaxWidth > 0) ? MaxWidth : i.Width;
                int _maxHeight = (MaxHeight > 0) ? MaxHeight : i.Height;
                double _scaleWidth = (double)_maxWidth / (double)i.Width;
                double _scaleHeight = (double)_maxHeight / (double)i.Height;
                double _scale = (_scaleHeight < _scaleWidth) ? _scaleHeight : _scaleWidth;
                _scale = (_scale > 1) ? 1 : _scale;

int _newWidth = (int)(_scale * i.Width);
int _newHeight = (int)(_scale * i.Height);

b = new Bitmap(_newWidth, _newHeight);

                using (Graphics g = Graphics.FromImage(b))
                {
                    g.CompositingQuality = CompositingQuality.HighQuality;
                    g.SmoothingMode = SmoothingMode.HighQuality;
                    g.InterpolationMode = InterpolationMode.HighQualityBicubic;

                    g.DrawImage(i, new Rectangle(0, 0, _newWidth, _newHeight));
                    g.Save();
                }
            }

return b;
}

        public static void ToGrayscale(Bitmap b)
        {
            ColorMatrix cm = new ColorMatrix(new float[][]{
                            new float[] {0.3086f, 0.3086f, 0.3086f, 0f, 0f},
                            new float[] {0.6094f, 0.6094f, 0.6094f, 0f, 0f},
                            new float[] {0.0820f, 0.0820f, 0.0820f, 0f, 0f},
                            new float[] {     0f,      0f,      0f, 1f, 0f},
                            new float[] {     0f,      0f,      0f, 0f, 1f}});

ApplyColorMatrix(b, cm);
}

        public static void ToNegative(Bitmap b)
        {
            ColorMatrix cm = new ColorMatrix(new float[][]{
                            new float[] {0.992f,     0f,     0f, 0f, 0f},
                            new float[] {    0f, 0.992f,     0f, 0f, 0f},
                            new float[] {    0f,     0f, 0.992f, 0f, 0f},
                            new float[] {    0f,     0f,     0f, 1f, 0f},
                            new float[] {0.004f, 0.004f, 0.004f, 0f, 1f}});

ApplyColorMatrix(b, cm);

            cm = new ColorMatrix(new float[][]{
                new float[] {-1f, 0f, 0f, 0f, 0f},
                new float[] { 0f, -1f, 0f, 0f, 0f},
                new float[] { 0f, 0f, -1f, 0f, 0f},
                new float[] { 0f, 0f, 0f, 1f, 0f},
                new float[] { 0f, 0f, 0f, 0f, 1f}});

ApplyColorMatrix(b, cm);
}

        public static void ToSepia(Bitmap b)
        {
            ColorMatrix cm = new ColorMatrix(new float[][]{
                            new float[] {0.393f, 0.349f, 0.272f, 0f, 0f},
                            new float[] {0.769f, 0.686f, 0.534f, 0f, 0f},
                            new float[] {0.189f, 0.168f, 0.131f, 0f, 0f},
                            new float[] {    0f,     0f,     0f, 1f, 0f},
                            new float[] {    0f,     0f,     0f, 0f, 1f}});

ApplyColorMatrix(b, cm);
}

        public static void SetBrightness(Bitmap b, float Brightness)
        {
            ApplyColorMatrix(b, CreateBrightnessMatrix(Brightness));
        }

        public static void SetContrast(Bitmap b, float Contrast)
        {
            ApplyColorMatrix(b, CreateContrastMatrix(Contrast));
        }

        public static ColorMatrix CreateBrightnessMatrix(float Brightness)
        {
            if (Brightness < -1 || Brightness > 1)
                throw new ArgumentOutOfRangeException("Brightness value is out of range");

            ColorMatrix cm = new ColorMatrix(new float[][]{
                            new float[] {        1f,          0,          0, 0, 0},
                            new float[] {         0,         1f,          0, 0, 0},
                            new float[] {         0,          0,         1f, 0, 0},
                            new float[] {         0,          0,          0, 1f, 0},
                            new float[] {Brightness, Brightness, Brightness, 1f, 1f}});

return cm;
}

        public static ColorMatrix CreateContrastMatrix(float Contrast)
        {
            if (Contrast < 0 || Contrast > 3)
                throw new ArgumentOutOfRangeException("Contrast value is out of range");

float Trans = (1f - Contrast) / 2f;

            ColorMatrix cm = new ColorMatrix(new float[][]{
                            new float[] {Contrast,       0f,       0f, 0f, 0f},
                            new float[] {      0f, Contrast,       0f, 0f, 0f},
                            new float[] {      0f,       0f, Contrast, 0f, 0f},
                            new float[] {      0f,       0f,       0f, 1f, 0f},
                            new float[] {   Trans,    Trans,    Trans, 0f, 1f}});

return cm;
}

        public static void ApplyColorMatrix(Bitmap b, ColorMatrix cm)
        {
            using (Graphics g = Graphics.FromImage(b))
            {
                ImageAttributes ia = new ImageAttributes();
                ia.SetColorMatrix(cm);

                g.DrawImage(b, new Rectangle(0, 0, b.Width, b.Height), 0, 0, b.Width, b.Height, GraphicsUnit.Pixel, ia);
                g.Save();
            }
        }
    }
}

</code>

Second:
Add this line to you web.config in <system.web>:

<httpHandlers>
<add verb="GET" path="ImageProcessor.ashx" type="YourNamespace.ImageProcessor, NameOfDll" />
</httpHandlers>

Third:
Set the src attribute of an image to:

ImageProcessor.ashx?src=..%2fUploads%2fMyImage.jpg&w=0&h=0&g=False&n=True&s=False&b=0&c=1

Where:
src stands for the UrlEncoded Path of your image
w stands for the maximum with an image can be
h stands for the maximum height an image can be
g stands for grayscaling the image
n stands for negative of the image
s stands for sepia of the image
b stands for brightness of the image (between -1 and 1)
c stand for contrast of the image (between 0 and 3 where 1 is standard)

Fourth:
To make it easier create this control as well and compile and use it together:

<code>
using System;
using System.ComponentModel;
using System.Drawing;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace YourNamespace
{
    [
    DefaultProperty("src"),
    ToolboxData("<{0}:BetterImage runat=\"server\"></{0}:BetterImage>"),
    ToolboxBitmap(typeof(System.Web.UI.WebControls.Image))
    ]
    public class BetterImage : System.Web.UI.WebControls.Image
    {
        [
        Bindable(true),
        Category("Behavior"),
        DefaultValue(0),
        Description("Maximum width of the image."),
        ]
        public virtual int MaxWidth
        {
            get
            {
                object b = ViewState["MaxWidth"];
                return (b == null) ? 0 : (int)b;
            }
            set
            {
                ViewState["MaxWidth"] = value;
            }
        }

        [
        Bindable(true),
        Category("Behavior"),
        DefaultValue(0),
        Description("Maximum height of the image."),
        ]
        public virtual int MaxHeight
        {
            get
            {
                object b = ViewState["MaxHeight"];
                return (b == null) ? 0 : (int)b;
            }
            set
            {
                ViewState["MaxHeight"] = value;
            }
        }

        [
        Bindable(true),
        Category("Behavior"),
        DefaultValue(false),
        Description("Grayscale the image."),
        ]
        public virtual bool Grayscale
        {
            get
            {
                object b = ViewState["Grayscale"];
                return (b == null) ? false : (bool)b;
            }
            set
            {
                ViewState["Grayscale"] = value;
            }
        }

        [
        Bindable(true),
        Category("Behavior"),
        DefaultValue(false),
        Description("Negative of the image."),
        ]
        public virtual bool Negative
        {
            get
            {
                object b = ViewState["Negative"];
                return (b == null) ? false : (bool)b;
            }
            set
            {
                ViewState["Negative"] = value;
            }
        }

        [
        Bindable(true),
        Category("Behavior"),
        DefaultValue(false),
        Description("Sepia of the image."),
        ]
        public virtual bool Sepia
        {
            get
            {
                object b = ViewState["Sepia"];
                return (b == null) ? false : (bool)b;
            }
            set
            {
                ViewState["Sepia"] = value;
            }
        }

        [
        Bindable(true),
        Category("Behavior"),
        DefaultValue(0),
        Description("Brightness of the image."),
        ]
        public virtual float Brightness
        {
            get
            {
                object b = ViewState["Brightness"];
                return (b == null) ? 0: (float)b;
            }
            set
            {
                if (value < -1 || value > 1)
                    throw new ArgumentOutOfRangeException("Brightness value is out of range");

                ViewState["Brightness"] = value;
            }
        }

        [
        Bindable(true),
        Category("Behavior"),
        DefaultValue(1),
        Description("Contrast of the image."),
        ]
        public virtual float Contrast
        {
            get
            {
                object b = ViewState["Contrast"];
                return (b == null) ? 1 : (float)b;
            }
            set
            {
                if (value < 0 || value > 3)
                    throw new ArgumentOutOfRangeException("Contrast value is out of range");

                ViewState["Contrast"] = value;
            }
        }

protected override void AddAttributesToRender(HtmlTextWriter writer)
{

            if (MaxWidth > 0 || MaxHeight > 0 || Grayscale || Negative || Sepia || Brightness != 0 || Contrast != 1)
            {
                StringBuilder newSrc = new StringBuilder("ImageProcessor.ashx?src=");
                newSrc.Append(HttpContext.Current.Server.UrlEncode(base.ImageUrl) + "&w=");
                newSrc.Append(MaxWidth + "&h=");
                newSrc.Append(MaxHeight + "&g=");
                newSrc.Append(Grayscale + "&n=");
                newSrc.Append(Negative + "&s=");
                newSrc.Append(Sepia + "&b=");
                newSrc.Append(Brightness + "&c=");
                newSrc.Append(Contrast);

base.ImageUrl = newSrc.ToString();
}

            base.AddAttributesToRender(writer);
        }
    }
}
</code>

Fifth:
After compiling add this control to your Toolbox and simply use it as you would any other control!

That's all!!

Ohh.... no it's not... this post is getting even more exciting..... I've packed these two controls and two other ones in a sample web which you can download here. If you don't agree with me that this is a BetterImageProcessor just let me know!

Cheers,

Wes

How to make the text wrap in a treeview structure?

2012-10-25T22:55:54.95-04:00

This is how I wrapped the text.

Basically NodeWrap does the trick.

<asp:TreeView ID="TreeView1" runat="server" ExpandDepth="0"PopulateNodesFromClient="true" ShowLines="true" ShowExpandCollapse="true"OnTreeNodePopulate="TreeView1_TreeNodePopulate" NodeWrap="true" >

Finding Controls in a Repeater Header

2007-12-12T09:02:01.773-05:00

The rationale behind many Microsoft ASP.NET controls is sound, but at times their implementation is frustrating, and even using VS2008, old issues still exist

For example, using a repeater, it is possible find controls in a header during databinding by adding a listener to the ItemCreated or ItemDataBound events.

Once a repeater is bound, only the bound Items are easily accessible through the Items property. If you subsequently want to get to a control in a header (or footer), there is no obvious method.

If you perform a recursive search of the repeater and its controls, you will see that the control structure does contain the header. So, what's an easy way to find controls in the header?

What I do is add a static helper class to a web site that contains a recursive control finder. Now, you need to be aware that with repeated items, there will be the same named item within each repeated item (that is ID : client ID and Unique ID are managed to be unique)

Since a header and footer only exists once, their controls are easier to find by name (assuming there is no control with that name elsewhere in the repeater control descendants).

Here is some code to find controls by name and type

/// <summary>

/// Finds the control by name, starting at a control and drilling down

/// </summary>

/// <param name="controlName"></param>

/// <param name="searchStart"></param>

/// <returns></returns>

static public Control RecursiveFindControl(string controlName, Control searchStart)

{

if (searchStart.ID == controlName)

return searchStart;

else

{

foreach (Control child in searchStart.Controls)

{

Control result = RecursiveFindControl(controlName, child);

if (result != null)

return result;

}

return null;

}

/// <summary>

/// Finds the first control derived from a particulr type, recursively, starting with the saerch start control and recursively drilling down

/// </summary>

/// <param name="controlType"></param>

/// <param name="searchStart"></param>

/// <returns></returns>

static public Control RecursiveFindControl(Type controlType, Control searchStart)

{

// if the control is derived from the type passed, return that control

if (searchStart.GetType().IsSubclassOf(controlType))

return searchStart;

else

{

// iterate the children

foreach (Control child in searchStart.Controls)

{

Control result = RecursiveFindControl(controlType, child);

if (result != null)

return result;

}

return null;

}

ASP .NET How to Lock a user account

2013-03-15T19:20:35.68-04:00

This is an informational post to try and help people find the information I was looking for more quickly.

I know there are people out there that will argue that my need for this function is a result of not setting my memberships up in a more productive fashion, but I really didn't want to go back and redesign all my pages to make up for this short-sightedness (sp?). Long story short what I've run into is that my site will allow you to request an account but it will not let you register on the site unless I manually approve it. This is for a company Intranet and because of the low volume of requests it seemed the easiest way to handle it at the time. The problem is that even at the very basic level of access, there are sensitive items that I didn't want available to the public. Sometimes it is neccessary for me to give someone temporary access to the site. Rather than having to delete their account after we are finished I wanted to be able to have an account I could just turn on and off as desired (lock/unlock). The built-in functions allow for IsApproved = True/False or User.UnlockUser(), but I couldn't find a User.LockUser() function anywhere. I googled searched for a while but everything kept taking me back to "IsApproved" true/false. This would not however, stop a user from authenticating and gaining access to the root of our site.

In the process of searching I saw many other people asking the same question but they couldn't find an answer on how to "Lock" a user account. As I stated before all the posts I saw kept pointing back to IsApproved = True/False. My hope is that this thread might save future people some time. It doesn't look like ASP .NET has a built-in module for locking a useraccount, just unlocking. So if, like me, you find yourself in need of the ability to lock user accounts you might find this next little bit of code helpful. I have a process to first find and select a user account. Please use what ever works best for you here. For my scenario with right around 25 accounts, I elected to just use a dropdownlist, but any method that will allow you to access their asp .net membershipuser information will work fine. Beyond that I have two buttons that change on selected item change, button lock and button unlock. They switch their enabled property back and forth based on the selected user's locked status. Once you can grab your user's account information you'll need some code like this to manually lock their account:

Sub BtnLock_Click(ByVal sender As Object, ByVal e As EventArgs) Handles BtnLock.Click
        
        Try
            
            Dim strUser As String = DLUsers.SelectedValue
            Dim usr As MembershipUser = Membership.GetUser(strUser)
        
            Dim strSQL As String = "Update aspnet_Membership set IsLockedOut = 1 Where LoweredEmail = '" & LCase(usr.Email) & "'"
            'This connection string needs to match your webconfig file for your asp .net application database
            Dim cnStr As String = ConfigurationManager.ConnectionStrings("ApplicationServices").ConnectionString
            Dim cnn As New Data.SqlClient.SqlConnection(cnStr)
            cnn.Open()
            Dim cmd As New Data.SqlClient.SqlCommand(strSQL, cnn)
            cmd.ExecuteNonQuery()
            cnn.Close()
            
            BtnLock.Enabled = False
            BtnUnlock.Enabled = True
            
        Catch ex As Exception

        End Try
        
    End Sub

I hope this saves someone else the time I spent looking for it.

Cheers!

Dynamically hiding web parts based on current user roles.

2007-11-30T21:03:25.563-05:00

The approach allows you to set permissions to Web Parts based on any of the current user’s roles. If a user does not have a matching Role that the Web Part is configured for, the Web Part will simple not be Visible in the Declarative Catalog. If the user is later removed from the role, the Web Parts will disappear from the Zones the next time the Web page is refreshed.

(1) Add a WebPartManager, WebPartZone, CatalogZone, and a DeclarativeCatalogPart to a Default.aspx file and configure them as you would normally.

(2) Add and event handler for OnAuthorizeWebPart to the WebPartManager (You can also do this in the property page for the WebPartManager).

<asp:WebPartManager ID="WebPartManager1" runat="server" OnAuthorizeWebPart="AuthorizeWebParts">

</asp:WebPartManager>

(3) Add an AuthorizationFilter tag containing all of the roles that can access that particular control separated by a semi-colon. In this example I am using the roles AccountManagerRole, AdminRole, ManagerRole, UserRole, and TesterRole as outlined below (NOTE: I added these roles using the ASP.NET Configuration Tool under the Security tab and created a few users with mixed role assignements for testing):

<WebPartsTemplate>

<asp:Calendar ID="Calendar1" AuthorizationFilter = "AccountManagerRole; AdminRole; ManagerRole; UserRole; TesterRole" title="Calendar" runat="server"/>

</WebPartsTemplate>

(4) Add the following code to the AuthorizeWebParts function in the Default.aspx.cs file:

protected void AuthorizeWebParts(object sender, WebPartAuthorizationEventArgs e){

// Author: James Edgell 11/28/07

// This function is called for each web part by the OnAuthorizeWebPart

// event in the WebPartManager.

     // If no roles are set, simply exit
     if (String.IsNullOrEmpty(e.AuthorizationFilter))
          return;

// Separate the different roles into and array of strings
string[] rolesArray = e.AuthorizationFilter.Split(new Char[] { ';' });

// Assume the user does not have access to the web part
e.IsAuthorized = false;

     // Loop until the first role that allows the user access to the
     // web part is encountered.
     foreach (string roleStr in rolesArray)
     {
          roleStr.Trim();
          if (Roles.IsUserInRole(roleStr))
          {
               // the user ihas the rights, so authorize them
               e.IsAuthorized = true;
              break;
          }
     }
}

By setting the AuthorizationFilter to the authorized roles for each control in the WebPartsTemplate, ASP.NET will dynamically grant access and visibility of the individual Web Parts. For example: If I do not wish Users or Testers to have access to the Calendar1 Web Part, simply remove the UsersRole and TestersRole from the AuthorizationFilter tag, such as:

<asp:Calendar ID="Calendar1" AuthorizationFilter = " AccountManagerRole; AdminRole; ManagerRole " title="Calendar" runat="server"/>

This will work with any combination of User Roles set in the ASP.NET Membership system or the ASP.NET Configuration Tool. It’s that simple!

Confirm value return

2013-02-16T00:06:49.927-05:00

I just want to share this with you guys. If you are trying to get return value back from comfirm messagebox, here is the simple way.

1. insert HiddenField in the .aspx

2. Create a javascript function and include this code. like this

function DeleteMsg() {

                     var Dmsg = confirm("You about to Delete all this record(s). Are you sure you want to continue ?");

                       document.getElementById('<%=HiddenDmsg.ClientID%>').value = Dmsg;

                     return HiddenDmsg;
                 }

3. Drag a Button in the interface and call your java function. Like this

<asp:Button ID="btnDelete" runat="server" Text="Delete" onclick="btnDelete_Click" class=" " OnClientClick="return DeleteMsg();" />

4. Received the value like this

protected void btnDelete_Click(object sender, EventArgs e)
        {
            string DelMsg = HiddenDmsg.Value;

        }

Hope this will help somebody.

This is how to export data from ASP.Net database into Excel

2012-02-11T16:40:05-05:00

Moderators, if this should go into another forum that is more appropriate, please feel free to place it there.

I've seen a lot of examples of how to export data into an Excel spreadsheet using ASP.NET and most have been wrong.
This code works and is very simple to follow.
This is my first contribution to the forums, enjoy...Paul

// these namespaces need to be added to your code behind file
using System.Configuration;
using System.Data.SqlClient;
using System.Data;

namespace MySpot.UserPages
{
    public partial class Journal : System.Web.UI.Page
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MySpotDBConnStr"].ConnectionString);
        DataTable dt = new DataTable();

        // regular page_load from .aspx file
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
            }
        }

        // added a button with ID=btnDownload and double clicked it's onclick event to auto create method
        protected void btnDownload_Click(object sender, EventArgs e)
        {
            string queryStr = "SELECT * from table";
            SqlDataAdapter sda = new SqlDataAdapter(queryStr, conn);
            sda.Fill(dt);
            ExportTableData(dt);
        }

        // this does all the work to export to excel
        public void ExportTableData(DataTable dtdata)
        {
            string attach = "attachment;filename=journal.xls";
            Response.ClearContent();
            Response.AddHeader("content-disposition", attach);
            Response.ContentType = "application/ms-excel";
            if (dtdata != null)
            {
                foreach (DataColumn dc in dtdata.Columns)
                {
                    Response.Write(dc.ColumnName + "\t");
                    //sep = ";";
                }
                Response.Write(System.Environment.NewLine);
                foreach (DataRow dr in dtdata.Rows)
                {
                    for (int i = 0; i < dtdata.Columns.Count; i++)
                    {
                        Response.Write(dr[i].ToString() + "\t");
                    }
                    Response.Write("\n");
                }
                Response.End();
            }
        }
    }
}

In IE9 the regular bar comes on down at the bottom asking to save or open, just click open and there it is
In FireFox that pesky download box comes on, then pops up a dialog, click open and there it is
in Opera it asks to save or open, click open and there it is.

Apply Transactions

2013-01-05T17:54:33.717-05:00

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        string ConStr = "Data Source=ADMIN\\SQLEXPRESS;Database=shail;Integrated Security=True;";
        SqlConnection con = new SqlConnection(ConStr);
        con.Open();
        using (SqlTransaction Trans = con.BeginTransaction())
        {

            try
            {
                SqlCommand com = new SqlCommand("SaveUpdateStuPer",con);
                com.CommandType = CommandType.StoredProcedure;
                com.Parameters.AddWithValue("@Action", 0);
                com.Parameters.AddWithValue("@StdId", 0);
                com.Parameters.AddWithValue("@Name", txtName.Text);
                com.Parameters.AddWithValue("@Age", Convert.ToString(txtAge.Text));
                com.Transaction = Trans;
                com.ExecuteNonQuery();

                SqlCommand com1 = new SqlCommand("SaveUpdateStuClass", con);
                com1.CommandType = CommandType.StoredProcedure;
                com1.Parameters.AddWithValue("@Action", 0);
                com1.Parameters.AddWithValue("@ClassId", txtClassId.Text);
                com1.Parameters.AddWithValue("@Class", txtClass.Text);
                com1.Transaction = Trans;
                com1.ExecuteNonQuery();

                SqlCommand com2 = new SqlCommand("SaveUpdateStuSub", con);
                com2.CommandType = CommandType.StoredProcedure;
                com2.Parameters.AddWithValue("@Action", 0);
                com2.Parameters.AddWithValue("@SubId", txtSubId.Text);
                com2.Parameters.AddWithValue("@Subject", txtSubject.Text);
                com2.Transaction = Trans;
                com2.ExecuteNonQuery();

                Trans.Commit();
                con.Close();
                lblMsg.Text = "Saving Done..";
            }
            catch (Exception ex)
            {
                Trans.Rollback();
                lblMsg.Text = "Saving Failed..";
            }
        }

        txtName.Text = "";
        txtAge.Text = "";
        txtClassId.Text = "";
        txtClass.Text = "";
        txtSubId.Text = "";
        txtSubject.Text = "";

    }
}