.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Possible to insert & update in formview?

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :ASP.Net
I have a formview where DefaultMode="Insert". Underneath, I have a gridview that displays the information from the inserts. Is there a way to update the information as well as insert? Maybe there is a better way to do what I'm trying to do. Any help is appreciated. Thanks!

View Complete Post

More Related Resource Links

Possible to update and insert from formview?

I have a formview where DefaultMode="Insert". Underneath, I have a gridview that displays the information from the inserts. Is there a way to update the information as well as insert? Maybe there is a better way to do what I'm trying to do. Any help is appreciated. Thanks!

SqlCommand.ExecuteNonQuery() returns -1 when doing Insert / Update / Delete

Sometimes you end up with a return value of -1 when using the SqlClient.SqlCommand.ExecuteNonQuery method.

Why is that?

Well, the ExecuteNonQuery method is there for statements for changing data, ie. DELETE / UPDATE /INSERT, and the returned value are the number of rows affected by that statement.

When checking the documentation we can see that there are some conditions that return -1.

For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command.

When a trigger exists on a table being inserted or updated, the return value includes the number of rows affected by both the insert or update operation and the number of

rows affected by the trigger or triggers. For all other types of statements, the return value is -1. If a rollback occurs, the return value is also -1.

Help ~~ How to Update Binary Image on Formview

Hi All ~~ I'm confused, Can i have some help please... Thanks
Database: Books
uid dataType uniqueidentifier
Cover dataType image 
aspx :
 <asp:FormView ID="FormView1" runat="server" BackColor="LightGoldenrodYellow"   BorderColor="Tan" BorderWidth="1px" CellPadding="2" DataKeyNames="uid"     DataSourceID="SqlDataSource1" ForeColor="Black" Width="525px">
         <table class="table_width">
                 <td class="imageWidth">
                     <asp:Image ID="Image1" runat="server" Height="245px" 
                                       ImageUrl='<%# IIF(Eval("Cover") Is DbNull.Value, "~/Styles/Global/CFZ-No-Images.png", Eval("uid", "~/ImageServices.ashx?BooksID={0}")) %>' Width="180px" />

Insert/Update OLE Attachment(Binary datatype) using SQL server 2000

Hi All, In the same senario how we can Insert/Update OLE Attachment(Binary datatype)  from one source table to other destination table by using SQL Server 2000 not with C# fronend code. Appreciated if you can give fix on this regads, Divakar.

formview insert help!!!

im using FORM VIEW Control for inserting , i want as i click on insert button of form view control it shows the just inserted data by form view in any GRID VIEW, FORM VIO

Allow or deny roles to update, insert and delete records.

Hello, I have two roles "Admin" and "Basic". I also have a listview on the web page. My goal is that to make "Admin" role has the highest privilege to deal with records such as "insert", "update" and "delete". For the role "Basic", it only can update the records. Is there any sample code for that? Thanks.  

update/insert parent child at the same time

Hi Al, Is there a way to create a contact form that takes the name. address and other info for the master record; Then, somehow, on the same page, allow the user to enter multiple contact info as chid records (i.e. phone, email, etc.) All this using the Objec DataSource or SQL DataSource (which ever is easy) and doesn't require writing too much code. Any reference material welcomed. Thanks, rod.

Concurrent INSERT and UPDATE

I created a table with the following columns in SQL server 2008 express version,   create table action (id int identity , comment varchar(256), description varchar(max), opendate date, closedate date) I was trying to verify whether inserts will slow down once the table has large number of records. Hence i started inserting in loop (30 times) 10000 records. This was done using Microsoft jdbc driver ver 4.0. The time taken was almost in the range 8-10 seconds. In between i also tried to update the 'description' column for all the rows from sql client window. This affected the insert operations and it took 31 seconds for inserting one set of 10,000 rows. Please suggest how to handle such scenarios. Is the slowness because of the entire table update?

Formview check for duplicate value before insert

I've looked at some posts on here but I keep getting errors.  I am just trying to see if an email address exists already before the insert and if it does, have a label display that message to the user. From what I read so far, it looks like I could do a query in the ItemInserting event.  I just need help on the code.  Thanks in advance for any help.. Here is the Code Behind.....where I assume I can do the duplicate check in the ItemInserting event... Protected Sub duplicatecheck(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertEventArgs) Handles FormView1.ItemInsertingEnd   End Sub     Here is the formview page...   <%@ Page Language="VB" AutoEventWireup="false" CodeFile="signup.aspx.vb" Inherits="signup" %> <! < <DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">html xmlns="http://www.w3.org/1999/xhtml">head runat="server">   </ <<title></title>head>body>  <form id="form1" runat="server">  <div>      <asp:FormView ID="FormView1" runat="server" DataKeyNames="ID" DataSourceID="SqlDataSource2" Def

SqlDataSource, FormView, and Update with stored procedure in code behind

Hello, Using a FormView with a SqlDataSource, I'm attempting to Update data by calling a stored proc in code behind. I was having trouble getting parameters using Update Parameters in the SqlDataSource, but found a working solution by coding the parameters. The problem now is I'm getting an "Updating is not supported by data source 'XYZ' unless UpdateCommand is specified'. I saw some previous posts on the forums, but didn't find them very enlightening. 

Display Inserted Record After Insert Using A FormView

How do I display a record in a FormView once the record has been inserted? I'm able to get the Identity of the new record without anyproblems, but I can't figure out how I should code the _ItemCreated event. Protected Sub FormViewMessageDetail_ItemInserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertedEventArgs) 'Refresh the list to show the new record RepeaterMessages.DataBind() 'Set the .SelectCommand to Select the New Record SqlDataSourceMessageDetail.SelectCommand = "SELECT * FROM Messages WHERE [Id] = " & NewId FormViewMessage.DataBind() FormViewMessage.ChangeMode(FormViewMode.Edit) test.Text = NewId.ToString End Sub Protected Sub SQLDataSourceMessageDetail_Inserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) NewId = e.Command.Parameters("@NewId").Value End Sub

DropDownList inside FormView Insert Template

Hi, I am trying to change the textboxes in the FormView insert template to dropdownlists but they keep setting the parameters to null.   Here's what I have:  <asp:DropDownList ID="ddlYearOfQualification" SelectedValue='<%# Bind("YearOfQualification") %>' runat="server"> </asp:DropDownList> In Page_Load CType(frmSurvey.FindControl("ddlYearOfQualification"), DropDownList).Items.Add(New ListItem("2010", "2010"))CType(frmSurvey.FindControl("ddlYearOfQualification"), DropDownList).Items.Add(New ListItem("2009", "2009"))   and in the SqlDataSource InsertCommand="INSERT INTO [tblSurvey] (... [YearOfQualification] ...) VALUES ( ... @YearOfQualification ... ) And in insert parameters: <asp:Parameter Name="YearOfQualification" Type="Int16" /> And the insert fails with YearOfQualification as null. If I sue the standard textbox: <asp:TextBox ID="YearOfQualificationTextBox" runat="server"                 Text='<%# Bind("YearOfQualification") %>' /> It works.   Any ideas? Many thanks in advance.

EntityDataSource Insert, Update, and ConvertEmptyStringToNull

I've noticed that when using an EntityDataSource with FormViews, GridViews, and other databound controls, that empty strings are not always converted to null for inserts and updates. This isn't an issue when using templated DynamicControls, but when normal WebControls are bound to the datasource. For example: <asp:TextBox ... Text='<%# Bind("NullableColumnName") %>'  During inserts and updates, when the text box has an empty string, the value saved to the table cell in the db is an empty string rather than NULL. This is avoidable if normal <asp:Parameter Name="NullableColumnName" Type="String" /> parameters are added to the InsertParameters and UpdateParameters collections, since the default property of ConvertEmptyStringToNull is true. Is there another way to ensure empty strings get converted to null, other than using DynamicControls with EDS? I'm just curious what is happening behind the scenes here. Data values of type Int32 are automatically converted to null when they are bound to an empty string, as are datetime values. It only seems to be normal strings that get pushed to the EDM without conversion to null. Any explanations?

Update in formview doesn't work, but I don't get an error message?

