Computer Programming

Sunday, June 1, 2014

June 01, 2014

How to get cell value in selected row of DataGridView in windows form c#

If you want to get cell value from DataGridview then first to bind grid with data table with any data source. Now, use this code to retrieve the cell value.

Binding Data

private void binddata()
{
con.Open();
cmd.CommandText = "select * from [student_record]";
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = ds.Tables[0].ToString ();

}

Get cell value on message box

private void button1_Click(object sender, EventArgs e)
{
string name = dataGridView1.SelectedRows[0].Cells[1].Value.ToString();
MessageBox.Show(name);

}

Code generate the following output

How to get cell value in selected row of DataGridView in windows form c#

Saturday, May 31, 2014

May 31, 2014

How to validate fileupload control in asp.net also choose selected format

In my previous article we already discussed about file upload control. Suppose your picture is required in the form of registration then you must to validate the file upload control. Also you want to take only jpeg, gif and selected format then should use RegularExpressionValidator with regular expression. Now lets take a simple example.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default5.aspx.cs" Inherits="Default5" %>

<!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>dotptogramming</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:FileUpload ID="fileUpload1" runat="server" Width="280px" />

<asp:RequiredFieldValidator ID="R1" runat="server"
ErrorMessage="Select File From File Upload" Text="*" ValidationGroup="v2"
ControlToValidate="fileUpload1" ForeColor="Red"></asp:RequiredFieldValidator>

<asp:RegularExpressionValidator ID="RE1" runat="server"
ErrorMessage="Upload .jpg, .jpeg, .gif files only." Text="*"
ValidationGroup="v2" ControlToValidate="fileUpload1"
ValidationExpression="^.+\.((jpg)|(jpeg)|(gif))$" ForeColor="Red"></asp:RegularExpressionValidator>

</div>
<p>

<asp:Button ID="Button1" runat="server" Text="Button" ValidationGroup="v2"/>
</p>
<asp:ValidationSummary ID="ValidationSummary1" runat="server"
ValidationGroup="v2" ForeColor="Red" />
</form>
</body>
</html>

Code Generate the following output

How to validate fileupload control in asp.net also choose selected format

May 31, 2014

How to pass session value in page title in asp.net

Suppose you have to enter into your account. Now, a session variable created after login and you want to pass this value in page title. If you have a master page then simple use this code in code behind page. Also you can use this code in web form. Lets take a simple example

Use only Business Logic code

public partial class Default5 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Session["username"] = "- ASP.NET CODE";
Page.Title += Session["username"].ToString();
}
}

Code Generate the following Output

How to pass session value in page title in asp.net

May 31, 2014

Dynamically add rows and columns in data table, also bind Gridview with data table

First create instance of DataTable class, which is inside in System.Data namespace. After that you make columns and rows inside the DataTable. First create columns with their data type also insert rows data in it.

Source Code

<div>
<asp:GridView ID="GridView1" runat="server">
<HeaderStyle BackColor ="Green" ForeColor ="Orange" />
<RowStyle BackColor ="Black" ForeColor ="White" />

</asp:GridView><br />

<asp:Button ID="B1" runat="server" Text="Bind GridView" onclick="B1_Click" />

</div>

Business Logic Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

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

}

protected void B1_Click(object sender, EventArgs e)
{

DataTable datatable = new DataTable();
datatable.Columns.Add("serial Number", typeof(Int32));
datatable.Columns.Add("Name", typeof(string));
datatable.Columns.Add("Address", typeof(string));
datatable.Rows.Add(1, "Jacob", "USA");
datatable.Rows.Add(2, "Lefore", "USA");
datatable.Rows.Add(3, "Bill", "UK");
datatable.Rows.Add(4, "Smith", "UK");
GridView1 .DataSource =datatable;
GridView1.DataBind ();

}
}

Code Generate the following Output

Dynamically add rows and columns in data table, also bind Gridview with data table

Friday, May 30, 2014

May 30, 2014

How to call event in page load method and example of EventHandler class

If you want to add event at run time like click event in page load method. For this types of problem you can use EventHandler class. Create a object of this class also pass new method as a parameter.

Source Code

<div>

<asp:Button ID="B1" runat="server" CommandName="Add" Text="Button" />

</div>

Business Code

public partial class Default4 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
B1.Click += new System.EventHandler(this.calculate);
}
protected void calculate(object sender, System.EventArgs e)
{
switch (((Button)sender).CommandName)
{
case "Add": Response.Write("hello");
break;
}
}

}
Code Generate the following output

How to call event in page load method and example of EventHandler class

May 30, 2014

How to Use Filtered TextBox Extender of AJAX in ASP.NET

FilteredTextBoxExtender enables you to apply filtering to a text box control that prevents certain characters from being inserted in the text box. For example, you can limit a text box to either enter only characters, or digit, or dates. This extender is different from ASP.NET validation controls as it prevents the users from entering invalid characters.

Lets take an simple example

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

<!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">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<div>
Enter Number only:
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" />
<asp:FilteredTextBoxExtender ID="FilteredTextBoxExtender1" runat="server" TargetControlID ="TextBox1" FilterType="Numbers">
</asp:FilteredTextBoxExtender>
</div>
</form>
</body>
</html>

Code Generate the following Output

How to Use Filtered TextBox Extender of AJAX in ASP.NET

For Lower case Letter Only Set

FilterType="LowercaseLetters"

For Upper Case Letter only

FilterType="UppercaseLetters"

For Upper and Number

FilterType="UppercaseLetters,Numbers"

Thursday, May 29, 2014

May 29, 2014

Nested Gridview Example in ASP.NET

A gridview with some items and another gridview structure

<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server">
<Columns>
<asp:TemplateField>

<ItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text ='<%# Eval("database field") %>' />

</ItemTemplate>
<ItemTemplate>
<asp:GridView ID="GridView2" runat="server">
<Columns>
<asp:TemplateField>

<ItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server">
</asp:DropDownList>

</ItemTemplate>

</asp:TemplateField>

</Columns>
</asp:GridView>

</ItemTemplate>


</asp:TemplateField>

</Columns>
</asp:GridView>
</div>
</form>