A table can be used to automatically sense Model. But when I get more than one table after the SQL query is a DataTable. When this DataTable to return View (DataTable) later. In the aspx file, can automatically perceive it as the Model, as the self-paragraphs?
[Code]....
Is there a was to automatically write a tables contents to a .txt file? For example, a table 'deals' has the columns [id], [col1] and [col2]. Another table called 'customs' has the columns [id], [info] and [details]. both [ids] relate to one another. In 'deals', the col1 and col2 data will change, but when the [col1] = [col2] id like the corresponding [id]'s on the other table to be identified and [info] and [details] data be written to a .txt file.
View 2 Repliesi"m using write.xml to write xml files from ms sql server table. the problem is that the information is not trimed... so i get lines like-
<data>1 </data>
are there is a way to trim the data even if i use write.xml mathod?
I want to use response.write to generate a table. but I have a question, the result of table must display on the top of web page. How can I control the location of table? e.g. at the middle or end of web page or starting from number of line.
View 5 RepliesI am going to create a table with SQL Server, this table only has two columns: MessageName and Message.
One example is like
[Code]....
[Code]....
But I don't want to manually type in the message because of trmendous text; what I want is to read the message from an existing web page which like
[URL]
Being new to Linq and Entity Framework, I find myself struggling to write queries that are relatively simple in SQL. My latest challenge is how to write a query that pulls records from a master table and includes a column for aggregating data from related detail records. Let's start with this example:
List<Customer> list = (from x in Customer select x.Customer_ID, x.CustomerName).ToList();
Now I'd like to modify this so that I include a column indicating how many orders each customer has, where there is a one-to-many relationship between the Customer and Order entities. I suspect the solution might result in a List of an anonymous type rather than the List of Customer like my example, but that would be
I have some information I am pulling from my db into a table. Can anyone direct me to a tutorial that shows how to dynamically create a file and allow a user to download that file with the table contents. All this must be dynamic.
View 2 RepliesWe have two database called First(Application) and Last(Workflow) I am submitting a Personal injury report which contains Date of Accident,time,eventID,eventDate,etc.
After submitted the button, these values in insert one of the database(First). At the same time few above column values in insert on another database(Last). Now i want to write a function to insert these values (selected values from both the tables) into new table in First Database.
Because we are adding new tables for audit purpose. User are saying their report are missing. that y we are inserting new table.
i have 2 databases in my project with many tables of information. my need is to pull certain pieces of data from different tables and put them into one table called "results" at a certain time called "endDate" in the database. what is the best way to do this automatically?
View 6 RepliesI have to write data from excel to data table on my server and ms office is not installed on the server. I am able to save the excel file but I don't how I can write it to data table from excel when ms office is not installed.
View 3 RepliesNot a fan of creation and modifcation data in each table's row but I don't make the rules here. Something about normal comes to mind. Simple method to insert or update data in a table ia EF. Datatype = smalldatetime and no it is not changing across schema. Don't care about milli seconds. In oOrg = null I always fail because of a datatype mismatch.Not sure but didn't M$ make both of these products, and shouldn't the EF know about a smalldatetime when it reads the schema? So what is the fix outside of changing many tables to be datetime which is frowned upon at this piont.
public static String updateOrgs(Orgs org, Guid user)
{
using (ELogs2Entities EL = new ELogs2Entities())
[code]...
I want to write the query for finding second highest salary in my employee table how to find it??
View 3 RepliesI have gridView with checkbox on each row, when user click "Submit" then I want a loop go through the gridview, then save those are checked.
ClientID | Client | Emails | chkBox |
[Code]....
On the code behind, how can I identify the data on each row to save to database?
[Code]....
I need to read a table from a dtgrid there is one code for example?
View 5 Replies i'm trying to write out an html output using jquery from a table
see below
[Code]....
On the alert msg i can print out
[Code]....
But i don't want to append it to any <div> or any element.I just want it to output the html to the screen.
I'm doing tis because i have a jquery that displays the blockquotes and if i have a parent DIV or any other element it doesn't work.
How can i achieve this
Suppose we want to select the data from the database then we write the query for that. Example:
SqlConnection con=new SqlConnection(Connetion name) string selectPkId = @"SELECT PK_ID FROM TABLE" SqlCommand cmd=new SqlCommand(selectPkId ,con);
So,my question is that why we basically use @ before the sql query.If I don't use @ before that then it again work fine (does not give any error), then what is need of using "@"?
I am reading in a file into a string. Then I am writing this string to a stream. I know this code works fine.
The only problem that I have is with the line that write the data in chunks where the parameters is not supported for the Write method.
The line that has the problem is this line. What do I need to change here?
OutPut.Write(buffer, 0, Math.Min(to_write, WRITE_CHUNK));
[Code]....
its said that 1 ViewModel has 1 View. 1 View is for me a UserControl. What if my UserControl has different areas filled with data from different entities, do I have then several Views and need to build several ViewModels? e.g: I display in a UserControl 3 entities: customer(listbox),order(datagrid),product(datagrid). Each of those "data areas" has add+remove buttons and textboxes to enter data.
Actually each of those "data areas" are put in its own GRID having so the posibility to set a individual datacontext.
1.) Should I now create 3 ViewModels CustomerVM,OrderVM and ProductVM?
2.) Are those 3 "data areas" seen as an own sort of separated View, although I have not put them in 3 UserControls.xaml files ???
3.) When this one UserControl is inside a TabControl`s tabpage where do I load the 3 entities related data? Inside the MainViewModel? I want to show/load that data only when the user clicks the tabheader.
I have 2 properties in my ViewModel
class ViewModel1
{
Dictonary<int, string> PossibleValues {get;set;}//key/value
int SelectedKey {get;set}
}
I want to edit this using a Html.DropDownListFor I want to get MVC to auto serialize the data into/from the ViewModel so I can the following
public ActionResult Edit(ViewModel1 model) ...
I'm new to .Net development, and now are following NerdDinner tutorial. Just wondering if any of you would be able to tell me What is the differences between ViewData and ViewModel(all I know is they are used to pass some form of data from controller to view) and perhaps tell me on what situation should I use ViewData instead of ViewModel and vice versa
View 1 Replies[HttpPost]
public ActionResult Edit(int id, FormCollection fc)
{
Movie movie =
(
from m in _ctx.Movie.Include("MovieActors")
where m.MovieID == id select m
).First();
MovieActorViewModel movieActor = new MovieActorViewModel(movie);
if (TryUpdateModel(movieActor))
{
_ctx.ApplyPropertyChanges(movieActor.Movie.EntityKey.EntitySetName,
movieActor.Movie);
_ctx.SaveChanges();
}
return View(movieActor);
}
However, I am not sure how to test this, and in general would much rather have the method take a typed model like:[HttpPost] public ActionResult Edit(MovieActorViewModel movieActor) Is this possible? What changes to my MovieActorViewModel class do I need to make in order to enable this? That class looks like this:
public class MovieActorViewModel
{
public Movie Movie { get; set; }
public Actor Actor { get; set; }
public PublisherDealViewModel(Movie movie)
{
this.Movie = movie;
this.Actor =
(
from a in this.Movie.Actors
where a.ActorID == 1 select a
).First();
}
}
The view is typed (inherits ViewPage) simple:
<% using (Html.BeginForm()) {%>
Movie Title: <%= Html.TextBoxFor(model=>model.Movie.Title) %><br/>
Actor Name: <%= Html.TextBoxFor(model=>model.Actor.Name) %>
<% } %>
I have used IDataErrorInfo Validation for my Model.
But when I use these model classes inside a view model, the validation does not happen.
sample viewmodel below
[code]....
Now, if Category or Subcategory classes are directly used as models for view, the validation works fine. But, if CategoryViewModel is used, no validation occurs.
I'm trying to get my own viewmodel after submit my form and I got the following error:
"Unable to cast object of type 'System.String[]' to type 'System.String'"
This is my code:
ViewMode:
public class SoftwarePackages
{
public string[] PermissionsList { get; set; }[code].....
In my page there is a Login form. It looks like
[Code]....
But at the same time in this page I need to render some info from another ViewModel. Is it possible to write in action something like
return View(Model1, Model2); ?And how could I get access to these ViewModels in this case?
This is probably basic stuff, but I can't find the clear answer anywhere..Lets say I'm doing an MVC (3) application with Entity Framework (EF4), and I have these three classes:
public class Foo
{
public int FooID
[code]...
