Storing more than 254 characters to foxpro 2.6 memo field through c# ODBC

<script runat="server">
   
 
void CustomerDetail_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
  {
    TextBox nextCallDate = (TextBox)DetailsView1.FindControl("next_call");
    TextBox notesBox = (TextBox)DetailsView1.FindControl("notes");
    string nextCallString = nextCallDate.Text.ToString();
    string notesString = notesBox.Text.ToString();
    string billid = Request.QueryString["id"];
    notesString = notesString.Replace("'","\"");
 
    Oakstreet.UpdateParameters["notes"].DefaultValue = notesString;
    
 
    Oakstreet.UpdateCommand = "UPDATE customrs set next_call ={^" + nextCallString + "}, notes = ? WHERE cust_id = '" + billid + "'";
    
    Oakstreet.Update();
    
    
  }
 
 
</script>
 
<asp:Content ID="Content1" ContentPlaceHolderID="Content" Runat="Server">
    <form id="form1" runat="server">
    <asp:DetailsView ID="DetailsView1" runat="server" BackColor="White" 
        BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" 
        DataSourceID="Oakstreet" ForeColor="Black" GridLines="Vertical" Height="50px" 
        Width="600px" AutoGenerateEditButton="True" AutoGenerateRows="False" >
        <FooterStyle BackColor="#CCCC99" />
        <RowStyle BackColor="#F7F7DE" />
        <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
        <Fields>
            <asp:BoundField DataField="cust_id" HeaderText="Bill ID #" ReadOnly="True" />
            <asp:BoundField DataField="name" HeaderText="Name" ReadOnly="True"  />
            <asp:BoundField DataField="city" HeaderText="City" ReadOnly="True" />
            <asp:BoundField DataField="state" HeaderText="State" ReadOnly="True" />
            <asp:TemplateField HeaderText="Next Call Date">
                <ItemTemplate>
                    <asp:Label ID="next_call" Text='<%# Bind("next_call","{0:yyyy/MM/dd}") %>' Runat="server" ReadOnly="true" Wrap="true" Height="30px" Width="150px" />
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:TextBox ID="next_call" Text='<%# Bind("next_call","{0:yyyy/MM/dd}") %>' Runat="server" ReadOnly="false" Wrap="true" Height="30px" Width="150px" />
 
                </EditItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Notes" HeaderStyle-VerticalAlign="Top">
                <ItemTemplate>
                    <asp:Label ID="notes" Text='<%# Bind("notes") %>' Runat="server" ReadOnly="true" Wrap="true" TextMode="MultiLine" Height="300px" Width="600px" />
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:TextBox ID="notes" Text='<%# Bind("notes") %>' Runat="server" ReadOnly="false" Wrap="true" TextMode="MultiLine" Height="300px" Width="600px" />
 
                </EditItemTemplate>
            </asp:TemplateField>
        </Fields>
        <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
        <EditRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" Wrap="true" Width="600px" Height="100%" />
        <AlternatingRowStyle BackColor="White" />
       
    </asp:DetailsView>
    <asp:SqlDataSource ID="Oakstreet" runat="server" 
        ConnectionString="<%$ ConnectionStrings:OakODBC %>" 
        ProviderName="<%$ ConnectionStrings:OakODBC.ProviderName %>" 
        
        SelectCommand="SELECT cust_id,name,city,state,next_call, notes FROM customrs WHERE cust_id=?" 
        UpdateCommand="update customrs set next_call=?, notes=? where cust_id=?">
        <UpdateParameters>
           <asp:Parameter Name="next_call" Type="DateTime"/>
           <asp:Parameter Name="notes" />
           <asp:QueryStringParameter Name="cust_id" QueryStringField="id" DefaultValue="26555" />
        </UpdateParameters>
        <SelectParameters>
            <asp:QueryStringParameter Name="cust_id" QueryStringField="id" DefaultValue="26555" />
        </SelectParameters>
        </asp:SqlDataSource>
    </form>
</asp:Content>
                                              

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:

Oakstreet.UpdateCommand = "UPDATE customrs set next_call ={^" + nextCallString + "}, notes = ? WHERE cust_id = '" + billid + "'";
    
Oakstreet.Parameters.Add("notes", OleDbType.Char, 10000).Value = notesString; 
 
Oakstreet.Update();
    
                                              

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

TextBox nextCallDate = (TextBox)DetailsView1.FindControl("next_call");
    TextBox notesBox = (TextBox)DetailsView1.FindControl("notes");
    string nextCallString = nextCallDate.Text.ToString();
    string notesString = notesBox.Text.ToString();
    string billid = Request.QueryString["id"];
    notesString = notesString.Replace("'","\"");
    Char pad = Convert.ToChar("-");
    notesString = notesString.PadRight(2500, pad);
    
    //Oakstreet.UpdateParameters["notes"].DefaultValue = notesString;
 
    //Oakstreet.UpdateCommand = "UPDATE customrs set next_call ={^" + nextCallString + "}, notes = '" + notesString + "' WHERE cust_id = '" + billid + "'";
    
    //Oakstreet.Update();
    
    string strConnect = Oakstreet.ConnectionString.ToString();
 
    OdbcConnection updateConnection = new OdbcConnection(strConnect);
    updateConnection.Open();
    OdbcCommand updateCommand = updateConnection.CreateCommand();
    updateCommand.CommandText = "UPDATE customrs set next_call ={^" + nextCallString + "}, notes = ? WHERE cust_id = ?";
    updateCommand.Parameters.Add("notes", OdbcType.Char, 10000).Value = notesString;
    updateCommand.Parameters.Add("cust_id", OdbcType.Int, 5).Value = billid;
    updateCommand.ExecuteNonQuery();
    updateConnection.Close();

                                              

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: