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
I have two tables: Projects and ProjectsData and I want to execute query with join and get the result in the View. In the Controller I have this code:
ViewBag.projectsData = (from pd in db.ProjectsData
join p in db.Projects on pd.ProjectId equals p.ID
where pd.UserName == this.HttpContext.User.Identity.Name
orderby p.Name, p.ProjectNo
select new { ProjectData = pd, Project = p });
What I should use in the View to extract this data. I tried that:
@foreach (var item in ViewBag.projectsData)
{
@item.pd.UserName
}
but it doesn't work.
I wrote a linq code to read from database if its value is equal to textBox that user enters.
I dont wanna show the result in Gridview,so jz I wanna use that value. The code I wrote is
var sql = from x in db.Managers
where x.M_Name == TextBox1.Text.ToString()
select x.M_Name;
in this code I'm selecting only the name that user entered in textBox
so i want to do like tis
String Name = sql.ToString();
means to store the value in string. so the problem is i can not assign the var to string.
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
I don't see a LINQ option when picking a data source for a grid view - I see the other options like SQL etc.
If I go into a page in another folder, I'm able to see this option.
I just upgraded to Visual Web Developer 2010.
I want to get data from Projects(which have CourseId) and related CourseName from Courses table.
I have written following code:
var projects = from n in db.Projects
join c in db.Courses on n.CourseId equals c.ID
orderby n.Name
select new { Project = n, Course = c };
return View(projects.ToList());
and I get error:
The model item passed into the dictionary is of type 'System.Collections.Generic.List1[<>f__AnonymousType22[ProjectManager.Models.Project,ProjectManager.Models.Course]]', but this dictionary requires a model item of type 'System.Collections.Generic.IEnumerable`1[ProjectManager.Models.Project]'.
What I need to do in Controller and in View to display this data?
I can see the issue here but can't get my head around a dv and dv.Table unless I'm looking too deep into this.Essentially, I can't get AsEnumerable.Sum() on dv but on dv.Table but I need it on the filtered view (ie. dv).This is the framework the entire application is built on so I can't pass these parameters to the stored procedure! Well I could but cannot be bothered re-writing and testing eveyrthing!
[Code]....
When I am creating Strongly Typed View I get lots of Classes in View Data Drop down. Classes like Automapper, ninject, Interface..., latebound... Due this its very hard to find my project classes. Is there any way to restrict dropdown to only display my project classes?
View 1 Repliesspeed Performane i create a web site but it very slow run i use tree view and grid view but i do it run very fast
View 1 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 have a view which takes two objects: booking and list of reasons for canceling that booking.I have two classes: clsBooking, clsBookingCancelationReason I can read both objects in my view - no problems there. After I read the objects, I display the booking details and I generate a list of cancelation reasons in the following way:
[Code]....
The code above generates a list of cancelation reasons.How do I pick up the selected ReasonId from the list?
I need to generate a link that will contain the bookingId and the selected reason for canceling the booking.I can get the bookingId out easily since it's stored in the Model...but how do I go about the selected ReasonId?
i'm tring to search my table according to id number or the case number then view it in a gridviewbut it work for the first time then after it stop for error
Dim conn As New SqlConnection
conn.ConnectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL10.SQLEXPRESSMSSQLDATATask.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
[code]...
I have a field in a details view shown below
<asp:BoundField DataField="DTMON_F" HeaderText="Monday Hours From: " InsertVisible="False"
ReadOnly="True" SortExpression="HOURS" Visible="false" />
<asp:TemplateField HeaderText="Monday Hours From: " SortExpression="HOURS">
<EditItemTemplate>
<uc1:TimePicker ID="tpMondayHours" runat="server"/>
</EditItemTemplate>
<InsertItemTemplate>
<%-- <uc1:TimePicker runat="server" ID="tpMondayHours" />--%>
<asp:TextBox ID="txtMondayHours" runat="server" Text='<%# Bind("DTMON_F") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="lblMondayHours" runat="server" Text='<%# Bind("DTMON_F") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
Before "DTMON_F" is binded to the view I want to cut the string that is returned...Where and how might I do this?
I have added a jquery datepicker on my MVC view. This view has a partial view. I need to filter my partial view based on the datepicker's selected date. I need to show buttons on partial view based on the date.
I have added partial view like this:
div id="dvGames" class="cornerdate1"> % Html.RenderPartial("Partial3"); %>
/div>
one thing that has been puzzling me since learning MVC2 is the following case scenario: I have a view which contains two latest news lists, a login form and a signup form. Every example I found on Views and View Models so far has a one-to-one example such as a simple login form etc. But how do I create a model that provides the properties and validation for a login and signup form and manages the data for the news lists. can I pass multiple models in the strongly typed view? When I created one model the form validation would fail as it expects all fields - login and signup to be filled. I am missing some advanced examples or information.
View 2 Repliesi have created a simple view, and display it into gridview.. i have successfully created view but it is not shown in grid view , it return nothing...
protected void Button3_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=.SQLEXPRESS;AttachDbFilename=E:
arenHDI-AJAX-TK-Calendar-CSApp_DataDatabase.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand cmd = new SqlCommand("select * from nview", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
Can i create a partial view and a controller that will feed data to the view, and if i render that partial in a Master page, the Data will show on whatever URL i am?
Or is there another way of showing content from database on every page(view)?
I have a grid view with a few columns, for example a column in the grid view contains description of a product. The description might be very long, so i want to display only first 100 characters of the description and then provide a . when we click on the. then the whole description should be displayed.
View 3 RepliesI have a view that displays all the records of my Roles table. I want to be able to click a Role record and have a list of users that pertain to that role displayed to the right of the Roles list. I'm sure I need to use a view model for this so I can get two sets of models in one view, but I'm not sure how to set up the view model.
Controller code:
[Code]....
Repository (userRep) code:
[Code]....
I can just as easily get the full user list with return db.Users;
So what method needs added to my repository and how should my view model look?
If i have a page which displays all the data but with only a few fields, then i select one of the data and then i want to be able to view that data with all the fields related to that data on another web page.
I have been able to view the data in Grid view and enable the Select, Update, Insert and Delete. But not able to use the select button to view the information on another web page.
I have this url string on {Controller/View} in mine {Home/Contact}:
http://localhost/sendemail/home/contact?kiosk=1
I have button SEND and when i click on this button my url is
http://localhost/sendemail/home/sent
Now, i want here in this link http://localhost/sendemail/home/sent to put 8 characters ?kiosk=1
I currently have this as my controller:
public ActionResult Index()
{
MembershipUser currentUser = Membership.GetUser();
Guid UserId = (Guid)currentUser.ProviderUserKey;
using (var db = new MatchGamingEntities())
{............
Currently my table "BankTransactions" could have multiple records in there with the same Account Id, so when I run this querry I get a more than one bank transaction related to a given accountid. I want to be able to print this into a view, but I am not sure how my var MyAccount is returning given that there are multiple BankTransactions. How would I transfer this model into the view and be able to iterate through all the bank transactions associated with an AccountId
I have a view on my database and I am trying to add a new record using the AddTo method but it is not working. I noticed that LinqToEntities is creating the insert statement like this
Insert into (select field1, field2 from my_view) (field1, field2) values (value1, value2)
Is it possible to make LinqToEntities create the insert statement like the one below ?
Insert into my_view (field1, field2) values (value1, value2)
new to asp.net and mvc, sorry if the question sounds dumb. I currently have a model (a Linq type) that get data from a table. I use this model to do a Linq qery and display all records in a listing table.I would like to do exactly the same but using a SQL command/query rather than Linq as I'm much more confortable with "standart" SQL. I now need to join tables and return specific columns with custom names as some columns have the same name in the join of my query.If you have another idea (create a stored procedure to be in control of the SQL and then use Linq to call it, for example), I'm open to sugestions.In the view, I loop all records doing: foreach (var item in Model) {}Not sure if this could be important o note
View 2 RepliesI have a vb.net page that has a editable detailsview. When a user wants to erase the data for a field, they highlight the data, and delete/backspace over it, and click update. However, the original data is still saved. If they are replacing the current data with new data, that works fine and updates/saves correctly. This problem only happens when the current data needs to be removed.
View 6 Replies