WEB FORMS and datasetS (do I have to repeat the file definition in every web form?)

I am working on vb.net.
I have a project with 35 web forms and an access file with 18 tables.
Until now I have defined the oledbadapters in every form by dragging the tables from the server explorer tool box.
This is not a good idea because every time that I make a change on the database design I have to drag the new definition on 35 web forms and I have to create the datasets again. This is boring and time consuming!

The question is:
6/10/2005 8:44:49 AM
asp.net.web-forms 93655 articles. 5 followers. Follow

2 Replies

Similar Articles

[PageSpeed] 31

how about if you write a class that has all the data access functions that returns datasets, and use this class in all your forms. This way if you change the database, you just have to change the class.
Wessam Zeidan
6/10/2005 12:27:47 PM
Thank you for your answer:

But I don't understan what do you call  "Data access functions that returns datasets"
I mean, the wizard generates in the web form code like this

Me.OleDbSelectCommand1 = New System.Data.OleDb.OleDbCommand

Me.OleDbInsertCommand1 = New System.Data.OleDb.OleDbCommand
Me.OleDbUpdateCommand1 = New System.Data.OleDb.OleDbCommand
Me.OleDbDeleteCommand1 = New System.Data.OleDb.OleDbCommand
Me.OleDbConnection1 = New System.Data.OleDb.OleDbConnection
Me.OleDbDataAdapter1 = New System.Data.OleDb.OleDbDataAdapter
Me.DataSet11 = New globales.DataSet1
CType(Me.DataSet11, System.ComponentModel.ISupportInitialize).BeginInit()
Me.OleDbSelectCommand1.Connection = Me.OleDbConnection1

How can I access to this from another form ?
Can you give me an example?

Thank you in advance !

6/10/2005 3:01:09 PM

Similar Artilces:

How to Make Web Forms from other Web Forms
In putting together an ASP.NET application for a biz application, we have come to the point where there are three different types of basic forms which have, for the most part, been perfected. Now its is a matter of cloning those forms for various uses and modifying or adding code to suit the particular need. Copy and paste works OK, but there is a lot of changing of certain words, etc. Is there a way in ASP.NET to take these basic forms, turn them into classes or templates, create forms from them, then add or overwrite code? ? (Anybody who is a Vis Fox Pro programmer would know imme...

Web forms and mobile web forms
Hey everyone, I am looking to develope a web site that depending on the device connecting to it, it will display a certain page. In this case im looking to create a web and wap version of the same project. I have the Web forms version finished using ASP.NET and C# and I am wondering how to create the mobile web form and incorporate it in the project. In the project folder, can I just add a mobile web??? But what about displaying device specific pages?? Cheers -Dudach Yes, you can add mobile web forms and controls to your Web Application project. No problem. For device/br...

For interrupting.web form Resized by position of the div : if div can't dispaly all (such as only top part , then web form heithten the heght),resize the web form
Web Form Resized by position of the div : if div can't dispaly all (such as only top part , then web form heithten the heght),resize the web form ! Because of my pool English, if you can't see , I will explain more ! ThanksGambler is the real life I guess you mean when form grows it also grow parent div element. This is normal. If you want div to stay fixed size and rather clip the form and maybe show a scrollbar, look at overflow property in CSS.Thanks------------------------------------------------------------This posting is provided "AS IS" with no warranties, and confers no ...

Web Form vs. Web Content Form
If you don't mind, I would like to know what is the difference between those two items, when I go to add a new item I see both of those and I don't know what the difference is.  A content form is for use with a masterpage. A web form is a standalone web page. If you select web content form, you will then have to specify a masterpage for it. and what is a master page used for?  Hi, a master page is used to give a constant look and theme to a site, without having to duplicate code. So basically you can put your header, menu, nav and footer on a master page. Then a...

Include web form inside web form
I tried to include an aspx file in a asp.net web form. However, all the web controls (textbox, button) in the included page are not displayed when called. <Form id="Form1" method="post" runat="server"> <%   Response.writeFile("subPage.aspx"); %> <asp:button id="btnPrev" runat="server" text="Previous"></asp:button> </Form> There are some <asp:textbox> controls in the subPage.aspx file, the file itself works fine, but when it is included in the main page, all the controls are not displayed. Please assist. Thanks   u should use iFrame instead...   <iFrame src="subPage.aspx" /> Hi, much more convenient way to have reusability in "page-like way" is to use user controls. Web Forms User Controlshttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconwebformsusercontrols.aspThanks,Teemu KeiskiFinland, EU...

Web Form embedded in another Web Form
Hi,  I have programmed a Web Form which acts like a scientific calculator. I would like to embedd this calculator in the upper left hand corner of another accounting Web Form. I don't want to host the calculator on the same server as the accounting page. I.e. I want them to have distinct URLs. Classically, I would do this using frames, but is there a better way using ASP? Is there some sort of Panel which can display the webpage at a specific URL which I can just drag onto my accounting Web Form? Thanks,  P1000   Frames are the only way to embed a webform inside ano...

How to fire events in other web form from other web form ?
Suppose that I have A and B web form. I want to trigger B web form's Page_Load event from A web form. How can I do that ? Thanks in advanced WilbertWilbert Bujn Create a public method in B that call the load method : public void Load(object sender, System.EventArgs e) { Page_Load(sender, e) ; } In the page_load of A, instanciate a B object and then call the function B myB = new B() ; myB.Load() ; Quicky Thank you quicky, it works fine. WilbertWilbert Bujn...

calling a web form from another web form
I would like to know what is the best way to open a web form from another web form. I would like to call it from a button control. Thanks Well, if I've grasped your question right, there are many methods to do that: 1)Response.Redirect > To navigate to another page from code and is equal to clicking a hyperlink. I suggest this as I think it's closer to your question. 2)Server.Transfer > This ends the current web form and begins a new web form. It's usable when you want to pass some variables i.e (Label1.Text) to the next immediate page. It's not safe though and not used to send p...

