Forms Data Controls :: ListView Not Inserting Records
Sep 20, 2010
Here's the next instalment of my asp.net data access nightmare!
I've got a listview on my page, and when I run the page it correctly displays the data that it should. However, when I add data into the empty new record and hit the 'Insert' button the page posts back but the record isn't inserted. Annoyingly, I don't get any error!
The listview's datasource has an INSERT command and insert parameters specified. The button seems to be triggering the listview's insert method because the ItemInserting event fires.
With no error message to go on I'm struggling to figure out what the problem is. I have a feeling it's something to do with the makeup of the page. The listview in question is nested within an Accordion control and the listview's data source isn't set until runtime, when it's done in the ItemDataBound event of the Accordion control. As I say, though, it does RETRIEVE data correctly, it's just the inserting that's a problem.
I created a new, blank page with just this listview on it using the same code but not nesting it within any other control and hardcoding the datasource instead of setting it at runtime and that works perfectly, so I'm confident that my INSERT command, insert parameters and so forth are correct.
I've tried to get my listview to break, deliberately leaving out insert parameters and so forth just so it'll give me an error message but it never does! It's as if the insert isn't taking place at all, except that because the ItemInserting even takes place I'm assuming that it is.
View 14 Replies
Similar Messages:
Feb 5, 2010
I have a listview that I automatically generated from a database table, enabling editing and inserting on the listview and the EntityDataSource that runs it.
I started customizing the listview templates so that I didn't have to see some of the fields (they're unnecessary from the standpoint of the form), and have alternately tried removing or hiding the unwanted fields. This pretty much patently results in me not being able to insert new records, although updating seems to work just fine. There are no error messages.
I then tried using InsertParameters in the datasource, but that didn't really help either.
In the codebehind I have an onInserting handler that should fill in some of the hidden/removed fields before the record goes to the database.
I've tried pretty much everything I can think of, and even my colleagues are kind of stumped. Why can't I insert records into this table/listview?
<asp:EntityDataSource ID="gradesEds" runat="server"
ConnectionString="name=SAAEntities" DefaultContainerName="SAAEntities"
EntitySetName="tblStudentGrades" AutoGenerateWhereClause="True" OrderBy="it.Date DESC"
EnableUpdate="True" EnableInsert="True">
<WhereParameters>
<asp:SessionParameter Name="StudentID" SessionField="SelectedStudentID" Type="String" />
<asp:SessionParameter Name="Class" SessionField="SelectedClass" Type="String" />
</WhereParameters>
<InsertParameters>
<asp:Parameter Name="GradeID" Type="Int32" Direction="Output" />
<asp:Parameter Name="StudentID" Type="String" />
<asp:Parameter Name="Prof" Type="String" />
<asp:Parameter Name="Class" Type="String" />
<asp:Parameter Name="Date" Type="DateTime" />
<asp:Parameter Name="Term" Type="String" />
<asp:Parameter Name="Year" Type="String" />
<asp:Parameter Name="Source" Type="String" />
<asp:Parameter Name="Grade" Type="String" />
<asp:Parameter Name="Read" Type="Boolean" />
<asp:Parameter Name="OtherInfo1" Type="Boolean" DefaultValue="false" />
<asp:Parameter Name="OtherInfo2" Type="Boolean" DefaultValue="false" />
<asp:Parameter Name="OtherInfo3" Type="Boolean" DefaultValue="false" />
<asp:Parameter Name="OtherInfo4" Type="Boolean" DefaultValue="false" />
<asp:Parameter Name="OtherInfo5" Type="Boolean" DefaultValue="false" />
<asp:Parameter Name="OtherInfo6" Type="Boolean" DefaultValue="false" />
<asp:Parameter Name="OtherInfo7" Type="Boolean" DefaultValue="false" />
<asp:Parameter Name="OtherInfo8" Type="Boolean" DefaultValue="false" />
<asp:Parameter Name="OtherInfo9" Type="Boolean" />
</InsertParameters>
</asp:EntityDataSource>
<asp:ListView ID="ListView1" runat="server" DataKeyNames="GradeID,StudentID"
DataSourceID="gradesEds" InsertItemPosition="LastItem" >
<ItemTemplate>
<tr style="background-color: #FFFBD6;color: #333333;">
<td>
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
</td>
<td>
<asp:Label ID="GradeIDLabel" runat="server" Text='<%# Eval("GradeID") %>' />
<asp:Label ID="StudentIDLabel" runat="server" Text='<%# Eval("StudentID") %>' />
<asp:Label ID="ProfLabel" runat="server" Text='<%# Eval("Prof") %>' />
<asp:Label ID="ClassLabel" runat="server" Text='<%# Eval("Class") %>' />
<asp:Label ID="DateLabel" runat="server" Text='<%# Eval("Date") %>' />
<asp:Label ID="TermLabel" runat="server" Text='<%# Eval("Term") %>' />
<asp:Label ID="YearLabel" runat="server" Text='<%# Eval("Year") %>' />
</td>
<td>
<asp:Label ID="SourceLabel" runat="server" Text='<%# Eval("Source") %>' />
</td>
<td>
<asp:Label ID="GradeLabel" runat="server" Text='<%# Eval("Grade") %>' />
</td>
<td>
<asp:Label ID="CommentsLabel" runat="server" Text='<%# Eval("Comments") %>' />
</td>
<td>
<asp:Label ID="NotesLabel" runat="server" Text='<%# Eval("Notes") %>' />
</td>
<td>
<asp:CheckBox ID="ReadCheckBox" runat="server" Checked='<%# Eval("Read") %>'
Enabled="false" />
</td>
<td>
<asp:CheckBox ID="OtherInfo1CheckBox" runat="server"
Checked='<%# Eval("OtherInfo1") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo2CheckBox" runat="server"
Checked='<%# Eval("OtherInfo2") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo3CheckBox" runat="server"
Checked='<%# Eval("OtherInfo3") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo4CheckBox" runat="server"
Checked='<%# Eval("OtherInfo4") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo5CheckBox" runat="server"
Checked='<%# Eval("OtherInfo5") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo6CheckBox" runat="server"
Checked='<%# Eval("OtherInfo6") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo7CheckBox" runat="server"
Checked='<%# Eval("OtherInfo7") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo8CheckBox" runat="server"
Checked='<%# Eval("OtherInfo8") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo9CheckBox" runat="server"
Checked='<%# Eval("OtherInfo9") %>' Enabled="false" />
</td>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr style="background-color: #FAFAD2;color: #284775;">
<td>
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
</td>
<td>
<asp:Label ID="GradeIDLabel" runat="server" Text='<%# Eval("GradeID") %>' />
<asp:Label ID="StudentIDLabel" runat="server" Text='<%# Eval("StudentID") %>' />
<asp:Label ID="ProfLabel" runat="server" Text='<%# Eval("Prof") %>' />
<asp:Label ID="ClassLabel" runat="server" Text='<%# Eval("Class") %>' />
<asp:Label ID="DateLabel" runat="server" Text='<%# Eval("Date") %>' />
<asp:Label ID="TermLabel" runat="server" Text='<%# Eval("Term") %>' />
<asp:Label ID="YearLabel" runat="server" Text='<%# Eval("Year") %>' />
</td>
<td>
<asp:Label ID="SourceLabel" runat="server" Text='<%# Eval("Source") %>' />
</td>
<td>
<asp:Label ID="GradeLabel" runat="server" Text='<%# Eval("Grade") %>' />
</td>
<td>
<asp:Label ID="CommentsLabel" runat="server" Text='<%# Eval("Comments") %>' />
</td>
<td>
<asp:Label ID="NotesLabel" runat="server" Text='<%# Eval("Notes") %>' />
</td>
<td>
<asp:CheckBox ID="ReadCheckBox" runat="server" Checked='<%# Eval("Read") %>'
Enabled="false" />
</td>
<td>
<asp:CheckBox ID="OtherInfo1CheckBox" runat="server"
Checked='<%# Eval("OtherInfo1") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo2CheckBox" runat="server"
Checked='<%# Eval("OtherInfo2") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo3CheckBox" runat="server"
Checked='<%# Eval("OtherInfo3") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo4CheckBox" runat="server"
Checked='<%# Eval("OtherInfo4") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo5CheckBox" runat="server"
Checked='<%# Eval("OtherInfo5") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo6CheckBox" runat="server"
Checked='<%# Eval("OtherInfo6") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo7CheckBox" runat="server"
Checked='<%# Eval("OtherInfo7") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo8CheckBox" runat="server"
Checked='<%# Eval("OtherInfo8") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo9CheckBox" runat="server"
Checked='<%# Eval("OtherInfo9") %>' Enabled="false" />
</td>
</tr>
</AlternatingItemTemplate>
<EmptyDataTemplate>
<table runat="server"
style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;">
<tr>
<td>
No data was returned.</td>
</tr>
</table>
</EmptyDataTemplate>
<InsertItemTemplate>
<tr style="">
<td>
<asp:Button ID="InsertButton" runat="server" CommandName="Insert"
Text="Insert" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel"
Text="Clear" />
</td>
<td>
<!--
<asp:TextBox ID="StudentIDTextBox" runat="server"
Text='<%# Bind("StudentID") %>' />
<asp:TextBox ID="ProfTextBox" runat="server" Text='<%# Bind("Prof") %>' />
<asp:TextBox ID="ClassTextBox" runat="server" Text='<%# Bind("Class") %>' />
--> <asp:TextBox ID="DateTextBox" runat="server" Text='<%# Bind("Date") %>' />
<!-- <asp:TextBox ID="TermTextBox" runat="server" Text='<%# Bind("Term") %>' />
<asp:TextBox ID="YearTextBox" runat="server" Text='<%# Bind("Year") %>' />
--> </td>
<td>
<asp:TextBox ID="SourceTextBox" runat="server" Text='<%# Bind("Source") %>' />
</td>
<td>
<asp:TextBox ID="GradeTextBox" runat="server" Text='<%# Bind("Grade") %>' />
</td>
<td>
<asp:TextBox ID="CommentsTextBox" runat="server"
Text='<%# Bind("Comments") %>' />
</td>
<td>
<asp:TextBox ID="NotesTextBox" runat="server" Text='<%# Bind("Notes") %>' />
</td>
<td>
<asp:CheckBox ID="ReadCheckBox" runat="server" Checked='<%# Bind("Read") %>' />
</td>
<td>
<!-- <asp:CheckBox ID="OtherInfo1CheckBox" runat="server"
Checked='<%# Bind("OtherInfo1") %>' />
<asp:CheckBox ID="OtherInfo2CheckBox" runat="server"
Checked='<%# Bind("OtherInfo2") %>' />
<asp:CheckBox ID="OtherInfo3CheckBox" runat="server"
Checked='<%# Bind("OtherInfo3") %>' />
<asp:CheckBox ID="OtherInfo4CheckBox" runat="server"
Checked='<%# Bind("OtherInfo4") %>' />
<asp:CheckBox ID="OtherInfo5CheckBox" runat="server"
Checked='<%# Bind("OtherInfo5") %>' />
<asp:CheckBox ID="OtherInfo6CheckBox" runat="server"
Checked='<%# Bind("OtherInfo6") %>' />
<asp:CheckBox ID="OtherInfo7CheckBox" runat="server"
Checked='<%# Bind("OtherInfo7") %>' />
<asp:CheckBox ID="OtherInfo8CheckBox" runat="server"
Checked='<%# Bind("OtherInfo8") %>' /> -->
<asp:CheckBox ID="OtherInfo9CheckBox" runat="server"
Checked='<%# Bind("OtherInfo9") %>' />
</td>
</tr>
</InsertItemTemplate>
<LayoutTemplate>
<table runat="server">
<tr runat="server">
<td runat="server">
<table ID="itemPlaceholderContainer" runat="server" border="1"
style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;font-family: Verdana, Arial, Helvetica, sans-serif;">
<tr runat="server" style="background-color: #FFFBD6;color: #333333;">
<th runat="server">
</th>
<th runat="server">
Date</th>
<th runat="server">
Source</th>
<th runat="server">
Grade</th>
<th runat="server">
Comments</th>
<th runat="server">
Notes</th>
<th runat="server">
Read</th>
<th runat="server">
OtherInfo9</th>
</tr>
<tr ID="itemPlaceholder" runat="server">
</tr>
</table>
</td>
</tr>
<tr runat="server">
<td runat="server"
style="text-align: center;background-color: #FFCC66;font-family: Verdana, Arial, Helvetica, sans-serif;color: #333333;">
<asp:DataPager ID="DataPager1" runat="server">
<Fields>
<asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True"
ShowNextPageButton="False" ShowPreviousPageButton="False" />
<asp:NumericPagerField />
<asp:NextPreviousPagerField ButtonType="Button" ShowLastPageButton="True"
ShowNextPageButton="False" ShowPreviousPageButton="False" />
</Fields>
</asp:DataPager>
</td>
</tr>
</table>
</LayoutTemplate>
<EditItemTemplate>
<tr style="background-color: #FFCC66;color: #000080;">
<td>
<asp:Button ID="UpdateButton" runat="server" CommandName="Update"
Text="Update" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel"
Text="Cancel" />
</td>
<td>
<asp:Label ID="GradeIDLabel1" runat="server" Text='<%# Eval("GradeID") %>' />
<asp:TextBox ID="StudentIDTextBox" runat="server"
Text='<%# Bind("StudentID") %>' />
<asp:TextBox ID="ProfTextBox" runat="server" Text='<%# Bind("Prof") %>' />
<asp:TextBox ID="ClassTextBox" runat="server" Text='<%# Bind("Class") %>' />
<asp:TextBox ID="DateTextBox" runat="server" Text='<%# Bind("Date") %>' />
<asp:TextBox ID="TermTextBox" runat="server" Text='<%# Bind("Term") %>' />
<asp:TextBox ID="YearTextBox" runat="server" Text='<%# Bind("Year") %>' />
</td>
<td>
<asp:TextBox ID="SourceTextBox" runat="server" Text='<%# Bind("Source") %>' />
</td>
<td>
<asp:TextBox ID="GradeTextBox" runat="server" Text='<%# Bind("Grade") %>' />
</td>
<td>
<asp:TextBox ID="CommentsTextBox" runat="server"
Text='<%# Bind("Comments") %>' />
</td>
<td>
<asp:TextBox ID="NotesTextBox" runat="server" Text='<%# Bind("Notes") %>' />
</td>
<td>
<asp:CheckBox ID="ReadCheckBox" runat="server" Checked='<%# Bind("Read") %>' />
</td>
<td>
<asp:CheckBox ID="OtherInfo1CheckBox" runat="server"
Checked='<%# Bind("OtherInfo1") %>' />
<asp:CheckBox ID="OtherInfo2CheckBox" runat="server"
Checked='<%# Bind("OtherInfo2") %>' />
<asp:CheckBox ID="OtherInfo3CheckBox" runat="server"
Checked='<%# Bind("OtherInfo3") %>' />
<asp:CheckBox ID="OtherInfo4CheckBox" runat="server"
Checked='<%# Bind("OtherInfo4") %>' />
<asp:CheckBox ID="OtherInfo5CheckBox" runat="server"
Checked='<%# Bind("OtherInfo5") %>' />
<asp:CheckBox ID="OtherInfo6CheckBox" runat="server"
Checked='<%# Bind("OtherInfo6") %>' />
<asp:CheckBox ID="OtherInfo7CheckBox" runat="server"
Checked='<%# Bind("OtherInfo7") %>' />
<asp:CheckBox ID="OtherInfo8CheckBox" runat="server"
Checked='<%# Bind("OtherInfo8") %>' />
<asp:CheckBox ID="OtherInfo9CheckBox" runat="server"
Checked='<%# Bind("OtherInfo9") %>' />
</td>
</tr>
</EditItemTemplate>
<SelectedItemTemplate>
<tr style="background-color: #FFCC66;font-weight: bold;color: #000080;">
<td>
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
</td>
<td>
<asp:Label ID="GradeIDLabel" runat="server" Text='<%# Eval("GradeID") %>' />
<asp:Label ID="StudentIDLabel" runat="server" Text='<%# Eval("StudentID") %>' />
<asp:Label ID="ProfLabel" runat="server" Text='<%# Eval("Prof") %>' />
<asp:Label ID="ClassLabel" runat="server" Text='<%# Eval("Class") %>' />
<asp:Label ID="DateLabel" runat="server" Text='<%# Eval("Date") %>' />
<asp:Label ID="TermLabel" runat="server" Text='<%# Eval("Term") %>' />
<asp:Label ID="YearLabel" runat="server" Text='<%# Eval("Year") %>' />
</td>
<td>
<asp:Label ID="SourceLabel" runat="server" Text='<%# Eval("Source") %>' />
</td>
<td>
<asp:Label ID="GradeLabel" runat="server" Text='<%# Eval("Grade") %>' />
</td>
<td>
<asp:Label ID="CommentsLabel" runat="server" Text='<%# Eval("Comments") %>' />
</td>
<td>
<asp:Label ID="NotesLabel" runat="server" Text='<%# Eval("Notes") %>' />
</td>
<td>
<asp:CheckBox ID="ReadCheckBox" runat="server" Checked='<%# Eval("Read") %>'
Enabled="false" />
</td>
<td>
<asp:CheckBox ID="OtherInfo1CheckBox" runat="server"
Checked='<%# Eval("OtherInfo1") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo2CheckBox" runat="server"
Checked='<%# Eval("OtherInfo2") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo3CheckBox" runat="server"
Checked='<%# Eval("OtherInfo3") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo4CheckBox" runat="server"
Checked='<%# Eval("OtherInfo4") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo5CheckBox" runat="server"
Checked='<%# Eval("OtherInfo5") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo6CheckBox" runat="server"
Checked='<%# Eval("OtherInfo6") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo7CheckBox" runat="server"
Checked='<%# Eval("OtherInfo7") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo8CheckBox" runat="server"
Checked='<%# Eval("OtherInfo8") %>' Enabled="false" />
<asp:CheckBox ID="OtherInfo9CheckBox" runat="server"
Checked='<%# Eval("OtherInfo9") %>' Enabled="false" />
</td>
</tr>
</SelectedItemTemplate>
</asp:ListView>
View 1 Replies
Mar 25, 2010
I have a DetailsView control that accepts two different fields to be populated. I need one of them to be masked so that whilst something can be entered, no-one can see what is actually being keyed?
View 6 Replies
Sep 12, 2010
This FormView is inserting two records instead of just one.
[Code]....
[Code]....
View 1 Replies
Nov 13, 2010
Iam using the Gridview control for inserting the records in Database i placed the controls in TemplateField tag like Textboxes and DropDownlist but when page executes nothing is displaying in the control Is there any way to get it work or i must have to define the datasource for the Gridview Control????
<asp:TemplateField ...>
<ItemTemplate>
<asp:DropDownList ..../>
And more textboxes like the above way but there is no Bound Field because iam going to insert the record in DB while placing the controls in Gridview Control
View 5 Replies
Jul 16, 2010
I have a gridview with 3 columns dropdown, textbox1, textbox2.
On pageload my gridview loads with one row i.e dropdown with databinding done with some values, empty Textbox, empty textbox2
i have add new row button
clicking on that i will get new row in gridview with dropdown with databinding done with some values, empty Textbox, empty textbox2
I have save button to save the gridview rows into DB.
Question:
I should not allow user to select same dropdown value in two different rows. How can i validate that.
View 2 Replies
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
Mar 15, 2010
I've looked all over for this problem but can't find anything that works. I have a details view bound to a database that when a user enters their details and clicks insert it will store the data and then send them to another page. I have tried response.redirect but that does nothing. I am using c# btw.
View 9 Replies
Feb 21, 2011
I am trying to insert manually new items in a Listview control using objects. The item seems to be inserted, but when the page is sent back to the browser, there is nothing there. Here is the code that I am using:
[Code]....
I can assign a list of object to the datasource, but when I try to input a new object to the list of items from the ListView, it doesn't work.
View 3 Replies
May 10, 2010
I need to check for duplicate records before inserting them into the SQL database.Thus I have the following codes:
For count = 0 To GridView1.Rows.Count
If (GridView1.Rows(count).DataItem("Student Name").Equals(dtDataTable.Rows(count).Item("Student ID"))) Then
lblMsg.Text = "Records Existed"
End If
but there are error message. "Object variable or With block variable not set."
View 11 Replies
Sep 10, 2010
Using checkboxes, can the row of record(s) be inserted into a database? I am populating a Gridview. Done. A checkbox field has been added, when the user selects one or more rows, a submit button (which is not working) needs to inserting those records into a table. The insert statment will work outside of the page but is not working using the scenario I jut described. Is this task as I have outlined doable?
View 13 Replies
Sep 19, 2010
I have created a ListView with a SQL DataSource. It has Item Template, Alternate Item Template, Insert Item Template, Layout Template, Edit Item Template & Select Item Template. There are delete buttons in the Item Template, Alternate Item Template and Select Item Template. The Delete command is
DeleteCommand="DELETE FROM [ClientNoteType_Lookup] WHERE [ClientNoteTypeCode] = @ClientNoteTypeCode"
which seems correct. I have not selected Use Optimistic Consurrency when I configured the data source. When I click on the Delete button, it deletes the selected record and the record after. THe ClienNoteTypeCode is a varchar(4) field and all codes are unique. It deletes both records in SQL Server when the button is clicked, but one one is deleted on the web page until I refresh the page and then both are deleted.
View 7 Replies
Feb 24, 2011
i am having problem to insert data in database from data list view...I want that when i click on download hyperlink, the file that has been downloaded and all its other related information must get save in the database
Below I am providing my code. ..when i use the below code..all the files that are show in data list view get stored in the database along with the one that i have clicked...i am biniding data to data list view of other database/table and i want to store the file info that i have downloaded into another database/table..CODE IS...
public void DataList1_ItemBound(Object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) [code]....
View 2 Replies
Jan 20, 2013
My project is in ASP.net and C#.I am doing webbased desktop application.I have some 4-5 textboxes on the webform like ItemCode, ItemName Qty Rate Amt and a Button called Add on the click event of the Add button i want the data from the textboxes to be inserted or added to the ListView, user can add multiple entries to the ListView through this textboxes and then finally he will have a button called save on the click of save button.i want this LIstView data to be inserted into the SQL Table
View 2 Replies
Feb 19, 2014
I have a detail view form consist of five fields my 1st field is jobnumber which is primary key i want to do that when user by mistake enter the duplicate jobnumber error occur that this is already used how can i do this ?
View 1 Replies
Feb 8, 2010
I'd like to be able to display multiple records in edit mode in a listview. Is this possible?
View 3 Replies
Nov 18, 2010
i use this query as my sql query :
SELECT TOP 5 * FROM MyTableName WHERE ID=@ID ORDER BY NEWID()
As you may know it gets 5 records by random. I use it with dataset and bind the listview to this dataset and in ItemDataBound i want to do some programming (like making some controls visible or invisible) i need itemindex.
but the question is : how can i get the itemindex of a listview when sql query selects records randomly?
View 8 Replies
Dec 2, 2010
I am building a retail shopping website and want multiple db records per row - e.g. 2 records per row side by side. Each record will have an image, a couple of labels from the database to state Item title / name, description etc and I need to add a textbox for the quantity. In clothing section a radio button for size and another textbox for item colour. I will then add a button (any button) to gather the info (recordID and textbox input) and take me to the shopping cart.
Problem: In ListView I get the multiple records but can't get the data from the textboxes: In Gridview I can get the textbox data but can't get multipe records per row.Which grid should I use to get both of these features working?
View 1 Replies
Mar 30, 2010
What is the best method in T-SQL 2008 for extending a table's records with the criteria of 'repeating' all fields but the Primary KEY e.g. Consecutive Date for the previous n Records.
So you have for example 7 records (Easy...2 Fields. Date and nvarchar) with th Date runing from Jan-01 to Jan-07
We want to extend the table by 21 records...so
Record 1,8,15,22 will look identical apart from the DateField.
Record 2,9,16,23 will look identical apart from the DateField. etc...etc..
I have tried a number of methods ...all coming up short....
View 4 Replies
Mar 10, 2010
I want to insert a large amount( approx 7000 records) of data into a table, My scenarios is that i need to check whether the record already exists then it will not insert it. Currently i am using a stored procedure for this which gets called for each record.
IF EXISTS(SELECT 'True' FROM MYTABLE WHERE ID = @ID)
BEGIN
--This means it exists, return it to ASP and tell us
SELECT 'This record already exists!'
END
ELSE
BEGIN
--This means the record isn't in there already, let's go ahead and add it
SELECT 'Record Added'
IF EXISTS(SELECT 'True' FROM [Aadil].[dbo].[SharePointSitesData] WHERE ID <> @ID)
View 11 Replies
Jul 12, 2010
I'm having a problem when two or more users simultaneous work on a webpage and provides info to create a new record in my database. the issue is that for some reason, their entries get mixed up and the wrong data gets commited to the database, how can i fix this. All the webpages i browsed for help provide optimistic concurrecny on updaing/deleting existing records, not creating new ones.
I also turned off SessionViewState, but I don't think it helps.
I'm not using a ObjectSource Control, i'm creating new instances of the BLL Classes in my code as I need. Should I null the objects after I use them? They are only created in the scope of a method, so it should essentially dispose of the object when the method completes.
View 12 Replies
Feb 13, 2010
I have this "SP" that will insert one record to Table 1 and multiple records in Table 2 ...
I just need a way to prevent null values to be inserted in Table 2 ? here is how it looks in my table 2
ID Col1 col2 Col3
3 AB CDE EFGs
4 NULL NULL NULL
4 GDF SSS DFGD
i don't want to insert the second record ... how do i do that using existing "SP" ?
here it is my SP :
CREATE PROCEDURE dbo.Insertvalues
(
@newParentName NVARCHAR(100),
@NewJobTitle NVARCHAR(100) ,
@NewDepartment NVARCHAR (100) ,
@NewCompanyName NVARCHAR (100) ,
@NewURLAddress NVARCHAR (100) ,
@NewOfficePhone char(15),
@NewFax char(15),
@NewMobilePhone char(10),
@NewEmailAddress nvarchar(50),
@NewChiledGroup NVARCHAR(100) ,
@Newchiled_jobTitle nvarchar(100),
@Newchiled_department nvarchar(100),
@Newchiled_phone char(15),
@Newchiled_mobile char(10),
@Newchiled_email nvarchar(50),
@NewChiledGroup1 NVARCHAR(100) ,
@Newchiled_jobTitle1 nvarchar(100),
@Newchiled_department1 nvarchar(100),
@Newchiled_phone1 char(15),
@Newchiled_mobile1 char(10),
@Newchiled_email1 nvarchar(50)
)
AS
-- add parents group
INSERT INTO parents_group (Name,JobTitle,Department,CompanyName,URLAddress,OfficePhone,Fax,MobilePhone,EmailAddress)
VALUES (@newParentName,@NewJobTitle,@NewDepartment,@NewCompanyName,@NewURLAddress,@NewOfficePhone,@NewFax,@NewMobilePhone,@NewEmailAddress)
--obtain inserted id
DECLARE @NewParentId INT
SET @NewParentId = scope_identity()
-- insert into childe table
INSERT INTO childe_group
(groupId , chiled_name,chiled_jobTitle,chiled_department,chiled_phone,chiled_mobile,chiled_email)
(SELECT @NewParentId,@NewChiledGroup,@Newchiled_jobTitle,@Newchiled_department,@Newchiled_phone,@Newchiled_mobile,@Newchiled_email)
UNION
(SELECT @NewParentId,@NewChiledGroup1,@Newchiled_jobTitle1,@Newchiled_department1,@Newchiled_phone1,@Newchiled_mobile1,@Newchiled_email1)
GO
View 5 Replies
Oct 13, 2010
Why am I getting two records inserted into the table, when I'm expecting and needing one? The VB code below is checking whether the HTTP is secure or not, and if it is then execute the SPROC. But for whatever reason, I'm getting two records inserted about 5 seconds apart. Does anyone know why and how to fix? I just need one record.
SPROC [Code]....
VB [Code]....
GLOBAL.ASAX [Code]....
View 4 Replies
Apr 5, 2010
I am having 3 textboxes where I am inserting 3 employee names.I want to insert these details into database as 3 different records.Pls respond me ASAP
View 7 Replies
Apr 27, 2010
I've got a sp as below:
The functionality I want to achieve is that when isHomePageFeatured is checked then this record is set to 1 for that column and for all the other records in the table it is set to 0.
This is fine for update as I can use the property Id to compare against, but for the newly inserted record it doesn't yet have a propertyId so I wondered if using newID() to affect all other records would have the same affect.
[Code].....
View 3 Replies
