Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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,746 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

578 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