I am using Stored Procedure as my Insert/Update command in a FormView. The sp returns a value which I will need to use. How do I retrieve the value after doing an insert / update?
View 4 RepliesData entered in textboxes is not getting updated in database. In debug mode I see that textbox1 and textbox2 in ItemUpdating event contain the same values as they had before calling ItemUpdating.
Here's my listview control:
[Code]....
What's wrong with updating of text1.Text, text2.Text in ItemUpdating event? Should I use e.NewValues property? If so, how to use it?
Here is the scenerio:I have a radtabstrip (with 2 tabs) at the top of my page followed by radMultiPage control Tab 1 displays pageview 1 which has a gridview showing data from our database and allows for selection or deletion of data tab 2 displays a detailsview when gridview_selectedindexchanged(from tab 1) is fired.Problem... If you select an entry in the gridview it switech the page and the detailsview into editmode (works fine) but if you then click on tab 1 without clicking update or cancel in the detailsview, the data is updated. This is what i don't want as the user has basically abandoned the changes.So what i need is a what to say ... if the detailsview is in edit or insert when the tabstrip is clicked then cancel the insert or update. I tried switching it back to readonly mode but that did not seem to work.
View 2 RepliesI've the user creation form where a user will be created by entering username. Below that is checkboxlist for UserGroup which is binded with the dataset with the all the usergroup. Hence up on entering the username and checkbox selected(as the user can belong to multiple UserGroups).At database end, there are basically 3 tables-
Users(UserID,UserName)
UserToGroup(UserID,GroupID)
Groups(GroupID,GroupName)
So when i click create new user, the UserId along with GroupID(whichever checked) is saved into UserToGroup table.Im relative to this kind of process and hence facing setbacks. Can somebody help in end to end process. From front to DB SP.
I have a web page with a gridview & formview (master/detail relationship) combo. On page load the gridview shows all records from a SQL table. On my page I have a button that when clicked shows the formview in Insert mode to allow users to add a new record to the data. I have also added a column to my gridview that has a link. When a user clicks this link it hides the gridview and shows the formview in edit mode with the detail from the record selected from the gridview.
In my formview I am using a listbox control to allow users to select multiple values. The choices in the listbox are populated by a SQL data table. I have successfully written code to post the selected listbox values to my SQL data field during Insert. When the user selects a record to edit I have code in the databound event to select values in the listbox from the choices based on the value in the sql data field. This works as well. My problem is that I cannot figure out the correct code to update my SqL data when a user is editing the record and makes changes to the selected listbox value. I have included my design code for my listbox in my formview edittemplate and also my behind code that I have attempted.
<td
style="width: 454px">
<asp:ListBox
ID="lbox_ConstructionType"
runat="server"
DataSourceID="SqlDataConstructionTypes"
DataTextField="Construction_Type"
DataValueField="Construction_Type"
SelectionMode="Multiple"
Width="144px"></asp:ListBox>
<asp:TextBox
ID="tbox_Ctype"
runat="server"
Text='<%# Bind("ConstructionTypeID") %>'></asp:TextBox></td>
[Code]....
I am using Asp.net 3.5 listview control. In item_updating event I am using this code...
dim country as string = Dim country As String = e.NewValues("country_name").ToString.Replace(" ", "")
It's updating record correctly. for example if I update USA to USA 1 1 then it's updating like as it. But I want it to be USA11
I m getting following error in my eventvwr . I couldnt find reasons of the following error.
"Transaction (Process ID 110) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. "
The only thing my page is doing is inserting/updating data into a table in sql and the thing I can think of is because multiple users are using the same page to insert/update data? Will that cause deadlock?
I am Using a third party tool DevExpress ..
I need to perform Editing , Deleting , Updating and inserting in GridControl .. I am unable configure it properly ..
generating logic for follwing:An option to add a range of computers based on tag numbers, for instance, user input 800101 and 800110 would add computers SYS800101, SYS800102, SYS800103, SYS 800104, SYS800105, SYS800106, SYS800107, SYS800108, SYS800109, and SYS800110. Currently the app adds a single computer at a time.Here I am using ASP.NET using C# and my backend in active directory. I had made the following code and the problem is when I enter the range like given above only the first computer in entered in the list and does not give me any error.
[Code]....
I have seen a project where my friend has used a sqlhelper.dll which make it easy to write code for inserting,Deleting and updating data.
ex:
ds=sqlhelper.ExecuteDataset(con,[StoredProcedure],parameter1,parameter2,...,parametern)
Or
sqlhelper.ExecuteNonQuery(con,[StoredProcedure],parameter1,parameter2,...,parametern)
And he had used a dal(data access layer)...
have a form where I insert record via DetailView control. I have some string fields. For each string field (nvarchar in sql) I have defined the Default Value in the SQL SERVER (2008) as ''. Also I have added to each InsertParameter of the DetailsView a DefaultValue="".Yet still, if the user enters no value for one of the string fields, NULL is inserted into the table.
View 4 Replieswhy if I write the following SQL SELECET under gridview or details view I statement get all the data under thelogin name :
SELECT * FROM CustOrder WHERE (CustomerName = @UserName)
While if I write the following INSERT statement it save all data but it does not save the
login name to database:
INSERT INTO CustOrder
ItemName, ItemPrice, Quantity, CustomerName, Status)
VALUES (@Username,@ItemPrice,@Quantity,@Username, 'New Order')
I'm using Accordion panes and gridviews which are created at run time. For each action item I create an accordion and then populate the tasks that are relevant to that action item in a gridview ( grid view is populated using the second query).
DataRow value dr[1].Tostring ( in the comments below in bold) is not updated with the next row value .
[code]....
I want to insert Data Rows into Gridview from web page and I want to send the Inserted Row to Database table.
So I have 3 columns to insert the row.
I added itemtemplate & fotter template with textbox control for each column Inside Templatefield.
I added two buttons [Insert & Cancel buttons ] in fotter template to insert the row in Gridview.
After debugging the page I can't see gridview in my webpage. i can see only EdItdatatemplate items only.Why ?
Can you look at my code & me to insert the records in gridview..
.aspx page,
[Code]....
.cs
[Code]....
My problem is this "I have all the tools, VS 2005, 2008, 2010. I have every book, I have SQL server 2005 and 2008" I have all the tools, but I do not know what tool or technology to use when starting out learning all this. I juat do not know what book teaches what I need to do for something like below.
Here is my question:
I created an .ASPX webform that is to "Submit" to a SQL 2005 database. I gave this form to my DBA, and he has made up a Data Model. Now I have to figure out how to write the ASP.NET code so it will submit to the DB. My first issue is not knowing this:
1. "How do I loop through my CheckBox List", and then insert the values checked into a "Database Table" (Each Checkbox value MUST be a seperate row in the table, the DBA does not want a seperate column for each checkbox value)
2. The database is using stored procedures
3. My third issue is this: "I do not know "where" to put the "code". If you do resond to this,
Summary: I just need shown the code on how to "loop through" the CheckBox List on my form, and insert those values into a database table as seperate rows.
I'm using ADO.Net code to access and update the data from the database. I'm using GridView for presentation. I wish to preserve old values of all the columns while updaing the records.
I'm using Code behind and not d Data Source controls. I wish to list the old records once record is updated.
i've got a gridview and sql datasource. Its connected to a stored proc that has four optional parameters. In VS when i set up the data source, if i use the test option, and dont supply any values for the sproc, it returns all the values in the table which is what it should do. Now when i try to fill the gridview, it wont return anything at all unless i provide values for all 4 parameters.
It's not even trying to search because i had sql profiler open and nothing shows up until i provide all 4 values. any idea why it's doing this? How do i get it to actually bind even if provide less then all 4 (or none) of the values?
I have a multiple page gridview and edit link on each row.
View 8 RepliesI have a grid view and I added edit and Save buttons to it. When I click on edit I am able to edit the data but when I click on save I amgetting the data before edit.
Please see my code below.
Eg: I have start date as 2005-10-10 12:00 AM so After I click On edit it is letting me to edit, So If I edit the start date to 2010-10-10 12:00 PM and click on the save button I am stil getting the old start date. which is 2005-10-10 12:00 AM instead of 2010-10-10 12:00 PM
<asp:GridView ID="gvPosHistory" runat="server" AutoGenerateColumns="False" AllowPaging="True"
AllowSorting="true" Width="650px" PageSize="20" CssClass="Gridview" Visible="false"
OnRowCommand="gvPosHistory_RowCommand"
OnRowDataBound="gvPosHistory_RowDataBound"
OnRowEditing="gvPosHistory_RowEditing"
OnRowUpdating="gvPosHistory_RowUpdating"
onrowcancelingedit="gvPosHistory_RowCancelingEdit" >
<Columns>
<asp:TemplateField HeaderText="Start Date" SortExpression="startDate">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblstartdate" runat="server" text='<%# Eval("StartDate")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtStartDate" runat="server" Text='<%# Bind("StartDate")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="End Date" SortExpression="endDate">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblenddate" runat="server" text='<%# Eval("EndDate")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtEndDate" runat="server" Text='<%# Bind("EndDate")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Functional Job Title" SortExpression="JobTitle">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblFunctjobTitle" runat="server" text='<%# Eval("FunctionalJobTitle")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtFuncJobTitle" runat="server" text='<%# Bind("FunctionalJobTitle")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Department" SortExpression="Department">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblDepartment" runat="server" text='<%# Eval("DeptName")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtDeptName" runat="server" Text='<%# Bind("DeptName")%>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Supervisor" SortExpression="Supervisor">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblSupervisor" runat="server" text='<%# Eval("Supervisor")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtSupervisor" runat="server" Text='<%# Bind("Supervisor")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Bargaining Unit" SortExpression="bargainingunit">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblbargainingunit" runat="server" text='<%# Eval("BargainingUnit")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtBargainingUnit" runat="server" text='<%# Bind("BargainingUnit")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="UCP Level" SortExpression="UCPlevel">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblUCPlevel" runat="server" text='<%# Eval("UCPLevel")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtUcpLevel" runat="server" Text='<%#Bind("UCPLevel")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Edit" SortExpression="Edit">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Top" />
<ItemStyle Wrap="True" HorizontalAlign="Left" />
<ItemTemplate>
<asp:LinkButton ID="LBPosHistoryEdit" Text="Edit" runat="server" CommandName="Edit" ></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Save" SortExpression="Save">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Top" />
<ItemStyle Wrap="True" HorizontalAlign="Left" />
<EditItemTemplate>
<asp:LinkButton ID="LBPosHistorySave" Text="Save" runat="server" CommandName="SavePosHistory" CommandArgument='<%# Eval("UCPLevel")%>' ></asp:LinkButton>
</EditItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
.aspx.cs
protected void gvPosHistory_RowCommand(object source, GridViewCommandEventArgs e)
{
if (e.CommandName == "SavePosHistory")
{
string arg = Convert.ToString(e.CommandArgument);
System.Web.UI.WebControls.LinkButton btnPosHistory = e.CommandSource as System.Web.UI.WebControls.LinkButton;
GridViewRow row = btnPosHistory.NamingContainer as GridViewRow;
TextBox tSdate = row.FindControl("txtStartDate") as TextBox;
TextBox tEdate = row.FindControl("txtEndDate") as TextBox;
TextBox tFuncJobTitle = row.FindControl("txtFuncJobTitle") as TextBox;
TextBox tDeptName = row.FindControl("txtDeptName") as TextBox;
TextBox tSupervisor = row.FindControl("txtSupervisor") as TextBox;
TextBox tBargainingUnit = row.FindControl("txtBargainingUnit") as TextBox;
TextBox tUCPLevel = row.FindControl("txtUcpLevel") as TextBox;
}
}
I am updating a gridview. Problem is that when I hide certain fields that I do not want the user to update, they lose their values ie. the data is wiped out in the field unless I show them on the grid and make them writeable. Is there a property I need to set for the field to retain the value when the grid is updated or is this in the sql statement?
View 7 RepliesI am working with a formview edititemtemplate. Currently in my page load, i have some stuff that would show or hide certain panels based on dropdownlist values. These dropdown values get binded during page load. I need to be able to change the values/dropdowns, without rebinding the old data, and updating the visibility of the panels based on predefined rules.
I have experimented with putting my formview.databind() in page load if isnotpostback, in prerender, in prerender if isnotpostback. I have tried my rules (ex if ddlState.selectedvalue = "DE" then pnlDelaware.visible = "true") in the page load, and the page render. I'm just not sure how to get the stars aligned here. The closest i have come is having the databind in the pageload if notispostback, and the rules in the prerender. However I get an error "dropdownlist has a SelectedValue which is invalid because it does not exist in the list of items.
So I have two tables in my database, Contacts and Addresses:
Contacts : ContactID | AddressID | FirstName | LastName
Addresses: AddressID | Address1 | Address2 | City | State | Zipcode
I have a page where you can add a contact. It contains all the information for a contact and an address for a contact. Here's my code for when you submit the form:
[code]...
Now my main concern is that the address is added successfully, but then an error occurs when I try to save the contact, leaving the address in the database with no contact.
What's the best practice here for rolling back any changes if an error occurs?
I`m extremely newbie to asp.net and oracle but i need to make a very simple project where asp.net inserts/updates data is oracle db. A managed to the connections, everything, made a DetailView of the DB data on the page, enabled in the Advanced SQL Generation Options the "Generate INSERT, DELETE and UPDATE statesments". Here is the code:
[Code]....
But unfortunately this does not work! I get the following error:
[Code]....
Oracle gives me creeps with these invalid characters and dates.
My insert is adding a record to the database in the call to the stored procedure in SQL Server, but a -1 is returned - Shouldn't it return 0 if the insert/update was successful?
Result = myCommand.ExecuteNonQuery();
how to change gridview cell value for a checked row without affecting any changes in database for ex if a row contains quantity of item 6 i want to change it value to 5,4 upto 0 that is on click event of delete quantity button i have identified row with a checkbox in grid view.
View 1 Replies