I can't for the life of me remember how to do this and I'm sure someone will answer this pretty quickly. I need to insert or update a record based on if it exists so in the SP I need to do:
SELECT * FROM table1 WHERE LinkedID = @ID Then I need to check if any rows were returned and apply it to an if statement which is where my mind is blocked.
I'm having trouble with an SQL statement. I want to have one statement that checks to see if it a record exists. If it does, then update it and if it doesnt then insert a new one in the server. Here is what I have so far:
[Code]....
When processing many records starting from 10,000 System.OutOfMemoryExceptio get the error. There would be some way to handle this type of memory error ?.
ASP.Net SqlBulkCopy- Bulk Insert records and Update existing rows if record exists Exception: Out of Memory Exception C# and VB.Net
I need a way of doing the following:
I receive data in .csv format. I have a some records on a table, so what I need to do is to check if the data I receive exist on the table of records that I need to match against.
If the record exist, then an email/sms should be sent to notify me that the records has been matched and then that record should be flaged that it has been tested so that I don't test it again as the incoming data are saved.
How can insert, Display ,update multiple records simultaneously through GridView in Asp.net.I have Button for insert, update . I want insert, update multiple records through a GridView in a single click.
View 1 RepliesI have written a script to write several values to an Access Database Table, but I need to ammend i so it checks for two values (Asset and LName) to see if they match if they do it updates the record if not it writes a new record, my script so far is as follows :
[Code]....
I'm just stuck as I can't work out the best way to do it,
how to update a grid view when we insert or delete a record using jquey
View 3 Replies[Code]....
After this and in the same procedure i want to update the inserted or the updated record which occared in the above code with the follwing update statment :
[Code]....
updating mark is completed successfully if the record is existed (Update Case) but if the record does not exist (new record) ... the update of the mark is not occured ..
i would like to ask about the design pattern of insert/update/delete record in the datagrid.
my page have 3 datagrids, each datagrid display different data.
but when clicking the save/update/delete button, how can i write a good progrmming pattern to perform this action.
any example code for my reference?
when i want insert a record i see an error like this Can't perform Create, Update, or Delete operations on 'Table(MainMenuLink)' because it has no primary key. with this codes:
MyLinqDataClassesDataContext db = new MyLinqDataClassesDataContext();
MainMenuLink li = new MainMenuLink { Link = "www.tprogrammer.com", LinkSubject = "subject" };
db.MainMenuLinks.InsertOnSubmit(li); [code]....
I need to insert a record in table which is in remote server....I am using two connection strings for local and remote....both the servers are in same workgroup only...so am able to connect the both.The problem is am filling data of local table in on dataset1 and remote server table data in another dataset dataset2..Now whil inserting a record local an error occured like "This row already belongs to another table" after googlingI found like this like "Dataset.importrow()" instead of "dataset.add()" method...then there is no errors but the inserted record is not inserting in remote server database...
View 5 RepliesI have the query to retrieve selected record in textbox. How to use this query to update record: I want when I enter sumit in textbox1 and click submit button then the record with ID 1 will be updated to name sumit
Dim SQLData As New System.Data.SqlClient.SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True")
Dim cmdSelect As New System.Data.SqlClient.SqlCommand("SELECT TOP 1 Name FROM Table1 Order by Id DESC", SQLData)
SQLData.Open()
Dim dtrReader As System.Data.SqlClient.SqlDataReader = cmdSelect.ExecuteReader()
If dtrReader.HasRows Then
While dtrReader.Read()
TextBox1.Text = dtrReader("Name")
End While
Else
Response.Write("No customer found for the supplied ID.")
End If
dtrReader.Close()
SQLData.Close()
I want to insert a new record into a table. The table has relationships with other secondary tables, For example:
Table: Stores
Table StoreCategories (a store can have many of these)
I want to insert a new store, get its ID and insert some categories in one go.
How do I go about this?
If I have records in a table in this order:
Id - Date - Type
1 - 2011-03-01 - 1
2 - 2011-03-02 - 0
3 - 2011-03-03 - 0
4 - 2011-03-04 - (-1)
5 - 2011-03-04 - 0
Can I somehow select the records between a record having type 1 and type -1 without using a cursor,for example the records with ids 1-4 in this example?
tbl_salary
salary salperyr hike20 hike20yr
10000.0000 NULL 12000.00 144000.00
12000.0000 NULL 14400.00 172800.00
14000.0000 NULL 16800.00 201600.00
15000.0000 NULL 18000.00 216000.00
18000.0000 NULL 21600.00 259200.00
20000.0000 NULL 24000.00 288000.00
22000.0000 NULL 26400.00 316800.00
in above table salaryper yr (salperyr) has to be modified after caliculation my null values has to be removed and place(salary*12)in one shot.
i made two table and their repectively sp
[code]....
nw firstly i insert all value which appears on Default.aspx page and then display on grid..
but primary i couldn't work insert that value then after display grid..
how to insert record in sql server database by using linq?
still i m using MVC 3.0 send me full detail example for insert record using Linq
How to insert one record in SQL Server by using the xmlhttp object and Asp.net
View 1 RepliesI am designing a social networking site that has a "wall" feature like the others out there today. The database has an alerts table that stores some user action worthy of sharing with his friends. For example, when a user updates his status, all of his friends are notified. The below table shows two status updates from two unique users. The first (AlertId 689 and 690) is submitted by AccountId 53. Since he has one frinend - AccountId 57 - that row is added to the table so when this user logs on, he will see Account 53's update on his wall. In the same manner, the other user's status update has four rows because he has three friends.
[AlertId] [AccountId] [CreateDate] [Timestamp] [AlertTypeId] [IsHidden] [Body]
689 57 2010-08-10 0x0000000000018725 10 0 HTML
690 53 2010-08-10 0x0000000000018726 10 0 HTML
691 53 2010-08-10 0x000000000001872B 10 0 HTML
692 52 2010-08-10 0x000000000001872C 10 0 HTML
693 51 2010-08-10 0x000000000001872D 10 0 HTML
694 57 2010-08-10 0x000000000001872E 10 0 HTML
Now, a user can comment on any given item, in this case a statusupdate. When AddComment is submitted, we are using ObjectRecordId (which is the primary key of the alert being commented on) in order to identify which statusupdate is being commented on (fyi - the objectId tells us its a statusupdate):
public void AddComment(string comment)
{
if (_webContext != null)
{
var c = new Comment
{
Body = comment,
CommentByAccountId = _webContext.CurrentUser.AccountId,
CommentByUserName = _webContext.CurrentUser.UserName,
CreateDate = DateTime.Now,
SystemObjectId = _view.ObjectId,
SystemObjectRecordId = _view.ObjectRecordId
};
_commentRepository.SaveComment(c);
}
_view.ClearComments();
LoadComments();
}
Now, the problem is that when a user wants to comment on a friend's status update, he will be using the AlertId (or ObjectRecordId in the Comments table) corresponding to his account in the alerts table. The result is that comments are only viewable by the commenter and none of his friends:
[CommentId] [Body] [CommentById] [CommentByName] [ObjectId] [ObjectRecordId] [Delete]
97 hello world. 57 GrumpyCat 7 690 0
Of course the solution to this is to do something similar to what I did in the alerts table - when somebody makes a comment, make a corresponding row for every friend in the comments table. But how do I access the AlertIds of all of my friend's status updates in the Alerts table and map them to the ObjectRecordId column in the comments table? Since I can only access the status updates corresponding to my account (and their corresponding alertids), I don't know what the alertids are for the same statusupdate in my friend's accounts.
I would like to check and see if a record exists before doing an insert. Here is the code I have tried:
[Code]....
I am using a SP to insert into tables base on the parameters but getting syntax errors on:
Msg 156, Level 15, State 1, Procedure Dyno_InsertNewItem, Line 27
i need to call multi dropdown for products that retrieve product name from microsoft sql and get the price as the product is been selected from the dropdown for total amount for the customer.Example is for customer to buy 6 product.The client is to enter the number of product purchase and the 6 dropdown appears as he click ok button.And as the clients select the product from the dropdown the price sum up together before saving into database.
View 1 Repliesinsert update delete in gridview using sqldatasource in asp.net
View 1 RepliesI am getting the following error when I try to update my record in a GridView. I am using a DataObjectSource and its grabbing the update from a DAL. This is the error:Index (zero based) must be greater than or equal to zero and less than the size of the argument list.This is my code where it says the error is:
[Code]....
I have three column comes from database table(Table1) and one column is for entering data for the user let us consider it look like this
ItemNo ItemName Qty uservalue
001 A 50 20
002 A 20 5
003 B 50
004 C 60 10
005 D 40
006 E 90 15
........
If its 300 row from database to gridview it will show 50 record with page navigation..What i need is i need to insert data in to database table which gridview row has user value..The output of the another table(Table2) will look like this after insert
ItemNo ItemName uservalue
001 A 20
002 A 5
004 C 10
006 E 15