Please Anybody can help me with this problem that I am having in FormView Control.
<InsertItemTemplate>
<table style="width: 415px">
<tr bgcolor="#ffcc66">
<td align="right" style="width: 117px"><b>ContractorId:</b>
</td>
<td>
<asp:TextBox ID="InsertContractorIdTextBox"
Text='<%# Bind("ContractorId") %>'
RunAt="server" /></td>
<td>
</td>
</tr>
<tr bgcolor="#ffcc66">
<td align="right" style="width: 117px"><b>From Language:</b>
</td>
<td>
<asp:TextBox ID="InsertFromLanguageTextBox"
Text='<%# Bind("FromLanguage") %>'
RunAt="server" /></td>
<td>
<asp:DropDownList DataSourceID="SqlDataSourceLanguages" DataTextField="Language" ID="InsertFromLanguageDDBox" runat="server" DataValueField="Language_ID" Width="155px"></asp:DropDownList></td>
</tr>
<tr bgcolor="#ffcc66"><td align="right" style="width: 117px"><b>Into Language:</b></td>
<td><asp:TextBox ID="InsertIntoLanguageTextBox"
Text='<%# Bind("IntoLanguage") %>'
RunAt="server" /></td>
<td>
<asp:DropDownList DataSourceID="SqlDataSourceLanguages" DataTextField="Language" ID="InsertIntoLanguageDDBox" runat="server" DataValueField="Language_ID" Width="155px">
</asp:DropDownList></td>
</tr>
<tr bgcolor="#ffcc66">
<td align="right" style="width: 117px"><b>Service Type:</b></td>
<td><asp:TextBox ID="InsertServiceTypeTextBox"
Text='<%# Bind("ServiceTypeId") %>'
RunAt="Server" /></td>
<td>
<asp:DropDownList ID="DDListServiceType" runat="Server" DataSourceID="SqlDataSourceServiceType" DataTextField="ServiceName"
DataValueField="ServiceTypeId" Width="157px" >
</asp:DropDownList>
</td>
<td>
</td>
</tr>
<tr bgcolor="#ffcc66"><td align="right" style="width: 117px"><b>Subject:</b></td>
<td><asp:TextBox ID="TextBox2"
Text='<%# Bind("Subject") %>'
RunAt="Server" /></td>
<td>
</td>
</tr>
<tr bgcolor="#ffcc66"><td align="right" style="width: 117px"><b>Desired Rate:</b></td>
<td><asp:TextBox ID="TextBox3"
Text='<%# Bind("DesiredRate", "{0:c}") %>'
RunAt="Server" /></td>
<td>
</td>
</tr>
<tr bgcolor="#ffcc66"><td align="right" style="width: 117px"><b>Desired Unit:</b></td>
<td><asp:TextBox ID="TextBox4"
Text='<%# Bind("DesiredUnit", "{0:c}") %>'
RunAt="Server" /></td>
<td>
</td>
</tr>
<tr bgcolor="#ffcc66"><td align="right" style="width: 117px"><b>Availability:</b></td>
<td><asp:TextBox ID="TextBox5"
Text='<%# Bind("Availability") %>'
RunAt="Server" /></td>
<td>
</td>
</tr>
<tr bgcolor="#ffcc66"><td align="right" style="width: 117px"><b>Period of Unavailability:</b></td>
<td><asp:TextBox ID="TextBox6"
Text='<%# Bind("PeriodAvailable") %>'
RunAt="Server" /></td>
<td>
</td>
</tr>
<tr bgcolor="#ffcc66"><td align="right" style="width: 117px"><b>Note:</b></td>
<td><asp:TextBox ID="TextBox7"
Text='<%# Bind("Note") %>'
RunAt="Server" /></td>
<td>
</td>
</tr>
<tr bgcolor="#ffcc66">
<td colspan="2">
<asp:LinkButton ID="InsertButton"
Text="Insert"
CommandName="Insert"
RunAt="server"/>
<asp:LinkButton ID="CancelInsertButton"
Text="Cancel"
CommandName="Cancel"
RunAt="server"/>
</td>
</tr>
</table>
</InsertItemTemplate>
Now When I try to Save the record I get Error as follows:
Disallowed implicit conversion from data type nvarchar to data type money, table 'dbo.ContractorsDetail', column 'DesiredRate'. Use the CONVERT function to run this query.
Ok Now. How do I convert String Value to Money in the BIND Property of the control.
Thank you.
FormView Control
