Want to add hyperlink to datatable for grid view: C#

by: philipjonathanPosted on 2008-08-26 at 19:48:34ID: 22321467

You can use expression column.
For example suppose each row has a column called Model, and you want to add another column called UrlLink, which looks like: http://yourserver.com/path/modelA.aspx, http://yourserver.com/path/modelB.aspx, etc.

ps. Don't forget to bind this column to your GridView

dataTable.Columns.Add("UrlLink", typeof(string), "'http://yourserver.com/path/'+Model+'.aspx'");

1:

Select all Open in new window

by: guessdipPosted on 2008-08-26 at 21:37:08ID: 22321889

I need hyperlink in every row. now i have four column in one row. so i need to put one hyperlink column name 'Edit' and i will set navigate url so when i click on edit link then i will set proper aspx file. hope u understand.

by: philipjonathanPosted on 2008-08-26 at 22:29:02ID: 22322075

Ok, probably my example is not accurate enough. What about this?

dataTable.Columns.Add("Edit", typeof(string), @"'<a href=""Edit.aspx?id='+Model+'"">Edit</a>");

1:

Select all Open in new window

by: guessdipPosted on 2008-08-26 at 22:47:06ID: 22322136

I used dataTable.Columns.Add("Edit", typeof(string), @"'<a href=""Edit.aspx?id='+Model+'"">Edit</a>");
but when i debug then i go error

The expression contains an invalid string constant: '">Edit</a>.

by: informaniacPosted on 2008-08-26 at 22:47:17ID: 22322137

Your datatable will have to contain a column for the url.

<asp:GridView ID="gvRegion" runat="Server" RowStyle-HorizontalAlign="Center" CssClass="grid_bg" 
                    AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" Width="100%" cellpadding="3" 
                    cellspacing="0" OnPageIndexChanging="gvRegion_PageIndexChanging" OnRowDataBound="gvRegion_RowDataBound" OnSorting="gvRegion_Sorting">
                    <Columns>
                        <asp:BoundField DataField="Project" SortExpression="Project" HeaderText="PRoject Name" />
                        <asp:BoundField DataField="bitIsActive" SortExpression="bitIsActive" HeaderText="Status" />
                        <asp:TemplateField HeaderText="Edit">
                            <ItemTemplate>
                                <asp:LinkButton ID="lnkEdit" runat="Server" CommandName="Edit" CommandArgument='<% #Bind("linkURL") %>'>Edit</asp:LinkButton>
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                        <RowStyle HorizontalAlign="Center" />
                    </asp:GridView>
 
protected void gvRegion_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName=="Edit")
        {
            Response.Redirect(e.CommandArgument.ToString());
        }
    }

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:

Select all Open in new window

by: guessdipPosted on 2008-08-26 at 22:56:19ID: 22322166

I did web part for sharepoint and i used gridview and datatable and i code

dtProjectList.Columns.Add("Project", typeof(System.String));
dtProjectList.Columns.Add("OS", typeof(System.String));
dtProjectList.Columns.Add("OS Version", typeof(System.String));
dtProjectList.Columns.Add("Model", typeof(System.String));
Now i need one more colum and it must me hyperlink so i can set navigate url for each column.

by: philipjonathanPosted on 2008-08-26 at 23:06:35ID: 22322192

I missed an apostrophe after the
"">Edit</a>

What about this:

dataTable.Columns.Add("Edit", typeof(string), @"'<a href=""Edit.aspx?id='+Model+'"">Edit</a>'");

1:

Select all Open in new window

by: guessdipPosted on 2008-08-26 at 23:16:55ID: 22322235

HIi, This time i dont get any error ., page is display but it displays the text.

i coded dtProjectList.Columns.Add("Edit", typeof(string), @"'<a href=""Edit.aspx"">Edit</a>'");
and i got column name Edit and value is <a href="Edit.aspx">Edit</a>. i needed edit link in that colum so i can click ang go to that url.. i m sendin my whole code..

using System;
using System.Runtime.InteropServices;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Serialization;
using System.Data;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using Microsoft.SharePoint.WebPartPages;
 
namespace GridTreeDmg
{
    [Guid("d57d67d5-0b80-443d-8eb3-96f05f6c7cd9")]
    public class GridDmg : System.Web.UI.WebControls.WebParts.WebPart
    {
        private InterfaceTree theprovider;
        GridView gr = new GridView();
        
        SPWeb web = SPContext.Current.Web;
        DataTable dt ;
        DataTable dtProjectList;
        DataTable dtPhases ;
        DataTable dtMilestone;
        DataTable dtIssue ;
        DataTable dtTask ;
        DataTable dtSubTask ;
        string TheContentProject = "ktazu400";
        string TheContentPhase = "ktazu400";
        string TheContentTask = "ktazu400";
        string TheContentSubTask = "ktazu400";
        string TheContentListname = "ktazu400";
        string TheContentIssue = "ktazu400";
        string TheContentMilestone = "ktazu400";
        string TheContentPath = "ktazu400";
 
 
        
 
        
         
        protected override void CreateChildControls()
        {
         //   Controls.Clear();
         //   base.CreateChildControls();
        
            gr.ID = "gr";
            
            
            
         
 
 
            dt = new DataTable();
            dtProjectList = new DataTable();
            dtPhases = new DataTable();
            dtMilestone = new DataTable();
            dtIssue = new DataTable();
            dtTask = new DataTable();
            dtSubTask = new DataTable();
            
            
 
            gr.EnableViewState = true;
            gr.AutoGenerateEditButton = true;
            
            gr.RowEditing += new GridViewEditEventHandler(gr_RowEditing);
 
            dtProjectList.Columns.Add("Project", typeof(System.String));
            dtProjectList.Columns.Add("OS", typeof(System.String));
            dtProjectList.Columns.Add("OS Version", typeof(System.String));
            dtProjectList.Columns.Add("Model", typeof(System.String));
            dtProjectList.Columns.Add("Edit", typeof(string), @"'<a href=""Edit.aspx"">Edit</a>'");
 
 
 
 
 
 
 
            dtPhases.Columns.Add("Phase", typeof(System.String));
            dtPhases.Columns.Add("Assigned To", typeof(System.String));
            dtPhases.Columns.Add("Project", typeof(System.String));
            dtPhases.Columns.Add("Status", typeof(System.String));
 
 
            dtMilestone.Columns.Add("Milestone", typeof(System.String));
            dtMilestone.Columns.Add("Due Date", typeof(System.String));
            dtMilestone.Columns.Add("Complete", typeof(System.String));
            dtMilestone.Columns.Add("Project", typeof(System.String));
 
            dtIssue.Columns.Add("Issue", typeof(System.String));
            dtIssue.Columns.Add("Assigned To", typeof(System.String));
            dtIssue.Columns.Add("Status", typeof(System.String));
            dtIssue.Columns.Add("Project", typeof(System.String));
 
            dtTask.Columns.Add("Task", typeof(System.String));
            dtTask.Columns.Add("Assigned To", typeof(System.String));
            dtTask.Columns.Add("Status", typeof(System.String));
            dtTask.Columns.Add("Due Date", typeof(System.String));
 
            dtSubTask.Columns.Add("Sub Task", typeof(System.String));
            dtSubTask.Columns.Add("Assigned To", typeof(System.String));
            dtSubTask.Columns.Add("Status", typeof(System.String));
            dtSubTask.Columns.Add("Due Date", typeof(System.String));
 
 
           
          
 
    
            
 
        }
 
        void edit_Click(object sender, EventArgs e)
        {
            //throw new NotImplementedException();
            WebPartManager.DisplayMode = WebPartManager.EditDisplayMode;
            TheContentProject = "";
        }
 
        void gr_RowEditing(object sender, GridViewEditEventArgs e)
        {
            //throw new NotImplementedException();
            gr.EnableViewState = true;
            WebPartManager.DisplayMode = WebPartManager.EditDisplayMode;
            
        }
 
 
        private void FillDataForProjectList()
        {
            // For Project List
            try
            {
 
 
               
               
                SPList Projectlist = web.Lists["Project List"];
                SPQuery queryProjectList = new SPQuery();
                queryProjectList.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='OS' /><FieldRef Name='OS_x0020_Version' /><FieldRef Name='Model' /><FieldRef Name='Environment' /><FieldRef Name='HostType' /><FieldRef Name='CPUs' /><FieldRef Name='Project_x0020_Manager' />";
                queryProjectList.Query = " <OrderBy><FieldRef Name='Title' /><FieldRef Name='OS' /><FieldRef Name='OS_x0020_Version' /><FieldRef Name='Model' /><FieldRef Name='Environment' /><FieldRef Name='HostType' /><FieldRef Name='CPUs' /><FieldRef Name='Project_x0020_Manager' /></OrderBy><Where><Eq><FieldRef Name='Title' /><Value Type='Text'>" + TheContentProject + "</Value></Eq></Where>";
                SPListItemCollection colProjectlist = Projectlist.GetItems(queryProjectList);
 
                dt = colProjectlist.GetDataTable();
                foreach (DataRow dr in dt.Rows)
                {
                    DataRow newrow = dtProjectList.NewRow();
                    try
                    {
                                                       
                        
                        
               
                        newrow["Project"] = dr["Title"];
                        newrow["OS"] = dr["OS"];
                        newrow["OS Version"] = dr["OS_x0020_Version"];
                        newrow["Model"] = dr["Model"];
                              
                        
                        dtProjectList.Rows.Add(newrow);
                    }
                        
                    catch { }
                 
                }
            }
            catch { }
            { }
                  
        }
 
        private void FillDataForPhase()
        {
 
            // For Phases
            try
            {
                SPList Phase = web.Lists["Project Phase"];
                SPQuery Phasequery = new SPQuery();
                if (TheContentListname == "PhaseList")
                {
                    Phasequery.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='Column2' /><FieldRef Name='Column3' /><FieldRef Name='Column7' />";
                    Phasequery.Query = "<OrderBy><FieldRef Name='Title' /><FieldRef Name='Column2' /><FieldRef Name='Column3' /><FieldRef Name='Column7' /></OrderBy><Where><Eq><FieldRef Name='Column7' /><Value Type='Text'>" + TheContentProject + "</Value></Eq></Where>";
                }
                else
                {
                    Phasequery.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='Column2' /><FieldRef Name='Column3' /><FieldRef Name='Column7' />";
                    Phasequery.Query = "<OrderBy><FieldRef Name='Title' /><FieldRef Name='Column2' /><FieldRef Name='Column3' /><FieldRef Name='Column7' /></OrderBy><Where><And><Eq><FieldRef Name='Title' /><Value Type='Text'>" + TheContentPhase + "</Value></Eq><Eq><FieldRef Name='Column7' /><Value Type='Text'>" + TheContentProject + "</Value></Eq></And></Where>";
                                                                                                                                                                      
                }
 
                SPListItemCollection colPhases = Phase.GetItems(Phasequery);
 
                dt = colPhases.GetDataTable();
                foreach (DataRow dr in dt.Rows)
                {
                    DataRow newrow = dtPhases.NewRow();
                    try
                    {
                        newrow["Phase"] = dr["Title"];
                        newrow["Assigned To"] = dr["Column2"];
                        newrow["Status"] = dr["Column3"];
                        newrow["Project"] = dr["Column7"];
                        dtPhases.Rows.Add(newrow);
                    }
                    catch { }
                }
 
 
 
            }
            catch
            {
            }
        }
 
        [ConnectionConsumer("The Content")]
        public void InitializeProvider(InterfaceTree provider)
        {
            theprovider = provider;
        }
 
