my project needs to store data online, and since i have no experience with databases ( aside from .txt base ones ) i wanted to know if it is possible ( and secure ) to save a database online and allow the program to write data to it and to read data of it. if this is possible could any body hint me in the right wa
View 6 RepliesWhat is the difference between a local database and a Service-based database? I read the MSDN and searched the Inet.
View 4 RepliesI have developed some software(vb.net) that records fees paid by the students. The purpose is that the database should be stored in a server, which can be accessed from any stations linked with it.This is working fine with a network of 10 computers. I need to publish it over the net so people could do this job logging in over internet. Database (access database) should be stored on a web based server.
View 1 RepliesRecently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 RepliesHow to make a lan based program using ms access is there a exact code do I have to put in my connection string or what are the configurations should I make in the computer.
View 5 RepliesWhat would be the most clean & efficient method to make a page based interface, such as an installer?
I've had a few ideas, I could make a class for each control i'm going to use that has a Page ID number, and compare that against a global current page number, except I want it to be reusable, so that would mean i'd have to make a class for every control.
I'm trying to make a menu based off of an asp.net sitemap. How do you nest the sitemap nodes so that they all appear on the same level. Here is what I have:
<siteMap xmlns="[URL]" >
<siteMapNode>
<siteMapNode url="~/Default.aspx" title="Home" description="link to Home" />
<siteMapNode url="~/about.aspx" title="About" description="abot" />
</siteMapNode></siteMap>
Here is what the code for the Menu control looks like:
<asp:Menu ID="Menu1" runat="server" BackColor="#E3EAEB"
DataSourceID="SiteMapDataSource1"
</asp:Menu>
They both appear as 2nd tier elements underneath an arrow.
Is there a way to make one list box dependent on the other based on user input. Here's my situation: A teacher has the ability to enter the name of the student into a listbox via a textbox. The teacher may then select the student from the first student list box and input grades that would go into a grade listbox. If the teacher selects another student from the student list box, the grade listbox would either go empty or show the grades inputed for the other student; all the while retaining all previously recorded grades for other students.
View 1 Replies[code]...
Yup,not PHP but it's the same for readability)As you may imagine I want to make a simple text based rpg game, but that's not an important fact.The buttons btn1 to btn3 are already created at the designer, and there are going to be other procedures which will assign values to their text property according to the game context (main menu, combat, shopping, training, etc.) you're at.Ok, so what I want to do with that procedure I pasted is to parse the text of ANY of those buttons when I click them, and according to its value select a case which will trigger another appropriate procedure (now there are only msgboxes as placeholders for testing only).My problem is that I dont know how to refer to the originating class of the handled event! I mean, let's say I click btn2. I'll want to immediately get the text property of that button only and use it as the value for the select case tree. I suppose I need to put something at that ?I wrote there, but I don't have any idea. The first time I was so naive to put me.text in there, and of course it returned the form name. Is there's something to do this thing...? I thought at first it would be a very simple task, but I'm going nuts searching for a solution so it's like if it was not possible, but I find hard to believe that, because this would be very useful, right? By the way, what I want to achieve is not needing to make a separate procedure for each button and to avoid as well the need to move any game option to another procedure if later on I want to rearrange the menus, because I expect the game to have more than three buttons actually.
I've decided to make an new archiver based on existing dlls. Im aiming at a simple 7zip style archiver thats quadcore optimized and 8 core compatible (the 8 core part can wait cause amd's bulldozer aint out yet). I'd like to include [code]Where do I start? And where can I get the dll's? (multiupload.com links are nice).
View 3 Repliesthere is a way to turn the following code into a sub so I don't have the same boilerplate show form code in use a thousand times in a program:
Example:
Public InstanceOfFrmGeneric As frmGeneric
If InstanceOfFrmGeneric Is Nothing Then
InstanceOfFrmGeneric = New frmGeneric()
[code]....
I have the following problem. I try to create a Database based on SQL. But i have problems to get the connection open! I have following code:[code...]
View 5 Repliesminiproject in vb.net based on database?
View 2 RepliesIn my grid I have data in two columns same for couple of rows. Then again couple of other rows will same with different data.I want make them into alternative sections with colors In below example(image).
Rows no 1 to 4 has 'High', 'High'. I want make them gray bgcolor for those rows.
Rows no 5 to 8 has 'High','Low'. I want make them white bgcolor for those rows
Rows no 9 to 12 has 'High','Medium'. I want make them again gray bg color for
those rows.
How to make a combobox only list based on user's input via autocomplete?For example, if user input "A" the combobox only lists all names start letter "A".If user input "AM" the combobox only lists all names start first two letter as "AM" and so on.
View 6 RepliesI often think of classes and modules as "global" variables or variables you can use any where in your solution/project. can you make global timers? I basicly want to make a farming like game but the plants will grow based on a timer. So if the player closes that form the timer needs to still tick. So can I make global timers so the timer would not have to start over if the form is closed and reopened?
View 4 RepliesI am trying to make a turn-based board game that will be run on multiple computers. I am writing the game logic and design in VB. I searched for a little and could not find the information I was looking for. One question I have is, will I need a server if there will only be 2 players. Also, what language should I use to write the server side code.
View 1 RepliesI have a grid view which uses SQL to calculate information that I need! I want to put this calculated total into another table in database.
SELECT StaffDetails.StaffID, SUM(HolidayRequests.RequestTotalDays) AS Expr1
FROM HolidayRequests INNER JOIN StaffDetails ON HolidayRequests.Username = StaffDetails.UserName
[Code]....
It basically calculates the total number of approved holiday requests for a staff member which is correct. I want this number to then update the HolidayTaken field in another table each time a holiday is approved.
I have tried an update however you cannot use an aggregate in an update as I have found.
i have a datagridview which has a datasource of a SQL database. In this database i have a column which has a boolean value, and in my form, it is used to specify whether a checkbox is ticked or not. What i need my program to do is color the cells of the datagridview based on if the checkbox is ticked or not for the particular rows which have it ticked in the database. Here is what i have, but it doesnt work:
Code:
Dim count As Integer = 0
While DataGridView1.CurrentCell.RowIndex <= DataGridView1.RowCount
If CellIDCheckBox1.Checked Then
[code]....
what im trying to do here is loop through the datagridview and see if the checkbox is ticked or not and coloring it based on that.i have also been messing around with some LINQ code, but that doesnt seem to work either..
I am working on a database application for my Class Reunion in VB.et and VS 2008, My problem is when i build the program it will only work with 1 Database For my Class year, I would like the ability to be able to create a new database for a different classyear than the 1 i build and pre-Populate, so the person using it can do more than 1 year and keep the databases seperate.
View 3 RepliesI have decided I would start small and make a program that would create a "receipt" list in a listbox and a total. Now, I would like the user to be able to add their own "menu" items. I'm assuming the best way to go about this would be to have them actually add it to a database and then a function in the program will refresh the dataset with the new list. However, this is where my problem lies. How can I tell VB .net 2010 that I want to create a new button (or buttons) on the fly, in an orderly pattern on the form, based on the input from a DB?
View 10 Replieshow to display the user name based on successful login id i have one database table name: UserMark in the table:
UserId
UserLogin
Password
Fullname
SurveyId
i have login.aspx page which required me to enter login id and password, if sql success, it will redirect the page to home.aspx however, at the home. aspx page required to display the full name based on login id.i place the code on login button
Private Sub btnLogin_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnLogin.Click
strSQL = "SELECT LoginID FROM UserMark WHERE LoginID='" & oCommon.FixSingleQuotes(txtEmail.Text) & "' AND Pwd='" & oCommon.FixSingleQuotes(txtPassword.Text) & "'"
[code]....
I'm developing a program working with database. Id like to use the Service base database but it gives me an error when I try to add it in my project Project > Add new Item > Service-based database
I wanted to use this database so I could make a table in it.
Error:
Connections to SQL Server Files (*.mdf) requires SQL Server Express 2005 to function properly. Pls verify of the component or download from the URL
go.microsoft.com/fwlink/?LinkId=49251
But when i go to that site its just the vs express websites.
Im using VS2008 Pro. I also installed other files like SQLEXPRADV_x64_ENU
Am I missing something that i need to install?
I already have "SQL Server Management Studio" listed in All Programs> Microsoft SQL Server 2008
Even the SQL Server Compact 3.5 is already installed
How will I know if I properly installed the required components or application?
I want to limit the number of students (60) that will be enrolled in one section and prompt a message that it surpass the limit. I inserted it in my combobox1
Here's my code :
strsql = "select * from Schedulings where Sections = '" & ComboBox1.Text & "'"
Dim acscmd As New OleDb.OleDbCommand
acscmd.CommandText = strsql
acscmd.Connection = asconn
acsdr = acscmd.ExecuteReader()
It doesn't work. How should I do it?
i have a problem trying to query my database based on a value in a label. Here is the code for the query,
[Code]...
With the code attacehd I would like to print the resulting queires on a winform, wich is happening now but only at the form load time.What I'm looking for is a way to have these databounds updated automaticaly everytime date changes on the database or timely every xxsecs or manually via a refresh buttom.
Public Class Form1
Public Function MyTime() As String
' Changes Today's Date into the DD-MM-YY format
[code].....
I am trying to make a simple program to display a shipping charge based upon a selected zip code. Where can I find sample code that I can use as a guide? I can create the GUI but can't figure our the code.
View 2 RepliesWell this is a re-post now as nobody replied in the gaming section, and i believe this question could go as a normal VB question, therefore I'm asking in this category instead.I have decided to pick up on programming and want to make a text based RPG Game i will "upgrade" as my programming knowledge grows.I got some ideas that i think i should use, but i want you guys' opinions on it.I assume I'll use different classes for each monster, which will have properties.Should those monsters then be inside a list of all possible monsters, or would i have a monster class which i would use and generate the enemies when needed? And would i use the same approach on items and character stats?
View 4 Repliesi have a datagridview which has a datasource of a SQL database. In this database i have a column which has a boolean value, and in my form, it is used to specify whether a checkbox is ticked or not.
What i need my program to do is color the cells of the datagridview based on if the checkbox is ticked or not for the particular rows which have it ticked in the database. Here is what i have, but it doesnt work:
Code:
Dim count As Integer = 0
While DataGridView1.CurrentCell.RowIndex <= DataGridView1.RowCount
If CellIDCheckBox1.Checked Then
[Code].....
Recently, I've changed my job to a biological company, they have huge data but managed by Excel, only by Excel. For example, they have hundreds of orders every month, but they just simply record them by Excel. No database concept is used in this company. Excel to manage this is nightmare, only one person can write the file, others can only read the file by ReadOnly. And these data is very easy to be mistakenly modified.
So, since I come to the above Excel-managed company about one month ago, I cannot stop myself thinking apply database.But I have no programming background at all, only used VB6.0 to create some tiny program in High School. Now I started to think whether I can use VB2010 to do this.First of all, I turn this problem to Access, and I learned a lot database design theory from getting to know Access. However, I finally find out that Access can hardly freely create Form like VB (maybe I didn't find out how)
Anyway, I started to study VB2010, to add DataSet to my Form1, and use DataGridView to display data, and to use TableAdapter to modify data. However, it is quite hard to learn, without any systematic books. For example, I am confused about TableAdapter and TableManger, and I don't know how to simply display a modified DataTable by DataGridView control. And SQL search language is new to me as well.
So, I'm wondering if anyone could recommend me any books based on what I would like to learn? Or any tips and reviews?