Customer customer = (from c in db.Customers
where c.CustomerID == "ABCD"
select c).Single();
customer.Country = "Canada";
db.SubmitChanges();
How to Print the SQL statement being sent to database server by the above Linq Query?
i want update record of Photo table with linq to sql so i create a sproc for it
i dispaly records of Photo table into the Gridview untill when user click on the update command
can updating selected row in a set of textbox
how can i fetch Fields value of selected row for put in the textboxs and updating them?
how can i bind DDLCategory(dropdownlist) to CategoryDatasource(LINQdatasource) with coding?
i want when i select cotegory from DDLCategory ,gridview has been changed?
[Code]....
I had another post about this issue, but decided to modify it to drill down and find the issue. I was doing a master/details, and that was not working, so I have changed it to just a single data source with a single details view created entirely via wizards. The issue is, when I click on the auto generated edit link, and change values in the fields, after clicking update the page refreshes without error but does not update the record. Here is the code:
[Code]....
I'm new to asp.net 3.5 and I have been working through the tutorials using a real access database to learn how to use the new controls. I have an extremely simplistic page setup with a master-details view, the master using the gridview, and the detail using the detailsview controls. Everything seemingly functions correctly, except when I try to update the data in the details view. I make changes to the record, click update and the page posts back but nothing is updated in the database. No errors are given either.
View 10 RepliesI'm very new on VWD, but I got the hang of it for the past 2 weeks(thank you for all the videos posted here in ASP.NET),but I'm really weak on the coding part(vb & c#),except for all the sample shown on the tutorials. Anyways, I have a simple project that
does insert, update & delete to SQL express using the details view. But to complete my project, I need to add a button that will create an event to restore the very last record inserted in SQL and display it back into the details view for minor modification
and nserted again as the newest record with the mod. I'm doing this so user, doesn't need to re-key-in redundant information, like names, original date & time etc, and just make modification on the description of the last record.....
I'm using a details view and a sqldatasource control to populate it. Every once in a while i get an error message because more than one row is returned. How can I have the data display in a gridview instead if more than one row is returned?
View 1 RepliesI just come across this W3C validation errors: I have a LinkButton1 on my .aspx file, and in my c# code I want to disable this LinkButton1 in certiain circumstance, hence i was using this code:
[Code]....
"When a partial view is instantiated, it gets its own copy of the ViewDataDictionary object that is available to the parent view. The partial view therefore has access to the data of the parent view. However, if the partial view updates the data, those updates affect only the partial view's ViewData object. The parent view's data is not changed."Is there a common way around this? For instance I have a View containing two Partial Views (User Controls) that source the same data from the Parents ViewData. The first Partial View is able to update (add/delete) certain data from the Parents View Data, however the second Partial View sources the same data but obviously isn't reflecting the changes owing to the above MSDN statement.
View 4 Repliesi have gridview , it contains record of productsname field of product table and hyper link, hyperlink named as Detail.
when i click Detail link ,it will show record of that row in another page,means it shows complete fields of table in another page,,
i want to know only that,how detail link will perform,to view only that row record,
I retrieve a record on my database through Page_Load event here's the content of my Code:
hMenuID.Value = Request.QueryString["id"];
//Display information of links on the entries
cnDBConnection.ConnectionString = clsFunction.strConnection;
cnDBConnection.Open();
cmModule.Connection = cnDBConnection;
cmModule.CommandText = "SELECT * FROM modules WHERE id=" + clsFunction.ReplaceString(hMenuID.Value.ToString());
rdModule = cmModule.ExecuteReader();
if (rdModule.HasRows == true)
{
rdModule.Read();
txtModuleLabel.Text = rdModule["name"].ToString();
txtModuleLink.Text = rdModule["link"].ToString();
cboParentID.SelectedValue = rdModule["menuid"].ToString();
}
cmModule.Connection.Close();
rdModule.Close();
cnDBConnection.Close();
So, the data appears on my textboxes and a combo box. I tried to modify the content of my textbox and click on the Update button. Unfortunately, there's no modification that happen. Here's my code in the Update button
Code:
if (Page.IsPostBack)
{
if (Page.IsValid)
{
cnDBConnection.ConnectionString = clsFunction.strConnection;
cnDBConnection.Open();
cmModule.Connection = cnDBConnection;
cmModule.CommandText = "UPDATE modules SET name='" + clsFunction.ReplaceString(txtModuleLabel.Text.Trim()) + "', link='" +
clsFunction.ReplaceString(txtModuleLink.Text.Trim()) + "', menuid=" + cboParentID.SelectedValue +
" WHERE id=" + hMenuID.Value;
cmModule.ExecuteNonQuery();
cmModule.Connection.Close();
cnDBConnection.Close();
}
}
I am using LINQ and sending a linq object to the view and trying to show it in a textbox like this
<%=Html.TextBox("petname",Model.PetName) %>
But I am getting error, how can I show (PetRecord.PetName) which is my linq entity
Is there any benefit (performance wise) to check if a record exists before updating it or do I just go straight in with an UPDATE WHERE?
View 2 RepliesI am trying to update gridview record, i am not getting any error but its not updating the record either.
[Code]....
easiest way to create/update a parent and child record at the same time (like customer with multiple addresses) with least or no code as possible? Both Web Forms and in MVC.
View 1 RepliesI have GridView where I am binding payment_terms for an invoice. The Gridview Looks somethign like this.
Head Payment_Date
Advance payment 10/01/2010
25% after completion of the project 20/10/2010
So a command button i want to set the status of these heads from 'N' to 'Y'. The code that i am writing is appended below...
[Code]....
I have an ASP.NET Page that updates registered User Address Details for a selected record.
Below is the Update method that i am calling from Controller.
When i am calling ApplyPropertyChanges method, I am getting the below error.
Did anyone run into the same error while updating the record with Entity Framework.
[code]...
I am just starting to use linq to sql for data access. It is working fine for read only. But it does not work for update. I have been reading the threads over several forums. It is clear that anonymous types (in my case var) cannot be updated. I cannot find what I should replace the var with and where I find it.
Below is the code. The exception is
Error 1 Property or indexer 'AnonymousType#1.date_last_logon' cannot be assigned to -- it is read only
fmcsaDataContext db = new fmcsaDataContext();
// DataTable _UserTable;
UserModel _UserModel = new UserModel();
var users = from u in db.FMCSA_USERs
where u.USER_NAME == pName && u.ACTIVE == true
select new
{
date_last_logon = u.DATE_LAST_LOGON,
date_current_logon = u.DATE_CURRENT_LOGON,
failed_login = u.FAILED_LOGIN,
};
if (users.Count() == 0)
return null;
foreach (var user in users)
{
user.date_last_logon = user.date_current_logon;
}
I've been googling for 2 days for the solution, but I couldn't find something useful. The problem is that I have GridView that is connected to the SQL database and that is how it is being populated. I added EDIT and DELETE buttons in the columns, but as far as I can see the event which handles them is empty.
[Code]....
I've got a gridview with three fields, the last of which is a template field with an imagebutton in.
The first field is a Date, and the second is a time field (it is however just varchar field as it may differ and will not be programmatically used).
I want the following to happen if I click on the imagebutton (reserve):
Four other fields must be inserted into the record.
Is the best way to launch a detailsview where the row.imagebutton@=ID and just edit the fields like that or should I pass the two fields (and RecordID) along with the query string to a new page where the passed information can be in invisble textbowes and just have the user enter (UPDATE) the four outstanding fields? I feel like doing it this way?
can read on 1. setting up the onrowcommand code for the templatefield 2.
This should be simple as it is only one table with records that has to be partially inserted by an admin person (2 Fields) and then completed by a web user (4 fields).
I have a question about linq delete.
I have 2 table in database and they are joined.
First Table: UserID, UserName, UserSurname, UserPhone, CompanyId
Second Table: CompanyId, CompanyName
First Table I have many recods with related second table.
I want to delete one company in second record, But firtly I have to delete users (more than 1)
How can I delete it with using linq?
My project includes a grid view with some updtable fields, some fields throw an error on update and some do not and it does not really make sense. WORK_STATION_ID does not cause an error, ROOM _ID cause an error, both are int? (I am using c#) and for update I use the code liste below.
[Code]....
[Code]....
I have a GridView which needs to get updated on RowUpdating Event. How can I update data using LINQ?
I am populating GV using LINQ too and here is the code for that:
protected void Page_Load(object sender, EventArgs e)
{
string getEntity = Request.QueryString["EntityID"];
int getIntEntity = Int16.Parse(getEntity);
using (OISLinq2SqlVs1DataContext dt = new OISLinq2SqlVs1DataContext())
[Code]....
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();
I'm trying to set the ImageUrl property after I've uploaded an image so that I can display the newly uploaded image, but for some reason it's not working.
If I navigate from the record I've just updated and then return back to that same record, the image then displays. It just doesn't display right after I've updated it. Basically what I'm doing is this:
Sub FormView1_OnItemUpdated(Sender As Object, e As FormViewUpdatedEventArgs)
Dim MyImage As Image
MyImage = FormView1.FindControl("Image1")
MyImage.ImageUrl = "image1.jpg"[code]....
I've left out the path intentionally because I'm pretty certain that the path I'm giving is correct... again, if I navigate away from the record and then return to it, the image displays. In addition, when I view the "Page Source" to view the resulting html, the src property of the image tag is blank . So, it's not a path issue... the issue is that its not setting the src at all which is why the image is not displaying.
Hi to All,
I would like to ask for advice how can i load the data and the columns from MSSQL View to my app by View name.
Let say i have one methode/class that gets the view name and returns back the data (List<Object>).
And in the xml mapping i can set the relation between the object and the columns in the view.
Any advice will be appriciated.
Thank you
Ori