Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

No mapping exists from object type System.Web.UI.HtmlControls.HtmlInputText to a known managed provider native type

Posted on 2011-03-02
3
Medium Priority
?
1,696 Views
Last Modified: 2012-06-27
Hi ! I wrote following code in aspx file

<asp:Panel ID="Panel1" runat="server">
                    <h2>
                            Add New Mantle Image</h2>
                        <label>
                            Image Path</label>
                        <p>
                        <asp:TextBox ID="file" runat="server" />
                            <!--<input type="file" runat="server" id="File1"/> -->
                            <asp:Literal ID="lblmessage" runat="server"/>
                            </p>
                         <label>URL (optional)</label>
                        <p>
                        <asp:TextBox ID="url1" runat="server" />
                   <!--   <input type="text" runat="server" id="url" /> -->
                        </p>
                        <p>
                            <label>
                            Title of Image (optional)</label><input type="text"
                            runat="server" id="title" /></p>
                       <asp:CheckBox ID="Position" runat="server" Text="Top in the order?" Font-Bold="true" TextAlign="Left" />
                        <br />
                        <br />
                        <asp:CheckBox ID="CheckBox1" runat="server" Text="Published?  " Font-Bold="True"
                            TextAlign="Left" />
                        <div class="clear spacer">
                        </div>
                       
                      </asp:Panel>
                      <p align="center">
                        <asp:ImageButton ID="savebutton" runat="server" ImageUrl="assets/images/button_save.gif" OnClick="SaveButton_click" />
                            <input type="image" src="assets/images/button_cancel.gif" class="submit inline" onclick="history.go(-1);return false;" />
                        </p>


And following code in aspx.cs file:
                 try
                 {
                      m_db.OpenCommand();
                        m_db.Command.CommandText = "insert into mantle(title, url, image, position, published, deleted) values(@ttl, @img,@pos,@url, @publish,@del)";
                        m_db.Command.Parameters.AddWithValue("@ttl", title);
                        m_db.Command.Parameters.AddWithValue("@url", url);
                        m_db.Command.Parameters.AddWithValue("@img", image);
                        m_db.Command.Parameters.AddWithValue("@pos", position);
                        m_db.Command.Parameters.AddWithValue("@publish", CheckBox1.Checked ? "1" : "0");
                        m_db.Command.Parameters.AddWithValue("@del", "0");

                        m_db.DBExecuteNonQuery();
                    }
                    catch (Exception ex)
                    {
                        Response.Write(ex.Message);
                        errorfree = false;
                    }


And I am getting this error while debugging:

System.ArgumentException was caught
  Message=No mapping exists from object type System.Web.UI.HtmlControls.HtmlInputText to a known managed provider native type.
  Source=System.Data
  StackTrace:
       at System.Data.SqlClient.MetaType.GetMetaTypeFromValue(Type dataType, Object value, Boolean inferLen)
       at System.Data.SqlClient.SqlParameter.GetMetaTypeOnly()
       at System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc)
       at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser, SqlParameterCollection parameters)
       at System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior behavior, String commandText, SqlParameterCollection parameters, _SqlRPC& rpc)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at NeboWeb.Utilities.Data.database.DBExecuteNonQuery() in c:\inetpub\wwwroot\App_Code\database.cs:line 81
       at CMS_MantleAdd.SaveButton_Event() in c:\inetpub\wwwroot\CMS\MantleAdd.aspx.cs:line 94
  InnerException:
0
Comment
Question by:pratz09
  • 2
3 Comments
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 35016593
You appear to be trying to pass the control itself to your command, rather than it's value. Should be more like:
m_db.Command.Parameters.AddWithValue("@ttl", title[b].Text[/b]);

Open in new window

0
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 2000 total points
ID: 35016598
Ok, bold obviously doesn't work in code snippets :)
m_db.Command.Parameters.AddWithValue("@ttl", title.Text); 

Open in new window

0
 

Author Comment

by:pratz09
ID: 35017479
Oh Man.. Can't believe it was so silly mistake. Thanks man.


0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question