Inserting into a database with ASP.NET causes error

Question

I am working with VS 2017 for the first time.

I am trying to insert some values into a database. I already made the connection (checked with select statement) with the database, but now I am stuck in the insert portion.

I have a SqlDataSource defined as:

<div>
   <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="  <%$ ConnectionStrings:Sphinxx_Conn %>" 
        ProviderName="<%$ ConnectionStrings:Sphinxx_Conn.ProviderName %>"  
        InsertCommand="INSERT INTO &quot;DEMO&quot; (&quot;ID&quot;, &quot;NAME&quot;) VALUES (:ID, :NAME)">
        <InsertParameters>
            <asp:Parameter Name="ID" Type="String" />
            <asp:Parameter Name="NAME" Type="String" />
        </InsertParameters>
   </asp:SqlDataSource>
</div>

Now the following snippet:

 SqlDataSource1.InsertParameters["ID"].DefaultValue = '1'
 SqlDataSource1.InsertParameters["NAME"].DefaultValue = 'John'

Underlines the 'SqlDataSource1.InsertParameters' part and shows an error:

Property access must assign to the property or use its value.

What exactly am I doing wrong?

Ognjen Babic · Accepted Answer · 2017-03-27 11:23:32Z

2

You are passing invalid data because you are using single quotes, use double quotes instead:

 SqlDataSource1.InsertParameters["ID"].DefaultValue = "1";
 SqlDataSource1.InsertParameters["NAME"].DefaultValue = "John";

On the side note, if you started working and getting to know web development with Visual Studio, i recommend you to look at MVC. Web Forms are old tech that is no longer supported.

edited Mar 27, 2017 at 11:23

answered Mar 27, 2017 at 11:17

Ognjen Babic

7671 gold badge6 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Ranit Dholey Over a year ago

SqlDataSource1.InsertParameters["ID"].DefaultValue = "1"; SqlDataSource1.InsertParameters["NAME"].DefaultValue = "John"; Changing the code with double quotes doesn't solve it. Still getting that 'Property access must assign to the property or use its value.' error.

Ognjen Babic Over a year ago

Do you use this code in proper method scope? Can you show whole code file in which error is?

Ognjen Babic Over a year ago

You need to add your code in code behind file, not in aspx file. Place it in Default.aspx.vb file.

Ranit Dholey Over a year ago

<%@ Page aspcompat=true Title="Home Page" Language="VB" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Default.aspx.vb" Inherits="TestDemo._Default" %> <asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server"> <%          SqlDataSource1.InsertParameters["ID"].DefaultValue = "2"          SqlDataSource1.InsertParameters["NAME"].DefaultValue = "John"  %> </asp:Content>

This is all there is. The <div> tag which I gave in the question goes just before the <% tag for the SqlDataSource. The comment space here isn't letting me paste the entire thing.

Ranit Dholey Over a year ago

Can you please elaborate? What exactly to write in the .aspx.vb file? As of now the contents there are

Public Class _Default     Inherits Page      Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load      End Sub      Protected Sub DataList1_SelectedIndexChanged(sender As Object, e As EventArgs)      End Sub  End Class

Thanks for your response.

|

mason · Accepted Answer · 2017-03-27 12:10:31Z

0

There are 2 errors within your Code Snippet of assigning values.

You are setting a char value instead of string, replace single quoted 'values with double quotes ". Instead of '1' do this "1" same with John too.
You have not used ; to terminate your statement, so put semicolons in the end of your statements.

edited Mar 27, 2017 at 12:10

mason

32.8k12 gold badges83 silver badges127 bronze badges

answered Mar 27, 2017 at 12:08

M. Adeel Khalid

1,7902 gold badges21 silver badges24 bronze badges

1 Comment

Ranit Dholey Over a year ago

SqlDataSource1.InsertParameters["ID"].DefaultValue = "1"; SqlDataSource1.InsertParameters["NAME"].DefaultValue = "John"; Changing the code with double quotes doesn't solve it. Still getting that 'Property access must assign to the property or use its value.' error.

Collectives™ on Stack Overflow

Inserting into a database with ASP.NET causes error

2 Answers 2

6 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related