Extended Solution

How to Add Gridview Header columns Vertically not Horizontally/How to add GridView Rows Vertically

2011-07-04T20:36:00.000-07:00

This is scenario that many people stuck with so I did some investigation and finally came a good standard MSDN specified solution. So please take the advantage of it. Have nice cording ;)

Step 01

Add a gridview in to your aspx.(With no Columns)

<asp:GridView ID="GridView" runat="server" BorderWidth="0px" Width="100%" ShowHeader="False">

</asp:GridView>

Style it as you want.

Step 02

Code behind.Bind the data.

private void PopulateGridView()

{

GridView.DataSource = GetData();

GridView.DataBind();

}

private DataTable GetData()

{

DataTable table = new DataTable();

table.Columns.Add(GridColumnName, typeof(string));

table.Columns.Add(GridColumnEmail, typeof(string));

table.Rows.Add("Asaj saii", "asag@IBM.com");

GridFormatter gridformatter = new GridFormatter();

DataTable datatable = gridformatter.FormatDataTable();

gridformatter.AddDataRow(Localization.GetString("Name", this.LocalResourceFile), table.Rows[0][0].ToString(), datatable);

gridformatter.AddDataRow(Localization.GetString("Email", this.LocalResourceFile), table.Rows[0][1].ToString(), datatable);

return datatable;

}

public class GridFormatter

{

public DataTable FormatDataTable()

{

DataTable datatable = new DataTable();

datatable.Columns.Add("Description", System.Type.GetType("System.String"));

datatable.Columns.Add("Value", System.Type.GetType("System.String"));

return datatable;

}

public void AddDataRow(string description, string value, DataTable dt)

{

DataRow datarow;

datarow = dt.NewRow();

datarow["Description"] = description;

datarow["Value"] = value;

dt.Rows.Add(datarow);

}

Step 03

Test it.Cheers!

How to add grid view columns by code behind/Add columns by programmatically/Add columns by server side

2011-07-01T00:56:00.001-07:00

This code snippet show you how to add grid view columns by programmatically but nor actually by the design.

ASPX

<asp:GridView ID="Grid" runat="server" Width="100%" AutoGenerateColumns="False" OnInit="Grid_Init">

</asp:GridView>

ASPX.CS

At grid view initialization,

protected void Grid_Init(object sender, EventArgs e)

{

Grid.AutoGenerateColumns = false;

Grid.HeaderStyle.HorizontalAlign = HorizontalAlign.Right;

BoundField date = CreateBoundField("Date","Header name","format"}");

BoundField month = CreateBoundField("Month","Header name","format"}");

BoundField year = CreateBoundField("Year","Header name","format"}");

//Styling header columns

date.ItemStyle.HorizontalAlign = HorizontalAlign.Right;

month.ItemStyle.HorizontalAlign = HorizontalAlign.Left;

year.ItemStyle.HorizontalAlign = HorizontalAlign.Right;

Grid.Columns.Add(date);

Grid.Columns.Add(activity);

Grid.Columns.Add(paid);

}

private static BoundField CreateBoundField(string dataField, string header, string dataFormatString)

{

BoundField field = new BoundField();

field.DataField = dataField;

field.HeaderText = header;

if (!dataFormatString.Equals(""))

{

field.DataFormatString = dataFormatString;

}

field.SortExpression = dataField;

field.HtmlEncode = false;

return field;

}

Addition:

You can add image column also if you want by using the Grid_RowDataBound event.

protected void GridViewRowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

ImageButton Button = new ImageButton();

Button.ID = "actionNoteButton";

Button.ImageUrl = ResolveUrl("imagepath.jpg");

e.Row.Cells[column index].Controls.Add(Button);

}

cheers!

How to Pass value in to code behind when click on Gridview row - Server side

2011-06-30T22:11:00.000-07:00

This will show how to pass key values in to code behind when you click on GridView row link button.

You have to use:

· Command Name

· OnRowCommand Event

· TemplateField with Link button.

ASPX

· Add row command in to gridview

· OnRowCommand="GridViewRowCommand"

· Add template field with asp link button and set the command name as you wish.put the data table column name you want to bind in to the Text ad evalue.

<asp:TemplateField>

<asp:LinkButton ID="Number" runat="server" Text='<%# Eval("Number") %>' CommandName="Number"

CommandArgument='<%# Eval("Number") %>'></asp:LinkButton>

</ItemTemplate>

</asp:TemplateField>

ASPX.CS

· At the row command event capture the value set by aspx and do your work..

protected void GridViewRowCommand(object sender, GridViewCommandEventArgs e)

{

if (e.CommandName != null)

{

if (e.CommandName == "Number")

{

string Number = e.CommandSource.ToString();

//Your code

}

cheers!

How to add image link in to Gridview column

2011-06-30T22:10:00.003-07:00

This will add cursor hand when hover on to the image.

.aspx

<asp:TemplateField>

<asp:HyperLink ID="Image" runat="server" />

</ItemTemplate>

</asp:TemplateField>

</Columns>

aspx.cs

protected void GridViewRowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

HyperLink rLink = (HyperLink)e.Row.Cells[column index].Controls[1];

Link.ImageUrl = "image path";

Link.NavigateUrl = "http://www.google.com";

}

How to remove Gridview sort column Header underline - for beginners(C#)

2011-06-30T22:10:00.001-07:00

code behind:

Use fallowing method in RowDatabound Event.

RemoveHeaderUnderLine(e);

private static void RemoveHeaderUnderLine(GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.Header)

{

for (int cell = 0; cell < e.Row.Cells.Count; cell++)

{

if (e.Row.Cells[cell].Controls.Count > 0)

{

LinkButton Link = (LinkButton)e.Row.Cells[cell].Controls[0];

Link.Attributes.Add("style", "text-decoration:none;");

}

Creating a DataTable - for beginners(C#)

2011-06-30T22:09:00.004-07:00

How to create a DataTable for bind Data

private static DataTable CreateDataTable()

{

DataTable table = new DataTable();

table.Columns.Add(AccountNumb, typeof(Int64));

table.Columns.Add(Name, typeof(string));

table.Columns.Add(Owner Address, typeof(string));

table.Rows.Add("001225", "Gustavo Santaolalla", " frederick burner");

table.Rows.Add("001220", "Gustavo Santaolalla", " frederick burner");

return table;

}

Get started DNN - DNN for dummies

2011-06-30T22:09:00.002-07:00

CREATING A DNN WEB SITE

Prerequisite:

§ DDN Zip file(Required version ex:5.06.02)

§ DNN installation(5.6.2 Visual Studio starter kit)

§ MS SQL Express.

Standard way

1.Creat a class library project.

2.Install the Visual studio starter kit.

3.Extract the DNN Zip file and copy it inside to the physical location of the created class library project is.

4.Add the DNN location/Site as an existing web site to the project created early.

5.Then run the site if success it will automatically add the DB in to SQL Server.

Way -2

1.Change the configuration file by changing the Database.

2.Then run the site it will install the site. with adding required tables in to DB

IIS configurations

1.Create a virtual directory in IIS

2.Give the Physical path to the DNN directory in the project.

3.Giv "Network Services " Privileges to the DNN directory.

When does the Database.mdf crated in DNN

2011-06-30T22:09:00.000-07:00

this is important point that I'm used to forget ;D so I wanted to get it noted somewhere so that the reason of this post and think this might help some others as well.

• in DNN the database.mdf will created at the point of it going to install.
• In my case it will created when you build by using NANT in command line then after you can attach it.

Server Error in '/' Application

2011-06-30T22:08:00.000-07:00

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Fix- Go to Local service -start sql service :)

StringSplit function -SQL

2011-06-30T22:06:00.004-07:00

This is a function used to split string and fie sql queries

ALTER PROCEDURE [Door].[XXXXXXXXXXXXXXXXXXXXXXXXXXx]

@GroupIdList varchar(max)

,@Type int

BEGIN

DECLARE @Delimeter CHAR(1);

Fire javascript function by code behind

2011-06-30T22:06:00.002-07:00

You can access JavaScript function by code behind and fire those easily.

Server side

string myScript = "close();";

ScriptManager.RegisterStartupScript(this.Page, typeof(Page),"CloseWindowKey", myScript, true);

Client side

function close() {

//Functionality for close pop up window

}

Adding Image button to data grid view

2011-06-30T22:06:00.000-07:00

1.Add image button under template field it will be easier than adding a command field.

<asp:TemplateField ItemStyle-HorizontalAlign="Center">

<asp:ImageButton ID="selectButton" CommandName="Select" runat="server"/>

ItemTemplate>

asp:TemplateField>

<asp:BoundField DataField="Name">

asp:BoundField>

<asp:BoundField DataField="Id">

asp:BoundField>

<asp:BoundField DataField="MainCreditorName">

asp:BoundField>

Columns>

2.Add the SelectedIndexChanged event and it will fire when you click on image button on the grid.

protected void XXXXXXXXXX_SelectedIndexChanged(object sender, EventArgs e)

{

}

3.You are done

Server side Row Click - Get data from GridView

2011-06-30T22:05:00.003-07:00

ASPX Page

<asp:GridView ID="GridViewUsers" runat="server" AutoGenerateColumns="False"Width="100%"

OnSelectedIndexChanged="GridViewUsers_SelectedIndexChanged"DataKeyNames="Id" OnRowCommand="GridViewUsers_RowCommand">

<Columns>

<asp:BoundField HeaderText="User Name" DataField="Name" />

<asp:BoundField HeaderText="Main Creditor" DataField="Id" />

<asp:BoundField HeaderText="Main CReditorName" DataField="MainCreditorName"/>

Columns>

<HeaderStyle HorizontalAlign="Left" CssClass="spn_gridHeader" />

<%-- --%>

asp:GridView>

protected void GridViewUsers_SelectedIndexChanged(object sender, EventArgse)

{

}

protected override void Render(System.Web.UI.HtmlTextWriter writer)

{

foreach (GridViewRow row in GridViewUsers.Rows)

{

if (row.RowType == DataControlRowType.DataRow)

{

ClientScriptManager cs = Page.ClientScript;

row.Attributes["onmouseover"] =

"this.style.cursor='hand';this.style.textDecoration='underline';";

row.Attributes["onmouseout"] =

"this.style.textDecoration='none';";

// Set the last parameter to True

// to register for event validation.

row.Attributes["onclick"] =

cs.GetPostBackClientHyperlink(GridViewUsers,

"Select$" + row.DataItemIndex, true);

}

base.Render(writer);

}

Page Load

GridViewUsers.RowCommand += GridViewUsers_RowCommand;

First Post

2011-06-30T22:05:00.001-07:00

This site is all about sharing the knowledge with the world freely coz I believe that the human knowledge should share among us coz it belongs to the world. So take time surf yourself and make life easy.