I have a datasource:<asp:SqlDataSource ID="MySQLProfielDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:WAPMySQLConnStr %>" InsertCommand="INSERT INTO usergegevens(UserId, Geslacht, Voornaam, Tussenvoegsel, Achternaam, Adres, Huisnummer_toev, Postcode, Woonplaats, TelnrV, TelnrM, Geboortedatum) VALUES (@Param1, @Param2, @Param3, @Param4, @Param5, @Param6, @Param7, @Param8, @Param9, @Param10, @Param11, @Param12)" ProviderName="<%$ ConnectionStrings:WAPMySQLConnStr.ProviderName %>" SelectCommand="SELECT UserId, Geslacht, Voornaam, Tussenvoegsel, Achternaam, Adres, Huisnummer_toev, Postcode, Woonplaats, TelnrV, TelnrM, Geboortedatum FROM usergegevens WHERE (UserId = @Param1)" UpdateCommand="UPDATE usergegevens SET Geslacht = @Param1, Voornaam = @Param2, Tussenvoegsel = @Param3, Achternaam = @Param4, Adres = @Param5, Huisnummer_toev = @Param6, Postcode = @Param7, Woonplaats = @Param8, TelnrV = @Param9, TelnrM = @Param10, Geboortedatum = @Param11 WHERE (UserId = @Param12)" onselecting="MySQLProfielDataSource_Selecting" onupdating="MySQLProfielDataSource_Updating" onselected="MySQLProfielDataSource

Edit, Update and Cancel Buttons in FormView

Hi,    I have created a Formview1 which have 3 columns Name, Status and Description. I just wanted to update display the Status and Description but not the Name. Can anyone give me any guidelines how I can do this.  I have use the following code on my asp.net page<asp:FormView ID="FormView1" runat="server" DataSourceID="SqlApplication" DataKeyNames="applicationID"> <ItemTemplate> <asp:Label ID="lblAppsID" runat="server" Visible="false" Text='<%# Bind("applicationID") %>' /> </ItemTemplate> <ItemTemplate> <asp:Label ID="lblAppsName" runat="server" Font-Size="X-Large" Font-Bold="True"><%# Eval("applicationName") %></asp:Label> <br /> <br /> <ItemTemplate> Status: <asp:TextBox ID="txtSatusdesc" runat="server" Text='<%# Eval("Status") %>' ></asp:TextBox> </ItemTemplate><!--- ******** Need to create button Edit, update, Cancel button here to update status ************---> <EditItemTemplate> <asp:TextBox ID="txtSatusdescUpd" runat="server" Text='<%# Bind("Status") %>' ></asp:TextBox> </EditItemTemplate> <br /> <br />

How To Do An Insert Loop With Two Textboxes In A Formview

Hello forum I have a formview (frmExpenses) and it has two textboxes (txtCorporateCost and txtPersonalCost) .  I'm wanting to input their text into tblExpenses, however, in the same column (colExpenses) but different rows.  When txtCorporateCost's amount is inserted I would like for the text "Corporate_Exp" to be inserted in column "colExpenseName" and when txtPersonalCost's amount is inserted I would like for the text "Personal_Exp" to be entered in colExpenseName as well.  How do I go about this? Thank you

Formview: Insert Item Issues

Hi, I have a formview for insert and updates. I was trying to call a procedure in formview_itemcommand event without setting InsertMethod for the ObjectDataSource. I got anerror and so I gave the exact procedure name for insert method to get rid of the error. Since the formview objectdatasource method does not exactly match (the no of argument and name) with FormView Datasource(in insertiemtemplate), I was trying to avoid calling the selectmethod defined. I was able to insert the record in itemcommand event.  The problem is 1. While exiting out the Item_command event it gives the following error Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: FormView 'FormViewInsertApplication'                 must be in insert mode to insert a new record.2. After insert, I tried setting the default mode readonly. It does not work How do I by pass the above problems or is there other better way of accomplishing the same. ThanksSuresh Sections of Code----------------------  protected void FormViewInsertApplication_ItemCommand(object sender, FormViewCommandEventArgs e)    {        FormView fvApp = (FormView)FindControl("FormViewInsertApplication");        if (e.Comman
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend