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]....
[Code]....
pass values to sproc from sproc?
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 RepliesI 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 RepliesI 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>
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.
This FormView is inserting two records instead of just one.
[Code]....
[Code]....
I m unable to refersh my dropdownlist after inserting the records.
i m using this for textboxes...
finally
{
txtStdWeight.Text = string.Empty;
txtStdHeight.Text = string.Empty;
txtDisabilityPercentage.Text = string.Empty;
txtDisabilityDetail.Text = string.Empty;
txtFoodAllergy.Text = string.Empty;
txtMedicineAllergy.Text = string.Empty;
}
so how i set dropdownlist to "select" as default after inserting a record.
i'm making a application for a newslettersystem. The only thing i want yet is to subscribe to a elecronic newsletter, but the record to subscribe isn't inserting. What do i do wrong?
[Code]....
and the vb code
Protected Sub btn_verwerken(ByVal sender As Object, ByVal e As System.EventArgs)
Dim strConnectie As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("~/App_Data/nieuwsbrief.mdb")
Dim Connectie As New OleDbConnection(strConnectie)
Try
Connectie.Open()
Dim strSQL As String = "INSERT INTO TBL_Subscribers(Email, SubscribeDate, ActivateDate, UnsubscribeDate) VALUES (@Email, @SubscribeDate, @ActivateDate, @UnsubscribeDate)"
Dim command As New OleDbCommand(strSQL, Connectie)
command.Parameters.AddWithValue("@Email", Emailadres.Text)
command.Parameters.AddWithValue("@SubscribeDate", DateTime.Now)
command.ExecuteNonQuery()
Connectie.Close()
Response.Write("inserted")
Catch ex As Exception
MsgBox(ex.Message.ToString, MsgBoxStyle.Exclamation, "BCT")
End Try
End Sub
I have a form that is doing a simple insert, then a sub insert of a certain drop down selection is made. What i dont get is why the main insert is inserting duplicates and the sub works fine inserting 1 record per text as expected. I click the button 1 time, and when i check the table, there are 2 new records.. As you can see the insert is not wrapped with any conditions, once that is inserted i check if a slection was made and runs the sub insert.
My full code can be found in this post [URL], but here is what i have for my button event.
[Code]....
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
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.
I've a function named fillgrid() which fills the grid with data.This function works correctly on pageload,but after inserting into database i've called this function again, which is not getting executed.This issue happens only in real time server not in my local system,I'm not getting any error and i cannot recognize why fillgrid() function is not getting called??I've used update panel.This is the code for insert function which inserts over 500records.
DataTable dtMob = new DataTable();
dtMob = dtMobilizn.Copy();
DataSet dsMobilizn=new DataSet("dsMobilization");
[code]....
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 RepliesI 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."
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 Repliesi am trying to insert new records by using a stored procedure with the following code:
[Code]....
I get the following error:
Microsoft SQL Native Client error '80040e14'
A server cursor cannot be opened on the given statement or statements. Use a default result set or client cursor.
Referring to this line:
Records.Open Command, , adOpenStatic
When i am inserting my data i am getting this error
An explicit value for the identity column in table 'emp' can only be specified when a column list is used and IDENTITY_INSERT is ON.
i have set Identitty specification and is identity of the table as yes so i am getting this problem whenevr i set it to no i am not getting any error,can anyone explain me why i am getting this error??
I am using Linq to SQL. I have a table with a uniqueidentifyer column.
I need to insert 1000 records, each with all the same values except for the uniqueid field.
I know the syntax to insert a single record for example where dc is a DataContext():
[Code]....
Does anyone know how if there is a way, other than looping 1000 times, to tell SQL to insert 1000 records generating different unique ids but assign the constant values to the other columns?
I am inserting records using stored procedures in LINQ to SQL in MVC.but i don't know the proper way.
View 1 RepliesWhat 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....
i have 100 records to insert into DB for which i need to show the user progress of inserting records by using procress bar in asp.net by using vb.net how can i do it?
View 3 RepliesI 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)
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.
I have to insert a multiple records under the single table.So i have to execute the command in the frontend for every records.
Inorder to avoid i write the query like this
insert into table1(field1,field2) values('1','Test1'),('2','Test2');
and also i tried
insert into table1(field1,field2)
SELECT "1","Test1"
Union all
SELECT "2","Test2"
But I am getting syntax error.
How to insert a multiple records under the single query?