Currently I update a single item in a database as follows:
var master = (from tmi in db._Masters where tmi.Id == Id select tmi).FirstOrDefault();
master.logPosition++;
db.SubmitChanges();
This strikes me as inefficient, as (I think) I am pulling out a full DB row to just update a single value. Is there a more efficient query I can use?
I want to update object via entity framework
For example I have to changed object:
Obj1
Obj2
I want to save change to the Obj1 Only
[code]....
I try to Save with ApplyPropertyChanges but the data didn't saved
How can I update object?
I am having a hard time attempting to update a single field without having to retrieve the whole record prior to saving.
For example, in my web application I have an in place editor for the Name and Description fields of an object. Once you edit either field, it sends the new field (with the object's ID value) to the web server. What I want is the webserver to take that value and ID and only update the one field. There are only two ways google tells me to do this:
1) When I get the value I want to change, the value and the ID, retrieve the record from the database, update the field in the c# object, and then send it back to the server. I don't like this method because not only does it include a completely unnecessary database read call (which includes two tables due to the way my schema is).
2) Set UpdateCheck for all the fields (but the primary keys) to UpdateCheck.Never. This doesn't work for me (I think) due to my mapping layer between the Linq to Sql and my Entity/ViewModel layer. When I convert my entity into the linq to sql db object it seems to be updating those fields regardless of the UpdateCheck setting. This might be just because of integers, since not setting an int means it is a zero (and no, I can't use int? instead).
I have a table and i want to use this table in asp.net page
how i will call the stored procedure on the basis
of Stored procedure's Action .
CREATE TABLE Std_Enquiry(
StdID int IDENTITY(1,1) PRIMARY KEY CLUSTERED ,
FirstName varchar(50) ,
LastName varchar(50) ,
[Code].....
I am trying something apart of my boundries, is there any way to disable a single intem in dropdownlist or stop the ddl change event for a single item.
View 2 RepliesFor context: First of all, I am new to LINQ, as I have been using SubSonic for quite some time now.
I have two tables, Users, and Affiliates. They both have a very typical schema. The FK that joins them is the UserId field, which is in the Affiliates table. I want to create a LINQ query that pulls the Username from the Users table using the AffiliateId value. The AffiliateId is a primary key of the Affiliates table.
I have tried to accomplish this using many variations of the following code:
[Code]....
In the above query, I expect to get a single row result set. However, I instead receive the entire table of results.
How can I make this work? I have yet to see an example or article out there to do what I am trying to do.
I've got a single table, with project information and schedule information. To make the data easier to present, I created a tab control with two panels (a detailsview in each). The first tab is for project info, the second tab is for schedule info (again, all fields in the same table). The problem is, if i change info in both tabs, and then hit the update button, only the data from one tab is added to the table. I think this problem is simple to fix, and boils down to the way I have the page organized, but I can't quite figure it out.
I've boiled my code down to the following conceptualized structure:
[code]....
When you click the update button, you return to the listview, but with only the information from your current tab saved. How can I get it to update from both detailsviews?
i got a problem to update my database which i bounded to datagrid. The problem is, i want to update my database only by clicking one update button at the bottom.. when the user click it, all the fields will be updated to database.
View 3 RepliesI have the following .NET VB code to set and read objects in cache on a per user basis (i.e. a bit like session)
'' Public Shared Sub CacheSet(ByVal Key As String, ByVal Value As Object)
Dim userID As String = HttpContext.Current.User.Identity.Name
HttpContext.Current.Cache(Key & "_" & userID) = Value
End Sub
Public Shared Function CacheGet(ByVal Key As Object)
Dim returnData As Object = Nothing
Dim userID As String = HttpContext.Current.User.Identity.Name
returnData = HttpContext.Current.Cache(Key & "_" & userID)
Return returnData
End Function
I use these functions to hold user data that I don't want to access the DB for all the time. However, when the data is updated, I want the cached item to be removed so it get created again.
How do I make an Item I set disappear or set it to NOTHING or NULL?
i want take a single value result from linq query
if i have :[Code]....
the variable result does not return nothing, only tostring() and similar how can i get a single result from linq query and use it in my ID variable?
I have looked around different properties of asp:menu and set different properties but I just can't figure out a way to make asp:menu behave like "sample 2" from the following url.
http://simplythebest.net/scripts/DHTML_scripts/dhtml_script_122.html
I just want a single branch when a user clicks on an item, is this possible with asp.net's menu item?
I am using an asp.net details view. I added an entry into the details view like so...
<asp:BoundField DataField="DTMON_F" HeaderText="Monday Start:" InsertVisible="False"
ReadOnly="True" SortExpression="DTMON_F" Visible="false" />
<asp:TemplateField HeaderText="*Monday Start: " SortExpression="DTMON_F">
<EditItemTemplate>
[Code]....
Now I need to FIRST concatinate the values from the dropdown then bind the data gathered in the edit template form the 3 dropdowns. How might I do that?
I have this code in my controller:
public ActionResult Details(int id)
{
using (var db = new MatchGamingEntities())
[code]...
The title pretty much explains it. I want to bind a single item to a detail type control. I can bind to a repeater perfectly fine and obviously only one item will be displayed. It seems like there would be a better suited control for this. I know about FormView and DetailsView but they both generate a table which I don't really want. Something similar to the Repeater since it doesn't generate any content other than what you put in the template.
View 5 RepliesI've got this gridview. The gridview uses TemplateFields as the number of fields in the database's table. What I do next is use an ItemTemplate to present the correct column info.
Now, problems rise when the user click's Edit. Since I can only use EditItemTemplate to edit I am resulted with a control in each column. What I really want is to have a single row with no columns so I can easily style the edit mode (having a table with a different layout for example).
Is this possible?
I have this code which takes a value from a dropdown control as a parameter.
[Code]....
I'm now changing to a list control so that multiple items can be selected. So far I have some code that places the items selected into a string that looks like this:
'item1','item2','item4'
For the above example I would need all the the records returned when the field action_ref contains either item1 or item2 or item3.
I want to know how to Update / delete the table records in ASPNETDB.MDF in single update / delete query ?
View 1 RepliesI am developing asp.net mobile application. I am using XML as a database. I am querying on the XML to access the required elements & attributes by using LINQ to XML in .net. I have the follwing part in my XML file.
[code]....
The similar logic I need for the above defined XML part. In the above XML I want to write the LINQ to XML query which can access the NAME attribute of the 'VALVE' node (<VALVE NAME="PWV">), then it should access the text between 'DISPLAY-NODE' (<DISPLAY-NAME> Production Master Valve </DISPLAY-NAME>), & then it should access the all the attributes of the 'COMMAND' node dynamically ( <COMMANDS USE-TEMPLATE="TRUE" TEAMPLATE-NAME="ValveCommands.xml"></COMMANDS>). All these I want dynamically without explicitly specifying the name of the child node as well as name of their attributes ( similar to the way I written the above query ) Can we write such a code by using LINQ to XML ? It will be better if we can write code for above issue in a single logic ( similar to the way I written the above query ).
Context: In an ASP.NET application, I need the behavior of the ItemTemplate / EditItemTemplate that the DataList control provides. However, I only need one item in my control, which makes the DataList seems like overkill.
Question: Is there a control in ASP.NET made to store a single item that has the template content behavior of the DataList and DataGrid? Should I use a DataList for only one item?
I can return single integer values when using stored procedures with Linq but I cant get single string values returned.
View 2 RepliesThere is a session on a web form that holds the holidays of a year.I just intend to remove any repetitive days.... but couldn't get index of item in list.
Protected Sub PersianDateCalendar1_ValueChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles PersianDateCalendar1.ValueChanged
[Code]....
End sub
So I'm trying to add a single item to a query I wrote. The query is then pass to the e.Result of a LinqDataSource_Selecting event. This datasource is being used by a dropdown list and label in a listview.
I am trying to add a "New" field to the end of the list.
Currently I have this working, but it seems like a really messy solution. First I make a class with the fields I need:
[Code]....
Then I build the query:
[Code]....
Then a second list and query with the new value:
[Code]....
Finally, I union the two and set the e.Result:
[Code]....
net.3.5 linq 2 sql
if i need to update a single field in the db table - do i need to select all the row first?
can i say update myTable Field2 = x where field1=y?
dont know its look like too mach recourses
Order order =new ();
order.ID = 1; orderStatus = "test";
db.order.attach(order);
db.Refresh(RefreshMode.KeepCurrentValues, oOrder);
db.SubmitChanges();
well that delete all the other fields values
I have a datatable with some records.
i want that if record id is exists in database then update the record otherwise insert the record.
But i don't want to hit database again and again, i want to accomplish the task on a single hit.
i develop a c# windows application. My database is sql server 2008 exp. i want lock single row for user select it for update. for example;
userA - Connection a (connection id 52);
user select a single row (select * from t1 with(rowlock?, updlock?,or what) where id=1) and bind data to form fields (texbox, checkbox,combobox etc.). (there is no problem)
userB - Connection b (connection id 54);
userB can select all other rows from t1 (where id=2 or 3 or anything) but not id=1. when userB select * from t1 where id=1 system generate an exception with (you cannot select this row because it is updated. Updated users connection id is 52.)
when userA (connectionid52) close form or commit changes then userB can select id=1.
i am read few documents (transacions, rowlock,updlock, concurrency violation optimistic,pessimistic) but i couldn't understand.