.net - Built An Internal Tool That Generates The Whole Data Access?
Oct 20, 2010
We have built an internal tool that generates the whole data access, each table has a class the represents it's data and all the common operations.(think lightweight Entity framework).These DataAccess objects always have a constructor that receives a connection string, and a Load function that receives a SqlDataReader.
Something like this:
class Customer
{
public string ConnStr;[code]...
Btw, we are interested in open sourcing our DataAccess generator, it's amazing - it allow very effecient access to DB objects + creates a javascript data access layer that gives you FULL CONTROL of your DB from javascript(ofcourse this has security implications which can be managed).If anyone here knows how to "open source" a project like this or any company that wants to join the development of this product - please feel free contacting me: eytan@titkadem.co.il
View 4 Replies
Similar Messages:
Mar 10, 2010
what is the difference in C# between the access modifiers internal and protected internal?
View 4 Replies
Oct 20, 2010
I am trying to create a website that takes input from users and then updates a table in MS Access db. I have a plain html form that takes the imput and in the action I entered the asp file name. Once a user clicks on submit on the html page I get the 500 internal server error. I properly uploaded the files on the server,
I have created a DSN on the server, but cannot see the DSN under the "Select ODBC DSN" when I try to create a connection from DreamWeaver. I am using a 64 bit machine so nto sure if that might be causing the problem. Here is code form asp file :
<% @ Language="VBScript" %>
<% Option Explicit %>
<html>
<head>
<title>Form to database</title>
</head>
<body>
<%
'declare your variables
Dim name, email, comments
Dim sConnString, connection, sSQL
' Receiving values from Form, assign the values entered to variables
name = Request.Form("name")
email = Request.Form("email")
comments =Request.Form("comments")
'declare SQL statement that will query the database
sSQL = "INSERT into users_tbl (name, email, comments) values ('" & _
name & "', '" & email & "', '" & comments & "')"
'define the connection string, specify database
'driver and the location of database
sConnString=("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='d:/hosting/6859771/html/access_db/Users.mdb';User Id=;Password=")
'create an ADO connection object
Set connection = Server.CreateObject("ADODB.Connection")
'Open the connection to the database
connection.Open(sConnString)
'execute the SQL
connection.execute(sSQL)
' Done. Close the connection object
connection.Close
Set connection = Nothing
response.write "The form information was inserted successfully."
%>
</body>
</html>
View 1 Replies
Mar 3, 2010
i am developing an web application using vs 2008..( i am new to vs 2008)
Is there any .net tool to generate data access layer or common classes ?
View 2 Replies
Apr 4, 2010
What is internal access modifier? Where we are using the keyword? How should we use in our application?
View 3 Replies
Mar 31, 2010
I created a Website and i upload it using the asp.net development server.
So on the explorer the address is something like this http://localhost:port
The problem is that i can't access the Website(while its uploaded) using my internal IP from within the network.
So if i type http://10.0.0.180:port i get an error "Internet explorer cannot display the webpage".
I disabled my firewall(windows 7).
View 2 Replies
Jan 28, 2011
I do have another PC on the intranet and am not able to access the website using my internal IP address.
View 1 Replies
Mar 24, 2010
I cannot get VWD to recognize a database where access is limited to an internal IP from the Web server. Remote connections directly to the database aren't allowed.I'm using Visual Web Developer 2008 Express on my machine. Our Web site is on a remote hosted server, say 1.1.1.1. We have MSSQL 2005 set up on another remote hosted server, available only through an internal IP, say 2.2.2.2, from the Web server. RemotI'm going crazy trying to establish a connection in VWD that will actually display the database in VWD's Database Explorer, which would then allow me to use the VWD tools to add data elements to my pages.
View 2 Replies
Mar 24, 2010
I'm running into a weird issue that I can't find an answer for anywhere I've looked (and I've looked a ton).I built a web deployment project with Visual Studio 2008 Team System on my old Win XP machine. This has always worked flawlessly and installed everywhere. I can also copy this MSI to my new Windows 7 Ultimate machine and it again installs just fine.
HOWEVER, when I rebuild that exact same web deployment project on my new Win7 machine, also using VS2008, the MSI will build OK, but when I then run it to install my software I get a dialog box telling me "the installer was interrupted." Interestingly, when I built this MSI in my new environment one additional warning popped up during the build process, which was "Unable to copy the schema file '(null)'"After many searches and reading different web pages, I know this has to do with these two registry keys:
[HKEY_LOCAL_MACHINESOFTWAREMicrosoftVisualStudio9.0DeploymentSchema]
"DefaultMSISchemaFile"="c:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\Deployment\Vspkgs\..\VsdSchema\Schema.msi"
"DefaultMSMSchemaFile"="c:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\Deployment\Vspkgs\..\VsdSchema\Schema.msm"
Yet, everything checks out. All permissions are correctly configured, etc., etc.Then, when I enable the built-in administrator account and log in as that, and then rebuild this same web deployment MSI the "Unable to copy the schema file '(null)'" warning no longer appears. Then when I log back out, log back in as myself and then run this newly built MSI it installs fine, just like the original one that was built on XP.I also tried uninstalling VS2008 and re-installing it as the super user, but that also didn't change anything. And yes, I did also configure devenv.exe to run as administrator.
Has anybody seen this? Or is it a requirement that you can only compile deployment projects as the super user? That cannot be right.I've been thrashing for more than five days and for the life of me cannot figure this out. Of course, I can run as the super user when developing, but I thought the new security model in Win7 was designed exactly so you don't have to.
View 1 Replies
May 19, 2010
Can anybody tell me where can i access 'website administration tool' in visual studio 2010. I couldn't see any website tab in my IDE.
View 5 Replies
Oct 29, 2010
This stems from a recent similiar issue: I have since add edit capabilities.My access db is made up of imported records from recipes. In the memo fields are paragraphs users have typed replete with ingredients listed in succession (1 per line) then a normal paragraph follows. When in editmode(multi line textbox), suddenly in each line ends with <br>. How to fix this? I want to preserve the line breaks od course.
View 2 Replies
Aug 6, 2010
I'm pretty sure the answer to this question is no, but I just wanted to get some feedback before I go down another path.
Here is my scenario. I have two websites. Website 1 is an internal website that cannot be accessed outside of our domain. Website 2 is an external website that can be accessed outside of the domain, but has access to webservices inside of the domain.
My question is, is there any possible way to display the internal page through the external page without making the internal page external.
View 1 Replies
Nov 9, 2010
I'm working on an external web site (in DMZ) that needs to get data from our internal production database.
All of the designs that I have come up with are rejected because the network department will not allow a connection of any sort (WCF, Oracle, etc.) to come inside from the DMZ.
The suggestions that have come from the networking side generally fall under two categories -
1) Export the required data to a server in the DMZ and export modified/inserted records eventually somehow, or
2) Poll from inside, continually asking a service in the DMZ whether it has any requests that need serviced.
I'm averse to suggestion 1 because I don't like the idea of a database sitting in the DMZ. Option 2 seems like a ridiculous amount of extra complication for the nature of what's being done.
Are these the only legitimate solutions? Is there an obvious solution I'm missing? Is the "No connections in from DMZ" decree practical?
Edit: One line I'm constantly hearing is that "no large company allows a web site to connect inside to get live production data. That's why they send confirmation emails". Is that really how it works?
View 6 Replies
Jan 8, 2010
I have a Gridview that I am trying to add Paging to, however when the 2nd page is selected I get my EmptyDataText.n reviewing multiple sites and forums they have stated to send your Datatable to a Session - What am I missing here?
[Code]....
View 2 Replies
May 17, 2010
Im pretty new to ASP.net but am getting there slowly but surely! Its definitely growing on me.
The problem im looking at at the moment is i have a gridview displaying data from my SQL database, which works fine. I have enabled the selection option on the gridview which has placed a select link next to each row. Perfect.
What I am looking to do is be able to click the select button, and have the details from each column on that row go into variables when the page is posted back. I will then write these back to a different table in the database later on.
I see that when i click the link it is posting back the number of the row i have selected, but how do i use this to get the data from each column out of the gridview?
View 1 Replies
Apr 26, 2010
know in asp.net 1.0 the grid display controls would pull all the data in, and then provide paging but the paging was done in memory.Are there any smarter controls that provide paging where they only pull the data relevent to current page being displayed?ie. select 10 rows for the current page, instead of doing a select of ALL the rows in the table.
View 1 Replies
Jan 6, 2010
I would prefer that all middle tier methods that are used by GridViews be in the form that allows them to be used by ObjectDataSources...
<DataObjectMethod(DataObjectMethodType.Delete)> _
However, I am working on a project that I did not create. So, I was wondering if there is a way to use all the cool built-in editing functionality of a GridView without setting a DataSource? In other words, I am binding the datasource in the code behind (this works), and I have the following in my GridView...
<asp:CommandField ShowEditButton="True"></asp:CommandField>
And in the RowUpdating event (after the update button is clicked), I would like to call a stored proc to update a table and then use this kludge to get the GridView out of "edit" mode...
e.Cancel = True
grdWeeklyTime.EditIndex = -1
grdWeeklyTime.DataBind()
Is this possible or do I absolutely need to specify a DataSource in the GridView dropdown in design mode and then check the Enable Editing checkbox?
View 2 Replies
Sep 7, 2010
i am building my objectdatasource dynmically when certain buttons are clicked on the page.. and with that the gridview is being displayed with the results of the objectdatasource that was built.
So my gridview code looks like this:
[Code]....
How can i enable sorting and paging if the datasource is being built on button click event?
View 16 Replies
Feb 16, 2010
I am setting the Address of a class generated by Linq 2 Sql and when I try to SubmitChanges(), the sql query it generates is:
Update Users
Set Address = @po
Where 0 = 1
--@po: Input VarChar (Size = 15; Prec = 0; Scale = 0) [123 45th Street]
View 1 Replies
Mar 15, 2010
Trying to add some custom code behind the cancel button built into a details view. How would I go about doing this?This is what i have currently. But, when clicked, the cancel button does not pick this up.
[Code]....
View 2 Replies
Mar 17, 2011
I built a user control that displays a drop down list of states. I'm using it, but if I try to put it in a listview control, all I get is the frop down with nothing in it.
View 3 Replies
Nov 26, 2010
we try to disable a server control at code behand, say:
[Code]....
and obviously the above html/xhtml is not W3C compliance, it always compplians disabled is not a valid attribute. I am pretty sure there are heaps of ppl who would like to develop w3c complianced web application suffer this issue.I was searching on internet without any luck, could someone in here shed me a light or Will Microsoft do sth about it in the near future.
View 7 Replies
May 4, 2010
I am having a problem with code that worked fine in .NET 2.0 but is giving this error under .Net 4.
Build (web): Inheritance security
rules violated while overriding
member:
[code]...
View 2 Replies
Mar 10, 2011
writing the stored procedure that autogenerate the number like...
ABC0000001
It should happen for each entry we make through asp.net page. I mean for each time when the page loads it should create this unique number.
View 6 Replies
Jan 27, 2011
We've added a new column to a database table. The column is defined as follows:
Name: DisplayAsSoldOut
Type: Boolean
NOT NULLABLE
Default Value: 0
We've refreshed our EDMX data model and the new column appears just fine. We are on an ASP.NET 4.0 platform using C#.
We have a class defined as PagedList which inherits from List and implenents an interface IPagedList
Within the PagedList we have the following method:
[Code]....
When we reach the following line:
{ AddRange(source.Skip((index) * pageSize).Take(pageSize).ToList()); }
we receive the following Exception ...
Type: System.Data.EntityCommandExecutionException
Inner Exception: "Invalid column name 'DisplayAsSoldOut'."
I've tried searching for this type of exception but to no avail. The column appears in the EDMX dataset just fine. I even created a small throwaway program and imported the EDMX to do a simple read from the database and it worked fine. Has anyone run across something similar?
View 2 Replies