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
I am not able to figure out why I am getting the null error at SqlDataSource10.Insert(); I tried running through break points and i checked the Insert statement and it has all the required values .. but I get error saying it cannot insert null into NrNarrativeDays. I am working off a sample at this link..
http://www.aspdotnetfaq.com/Faq/How-to-insert-row-in-GridView-with-SqlDataSource.aspx
[Code]....
Datasource and Gridview code is below
[Code]....
this is the code
<%
@
Page
Language="VB"
AutoEventWireup="false"
CodeFile="Default.aspx.vb"
Inherits="_Default" %>
[Code]....
I'm having a strange problem - probably has a simple answer but, I haven't been able to find it or figure out the cause. I'm hoping someone has had this same problem and figured it out.
Basically - my application works great on the development machine. So I copy it over to the server and it works great. Come back the next day and my GridView is only displaying the first record...I then log into the server remotely and open the web page on the server and all records are returned, so the application works fine on the server. I then return to the local machine and now the application is returning all rows in the GridView. So, weird but, what whatever, it works. Go away and come back again the next day and...
1 ) Only 1 record from dataset is displayed in GridView
2 ) Log onto server remotely and view webpage on server --> all records now display
3 ) Try again on local machine, now application works fine...grr. What am I doing wrong here? Using Visual Web Developer 2008 on Windows XP. Querying SQL Server 2000 (I know, I should switch to 2005 and use VWD 2010 - but ouch, really!) when a text box value changes (Vendor_PO_TextBox.TextChanged)
[Code]....
I have an editable grid where user can add/edit data. They also have the option to load previously entered data from last month. When the user then clicks save, i want to readd this newly modified data as a new record for this month. So basically I want to call the insertcommand, but it does not work. My 'save' method just 'updates' the records.
Providing sqldatasource, grid and save method
<asp:SqlDataSource ID="SqlDataSourceLoadActivities" runat="server" [code].....
I have a problem with inserting some records into an access database using the sqldatasource control.
Here is Ex 1:
[Code]....
Ex 2:
[Code]....
I have tried both examples above, and some variants of them, but I'm getting errors.
With Ex 1 I get:
System.Data.OleDb.OleDbException was unhandled by user code
ErrorCode=-2147217913
Message="Data Type Mismatch." [code]....
what is wrong with both examples above?I'm adding values to all fields in the table, except for the ID field, ofcouse.
i have built an inserting interface in a GridView's Footer Template. Added Button for insert , auto generated the insertCommand in SqlDataSource. But then how to Bind the data of inserting interface to insert command of SqlDataSource ?In FooterTemplate. i have taken TextBox.GridView's RowCommand Event is handled in this way.
[Code]....
(all that i did , i took help from this web site's tutorial)
So,How to insert data?
I'll try to explain what I'm doing the best I can, but I'm pretty new to asp.net so be patient with me. I have a SqlDataSource which returns a simple select statement based on the WHERE clause using @COURSE_ID
What I want to-do is every time any one of 2 (this will change as it's going to be generated) asp:LinkButtons are pressed, they will change the @COURSEID value which i'd like to associate with the specific button.
Buttons:
<asp:LinkButton ID="LinkButton2" runat="server" onclick="MenuUpdate_Click">Course1</asp:LinkButton>
<asp:LinkButton ID="LinkButton1" runat="server" onclick="MenuUpdate_Click">Course2</asp:LinkButton>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:connString %>" SelectCommand="SELECT Chapter.chapterName, Chapter.chapterID
FROM Chapter
WHERE Chapter.courseID = @COURSE_ID
">
C#
protected void MenuUpdate_Click(object sender, EventArgs e)
{
Parameter p = SqlDataSource1.SelectParameters["COURSE_ID"];
SqlDataSource1.SelectParameters.Remove(p);
SqlDataSource1.SelectParameters.Add("COURSE_ID", THIS NEEDS TO BE VALUE ASSOCIATED TO BUTTON);
ListView1.DataBind();
UpdatePanel1.Update();
}
If anyone has any suggestions that'd be great, I've been trying lots of different things all night with no success :(
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?
I have three controls a textbox, a drop down and a check box on a webform as below;
[Code]....
I have an SqlDataSource defined and configured with SELETC and UPDATE commands as below;
[Code]....
How can I;
1. Query the SqlDataSource for a specific record (ie ApplicantID = some value) and then read the selected data in the three controls on the webform?
2. Update user changes from the three webform controls back to the SqlDataSource?
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)...
I am using a stored procedure for a sqldatasource to update a formview. I believe that I am passing the Obligation_Status value correctly to the stored procedure but the oblgation status field is always updated AS NULL in the database. Does anyone know what I am doing wrong?
[Code]....
[Code]....
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?
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?
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.
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 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 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 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 RepliesI 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 ..
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();
Up till the moment I can not understand why the "SqlDataSource_NewAccount_Inserting" event of the formview's SqlDataSource is not firing!
The code inside the event handler is not executed, even the debugger does not stop on break points inside the "SqlDataSource_NewAccount_Inserting" function!
Here is my code:
[Code]....
[Code]....
I am using VS2010 and target .NET Framework 3.5.
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]....
With reference to the following link: [URL] .....
I want to save data to a different table. My save is working fine but the challenge is that it saves empty cells as well.I will like to save only QTyDelivered cell with value. Any empty QTyDelivered cell should be ignored (which means the row of QTyDelivered cell that is empty will not be saved) .How can i achieve this?
