<div>
&gt; and not by adding calculated column in sql query<br />
<br />
Why not? That would be the easiest, wouldn't it?<br />
<br />
SELECT id, datestart, dateend, convert(char(10), datestart, 101) + '-' + convert(char(10), dateend, 101) AS starttoend FROM yourtable<br />

</div>


<div>
Use &lt;asp:template&gt; field
</div>


<div>
sybe,<br />
<br />
I don`t won`t to do it, because I`m using globalization in my application...<br />
<br />
lotusnotesnewbie<br />
<br />
Can you be more specific, how to do in my case?<br />
<br />

</div>


<div>
<br />
&lt;asp:TemplateField&gt; <br />
&lt;ItemTemplate&gt;<br />
&lt;asp:TextBox runat=&quot;server&quot; ID=&quot;calulatedDate&quot;&gt;<br />
&lt;%# Eval(&quot;DateStart&quot;) %&gt;<br />
&lt;/asp:TextBox&gt; <br />
&lt;/ItemTemplate&gt; <br />
&lt;/asp:TemplateField&gt;<br />
<br />
Convert the column to date in Eval statement<br />

</div>


<div>
&gt; because I`m using globalization in my application..<br />
<br />
You mean you want a specified dateformat returned from the database? Look here: <a href="http://howto.redcomputer.net/sql/select_datetime_format.php" rel="ugc">http://howto.redcomputer.net/sql/select_datetime_format.php</a>
</div>


<div>
I`ve found solution myself and I have to close question. Here is solution:<br />
<br />
I`ve overrided &nbsp;RowDataBound &nbsp;event of GridView and formatted fields as I wanted:<br />

<pre><code class="code-1 nolinks" id="code-265760"><span>protected void GDVDates_RowDataBound(object sender, GridViewRowEventArgs e)</span>
<span>    {</span>
<span>        if (e.Row.RowIndex &lt; 0) return;  // when e.Row.RowIndex is -1, it`s HeaderText</span>
<span>        e.Row.Cells[3].Text = Convert.ToDateTime(e.Row.Cells[1].Text).ToShortDateString() + &quot; - &quot; + Convert.ToDateTime(e.Row.Cells[1].Text).ToShortDateString();</span>
<span>        e.Row.Cells[1].Text = Convert.ToDateTime(e.Row.Cells[1].Text).ToShortDateString();</span>
<span>        e.Row.Cells[2].Text = Convert.ToDateTime(e.Row.Cells[2].Text).ToShortDateString();</span>
<span>    }</span>
</code></pre>
</div>


<div>
Posted incorrectly, code must be:<br />
<br />
<br />
<br />

<pre><code class="code-1 nolinks" id="code-265764"><span>protected void GDVDates_RowDataBound(object sender, GridViewRowEventArgs e)</span>
<span>    {</span>
<span>        if (e.Row.RowIndex &lt; 0) return;  // when e.Row.RowIndex is -1, it`s HeaderText</span>
<span>        e.Row.Cells[3].Text = Convert.ToDateTime(e.Row.Cells[1].Text).ToShortDateString() + &quot; - &quot; + Convert.ToDateTime(e.Row.Cells[2].Text).ToShortDateString();</span>
<span>        e.Row.Cells[1].Text = Convert.ToDateTime(e.Row.Cells[1].Text).ToShortDateString();</span>
<span>        e.Row.Cells[2].Text = Convert.ToDateTime(e.Row.Cells[2].Text).ToShortDateString();</span>
<span>    }</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
I have following &nbsp;fields in the table: &nbsp;<br />
<br />
ID &nbsp;int &nbsp;,<br />
DateStart DateTime.<br />
DateEnd &nbsp; DateTime<br />
<br />
<br />
I want &nbsp;to add calculated field besides these fields &nbsp;in GridView in asp.net but not by adding calculated field <br />
to my table and not by adding calculated column in sql query.<br />
<br />
I want to format that field using C# &nbsp;syntax like this: &nbsp; DateStart.ToShortDateStrin<wbr />g() + &quot;&nbsp;- &quot;&nbsp; &nbsp;DateEnd.ToShortDateString(<wbr />) <br />
<br />
<br />
<br />
<br />

</div>
</div>


I have following  fields in the table:  

ID  int  ,
DateStart DateTime.
DateEnd   DateTime


I want  to add calculated field besides these fields  in GridView in asp.net but not by adding calculated field 
to my table and not by adding calculated column in sql query.

I want to format that field using C#  syntax like this:   DateStart.ToShortDateString() + " - "   DateEnd.ToShortDateString() 






Add calculated field to GridView

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications