I am pleased to see that you have 30 years of experience and you want to learn MVC. I was starting MVC before 8 months ago and it was wonderful experience to learn . My learning path was 1) I started with some small samples on http://www.asp.net/mvc[^] on almost all topics. 2) JavaScript 3) JQUERY 4) AJAX ($.Ajax)widly used (http://api.jquery.com/jquery.ajax/[^]) 5) JSON 6) Entity Framework
Thanks
There are lot of material available on google try https://www.google.co.in/webhp?q=use%20stored%20procedure%20in%20entity%20framework[^] http://msdn.microsoft.com/en-us/data/gg699321.aspx[^]
Thanks
you can generate edmx file that maps your database objects into Entities. http://msdn.microsoft.com/en-us/library/vstudio/cc716703(v=vs.100).aspx[^] then you can query LINQ to Entities http://msdn.microsoft.com/en-us/library/vstudio/bb399367(v=vs.100).aspx[^]
Thanks
Hi, I am using two connection strings in web.config for accessing data from two databases. It is working fine on localhost but when I host it on IIS 7.5.On page that access both connection string ,Page work for 5-15 refresh and then error occured.
Quote:
Application information: Application domain: /LM/W3SVC/6/ROOT-1-130302610831717557 Trust level: Full Application Virtual Path: / Application Path: C:\inetpub\wwwroot\intranetuat\ Machine name: OMXSRVDMSTEST Process information: Process ID: 12108 Process name: w3wp.exe Account name: NT AUTHORITY\NETWORK SERVICE Exception information: Exception type: SqlException Exception message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Db.getListofPendingRequest(String mailid) at MainMaster.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Request information:
all opened connection are closed properly. I am unable to understand why this error occurred? plz help....
Thanks
Hosting providers provide support and user friendly GUI to easily host a website.For choosing hosting providers See previous Discussion
Thanks
you can easily clear concept by assuming factorial example http://www.c4learn.com/introduction-to-recursive-function-in-c.html[^]
Thanks
try something like
CREATE FUNCTION func_check_seat_availability
(
@in_bUS_No int,
@in_DateOfJourney datetime,
@in_NoOfAdults int,
@in_NoOfChildren int
)
RETURNS decimal(36,30)
AS
BEGIN
--considering 64 is the total count of bus
declare @value decimal(36,30)
select
@value=case when sum(@in_NoOfAdults+@in_NoOfChildren) >= 34 then 0
when sum(@in_NoOfAdults+@in_NoOfChildren) < 14 then 1
end
from Details where BusNo=@in_bus_No and DateOfJourney=@in_DateOfJourney
return @value
END
Thanks
You need to use these concepts 1.WCF Web Service with the client polling the service (simple-basic scenario - easy to implement, not very efficient) 2.WCF Duplex Web Service with the server updating clients when needed (a bit more complicated) 3.TCP Socket-based solution, hardest to implement but permits much better control. There is a very good example in Matthew McDonald's book "Pro Silverlight 3" http://stackoverflow.com/questions/4716279/need-concept-regarding-windows-based-chat-application[^]
Thanks
Intranet is also a web application that is hosted within organisation.You can develop it same as web application and host it on system connected with your company's network.
Quote:
connect to several database in SQL Server 2008 R2
make connection string for each database and use accordingly.
Thanks
Thanks David........ I used Linked Server,and My system administrator tell me that we are not hosting this in public domain,we host it on local IIS and we buy public IP and connect local IP to public IP. Is this possible? Is this secure?
Yes I tried this, but how can i update my database in SQL server in real time means when I update data in oracle ERP it should be updated in SQL Server. and does Hosting provide provides Linked server facility?
Problem: I developed a website with ASP.Net and SQL Server.All data I am accessing from SQL Server. This site will hosted in public domain as internet website and it is a kind of CRM portal.My Sql server datbase has 11 tables. My company uses Oracle ERP.Now I want to update data from oracle erp to SQL Server.I have created views in Oracle as data needed in SQL Server. Means when a customer created/information updated ,it should be updated in SQL Server database. Is there any solution? I tried google but there is no suitable answers. Please reply me.
Try this CP article Add, Edit, and Delete in DataGridView with Paging[^]
Use ItemDataBound event of datalist. take a gridview inside Datalist, and bind it in ItemDataBound event method. http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.datalist.itemdatabound.aspx[^]
Ok, My confusion not in replication, Please see the post again. I try to eleborate more, My company using Oracle ERP. Now i have to develop a customer portal in asp.net and sql server that is hosted by any hosting provider. then how I develop database is sql server(some tables of erp database) so that the customer data upadated if erp data upadated in real time. Is it possible?
I dont need whole data in sql server ,i only need some tables. so please tell me how to replicate local oracle database to sql server(hosted in public domain).....