Building Database App With Vb?

Sep 3, 2009

I am trying to write simple database application and try to understand ADO.net as well.say I have 2 table

1. table emp with the following field (empId, empName, empPhone, salary, deptId)

2. table dept with the following field (deptId, deptName, deptLocation, deptManager)

emp table is link to dept table via deptId.so I try to build a form with 2 data grids the top will be dept data grid and below it is emp data grid.I try to do this with out using the wizard so I know the flow and understand how to link together step by step.

in the form load section:

dim conn as new system.data.sqlclient.sqlconnection(connectionString)
dim daEmp as system.data.sqlclient.sqldataadapter
dim daDept as system.data.sqlclient.sqldataadapter

[code]....

I am kind of stuck on what to do next, I think the next step is to creat dataview from my understanding before mapping it to the datagrid, but on data grid documentation it say it can only filter datarow, it can't filter data column on the dataview.

I would like to be able to display deptName, deptLocation, no the whole column on the table to data grid, and when user select a record from dept datagrid then the employee info (empname, empphone, empsalary) is display on the second grid (again not the whole emp column table).

the user can update, add or delete emp record from employee data grid by clicing on update button, on update button callback routine I need to put something like.

daEmp.update()

from what my understanding then I need to create update, insert and delete routine and attach it to daEmp so the data grid know how to sync with sql server, so when the user say add new record since the data grid doesn't have all the field display, i.e deptId column is not on data grid, how the table know what the dept id would be? I'd like to learn without the wizard 1st since once I know how everything is link then it is easier to debug since the wizard create lots of file and it's everywhere which make it very hard to understand what is happening for someone new to vb & ado.

View 6 Replies


ADVERTISEMENT

Building A Program That's Linked To A Ms Access Database?

Dec 26, 2009

Im building a program that's linked to a ms access database. the function i use to update a row... In order to save a lot of typing i inserted a for loop that uses a directcast function. i did this because i have numerous text boxes that i name tb1, tb2, tb3, tb4...etc and they each correlate with row 1, row 2, row 3, row 4...etc in the database.[code].....

View 1 Replies

Building A Database Control Layer DLL For Project?

Jun 10, 2011

I'm building a database control layer DLL for my project.HelpDB is the project.HDB is the class name.I've written a few methods for connecting to the db, querying, and the usual.I've recently included a public class HDB_ParamValue in HDB to handle query parameters.

[Code]...

Note 1: I'm moving from VB6, so you'll appreciate that I have little experience with this real OOP. If there is a link or article you can recommend that might answer this, recommend away!Note 2: I'm not concerned about databases and parameters per se, but more the _concept_ of class in a class (or class of a class).

View 5 Replies

Asp.net - Building A WebService In ASP 4 - VB

Aug 31, 2011

I have a search engine that will use a webservice to search through my database to find 3 specific things. I don't even know if it will work like this, but I have a dropdown list on my main page to select Product, Feature, Description. From what the user selects, the webservice should then go to an if statement to use the correct SELECT statement and find results for the search.

Will someone help me figure out how to fix what I've written to make it work? Please don't be too critical, I don't have a lot of experience. I have also been researching SQL Injection because I have a lot of code that is vulnerable so keep that in mind when you look at my code.

I can't get the blue squiggly lines to go away that are underneath the DropdownList1.Value instances on the WebService page.

WebService:

<WebMethod()> _
Public Function GetCompletionList(ByVal prefixText As String, ByVal count As Integer) As String()
Dim Feature As String = DropDownList1.Value
Dim Description As String = DropDownList1.Value
Dim Product As String = DropDownList1.Value

[CODE]..........................

Default.aspx page - Here I need the dropdownlist to tie to the database somehow.

<asp:ScriptManager ID="ScriptManager1" runat="server">
<Services>

[CODE]........................

View 2 Replies

Building .exe With Program?

Dec 12, 2009

I was looking at making a program which can then build other seperate .exes, is this possible? For example the user types their mail username/password into my program then this builds a seperate one which just connects to their mail with their username/password.

View 2 Replies

Building A CRM Application?

Jun 21, 2010

I am doing a project on the CRM application which sending and receiving sms using the vb.net language. I am no where to conclusions of my project because I could not build the application. I have found many examples but the problem some of the examples some uses the sms gateway or the AT commands. I could not differentiate which one to use? I have a dateline to finish this project of mine.Most of the example does not look like a CRM application.

View 2 Replies

Building A Web Forum

Jun 16, 2009

I have a little bit of trouble figuring out why I am getting these error messages. Here is the error messages and then the code will follow behind it.The code is taken directly out of the book "ASP.NET 2.0 Everyday Applications for DUMMIES". [code]

View 6 Replies

Building An App Using VB 08 That Access The Web?

May 11, 2010

Wanting to know the best method to use if building a small app that will intereact with the web using usernames and passwords, captcha's etc.....

I'm thinking Window's Form but can you use captcha's in a windows form?

View 2 Replies

Building An Array?

Apr 28, 2011

relatively new at using Visual Basic, and I'm trying to make a decathlon calculator. My question is how do I make a blank array, and after each person is done calculating their decathlon score it adds the persons name, school,(which are both in text boxes) and score(which is calculated into a textbox) to the blank array

View 4 Replies

Building EXE's, CodeDom

Sep 21, 2009

Okay Is there a way In vb.net to create an exe from a predefined script, for example rather than writting the methods and subs into the codedom code could I just have a textbox that I could put a script into and then have that built? (obviously omitting button presses and things.)


Im not worrying about ui's at the moment just and exe (hello world style )

Are there any tutorials for this?


Code: None

View 2 Replies

Building F# Library?

Aug 21, 2011

Possible Duplicate:Building F# library to be used in C#

Let's say I have the following function.
let rec fib n =
match n with

[code].....

View 1 Replies

Building Webpages Is It Possible With Vb

Mar 26, 2011

building webpages is it possible with vb

View 2 Replies

Getting Error While Building

Oct 10, 2010

While I'm trying to build a solution after I've changed a little in its code it gave me an error and even when I've removed the code the same error appears.

"Unable to find manifest signing certificate in the certificate store." (That is the Error and it either stop building or run last successful build.)

View 2 Replies

VB - Building A GUI CAD Software ?

Aug 16, 2009

I'm interested in building a GUI CAD software in VB.NET, but I don't know from where to begin. I've looked in Audesks online help but there are no instructions, neither tutorials on the net for building something like this. When I'm saying GUI, I mean a work area, where you can use blocks from autocad and build a plan/circuit/PCB or other stuff like this.I'll be glad to see is this possible, and what kind of components can be used.

View 3 Replies

.net - Building A Project In VB2008?

Oct 15, 2011

I have a problem with building a project. When I build a project and when I create .exe file, I cannot run it on other computers.There is an error: "The application failed to initialize properly (0x0000135). Click OK to terminate the application.".ca i have any chance to solve this error without installing framework 3.5

View 2 Replies

Building A DNN Module Using Linq To SQL

Oct 26, 2009

I am building a module using linq to SQL and I am running into some problems. I have been following Michal Washington's tutorial on [URL]. The problem is that VB does not recognize my Complaint Class when I try to create new Complaint object. why I am unable to Dim a Complaint object? Here is my code:

[Code]...

View 2 Replies

Building A Project In VB2008?

Jul 20, 2009

I have a problem with building a project. When I build a project and when I create .exe file, I cannot run it on other computers. There is an error: "The application failed to initialize properly (0x0000135). Click OK to terminate the application.". When I install .NET framework on the computer, than there is no this error. Is there any chance to create a file that will run on the other computers without installing the .NET framework?

View 8 Replies

Building A Query In A VB Program?

Jan 4, 2011

I am working on a program. I created a database and used it to create a dataGridView in my program. I clicked the table adapter for the program and tried to create a new query. When I did this, I got the following error messages...Error message-the new command text returns data with schema different from schema of the main query check your query's command text if this is not desired Schema returned by the new query differs from the base query I cannot create a query for the database. What is a base query and what can I do to fix this?

View 7 Replies

Building An Array List?

Dec 13, 2011

I am successfully building an array list as shown below:

Dim obj1 As paperCutObj = New paperCutObj
obj1.Model = readLine(0)
obj1.IPaddress = readLine(1)

[code]....

View 5 Replies

Building An Autocomplete On Textbox?

May 14, 2010

I am building a autocomplete on my textbox. Really simple and it works really fine. But I like to do the next thing. When there is a match in the list and I will click on it. then i like to have a function.

For example

Private Sub ListItems_click(ByVal sender As Object, ByVal e As System.EventArgs)
MsgBox("test")
End Sub

How can i make this sub??

View 6 Replies

Building An Extender Provider?

Oct 30, 2011

I am trying to learn building an Extender Provider.I use VB 2008 express.I found an example in a book which adds an "ExtraTag" property to Labels and TextBoxes:

Imports System.ComponentModel
Imports System.Drawing
Imports System.Windows.Forms

[code]....

View 3 Replies

Building An Installer Of A VB App Using SqlServerCE

Jan 2, 2012

I have a VB app that uses a sqlServerCE database. Everything works quite fine on my computer.

When I try to install it on other computers I run into problems. The message "Unable to load the native components of SQL Server Compact corresponding to the ADO.net provider of version 8080"

I am testing on a Win XP virtual machine.

My first attempt was to use InstallShield LE to create the installer. I defined ServerCE as a prerequisite and when I check in add/remove programs it exists, but I still get the error.

Then I tried building the installer with the Microsoft installer. This adds the dll to the program directory automatically, but I still get the error.

I read the KB article referenced (874247) and recompiled the app as an x86 application only, and rebuilding the installer, but have the same problem.

View 4 Replies

Building For Windows7 64bit

Jan 7, 2011

I have an application that I built in VB.Net 2008 on Windows XP for Any CPU that I would like to run on Windows 7 64bit. Is this possible from Windows XP or do I need to compile and develope on Windows 7 64bit for it to work?

View 10 Replies

Building Menu Look Same Windows Xp

Feb 3, 2009

i saw menu in windows XP . i think it's beautiful and i want to build it vb.net 2005. How to do?

View 3 Replies

Building String From Listbox?

Feb 16, 2009

Does this code look correct to complete the task?'store all medications information as string value

While lstMeds.Items.Count > -1
For i = 0 To lstMeds.Items.Count - 1
strActiveMeds = strActiveMeds & lstMeds.SelectedItem & ", "
Next
End While

View 3 Replies

Building To Hard Drive?

May 18, 2010

I need to get my application to be installed on to the C: location in Visual Basic after ive published it.

View 7 Replies

C# - Application Framework Building

May 17, 2010

I was looking to build a Data Access Layer for my new web based application, I'm using ASP.NET. I'm want to build a framework not only for this application but also want to utilize it for my future projects.

Actually my main aim is to make a framework, from DAC, DAL, BL to GUI. I want suggestions from you guys that what should i adopt, what give me flexibility, which suits for both small and large size applications.

View 4 Replies

C# - Building A Local Cube?

Apr 29, 2009

I need to build a local .cub file for my Excel-using clients.

I have scrounged together some VB code but it fails :

ConnLocation = "LOCATION=C: est.cub;"
ConnDSN = "SOURCE_DSN=DSN=TEST;UID=test;PWD=pass;"
ConnCreateCube = _
"CREATECUBE=CREATE CUBE [TestCube] (" & _
"DIMENSION [account_code]);"

[Code]...

I have trimmed this down to the above code and am getting a mysterious OLE DB error: OLE DB or ODBC error." when I try to run it.

View 1 Replies

C# - Building A Roguelike In Silverlight (or WPF)?

Dec 10, 2009

I've been toying with the idea of building a web-based Roguelike game using Silverlight (or maybe just a desktop game using WPF).

If you don't know what a Roguelike is, it's a type of graphical RPG where the graphics are rendered using text. Because the graphics engine is relatively simple, you get to spend your time building features into the game and it's possible for one person to quickly build something fun.

For instance, a typical screen might look something like this (the @ is the player, # is a wall, the other characters are things like monsters, stairs, and items):

I'm an experienced ASP.Net dev and I'm just getting started with Silverlight. Is there a particular approach I should take for this? To provide some background, in Winforms, most standard approaches are too slow -- the text ends up updating with a visible, ugly blink. I'm thinking something to do with the Canvas might be appropriate, but even better would be to somehow draw a screen into a buffer and then instantly flip that onto the screen so that it becomes visible instantly.

But I don't really want to mess around with DirectX right now - I'm hoping WPF can get me to where I need to be without a big learning curve.

Update: So this turned out to be pretty challenging. I tried a lot of different approaches and I was finally able to get it to actually render fast enough, but I think that to make it blazing hot fast you should probably build a sprite map of the font you want to use and work from that instead of trying to use any of the built in font rendering stuff. I didn't do that.

When I got the core rendering engine done, I ended up with some annoying artifacts related to quirks of font rendering (even fixed width fonts are sometimes a liiitle bit wide...), and when I finally worked that out I discovered libtcod, which is a very impressive roguelike engine that has a C# wrapper. That's all console based. I played with it a little and I was blown away.

As of 1.5.1, everything I've touched in libtcod works great except for the mouse input stuff and one of the keyboard input modes (which I think they recently ditched), but everything you need to make a roguelike is in there, and that includes several line-of-sight, pathfinding, and even dungeon generation algorithms. It's pretty advanced visually. Have you ever seen an RL like this?

In a nutshell, it's possible to build a roguelike with silverlight, but I wouldn't go in expecting it to be easy unless you've already got a strong silverlight or game dev background. You're going to be re-inventing some serious wheels, and even with a powerful toolkit that allows to focus on gameplay, there's no shortage of things to do.

View 2 Replies

C# - Telerik RadComboBox Not Building?

May 20, 2011

I'm receiving a very peculiar Telerik error, I was wondering if any of you with Telerik experience had come across this one before.

I'm using a RadComboBox, when trying to build I get this error :

Method 'Protected Sub
ddlMyDropDown_SelectedIndexChanged(sender
As Object, e As

[code]....

It all runs as expected when I force run the project, but it won't build successfully or allow me to publish. The error message just doesn't make any logical sense.I've tried using System.EventArgs assuming that the Telerik event args derive from it. But still no success.

View 2 Replies







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