DB/Reporting :: Wizards Vs Hand Code
Apr 20, 2010
I have been a programmer for almost 14 years and have worked in SQL, VB, VBA and MS Access. I am making the transition to VB 2008 and as you can imagine, it is frustrating. One of the new things to be in VB2008 is working with data. They have made it easy to setup datasets and output data to a form. In VB6, I never used the GUI data tools, I always custom programmed recordsets and wrote loops to output the data. Then, I wrote my own code to update, insert or delete the data. With VB 2008 I dont have to do this anymore, but is it a better practice to hand code than rely on wizards.
I also noticed I don�t have as much control over the data with using the wizards, for example. There is 1 insert statement defined for a table adapter. Lets say I wanted to perform a slightly different insert based on a condition. I can�t do that anymore right?
View 1 Replies
ADVERTISEMENT
Jan 9, 2007
i was just wondering if I create wizards for my program? like to accept input from user then process them and stuff.
View 6 Replies
Dec 31, 2010
I want to ask if its better to make datasets with wizards or programatically. Im studing with a teacher that works programatically ... but its a lot of coding. so, retrieving data is faster when you write code or is the same using wizards on datasources?? when you use datasource wizard , it open and close conections automatically?
View 4 Replies
Nov 8, 2009
I have written this code implemeting MVC design pattern.... for simplcity... i have create Model with BLL having a two classes Employee and Designation and i have created the DAL using the Dataset designer tool....thus i've implemted all relationship bewteen the two tables Empoyee and Designation connected to each toher using field EmpIndex.
In MVC design pattern i should return objects to the controller (in this case i used only the view- win form) becuase of my Designer created DAL i cannot return objects of Employee and Designation to the View... this is becuase in BLL: the following method
Code: public TestMVCWithDataset.TestDataSet.tblEmployeesDataTable SearchByIndex(int iEmpIndex) { try { empAdapter.Fill(dtEmployees, iEmpIndex); return dtEmployees; } catch { throw new Exception("Employee not found!"); } }
[code]....
View 1 Replies
Apr 9, 2010
Coming form too many years of VB6 I have a natural inclination to write my own data access code, etc. rather than using database wizard, etc. Same goes for using simple databinding to recordset rather than managing object collections and tying those to controls
I am finally moving to VB.NET and find myself on a solo project without any team on which to lean, so I have a couple related questions as I try to get my head around the transition. The project is basically a line of business app with a SQL Server back end.
1. Are the data designers/wizards so good now that rolling your own is no longer worth while?
2. Is the data-binding now fast, flexible, and reliable?
3. Can you recommend a good book or robust on-line tutorial that covers this sort of programming? 2008 or 2010 preferred.
View 1 Replies
Oct 6, 2010
I've decided to build wizard style library to handle many wizards and make it more simple to work with. The difficulty is that next step window changes depending on user selection on current form with a lot of controls in each of them. After long time thinking I think best would be to recreate similar to TabControl and TabPage controls and instead tabs would be a in-built command Next, Previous and Finish buttons as default in TabPage control. I've tried something to create similar but with no success yet.
[Code]...
View 7 Replies
Sep 24, 2010
How do Microsoft make the controls for win forms, for example a grid ?
View 6 Replies
Jul 1, 2008
I'm trying to write code to create a new database and then create tables within the database.
I'm running into a strange problem right now, which is the fact that I was able to create a new database ok on either the regular SQL Server instance, or the SQLEXPRESS instance. However, when I attempted to create a table, I got an error message saying that there is already a table of the same name.
When I tried to connect to the new database via SQL Server Management Studio, I could see the database. However, there are no tables in it! So, theoretically, I'm creating a brand new blank DB, so there should not be anything in this DB, right? and I should be able to create any tables I want in it!
Here is the code that I have so far:
[code...]
I just have one simple form with a button on it. The click event on this button calls the CreateAllDBs() routine.
View 6 Replies
Feb 19, 2008
I have an open database (dataset) with two tables. It is binded to toolboxes, but I have one field, what I have to calculate about other parameters. I have binding navigator, and I can set field values from controls (eg. toolbox). I can step my rows, with binding navigator. I can update my database. But how can I set field value from code?
I want a code line:
database.fields("fieldname") = something - or something like this
View 8 Replies
Apr 25, 2012
I tried "PictureBox1.Cursor = Cursors.Hand" but that isn't what I'm wanting... I want the hand that "grabs" when you click. You can find it in picture editors and such. The "Cursors.Hand" just points.I'm sorry if I misspelled something or my grammar is wrong, I've never done well in those subjects.
View 5 Replies
Dec 21, 2011
We have made a service in vb2010, how can we detect that the service is stopped by hand?
We know the �Protected Overrides Sub OnStop()
View 3 Replies
Aug 11, 2011
I need to draw free hand on a form i know how i can change the colors buts its just the drawing part. i also need it to save and load how would i do this ive been searching but nothing.
View 10 Replies
Apr 18, 2012
was wondering if you could give me a hand and point me in right direction with the project i am creating. It is a toolkit They are 2 problems that i am having wondering if anybody knew the issues
1. The textbox is not having them 1 by 1 for example
service pack 2
service pack 3
2. The other problem is a bit more tricky, I have software on the hard-drive c:directorysp2
it has to be implemented into the toolkit anybody have any ideas how without a database if possible. I thought this could be done in the load form, pre-loads the software and then checks when comes to installing the software in the list.
[Code]...
View 2 Replies
Apr 14, 2012
I'm trying to print out some arrays of data, arranged in columns, but am having a few problems:
1) I don't think that I'm calculating the x coordinate correctly for each column
2) The text won't right hand justify
Sometimes, I get the code fairly close to working, and then make what I think is the final change, but it seems to make other things worse. I'm a hobbyist,just learning VB for my own use, so I know that my code won't bring tears of joy to a professional..[code]
View 8 Replies
Apr 8, 2009
We are working on a poker game as a class project. My part is to evaluate and then determine the value of a players hand. We are evaluating from highest to lowest (ie. determining whether the player has a straight flush, 4 of a kind, full house, flush and then going all the way down to a high card only "worthless hand"). My part is evaluating the 2 pair, 1 pair, and nothing hands. The hand will be a two-dimensional array with the row(0 thru 12),column (0) containing the numeric "face" value of the cards and the column(1) containing the value assigned to the suite (1=clubs, 2=diamonds,3=hearts,4=spades). I have NO IDEA where to even begin this evaluating procedure.
View 4 Replies
Jul 28, 2008
I have a datagrid in my project. The data connection is binded to it by the Tools -> Connect to a database feature in vb.net and it's working great. Since I have to use it for 2 countries how do I change the SQL in the connection and refresh the datagrid with the new data.
[Code]...
View 2 Replies
Aug 30, 2009
What is the best way to launch reporting services reports from .Net code? One method would be to dynamically build a URL and launch a browser. Something like this:
http://server/ReportServer/Pages/ReportViewer.aspx?%2fReport+Directory%2fReport%20Name&FirstParameter=1,2,3&SecondParameter=8/30/2009&rs%3aCommand=Render
[code].....
View 3 Replies
Mar 13, 2009
Is there a method to swap the left and right hand sides of a set of expressions in Visual Studio? I have a decent sized set of data that needs to be stored in an active record. In order to pre-populate the form fields on the page, I have already written the following [Code]
Is there some sort of the method (built-in functionality, macro, etc.) that I could use to swap each side of the expression such that the data is saved into the active record as opposed to read from it in order to perform a database insert? For example, after highlighting the above code and running the macro, it would become:[Code]
Since the number of columns in the database that this active record encapsulates is rather large, it seems like most of this typing could be avoided with a simple automated process. Obviously this wouldn't work 100% because sometimes there would have to be type conversions (e.g. int to string) but for the most part I think this would save a lot of time.
View 2 Replies
Feb 28, 2011
I am trying to get some data in DataGrid from XML files. I am reading that XML data and putting that data in DataView and giving that DataView as DataSource to DataGrid.As i have a schema for my XML, i dont even give HeaderName as system automatically takes HeaderText as whatever is in XML Tags. Now my problem is Pagination alignment, i have pagination on my DataGrid but even setting
<PagerStyle HorizontalAlign="Right" Mode="NumericPages"/>
doesn't bring pagination to extreme right of datagrid, rather it brings pagination on right of first column of datagrid(my datagrid has 9 columns) see attached pic
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'Bind data to Grid
BindGrid()
[code]...
View 2 Replies
Jan 2, 2009
I have a small problem, I have written a small application to update a database table. Now on my computer I have a copy of the database but using MSDE 2000 and when I run my application it works perfectly, however I also have a copy of the database attached to MS SQL 2005 on another computer. Now when I got an run my application on this machine, it fails with a "Time out" error. I have changed the timeout settings on the SQL Server however it then just sits there for ages, whereas when I run it on my development machine MSDE 2000 it loops through the code quickly.
[Code]...
View 2 Replies
Aug 1, 2011
I've been working with VB6, 2003, 2005 and 2010 and I've always hardcoded my database passwords. Recently we ran into a problem where we would like to change all our db passwords for audit purposes. The problem is passwords for different dbs have been hardcoded in all our programs. How can I create programs going forward without hard coding the passwords in? I think I should be using a config file of some sort, but not sure how or where to start.
View 1 Replies
Jul 5, 2008
I'm looking for some simple code that lets me create a Microsoft Access table via code.Currently all I do in Access is write and retrieve data from specific tables but now I want to be able to create them at runtime. Here is an example of the code I use to load some data just so you can get a feel of what I'm currently doing. Hopefully there is an easy way using the same rough way that I'm currently dealing with databases.
Code:
Public Sub LoadCareer()
Public rs As New ADO
[code]....
View 2 Replies
Jun 14, 2009
I want to add cross button image on the right hand side of tabPage.I m creating tabpages at Runtime.Mine code is added image to the left...I want to add it to the right....I m also adding text to the tabPage.& second Probs is dat..On button click suppose i add the first tab Page,Image is aded to the first Tab Page...When i click on button to create the second Tab,Image & text of First Tab Page is clear & so on.
[Code]...
View 1 Replies
Nov 20, 2009
Analog Clock Second Hand , X1 X2 Y1 Y2 Twips, and Pixels, Movement
View 2 Replies
Dec 21, 2010
Well I got the line to move from the top, in a kinda of a circle, clockwise.
[Code]...
View 3 Replies
Apr 8, 2010
I'm writing an vb.net application so that the user can type text to be added to a website. I'm using a richtextbox and I've added the facility to hyperlink selected text. This all works, but when the mouse cursor moves over a hyperlink it changes to a hand; how do I stop it doing that? It's confusing for the user as it looks like clicking the link will do something and it makes it awkward to correct spelling within the text of the hyperlink.
View 3 Replies
Mar 22, 2010
1) How do I force a form to open in a certain position on the monitor? ie. by default it starts in the top left corner of the screen. I want it to open in the bottom right corner. Also, is there a way to do this as a % rather than in pixels? As I want it to be in the correct position regardless of the resolution being used.
2) Can you remove the "x" close button on the top right hand corner of a form? If you can't, is there a way to disable it?
View 8 Replies
Jul 10, 2010
I have made a smtp client in c# and I use this code to split a string that contains multiple recipients.
foreach (var n in txtSendTo.Text.Split(';'))
{
mail.To.Add(n);
[code].....
View 3 Replies
Mar 20, 2012
I am trying my hand at making a simple poker hand analyzer in VB 2010 for a distance education intro to VB course at my school.My goal is to represent the cards in a table array. Rows are suits Clubs/Diamonds/Hearts/Spades and columns are values (A, 1, 2... K). However I have no clue how to design a Sub procedure that will recognize the hand the user inputs and add any possible results to a listbox (fourkind/threekind/pair/flush/straight/ace high straight). I don't understand how exactly I'm supposed to do this. My criteria isn't very strict. I can have a hand with more than one description, like a fullhouse + threekind + pair can all be used to describe one hand.
What I think I need to do is split the entered string to get 5 strings (each is a card). Then somehow find these in the table? I have no idea how to do this and I'm stumped... The instructions loosely call to look for a boolean value where cards(i,j) is set to 1 of the player is dealt card j in suit i. But I do not know how to achieve this.
As you can see my understanding on VB is extremely... basic (no pun intended). It's my first time ever learning a computer language, and I really regret taking this course via distance ed because the instructor and the TA absolutely refuse to communicate with the students. I am trying my best to practically self-teach with the thick text book.
View 9 Replies
Jun 8, 2012
Let assume below will be my richtextbox. This is what I have so far:
[U]Title name 1[/U]
Some text. Some more text.
[U]Title name 2[/U]
Some text. Some more text.
What I am willing to do now is: Only when you mouse over on underlined text - mouse cursor changes to 'Hand' Then you can click on it and message box appears with underlined text. How do I do these two things?
View 1 Replies
