.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:

Difference In C# Between The Access Modifiers Internal And Protected Internal?

Mar 10, 2010

what is the difference in C# between the access modifiers internal and protected internal?

View 4 Replies

Access :: Internal Server Error When Submitting Data

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

Tool To Generate Data Access Class In VS 2008?

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

What's Internal Access Modifier

Apr 4, 2010

What is internal access modifier? Where we are using the keyword? How should we use in our application?

View 3 Replies

Can't Access The Website (while Its Uploaded) Using Internal IP

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

Access The Website Using Internal IP Address

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

Visual Studio :: Cannot Get VWD To Recognize Database Where Access Is Limited To An Internal IP

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

VS 2008 Web Deployment MSI Built On XP Works Fine, But MSI Built On Windows 7 Does Not Work?

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

Visual Studio :: Access Website Administration Tool

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

Access :: Server.HtmlDecode The Right Tool / Preserve The Line Breaks Od Course?

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

Access An Internal Site Through An External Site?

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

Accessing Data In Internal Production Databases From A Web Server In DMZ?

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

Forms Data Controls :: Gridview Paging Can Use For Dynamically Built Function

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

Forms Data Controls :: Using Built In Enable Selection Option In Gridview?

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

Gridview - Built In Asp.net Grid Controls (or Similiar) Provide Effecient Data Paging

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

Forms Data Controls :: Use All The Built - In Editing Functionality Of A GridView Without Setting A DataSource?

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

Forms Data Controls :: Handle Sorting And Paging When Objectdatasource Is Being Built Dynamically?

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

Linq Update Query Generates Where 0 = 1?

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

Forms Data Controls :: Trying To Add Some Custom Code Behind The Cancel Button Built Into A Details View?

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

Forms Data Controls :: Built A User Control That Displays A Drop Down List Of States?

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

Web Forms :: .net Generates W3C Incomplinaced Source Code?

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

C# - Rendering A Control Generates Security Exception In .Net 4?

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

C# - How To Write A Stored Procedure That Generates A Unique Identifier

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

C# - EDMX New Column Generates Error On ToList() Call

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







Copyrights 2005-15 www.BigResource.com, All rights reserved