Web Form : Block the return button on the web form
Hello, I have a principal form with a list of information. From this form, I go on an edit forms and I want to control what is done on this form. For this, I want to block the button Windows back on my edit form. Somebody can help me ? Thank you for your help.  Jy. set the Session Variable (with your ID or whatever ) in the Principal Form when user click on Edit then put the One Back Button on your edit form and Redirect the page by using the Session variable value.Please Mark as Answred If This Blog has Helped You.RegardsMitesh Darjihttp://www.indianic.comhttp://www.mitatdotnet.blogspot.com You can avoid the windows tool bar.just make the edit page as a pop up window and you can set the parameters there .You can also disable the right click if you fear the user will right click and go back just add this code oncontextmenu="return false;"  to the body tag of the pop up window.or Did i get the problem right ???? Sumesh R"Don't hesitate to try , you may be wrong but still you could gain a lesson and that's what i call EXPERIENCE "Please remember to click “Mark as Answer” on the post that helps you Hello Thank you for you answer.   I have a question, on my edit button i wrote this code :Session.Add("UserID", gvUsers.DataKeys[gvUsers.SelectedIndex].Value.ToString());string sURL = string.Format("{0}", "./forms/fEditUsers.aspx"); Response.Redirect(sURL);  Now for the second part, I...

Strange output in web form after web form is displayed.
   I have been using a web user control for over a week now with no problems. I am now getting strange output in my web form after my controls display on the page. Below is the strange output. Can anyone tell me what is wrong here? Note I did not include it all because it is quite large.   Request Details Session Id: l5b5vkazucfatba4oliaw1vi Request Type: POST Time of Request: 9/10/2007 4:59:59 PM Status Code: 200 Request Encoding: Unicode (UTF-8) Response Encoding: Unicode (UTF-8) Trace Information Category Message From First(s) From Last(s) aspx.page Begin PreInit aspx.page End PreInit 3.68761951588819E-05 0.000037 aspx.page Begin Init 6.36952461835233E-05 0.000027 aspx.page End Init 8.91174716339647E-05 0.000025 aspx.page Begin InitComplete 0.000105879378524366 0.000017 aspx.page End InitComplete 0.000123479380759286 0.000018 aspx.page Begin LoadState 0.000139682557420007 0.000016 aspx.page End LoadState 0.0288617687443516 0.028722 aspx.page Begin ProcessPostData 0.0289100989092189 0.000048 aspx.page End ProcessPostData 0.0364705570121342 0.007560 aspx.page Begin PreLoad 0.0365082713026376 0.000038 aspx.page End PreLoad 0.0365431919419926 0.000035 aspx.page Begin Load 0.0365610713093424 0.000018 aspx.page End Load 0.0586415312560675 0.022080 aspx.page Begin ProcessPostData Second Try 0.0586867884046715 0.000045 aspx.p...

Accessing two web forms in a single web form
  Hi. I am developing a website in VS 2005 with Ajax & SQL Server. I am having 5 forms in my application. 1) Login Form 2) Main form 3) Form "A" 4) Form "B" I need to show the main form after the User login. I need to show all the contents of form A or form B (Ex: Form "A" user or form "B" user) in the Main Page. Can I show a single page having Main Form controls as well as Form "A" and Form "B" controls? I should access all the controls including Form A/B in the Main Page. Thanks ...

Passing Values from a Web Form to Another Web Form
Hello All! I am trying to pass values from one web form to another web form. I know that there are 3 ways of doing this: queryString, Server.Transfer and Session. I am using the Server.Transfer method. But I am not able to create, in my 2nd web form, an instance of my 1st web form. My 1st Web form is named CallTrack.aspx and my 2nd is named Export.aspx. What I mean is something like this: Public value as CallTrack. I can't create it in my 2nd web form because when the intellisense is displayed, there's no CallTrack in the options. Thanks!   How about using cross-...

How to access a control on a web form from anoter web form
hi all I have this scenarios i have two web forms, one called form1 and the other called form2 form1 has a label with id "lbl1" is it possible to access lbl1 from form2, change its text permenantly? thanks.   refer: http://dotnetslackers.com/Community/blogs/haissam/archive/2007/11/26/ways-to-pass-data-between-webforms.aspxSSNPlease remember to click "Mark as Answer" on the post that helps you. MinaSamy: hi all I have this scenarios i have two web forms, one called form1 and the other called form2 form1 has a label with id "lbl1" is it possible to access lbl1 from form2, change its text permenantly? thanks. Hi once you navigate from the page you can only access its properties if you you cant chnage it when you return back the value will again be new one unless you assign it So you can use session variables and set the session variable Session("lbl") = "Hello" Label1.Text = Session("lbl").ToString()   hence whenever you chnage value of Session variable it will be reflected in ur labelMAKMark as Answer if this reply helps youMVP ASP/ASP.NetASP.Net Hosting : Host DepotMy Site : ASPSnippets Thanks for you help but what I mean is there a method to add a control to form2 permenantly so even after i close the browser and re-open it the added control is still there . thanks. MinaSamy: Thanks for you help but what I mean is there a method to add a control to form2 permen...

can someone one give me difference between web form and mobile web form and which or where or when i'm using the forms?
thanks Marc Hi Marc, Based on my understanding, you want to know the differences between the ASP.NET web application and ASP.NET mobile web application. If I have misunderstood you, please feel free to let me know. The ASP.NET forms are used to develop the ASP.NET pages for desktop browsers and The ASP.NET mobile forms are used to develop the ASP.NET pages for mobile device browsers. When we create the ASP.NET mobile web forms pages, we can use nearly all the features of ASP.NET. But there are a couple of compatibility issues: Error Handling and Reporting. Tracing. Using Redi...

Comparison Web Form <-> Mobile Web Form
Hi all,Is there any overview of the (dis-)advantages using Mobile Web Forms compared with normal Web Form? I know I need to use Mobile Web Form if it should be accessible with handhelds, but does it make sense using Mobile web Form when the webpage should not be available for handhelds?Thanks!      The benefit on using the mobile web form is the ability to use the mobile controls that had adaptive rendering for different handsets. The built in features of controls like the objectlist and selectionlist are great and and form paging is also a neat thing.If you are not developing for portable hand held devices like pdas/mobile phones then don't even look into mobile web forms. Mobile web forms have a very limited set controls and unless you use device specific filtering (which gets ugly maintaining a code base and type safety) you cannot use ASP.NET controls and HTML, javascript etc.  ...

Submitting data from a know web form to unknown web form
hi i m making a software in which i will submitt some data from a web page that will go to a web form of which contrlos are unknown to me only i know the name and how many controls in that form it means i can see the form only. how can i do this please help me soon with code plz its very argent.i m doin this wit the help of foxtrot.xray.WebRobot but its giving me error that this dll file is already exists in The file ('C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\_foxtrot.xray.WebRobot.dll' already exists).i don know what will do so please help me soon please thanks praveen We ca...

Can my web page with a form submit to other web pages forms?
I was wondering if I created an aspx page that had a form on it that I could use the submit button to submit this form's contents to other web pages forms(servers accepting those form's data). I am thinking this would be a great way to update data on particular web pages without having to actually visit those similar web pages. Any ideas, examples would be much appreciated. Thanks in advance.  Yes you can.  It's called Cross Page Posting: http://msdn2.microsoft.com/en-us/library/ms178139.aspxAlso: http://msdn2.microsoft.com/en-us/library/ms178140.aspx might ...

Open web page in IE and populate fields on the form from my web form
To the dot net Knights.  Many humble thanks in advance from a dot net surf. We have an vb application that opens multiple instances of IE object, each to different web pages.  It then takes information from the current record in the app, populates fields on each of the web pages, and them submits the forms.  We are then able to look at the resulting web pages and quickly get the info we're looking for.This prevents us from having to manually navigate to each web site, enter the same information and then wait for the page to open.  If there is a captcha control, we only need to enter it and then manually hit submit. We are moving our systems to the web.  My question:  Is there a way to do this from a web form?The follow-up questions would be, where do I go to find out how to open multiple tabs in IE 7 to do the same thing?Thank you in advance,David C...

synchronizing chunk of data of one web form for another web form
I'm making a web application. In one web form; i'm taking inputs from user. Now; there is some info given by user in this page which is needed for web form which is going to be displayed next. i want to display that info automatically on that web form so that user doesn't have to re-input that info in this next web form. Info from first page would be inserted into database when user clicks on the submit button. then that next web form would be displayed. and the chunk of info from previous page should be displayed there!!! how can i do this?? cany anybody help?? nobody can help me!! I...

how to place a <form> in web form form
i placed a <form> in the web form, but i can't submit coz i neet to submit to another web site how can i do??? Mike Chan You cannot submit a <form> to another page if you have a RunAt="Server" in the form tag. Remove that RunAt="Server" and you can (though then you will need to use plain old HTML inside that form). What are you trying to do? Why do you need to post to another form?Starting with ASP.NET 2.0? Look at:Programming Microsoft Web Forms My Blog COZ I NEED TO POST SOME INFORMATION TO ANOTHER WEB SITE IS THERE ANY OTHER SOLUTION?M...

Need Windows Form to Retrieve Information From Web Form
I have a cash and carry web site that customers can order products, the next day come in to the company to pay and pickup. I would like to create a windows application for the company to do two things: 1. download all the orders from the day before 2. upload price changes, product changes, category changes I've search the internet and forums and the only thing I can find that I think would actually link these two together would be a web service. Can you please tell me if I am heading in the right direction or if there is another method to link the two applications, if there are any pitf...

Implementing .Net Form into an APS.net web form, can this be done
I am new here, but have been searching for a while, and may not have the correct lingo to find what I am looking for.  I am tasked with implementing a .exe application that was writen vb6 then converted to .net into a new website my team is developing. The idea is to put each of the 3 different forms in this .exe application of 3 different .aspx pages. I have attempted multiple things to get this into the page and even started to just rewrite it as an ASP.net web form, but even then I can't reuse any of the code since the System.Web.UI.Page doesn't inherit the sa...

windows forms in vb .net into web forms
we are creating a database driven website as part of our project. currently we have forms connecting to the database created in visual basic. these windows forms we need to convert into web forms which are asp .net compatible. can u give me an answer or show me a way. Hi, because of the difference in nature between web and win applications you'll need to reimplement at least the UI part. If you have a multitiered application in which the busines logic and data access are in different parts/assemblies you can reuse them. Grz, Kris.Read my blog. Handy Firefox plugins for web developers.Wor...

Data from a Web Service dataset into my web form
Hi all I'm using web services to retrieve certain data from my SQL Server DB. For the most part, I can use a basic dataset: <WebMethod()> _Public Function retrieveStuff(ByVal myCriteria As String) As DataSet     Dim dataSet As New DataSet("DataSet")     Dim adapter As New SqlDataAdapter     Dim connection As New SqlConnection(connectionString)     Dim command As New SqlCommand     Dim qryText As String = "SELECT [ID], [Status] [ FROM [Table= WHERE (([ColumnA]=&#...

Web resources about - WEB FORMS and datasetS (do I have to repeat the file definition in every web form?) - asp.net.web-forms

Dynamical system (definition) - Wikipedia, the free encyclopedia
This article presents the many ways to define a dynamical system. See the main article, dynamical system , for an overview of the topic. The ...

A case of definitions?
The Canberra Times report on bullying, harassment, and sexual misbehaviour by senior medical staff towards their juniors (&quot;Bullying rife ...

The real definition of risk for investors
... In last week's column , I discussed risk and volatility, making the very clear point, I hope, that prices moving around is the definition of ...

Verizon FiOS default speed now 50Mbps—double FCC’s broadband definition
Verizon dumps 25Mbps fiber plan despite complaining about broadband definition.

By Definition "The Establishment" Is Always A Force For Conservatism, Preserving The Status Quo
Increasingly loathed Democratic Party bosses like Schumer, Wasserman Schultz, Hoyer, Emanuel, Van Hollen, Israel can't understand why Bernie ...

James Clapper’s Twisted Definition Of An Insider Threat
Back when I reviewed the goodies the House Intelligence Committee had given James Clapper in this year’s Intelligence Authorization, I noted ...

Trump Adviser Outlines The Donald’s Immigration Plan: ‘It’s The Definition Of Compassion’
'Americans for the first time in their lives will wake up in a country where their immigration laws are enforced'

At CNN’s ‘Town Hall Meeting’ President Obama & Anderson Cooper Debate The Definition Of ‘Conspiracy’
Anderson Cooper sat opposite the President in an auditorium at George Mason University in Fairfax, VA filled with people who, Cooper promised, ...

Resources last updated: 2/29/2016 2:57:16 PM