        private void FillDataForIssue()
        {
            // For Issue
            try
            {
                SPList Issue = web.Lists["Issue"];
                SPQuery Issuequery = new SPQuery();
                if (TheContentListname == "IssueList")
                {
                   Issuequery.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='Assigned_x0020_To' /><FieldRef Name='Status' /><FieldRef Name='Project' />";
                   Issuequery.Query = "<OrderBy><FieldRef Name='Title' /><FieldRef Name='Assigned_x0020_To' /><FieldRef Name='Status' /><FieldRef Name='Project' /></OrderBy><Where><Eq><FieldRef Name='Project' /><Value Type='Text'>" + TheContentProject + "</Value></Eq></Where>";
                }
                else
                {
                   Issuequery.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='Assigned_x0020_To' /><FieldRef Name='Status' /><FieldRef Name='Project' />";
                   Issuequery.Query = "<OrderBy><FieldRef Name='Title' /><FieldRef Name='Assigned_x0020_To' /><FieldRef Name='Status' /><FieldRef Name='Project' /></OrderBy><Where><And><Eq><FieldRef Name='Project' /><Value Type='Text'>" + TheContentProject + "</Value></Eq><Eq><FieldRef Name='Title' /><Value Type='Text'>" + TheContentIssue + "</Value></Eq></And></Where>";
                }
                SPListItemCollection colIssue = Issue.GetItems(Issuequery);
 
                dt = colIssue.GetDataTable();
                foreach (DataRow dr in dt.Rows)
                {
                    DataRow newrow = dtIssue.NewRow();
                    try
                    {
                        newrow["Issue"] = dr["Title"];
                        newrow["Assigned To"] = dr["Assigned_x0020_To"];
                        newrow["Status"] = dr["Status"];
                        newrow["Project"] = dr["Project"];
                        dtIssue.Rows.Add(newrow);
                    }
                    catch { }
                }
            }
            catch { }
        }
 
        private void FillDataForMilestone()
        {
            // For Milestone
            try
            {
                SPList Milestone = web.Lists["Project Milestone"];
                SPQuery Milestonequery = new SPQuery();
                if (TheContentListname == "MilestoneList")
                {
                    Milestonequery.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='Project_x0020_Milestone' /><FieldRef Name='Due_x0020_Date' /><FieldRef Name='Complete' />";
                    Milestonequery.Query = "<OrderBy><FieldRef Name='Title' /><FieldRef Name='Project_x0020_Milestone' /><FieldRef Name='Due_x0020_Date' /><FieldRef Name='Complete' /></OrderBy><Where><Eq><FieldRef Name='Title' /><Value Type='Text'>" + TheContentProject + "</Value></Eq></Where>";
                }
                else
                {
                    Milestonequery.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='Project_x0020_Milestone' /><FieldRef Name='Due_x0020_Date' /><FieldRef Name='Complete' />";
                    Milestonequery.Query = "<OrderBy><FieldRef Name='Title' /><FieldRef Name='Project_x0020_Milestone' /><FieldRef Name='Due_x0020_Date' /><FieldRef Name='Complete' /></OrderBy><Where><And><Eq><FieldRef Name='Title' /><Value Type='Text'>" + TheContentProject + "</Value></Eq><Eq><FieldRef Name='Project_x0020_Milestone' /><Value Type='Text'>" + TheContentMilestone + "</Value></Eq></And></Where>";
                }
                SPListItemCollection colMilestone = Milestone.GetItems(Milestonequery);
 
                dt = colMilestone.GetDataTable();
                foreach (DataRow dr in dt.Rows)
                {
                    DataRow newrow = dtMilestone.NewRow();
                    try
                    {
                        newrow["Milestone"] = dr["Project_x0020_Milestone"];
                        newrow["Due Date"] = dr["Due_x0020_Date"];
                        newrow["Complete"] = dr["Complete"];
                        newrow["Project"] = dr["Title"];
                        dtMilestone.Rows.Add(newrow);
                    }
                    catch { }
                }
            }
            catch { }
        }
 
