to display my "latest updates" on my site.I have for example some photos and some journeys and reviews, these all have their own model.How do I go forward with displaying these in the same place,sorted by create date,with each having its own "look" to it.Like,photos have one template (I have a template as an .ascx already for each type) and journeys have one etc.
View 4 RepliesI have prepared a web project using ASP.net MVC. I want to display data by joining 2 or more tables and on Edit performing updation in 2 or more tables.
I have 2 tables :
Employee_master(EmpID,Name,Designation)
Employee_Detail(EmpId,Address,Phone,DOB).
I am using ADO.Entity framework to create the model.I want to perform following operations.
1.Applying 1:1 association between the tables.
2.To show the information EmpID,Name,Designation,Address,Phone for all the existing records in tables on View.
3.On Selecting the Edit link want to show EmpID,Name,Designation,Address,Phone for the corresponding EmpId in EditView and then perform updation of the records in 2 tables both in Employee_master,Employee_Detail on Save.
am in problem and cant sort it out... my code is somwat lyk dis:
[Code]....
end sub
i hav joined both table..but am not able to display it in those controls.
I m getting data from database using SQL
string mysql = "SELECT [ID],[FirstName],[LastName],,[MiddleInit],[DateLastModified] FROM [Databse] WHERE ([ID] = '54321') ORDER BY [DateLastModified]";
I have 4 rows for this sql and I m displaying in GridView. I want the latest modified date as my first row but it is displaying in a reverse order. How can I display rows using Latestmodified date without sorting.
i have a base controller that looks like this:
[Code]....
and a contact model that inherits from the base model.
the master page inherits form the base model,
nad the contact page inherits from the contact nodel,
but then i get an error while loading the contact page that it expects the contact model but gets the base model?
how to display latest recent posts in my facebook page to my website.
View 1 Repliesdisplay "new " img on latest added news in website
i am displaying news on website which stored in data base ,
these are displaying but now
i want that which news i recently add there should be a sign "new"
this new should shown with recently added news
I have two tables... Laptop category and Laptop details ... Laptop of each category is displayed using Imagebuttons in my website... eg: Dell.HP,Compaq and each category is associated with unique ID like 1 ,2, 3, etc.
Based on this category ID when i click on particular image button it should redirect to another web page ( I ve specified the page in each ImageButton's PostBackUrl property as LaptopDetails.aspx ? catId=1 ....). And in Details page I would like to display the sub models of particular Laptop Category...
for eg Dell has three sub models INSPIRON 1464, INSPIRON 15 and INSPIRON 15R
sub models has to be displayed with image and all the details from the database...
I have a gridview populated with some data.
There are following columns:
Reason, Remark1 & Remark2.
As per database designer's logic if there is no data in above field then he replace empty to 0 and in my gridveiw 0 is displaying whereever the cell is empty.
Now I just want to replace 0 to empty.
One more thing that if it displays 0 in a hyperlink Field then it should not be displayed.
I'm not sure on the best way to go about this one. Simply LINQ queries are easy enough for me, but I am looking for the most efficient way here.
I have 2 tables, Sliders and SliderItems. SliderItems have a FK that points to the Sliders Id.
I have been getting information on a particular slider like this:
public static List<Slider> GetSlider(Slider sItem)
{
DBContext db = new DBContext();
if (sItem.Id != Guid.Empty)
{
var list = from tbl in db.Sliders
where tbl.Id == sItem.Id
orderby tbl.Id
select tbl;
return list.ToList();
}
}
So what I need to do for my home page is pull back a set of data that I want to stuff into a data list. Thereby combining the Slider + SliderItems that go along with it.
Do I just do a normal LINQ query with a JOIN statement and toss them into a generic list that goes back to my DataList?
how can i do a join in this query to another table
dynamic list = _db.Users.Where(m => m.vcr_UserName != "superadmin" ).OrderByDescending(m => m.int_UserId).ToPagedList(Cpage, defaultPageSize);
i must have a topagedList there
I want to place two datalist controls at the same (x,y) position. When the first is visible, second should be invisible.
How would I go about implementing this?
[Code]....
[Code]....
I am trying to have the collection of order IDs be used in my where statement how come i can't get this to work?
List<int> orders = new List<int>(){1,2,3,4,5};
DataTable dtTable1 = getOrders();
DataTable dtTable2 = getOrderDetails();
var results = from a in dtTable1.AsEnumerable()
join b in dtTable2.AsEnumerable() on a.Field<int>("ID") equals b.Field<int>("ID")
where orders.Contains(b.Field<int>("OrderID"))
select a;
I have many excel files. How do i Join them to make just 1 file?
Like, I want the contents of 1 file below the other file and so on for all files.
I have been looking into using the Entity Framework for our project, but so far keep coming up a number of limitations trying to fit it to the way our databases are structured. Right now we are coding directly to the database through a MySQL connector, so we have full flexibility to do anything possible that SQL can handle. So the first issue I have is that I need the ability to select a different table for an Entity set at runtime, as we have some tables that have suffixes on them based on the 'brand' presented to the user (ie: shopping carts, config variables etc). I found this project on Codeplex that looks like it will allow me to easily solve that problem:[URL]
However I have another problem I need to solve. Our main database is actually re-factored into the core working set database (6 months of data), and archive databases. There is one archive database per year, where orders and other interesting stuff is archived away to get them out of the working set which keeps the database table sizes and server load down. However the problem is, every so often there are valid reasons to dip into the archive tables to pull stuff out and deal with data in the archive tables (to
refund a customer perhaps past 6 months, or to mark an order as fraud 8 months later etc, or just to query sales history for reporting). For our normal code we have structured some smart SQL pre-processing logic that allows us to find stuff across the archives and join it to the primary database. The result is a single query that returns data from either the working set, or any of the archives all at once (and can join stuff to items still in the working set, such as currently active products etc).
I have struggled to determine if there is even any way to represent that kind of thing with the Entity Framework? The schema of the archive databases is identical to the schema of the primary database, except that it only had a limited selection of tables in it (just stuff that needs to be archived). So how can we associate the main database schema with the archive tables, but more importantly be able to run a query across them all? Should I just write a separate schema for each individual archive database (or perhaps I should give up on archiving stuff by year, and just stick all the archives in one DB?)? But if I do that, is there any way in Entity Framework to join across to tables in a different database? Or for the archive database schema, to include references to tables in the main working set database?
I have to seach data from multiple table and fetch the data and from the result i have to search partical value in or condition .
Means i have 5 table from which i am fetching data and after that ihave to search multiple location means array location and from that array i have to check each location into fetch data.
I have the following tables:
1.) PRODUCT_INFORMATION
2.) CUSTOMERS
3.) DISTRIBUTORS
4.) PRODUCT_NAME
5.) CONTROLLER
Each table has a primary key assigned. The customers table has an ID column and a CUSTOMER_NAME column with unique index property set to avoid any duplication. How do I insert values in the product_information table that has a foreign key column from the CUSTOMERS table if we insert a value in the CUSTOMER_NAME field of the CUSTOMERS table. I want to know how can I create a join between all the tables so that when I insert values in individual tables they are joined with a serial number column in the PRODUCT_INFORMATION table?
I have a table "assignments" with records that are assigned to multiple "users" by the "department" they belong to. Each user then can have it's own "status" for each assignment.
When the user logs-in i need to show all his assignments and the status.(but status record doesn't exist yet)
When a new assignment is created I don't want to have to create a new record relating the assignment to the user. I want the relationship to be by the department the user belongs to and the department the assignment was assigned to.
Only thing i can think of is when the user logs in to load the assignments that belong to the user's department then look thru all the records. For each record loop thru the status table. If a record exist show the the status. if it doesn't then make default value and when the users clicks to view the assignment a new status record will be added.
Only thing i don't like is looping thru the status records while looping thru all the assignments.
How else can I do it? I don't see how could join the assignments table and the status table if the status record doesn't exist yet.
tables:
[ASSIGNMENTS]
assignmentID
departmentID
assignment
[DEPARTMENT]
departmentID
department
[USERS]
userID
departmentID
user
[STATUS]
userID
assignemntID
status
BTW, I'm using Linq-to-SQL
We have a very large .net site using the sql membershipprovider offered by .net. We need to join this to a ruby on rails project - allowing login to both platforms. The ruby project shoudl be able to read and write to the .net's profile information - but additionally may store extra records against the user. The .net user record should always be the master, with logins anthenticated against this. What is the best way to open up this membership provider - via api or similar. We need something that is easy to snap into the RoR solution but secure enough and extenable enough to meet our needs. Is there some way to add on openID or similar to the .net project - and would this be what is recommended or is there a better standard to allow us to link our users.
Other features we would need to have shared are: shared email address, email verification email for both platforms. Both systems have independent CRMs and email systems so unsubscribing from these would also need to be linked preferably with an independent unsubscribe system.
I have been trying to make this work for a while, but I have not been yet able to figure this put. I am using VS 2008 and mysql database. I wrote a query and checked to see if it works in database. It does.
I have a gridview, whose select command is that query. But for some reason, I just get all the rows from one table only. I rechecked my datasource and it is ok. I read on some discussions that it is NOT possible to have data from two tables in a gridview. Is that true? If that is not true, how can I have data from multiple tables in a gridview? Or any other web control for that matter.
I m having one dataset underwhich i have two DataTables ie Contact & Sales Order.In this two table my ContactId field is primary key in both the tables. I cot some code similar to the following code. But when i copy this code two my .net application it me an error saying semicolun expected ,etc as shown bellow.
Error 37 Invalid expression term 'in'
Because of this i m not able to test the code. can any body tell me how can i achive it . I kust want to inner join this two tables & want to store the result in another data table.
[code]....
A user can have many addresses, but I want to retrieve the latest entry for the user
In sql I would do:
SELECT TOP 1 *
FROM UserAddress
WHERE userID = @userID
How can I create a criteria query with the same logic?
I am an ASP.NET developer. What is the latest technology in ASP.NET and also the documentation about it?
View 4 RepliesI've heard that new version of Umbraco CMS will be completely rewritten and will be based on asp.net mvc?
Current version is 4.5 and as I see it is still based on ASP.NET.