bmanmike39
asked on
how do i prepopulate FormView textbox
Can someone show me the code to prepopulate a textbox in a FormView Control in insert mode, In c#. (using ASP 2.0 and VWD )I have the following code but it doesn’t work.
This is what i have:
protected void nameTextBox_TextChanged1(o bject sender, EventArgs e)
{
TextBox fnam =
(TextBox)FormView2.Row.Fin dControl(" nameTextBo x");
fnam.Text = Label3.Text;
}
<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:Connecti onString %>"
DeleteCommand="DELETE FROM [tesconntes] WHERE [myid] = @myid" InsertCommand="INSERT INTO [tesconntes] ([name], [lname]) VALUES (@name, @lname)"
SelectCommand="SELECT * FROM [tesconntes]" UpdateCommand="UPDATE [tesconntes] SET [name] = @name, [lname] = @lname WHERE [myid] = @myid">
<DeleteParameters>
<asp:Parameter Name="myid" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="lname" Type="String" />
<asp:Parameter Name="myid" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="lname" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
This is what i have:
protected void nameTextBox_TextChanged1(o
{
TextBox fnam =
(TextBox)FormView2.Row.Fin
fnam.Text = Label3.Text;
}
<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:Connecti
DeleteCommand="DELETE FROM [tesconntes] WHERE [myid] = @myid" InsertCommand="INSERT INTO [tesconntes] ([name], [lname]) VALUES (@name, @lname)"
SelectCommand="SELECT * FROM [tesconntes]" UpdateCommand="UPDATE [tesconntes] SET [name] = @name, [lname] = @lname WHERE [myid] = @myid">
<DeleteParameters>
<asp:Parameter Name="myid" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="lname" Type="String" />
<asp:Parameter Name="myid" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="lname" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.