        private void FillDataForTask()
        {
            // For Task
            try
            {
                SPList Task = web.Lists["Project Task"];
                SPQuery Taskquery = new SPQuery();
                if (TheContentListname == "TaskList")
                {
                    Taskquery.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='Status' /><FieldRef Name='AssignedTo' /><FieldRef Name='DueDate' />";
                    Taskquery.Query = "<OrderBy><FieldRef Name='Title' /><FieldRef Name='Status' /><FieldRef Name='AssignedTo' /><FieldRef Name='DueDate' /></OrderBy><Where><And><Eq><FieldRef Name='Project' /><Value Type='Text'>" + TheContentProject + "</Value></Eq><Eq><FieldRef Name='Phase' /><Value Type='Text'>" + TheContentPhase + "</Value></Eq></And></Where>";
                }
                else
                {
                    Taskquery.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='Status' /><FieldRef Name='AssignedTo' /><FieldRef Name='DueDate' />";
                    Taskquery.Query = "<OrderBy><FieldRef Name='Title' /><FieldRef Name='Status' /><FieldRef Name='AssignedTo' /><FieldRef Name='DueDate' /></OrderBy><Where><And><And><Eq><FieldRef Name='Project' /><Value Type='Text'>" + TheContentProject + "</Value></Eq><Eq><FieldRef Name='Phase' /><Value Type='Text'>" + TheContentPhase + "</Value></Eq></And><Eq><FieldRef Name='Title' /><Value Type='Text'>" + TheContentTask + "</Value></Eq></And></Where>";
 
                }
                SPListItemCollection colTask = Task.GetItems(Taskquery);
 
                dt = colTask.GetDataTable();
                foreach (DataRow dr in dt.Rows)
                {
                    DataRow newrow = dtTask.NewRow();
                try
                {
                        newrow["Task"] = dr["Title"];
                        newrow["Assigned To"] = dr["AssignedTo"];
                        newrow["Status"] = dr["Status"];
                        newrow["Due Date"] = dr["DueDate"];
                        dtTask.Rows.Add(newrow);
                }
                catch { }
                }
            }
            catch { }
        }
 
        private void FillDataForSubTask()
        {
            // For Sub Task
            try
            {
                SPList SubTask = web.Lists["Sub Task"];
                SPQuery SubTaskquery = new SPQuery();
                if (TheContentListname == "SubTaskList")
                {
                    SubTaskquery.ViewFields = "<FieldRef Name='project' /><FieldRef Name='phase' /><FieldRef Name='task' /><FieldRef Name='Title' /><FieldRef Name='AssignedTo' /><FieldRef Name='Status' /><FieldRef Name='DueDate' />";
                    SubTaskquery.Query = "<OrderBy><FieldRef Name='project' /><FieldRef Name='phase' /><FieldRef Name='task' /><FieldRef Name='Title' /><FieldRef Name='AssignedTo' /><FieldRef Name='Status' /><FieldRef Name='DueDate' /></OrderBy> <Where><And><And><Eq><FieldRef Name='project' /><Value Type='Text'>" + TheContentProject + "</Value></Eq><Eq><FieldRef Name='phase' /><Value Type='Text'>" + TheContentPhase + "</Value></Eq></And><Eq><FieldRef Name='task' /><Value Type='Text'>" + TheContentTask + "</Value></Eq></And></Where>";
                }
                else
                {
                    SubTaskquery.ViewFields = "<FieldRef Name='project' /><FieldRef Name='phase' /><FieldRef Name='task' /><FieldRef Name='Title' /><FieldRef Name='AssignedTo' /><FieldRef Name='Status' /><FieldRef Name='DueDate' />";
                    SubTaskquery.Query = "<OrderBy><FieldRef Name='project' /><FieldRef Name='phase' /><FieldRef Name='task' /><FieldRef Name='Title' /><FieldRef Name='AssignedTo' /><FieldRef Name='Status' /><FieldRef Name='DueDate' /></OrderBy> <Where><And><And><And><Eq><FieldRef Name='project' /><Value Type='Text'>" + TheContentProject + "</Value></Eq><Eq><FieldRef Name='ID' /><Value Type='Text'>" + TheContentSubTask + "</Value></Eq></And><Eq><FieldRef Name='phase' /><Value Type='Text'>" + TheContentPhase + "</Value></Eq></And><Eq><FieldRef Name='task' /><Value Type='Text'>" + TheContentTask + "</Value></Eq></And></Where>";
                }
                SPListItemCollection colSubTask = SubTask.GetItems(SubTaskquery);
 
                dt = colSubTask.GetDataTable();
                foreach (DataRow dr in dt.Rows)
                {
                    DataRow newrow = dtSubTask.NewRow();
                    try
                    {
                        newrow["Sub Task"] = dr["Title"];
                        newrow["Assigned To"] = dr["AssignedTo"];
                        newrow["Status"] = dr["Status"];
                        newrow["Due Date"] = dr["DueDate"];
                        dtSubTask.Rows.Add(newrow);
                    }
                    catch { }
                }
            }
            catch { }
        }
 
      
 
        protected override void Render(HtmlTextWriter writer)
        {
        //    base.Render(writer);
            EnsureChildControls();
            if (theprovider != null)
            {
                TheContentProject = theprovider.TheContentProject;
                ViewState["TheContent"] = TheContentProject;
 
                TheContentIssue = theprovider.TheContentIssue;
                ViewState["TheContent"] = TheContentIssue;
 
                TheContentMilestone = theprovider.TheContentMilestone;
                ViewState["TheContent"] = TheContentMilestone;
 
                TheContentPhase = theprovider.TheContentPhase;
                ViewState["TheContent"] = TheContentPhase;
 
                TheContentTask = theprovider.TheContentTask;
                ViewState["TheContent"] = TheContentTask;
 
 
                TheContentSubTask = theprovider.TheContentSubTask;
                ViewState["TheContent"] = TheContentSubTask;
 
                TheContentListname = theprovider.TheContentListname;
                ViewState["TheContent"] = TheContentListname;
 
                TheContentPath = theprovider.TheContentPath;
                ViewState["TheContent"] = TheContentPath;
                //    ThePhase = theprovider.ThePhase;
                //    ViewState["TheContent"] = ThePhase;
 
                //    TheContent = theprovider.TheTask;
                //    ViewState["TheContent"] = TheTask;
 
            }
            if (theprovider.TheContentListname == "Project List")
            {
                FillDataForProjectList();
                   gr.DataSource = dtProjectList;
      
                   
            }
            if (theprovider.TheContentListname == "Phase" || theprovider.TheContentListname == "PhaseList")
            {
                FillDataForPhase();
                gr.DataSource = dtPhases;
            }
            if (theprovider.TheContentListname == "Issue" || theprovider.TheContentListname == "IssueList")
            {
                FillDataForIssue();
                gr.DataSource = dtIssue;
            }
            if (theprovider.TheContentListname == "Milestone" || theprovider.TheContentListname == "MilestoneList")
            {
                FillDataForMilestone();
                gr.DataSource = dtMilestone;
            }
            if (theprovider.TheContentListname == "Task" || theprovider.TheContentListname == "TaskList")
            {
            FillDataForTask();
            gr.DataSource = dtTask;
            }
            if (theprovider.TheContentListname == "SubTask" || theprovider.TheContentListname == "SubTaskList")
            {
            FillDataForSubTask();
            gr.DataSource = dtSubTask;
            }
 
      
 
            gr.DataBind();
            Controls.Add(gr);
           
      
            Label l1 = new Label();
            Label lblPath = new Label();
               
                 
            if (theprovider != null)
            {
                l1.Text = theprovider.TheContentPath;
              //  l2.Text = theprovider.ThePhase;
              //  l3.Text = theprovider.TheTask;
 
            }
            lblPath.Text = "Path -->" + " " + l1.Text;
            
            lblPath.RenderControl(writer);
            gr.RenderControl(writer);
      
            
        }   
    }
}

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:
370:
371:
372:
373:
374:
375:
376:
377:
378:
379:
380:
381:
382:
383:
384:
385:
386:
387:
388:
389:
390:
391:
392:
393:
394:
395:
396:
397:
398:
399:
400:
401:
402:
403:
404:
405:
406:
407:
408:
409:
410:
411:
412:
413:
414:
415:
416:
417:
418:
419:
420:
421:
422:
423:
424:
425:
426:
427:
428:
429:
430:
431:
432:
433:
434:
435:
436:
437:
438:
439:
440:
441:
442:
443:
444:
445:
446:
447:
448:
449:
450:
451:
452:
453:
454:
455:
456:
457:
458:
459:
460:
461:
462:
463:
464:
465:
466:
467:
468:
469:
470:
471:
472:

Select all Open in new window

by: guessdipPosted on 2008-08-26 at 23:22:06ID: 22322252

i think y
ou are missing something.. it display the whole string. i think edit link should be display. i need that things.. now it display <a href="Edit.aspx">Edit</a>..

by: philipjonathanPosted on 2008-08-26 at 23:36:10ID: 22322298

Really? Hmm strange, I used to do that with DataGrid, thought could do the same with GridView. Can I see your aspx code please?

by: informaniacPosted on 2008-08-26 at 23:40:02ID: 22322316

Does this work?
dtProjectList.Columns.Add("Edit", typeof(string), Server.HtmlDecode("'<a href=""Edit.aspx"">Edit</a>'"));

by: philipjonathanPosted on 2008-08-26 at 23:44:39ID: 22322338

I saw HyperLinkField in another question thread, if expression column does not help you, see if this helps:

<asp:HyperLinkField HeaderText="your header" DataTextField="The field you want to display" DataNavigateUrlFields="The field that will provide the navigation, usually an ID field" DataNavigateUrlFormatString="Edit.aspx?id={0}" />

In your case I suppose DataTextField="Edit"

The link:
http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/ASP_DOT_NET/Q_22104733.html

by: guessdipPosted on 2008-08-27 at 09:44:00ID: 22326802

Hiii,i wrote dtProjectList.Columns.Add("Edit", typeof(string), Server.HtmlDecode("'<a href=""Edit.aspx"">Edit</a>'")); But it is also not working. we mention string type so it takes as a string only. and i did web part so i did not use aspx file. i have to mention each and everything in c# code only.

by: guessdipPosted on 2008-08-28 at 11:32:48ID: 22338179

Did u try for that?? I also used hyperlinkfield . but gridview dont accept this column..

by: philipjonathanPosted on 2008-08-28 at 19:01:47ID: 22341584

What about:

ps. Add this code before you databind the GridView.

HyperLinkField f = new HyperLinkField();
f.HeaderText = "your header";  // Maybe "Edit"
f.DataTextField = "The field you want to display";  // Maybe "Edit"
f.DataNavigateUrlFields="The field that will provide the navigation, usually an ID field";  // Maybe "ID
f.DataNavigateUrlFormatString="Edit.aspx?id={0}";
 
myGridView.Columns.Add(f);

1:
2:
3:
4:
5:
6:
7:

Select all Open in new window

by: guessdipPosted on 2008-08-28 at 19:15:09ID: 31490534

Thank u . i got the solution..

by: guessdipPosted on 2008-08-28 at 19:17:11ID: 22341643

Ok now i am able to navigate the url. But i also put the edit button. and i mentioned the event handling for that. but it is not fire when i click edit button.

Question

Want to add hyperlink to datatable for grid view

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

C#

Navigational Systems

Microsoft Visual C#.Net

Visual Studio

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Need individual assistance?

Our experts are ready to help.

Want to learn from the best?

Read articles from industry experts.

Working on a long term project?

Store your work and research.

What Makes Experts Exchange Unique?

Trusted by the world's most respected brands.

Faithfully serving IT professionals since 1996.

Related Solutions

Free Tech Articles

Cloud Class Webinars

Join the Community

Give a Little. Get a Lot.

Answers

3 Ways to Join

The Experts

The Experts

Testimonials

Testimonials

Testimonials

Business Clients

Business Clients

In the Press

In the Press

In the Press