Web Forms :: Inserting / Deleting And Updating Data

May 7, 2015

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)...

View 1 Replies


Similar Messages:

Data Controls :: Editing Deleting Updating And Inserting In WebForms GridControl

Mar 7, 2012

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 ..

View 1 Replies

Forms Data Controls :: Change Gridview Page Upon Inserting / Deleting Record?

Jun 22, 2010

I am having trouble changing page numbers on my gridview after deleting a record if the deletion of the record causes there to be no more records on that page. Currently I have a form below the gridview that adds a record to the datasource of the gridview.

[Code]....

Code behind stuff:

[Code]....

Now with this code above, if I insert a new record using the form below the gridview, it will reload and go to the new page if the insertion causes the record to appear on a new page, however when I delete that record, thus causing nothing to be on that page, the gridview visually just dissappears. I've got the gridview bound by a linqdatasource control, and on the page_load function I only databind if the page is not a postback.

View 2 Replies

Forms Data Controls :: Gridview Is Not Updating And Deleting Without ID Column?

Dec 1, 2010

I have a gridview in which update and delete is enabled.

I have the following fields in database table, which is binded to the grid view through sql datasource.

ID,Firstname,Lastname,Add,City,modifieddate. Here ID is primary key.

1. When edit and delete is enabled in the grid. The ID column is showing in the grid,which i don't want to show. But without that ID column the grid is not able to update and delete. Plz tel me how to update and delete without ID column in grid.

2. When ever any update is happen in the grid, the modifieddate should get updated. Here the date is not datetime.now , i need to use my own system date and time. Coz my server and system time has some difference.

I have use the following javascript to get system date and time, which is working fine. This date should be get and update in the modified column.

function displayTime() {
var m_names = new Array("Jan", "Feb", "Mar",
"Apr", "May", "Jun", "Jul", "Aug", "Sep",
"Oct", "Nov", "Dec");
var localTime = new Date();
var year = localTime.getYear();
var month = localTime.getMonth() + 1;
var date = localTime.getDate();
var hours = localTime.getHours();
var minutes = localTime.getMinutes();
var seconds = localTime.getSeconds();
var div = document.getElementById("TextBox1");
div.innerText = date + "-" + m_names[month] + "-" + year;
}

View 2 Replies

Forms Data Controls :: Deleting / Updating Record From SQL Database Via GridView

May 11, 2010

I've been googling for 2 days for the solution, but I couldn't find something useful. The problem is that I have GridView that is connected to the SQL database and that is how it is being populated. I added EDIT and DELETE buttons in the columns, but as far as I can see the event which handles them is empty.

[Code]....

View 11 Replies

Forms Data Controls :: Updating And Deleting Binary Data In DetailsView?

Apr 2, 2010

here is the link [URL]

for the updating and deleting binery data in Gridview same like that i want to updating and deleting data in detailsview?

View 7 Replies

Forms Data Controls :: Listview Not Updating And Inserting?

Apr 17, 2010

Data 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?

View 1 Replies

Forms Data Controls :: How To Stop A Detailsview From Inserting Or Updating

Aug 12, 2010

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 Replies

Forms Data Controls :: Inserting/updating To Database Via Checkboxlist?

Jun 16, 2010

I'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.

View 6 Replies

Forms Data Controls :: Get The Return Values After Inserting / Updating?

Jun 8, 2010

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 Replies

Forms Data Controls :: Inserting / Updating Sql Data From A Listbox In Formview?

Jun 2, 2010

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]....

View 9 Replies

C# - Best Practice For Inserting/updating Data In Multiple Tables At Once?

Feb 11, 2011

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?

View 4 Replies

Databases :: Updating, Inserting Data In Oracle /DetailsView?

Feb 10, 2010

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.

View 3 Replies

DataSource Controls :: Sql Server Deadlock / Only Inserting/updating Data Into A Table

Jun 11, 2010

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?

View 4 Replies

C# - Listview And Datalist Not Updating,inserting?

Apr 17, 2010

Data entered in textboxes is not getting updated in database. In debug mode I see that text1 and text2 in ItemUpdating event contain the same values as they had before calling ItemUpdating.

Here's my listview control:

<asp:ListView ID="ListView1" runat="server"
onitemediting="ListView1_ItemEditing"
onitemupdating="ListView1_ItemUpdating"[code]....

Codebehind file:protected void ListView1_ItemEditing(object sender, ListViewEditEventArgs e)
{
ListView1.EditIndex = e.NewEditIndex;
BindList();[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?

View 1 Replies

ADO.NET :: How To Use SqlDataSource For Inserting, Updating And Deleteing Through Gridview

Feb 8, 2011

I have to use SQLDataSource for inserting, updating and deleting in database through gridview instead of using SqlDataAdapter and SqlCommand object. I have to do it in ADO.NET (means C# code).

View 3 Replies

SQL Server :: Inserting And Updating 2 Tables In 2008 From 2 Worksheets In Excel?

Oct 4, 2010

I have an excel sheet with 2 tabs and has data in those 2 sheets(sheet1, sheet2) which correspond to different tables in the same database. This excel sheet gets updated daily, I am wiriting a console app( which will later be a batch build). I have to insert the data from the excel sheet to corresponding tables (table1, table2,table3) in database when i run it and and also if the table has the same data already present it should ignore and if there are any modifications done the data it should update the table. I know we can do this using ado.net or LINQ, I am a little new to database based programming .

View 4 Replies

DataSource Controls :: Store Procedure Is Returning -1 Even Though It Is Successfully Inserting/updating Record

Jan 29, 2010

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();

View 3 Replies

C# - Deleting From Repeater Item - Erroneous Deleting?

Sep 27, 2010

I have a repeater which binds a set of data. Within this repeater is a column with various controls for updating, deleting, etc. These are image buttons which fire an onclick event such as "DeleteRecord". All this does is fire a stored procedure, passing in the ID of the record to delete from the CommandArgument of the object.

This works wonderfully... except for one rather huge problem. Once you delete a record, if you refresh the page, the record where the first deleted record used to be gets deleted. For instance... if I have 4 records

1 Record1
2 Record2
3 Record3
4 Record4

and I delete record 2... The page reloads with (which is fine):

1 Record1
3 Record3
4 Record4

...if I then hit refresh...

1 Record1
4 Record4

I assume this is because the erroneously deleted object (record3) is now in the same hierarchical place as the old object used to be and .net therefore doesn't know the difference, the page refreshes and fires the onlick event, grabbing out the command argument of the new object and deletes based on the ID as obtained from the commandargument of the new object. This is obviously a huge problem, if a client did this it would destroy data erroneously and I'm at a loss here. Is there any way to stop this from happening? I'm not sure if there is a better way to go about doing things or not. If there isn't, I need some sort of way to tell the page not to execute the event or to cross reference the ID of the object that is intended for deletion against the object itself...

Code below for convenience...

EDIT Wrapped a LinkButton around it because I have some jquery code in here as well which stops the page execution to wait for user confirmation. Pressing "ok" continues page execution.

<asp:LinkButton ID="oDeleteLink" CssClass="oDeleteIcon" CommandName="Delete" CommandArgument='<%# Eval("iAccountID") %>' runat="server">
<asp:ImageButton ImageUrl="/files/system/icons/trash-steel-16.png" ToolTip="Delete This Account" AlternateText="Delete" ID="oDeleteIcon" runat="server" />
</asp:LinkButton>
protected void oAccounts_ItemCommand(Object Sender, RepeaterCommandEventArgs e) {
if (e.CommandName == "Delete") {
int ID = e.CommandArgument.ToString().Numeric();
db.SPs.SpDeleteAccount(ID).Execute();
UI.Confirm(uiBroadcast, "Account has been deleted", "300px");
BindAccounts();
}
}

View 2 Replies

Forms Data Controls :: GridView Deleting?

Sep 21, 2010

I am using VS2005 and SQL Server 2005. The problem I am having is when I call my SQLDataSource to delete rows the delete is firing twice. The trace and debugging show the code executing once. In fact right after the delete, the table only shows one delete, but right after the command function is exited the 2nd row is deleted. Also, I have tested the stored procedure to make sure it only deletes 1 one and then resequences the records.Show below are excerpts from my .aspx and code behind files.

[Code]....

View 4 Replies

Forms Data Controls :: Gridview_RowDataBound Deleting Row?

Mar 23, 2011

I have Gridview_RowDataBound event in my page. Inside this page I want to write some code which will not allow the row to be created.Here is the code:

[Code]....

View 3 Replies

Forms Data Controls :: Getting Values When Deleting?

Feb 25, 2011

I have a listview control. In the ListView1_ItemDeleting event I want to record what was deleted.

I tried using e.Values("ipAddr") but it's value is nothing.

Since this is the ItemDeleting event and not the ItemDeleted event, shouldn't I still have access to the field values? Is there a way to do this?

View 2 Replies

Forms Data Controls :: Deleting Row From DataTable Via GridView?

Feb 10, 2010

I've got a GridView that's databound to a DataTable that I have stored in Session. I want to be able to add a LinkButton into this gridview so I can delete rows from the DataTable, however, I need to reference the rows in the datatable somehow.

I figured the simplest was

[Code]....

but the problem is, I need to somehow cross-reference the particular row I want deleted.

View 4 Replies

Forms Data Controls :: Deleting Row In Gridview While Still In Session?

May 21, 2010

Would like to know how can I delete all the session state data (Empty Cart) and deleting a single row from the gridview while still in session state. (Remove Item).

[Code]....

View 2 Replies

Forms Data Controls :: Deleting Image From The Database?

Mar 13, 2010

I have a grid view that display a list of adverts that I have in the database. I was wondering if it is possible to delete an image from the database (the advet image) when I delete the row of a grid view.

When I delete the adverts how can I delete the image from the database too?

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved