How to add a mailto link inside a datagrid
<asp:TemplateColumn HeaderText=’Email Address’ HeaderStyle-Font-Bold=’True’> <ItemTemplate> <a href=’Mailto:<%# DataBinder.Eval(Container.DataItem,’email’).ToString() %>’> <%# DataBinder.Eval(Container.DataItem,’email’).ToString() %> </a> </ItemTemplate> </asp:TemplateColumn>
How do I use a ‘helper function’ to change the column value as Boolean in database to be displayed as Yes/No in Datagrid?
<asp:DataGrid id=’DataGrid1′ runat=’server’ AutoGenerateColumns=’False’> <Columns> <asp:TemplateColumn HeaderText=’Status’> <ItemTemplate> <%#ShowStatus(bool.Parse(DataBinder.Eval(Container.DataItem,’Discontinued’).ToString()))%> </ItemTemplate> </asp:TemplateColumn> </Columns> </asp:DataGrid> VB.NET protected Function ShowStatus(ByVal someval as boolean) If someval = true Then ShowStatus = ‘Yes’ Else ShowStatus = ‘No’ End If End Function C# protected string ShowStatus(bool someval) { if (someval == true) { return ‘Yes’; } else { return ‘No’; } }
How do I specify more than one parameter for my HyperlinkColumn?
<asp:DataGrid id=’DataGrid1′ runat=’server’ AutoGenerateColumns=’False’> <Columns> <asp:TemplateColumn HeaderText=’Sample Column’> <ItemTemplate> <asp:Hyperlink runat=’server’ Text=’<%#DataBinder.Eval(Container.DataItem, ‘ProductName’).ToString()%>’ NavigateUrl=’<%# ‘page1.aspx?id=’ + DataBinder.Eval(Container.DataItem,’ProductId’).ToString() + ‘&Name=’ + DataBinder.Eval(Container.DataItem,’ProductName’).ToString()%>’ ID=’Hyperlink1′ NAME=’Hyperlink1’/> </ItemTemplate> </asp:TemplateColumn> </Columns> </asp:DataGrid>
How to populate a DataGrid using a DataSet
<asp:DataGrid id=’DataGrid1′ runat=’server’></asp:DataGrid> Use the namespace System.Data.SqlClient VB.NET Dim cn As SqlConnection Dim da As SqlDataAdapter Dim ds As DataSet Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load cn = New SqlConnection(‘Server=localhost;uid=sa;pwd=;database=northwind’) da = New SqlDataAdapter(‘Select * from products’, cn) ds = New DataSet da.Fill(ds, ‘Products’) DataGrid1.DataSource = ds.Tables(0) ’DataGrid1.DataSource = ds ’DataGrid1.DataSource = ds.Tables(‘Product’) DataGrid1.DataBind() End Sub C# SqlConnection cn; SqlDataAdapter da; DataSet ds; private void Page_Load(object sender, System.EventArgs e) { cn= new SqlConnection (‘Server=localhost;uid=sa;pwd=;database=northwind’); da= new SqlDataAdapter (‘SELECT * FROM Products ‘, cn); ds= new DataSet (); da.Fill (ds, ‘Product’); DataGrid1.DataSource =ds.Tables[0]; //DataGrid1.DataSource= ds; //DataGrid1.DataSource= ds.Tables[‘Products’]; DataGrid1.DataBind (); }
How to populate a DataGrid using a DataReader
<asp:DataGrid id=’DataGrid1′ runat=’server’></asp:DataGrid> Use Namespace System.Data.SqlClient VB.NET Dim cn As SqlConnection Dim cmd As SqlCommand Dim rdr As SqlDataReader Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ’Put user code to initialize the page here Try cn = New SqlConnection(‘server=localhost;uid=sa;pwd=;database=northwind’) cmd = New SqlCommand(‘select * from employees ‘, cn) cn.Open() rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection) DataGrid1.DataSource = rdr DataGrid1.DataBind() Catch ex As Exception Response.Write(ex.Message.ToString()) Finally rdr.Close() cn.Close() End Try End Sub ’Page_Load C# SqlConnection cn ; SqlCommand cmd ; SqlDataReader rdr ; private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here try { cn = new SqlConnection(‘server=localhost;uid=sa;pwd=;database=northwind’); cmd = new SqlCommand( ‘select * from employees ‘, cn); cn.Open(); rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection ); DataGrid1.DataSource = rdr; DataGrid1.DataBind(); } catch (Exception ex) { Response.Write (ex.Message.ToString ()); } finally { rdr.Close(); cn.Close(); } }