How does UpdateModel() works? In the mvcmusic application the postback code contained the following:
UpdateModel();
storeDb.saveChanges();
How is this automatically saving changes to database?
Hi creating a simple blog site where u can login and save blog entries. I want to use the loginname control to automaticly save the username of the one entering the blog.
View 2 RepliesI have a view model class that looks something like this
public class ViewModel
{
public string Name { get; set; }
public IList<SubViewModel> Subs { get; set; }
}
[code]...
Now when I call try update model it replaces the "Subs" list with a new one rather than just updating the IsSet property at the correct index.
Is there any mechanism for saving an excel file automatically. The Code which i used for Generting Excel file is
Code:
HttpContext.Current.Response.Clear()
HttpContext.Current.Response.ClearContent()
HttpContext.Current.Response.ClearHeaders()
HttpContext.Current.Response.Charset = ""
HttpContext.Current.Response.Buffer = True
[Code]....
_strBuild contains the information to be displayed in the excel
The above code when i use it prompts user for open/save an excel file. Is the any mechanism for saving an excel file automatically.
How can I save images in SQL Server 2005 and then read them using VB .Net 2010 and telerik:RadBinaryImage.
View 8 RepliesI have a "hello world" database project. A mdf database with 1 table "users", the table has 2 columns userid & username (both varchar(50)). I added a dataset called Database1Dataset.xsd. I drag the table onto it and it creates the "users" datatable. I checked it to see if it created the insert and update commands and it has.
On my form I have 2 buttons, one for read and the other for write/save.
The read button works and I can see the test records in the database;
[Code]....
The second button should add a new record and save it down to the database but this does not work. Somehow the changes are not being commited and saved.
[Code]....
i am trying to save an image to database as a byte[]
The array size before i save it = 2118.
but in SQL 2008 the maximum size for an image type is 16.
so i am trying to get the image using Response.BinaryWrite(byte[]) I get an empty image.
I need to take an uploaded image, resize it, and save it to the database. Simple enough, except I don't have access to save any temp files to the server. I'm taking the image, resizing it as a Bitmap, and need to save it to a database field as the original image type (JPG for example). How can I get the FileBytes() like this, so I can save it to the database?Before I was using ImageUpload.FileBytes() but now that I'm resizing I'm dealing with Images and Bitmaps instead of FileUploads and can't seem find anything that will give me the bytes.
View 3 Replieshow to accomplish saving div+contents/layout to a database and then retrieveing that data to post back.
View 1 RepliesI have two buttons ... one is insert btn another one is fileupload btn.
In the fileupload btn i creat a code in blow. I can upload the file successfully.
I need to insert a file in sql by using insert btn. For that I can create a insert query every thing but I cannot access the string filename value in the insert btn. So how I get the string value for insert btn. I mentioned the insert query also.
protected void UploadButton_Click(object sender, EventArgs e) {
string filePath = FileUploadControl.PostedFile.FileName;
string filename = Path.GetFileName(filePath);
string ext = Path.GetExtension(filename);
string contenttype = String.Empty;
[Code] ....
Insert Btn:
protected void btnInsert_Click(object sender, EventArgs e) {
cmd = new SqlCommand("insert into emp(FileName,ContanType, Data)values(@FileName, @ContanType, @Data)", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@FileName", filename);
cmd.Parameters.AddWithValue("@ContanType", contenttype); cmd.Parameters.AddWithValue("@Data",bytes);
con.Open(); cmd.ExecuteNonQuery();
con.Close(); Response.Redirect("Default.aspx");
} }
I have been trying to develop edit functionality for a table in database using LINQ to SQL classes (.dbml). Thoiugh updatmodel does not fail, it still does not update the database. I have tried several different things with no resort. I have something going live in a day or so, Below is my code for controller class in MVC 1.1
//Homecontroller.cs
//Overload edit view for postback
[AcceptVerbs(HttpVerbs.Post)]
public object Edit(Guid id, FormCollection form)
{
//Get the row ID which is being edited
var Weballoc = db.WebAllocationImports.Single(w => w.OGReference == id);
try
{
// Weballoc.Side = Request.Form["Side"].ToString();
// Weballoc.Commission = Convert.ToDouble(Request.Form["Commission"]);
UpdateModel(Weballoc, new[] { "ClientSubAccount", "Quantity", "TradeDate", "SecurityID", "Side", "Commission", "NetAmount", "TradeID", "Price" });
db.SubmitChanges();
}
catch (Exception ex)
{
}
return View("ShowCGMAllocations",allocation);
The following is a sample of my edit.aspx view
<% using (Html.BeginForm()) {%>
<fieldset>
<legend>Fields</legend>
<p>
<label for="ClientSubAccount">ClientSubAccount:</label>
<%= Html.TextBox("ClientSubAccount", Model.ClientSubAccount) %>
<%= Html.ValidationMessage("ClientSubAccount", "*") %>
</p>
}
<p>
<input type="submit" value="Save" />
</p>
</fieldset>
<% } %>
I've been struggling with this issue for a few days now and I'm still not able to figure it out. I've created a sample project to hopefully help figure this issue out. The main issue is when I load a user from my context and perform an UpdateModel() on this object it seems to delete my entity references and I get null references in child objects. Here is the error: The operation failed: The relationship could not be changed because one or more of the foreign-key properties is non-nullable. When a change is made to a relationship, the related foreign-key property is set to a null value. If the foreign-key does not support null values, a new relationship must be defined, the foreign-key property must be assigned another non-null value, or the unrelated object must be deletedHere is the link to the code:
Here (line 42, causes the error to happen)
this is the code i am using for update model
[Code]....
on the line 2 i set new value to OrderDate.but after this step OrderDate get value of text box in view.the value of text box is shamsi date and on line 2 i convert that date to miladi date.why OrderDate get shamsi date?
I have a fileupload control in my form which stores image to the SQL database as binary data.
BUT it stores as 0X000000.... I just realized that.
BUT IT DOESN'T MAKE ANY SENSE BECAUSE WHEN I PRINT THIS BYTE ARRAY IT SHOWS THE CONTENT.
This part is the server side code:
[Code]....
StoreToDatabase function:
[Code]....
DisplayFileContent function:
[Code]....
Displaying function shows like 2552162552240167470737001110960960025521906708667658777998101220131211111225181............BUT IN DATABASE it stores like 0X00000000000000000...
I have a form for our staff to list an event in a calendar system. In the form, there is a DDL for their Department, and a CasscadingDropDown that provides a list of staff members (the staff list is filtered by Department, as chosen in the first DDL). When the form gets submitted, I need to store the selected values of both DDL's (DepartmentID and StaffID, respectively) into the database.
So, I have a DetailsView, and am using the InsertItemTemplate. Now, I can get both DDL's populated correctly (with the cascade working correctly), and I used custom DDL's derived from the standard DDL class to avoid any Postback/EventValidation problems. But I can't seem to get the values of the user's selected items so I can save them back into the database! I've tried many different approaches, but all I seem to get returned is a value of "".
Here's what I have so far...
[code]....
I am creating a winform app in C# to store formatted text from a rich text box to MySQL database, which can be retrieved back to the rich text box. The database field is a VARCHAR and my code is something similar to below. But I'm getting "file not in correct format" error. Can anyone tell what could be the problem? Is the VARCHAR field okay to store it or should I change it to a BLOB?
string rtfText = this.richTextBox1.Rtf;
// save rtfText to database field as varchar
// ...
// reload rtfText from database as string
this.richTextBox1.Rtf = rtfText;
I am using the following code to bind BusinessID as the DataValueField of the ddlIndustry dropdown. What I want to do is save the selected ID to a different table (Company). I am doing this with ddlIndustry.SelectedValue. For some reason, the first value is always saved (1), and not the selected value.
[code]....
I have to save user Credantials but I dont know how to save the password into the sql database
View 4 RepliesIn the following code i want to save the value selected by user from drop downlist into database. but whatever value is selected by user, first value of dropdown lsit is saved to database
View
<% =Html.DropDownList("lstUsertype", (SelectList)ViewData["UserTypeID"])%>
Controller
public ActionResult CreateUser()
{
UmUser _UmUser = new UmUser();
UMRepository _UMRepository = new UMRepository();
EvoLetDataContext db = new EvoLetDataContext();
ViewData["UserTypeID"] = new SelectList(_UMRepository.FillUserTypes(), "UserTypeID", "UserType",2);
return View(_UmUser);
}
[AcceptVerbs(HttpVerbs.Post)]
public ActionResult CreateUser(UmUser _umUser)
{
//try
//{
if (ModelState.IsValid)
{
//try
//{
UserRepository _UserRepository = new UserRepository();
_UserRepository.Add(_umUser);
_UserRepository.Save();
return RedirectToAction("Details", new { id = _umUser.UserID });
/*}
catch
{
ModelState.AddModelErrors(_umUser.GetRuleViolations());
}*/
}
return View();
//}
/*catch
{
return View();
}*/
}
By using the following code, i save the dateandtime to my MSSQL DB .
Code:
Dim dateTimeToConvert As New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, Now.Minute, Now.Second, Now.Minute, DateTimeKind.Utc)
Dim easternTime As DateTime = TimeZoneInfo.ConvertTime(dateTimeToConvert, easternZone)
Dim nowtime As DateTime = easternTime.ToUniversalTime
TIMESTAMPSqlDataSource1.InsertParameters("datee").DefaultValue = nowtime
TIMESTAMPSqlDataSource1.insert()
In the DB it saves the time as 21:.... but when I view the time using a gridview it shows 1:... (the correct time I want to show is the 1:... )
HTML Code:
<form id="form1" runat="server">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID" />
[Code] ....
I'm not sure why i'm getting two different dates?
dropdown list keep giving value -1 even i choose one of it already. tell me where i was doing wrong?
this is my code
<asp:DropDownList ID="ddl_viewer" runat="server">
</asp:DropDownList>
this is my vb code
Protected Sub LoadViewer()
ddl_viewer.DataSource = SQL_Viewer()
ddl_viewer.DataTextField = ("view_group")
ddl_viewer.DataValueField = ("view_ID")
ddl_viewer.DataBind()
ddl_viewer.Items.Insert(0, New ListItem("-- Choose --", "-1"))
[Code]......
this is my class
Dim sqlCmd As SqlCommand = New SqlCommand("Insert_News", ClsDBConn.GetDBConn)
sqlCmd.CommandType = Data.CommandType.StoredProcedure
Dim sqlParameter As SqlParameter
sqlCmd.Parameters.Add(New SqlParameter("RETURN_VALUE", SqlDbType.Int))
sqlCmd.Parameters("RETURN_VALUE").Direction = ParameterDirection.ReturnValue
[Code]......
and this is my stored procedure
ALTER PROCEDURE [dbo].[Insert_News]
-- Add the parameters for the stored procedure here
@News_Title VARCHAR (500),
@News_Viewer VARCHAR (500),
@News_Message VARCHAR (300),
@News_Author VARCHAR (100),
[Code]...
I am asking user to upload images using file upload control..In the database i am saving the filename as varchar. My problem is how do i save it.. If file name is saved in database where is file actually saved? If i make a folder to save,it is hard code path.. So, any way to save the file uploaded by user.
View 1 RepliesI am trying to make a photo gallery. I want to save the uploaded image to data base ...the article below at "
Display image after upload without page refresh or postback using ASP.Net AsyncFileUpload Control" shows how to show the uploaded image.. How to save the image in SQl Database?
I do not know how to do it.. Can the code be modified..?
Trying to get UpdateModel to work for my User. The User class has basic string properties like CompanyName, FirstName, LastName, etc so nothing exotic. Here is the header for my view:
<%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Public.Master" Inherits="System.Web.Mvc.ViewPage<User>" %>
After they submit, in my controller, the code looks like this:
[HttpPost]
public ActionResult Edit(string id, FormCollection collection)
{
[code]...
i have a project in which i want to write urdu text in textboxes and then save it to database.
View 3 Replies