Private Sub AutoNumberNo()
Dim myReader As SqlDataReader
conn = GetConnect()
conn.Open()
Dim temp As String
Try
Dim sql As String = "SELECT MAX(NO) 'IDNumber' FROM Invoice "
Dim comm As SqlCommand = New SqlCommand(sql, conn)
myReader = comm.ExecuteReader
If myReader.HasRows Then
While myReader.Read()
temp = myReader.Item("IDNumber") + 1
End While
End If
myReader.Close()
Catch ex As Exception
End Try
conn.Close()
textboxId.Text = String.Concat(temp) ' result will appear in textboxID txtId
End Sub
You could make use of a file server to store the movies and then create a table within your database with the movie title and links(directory path to the movie on the file server) so when a user searches by movie name, it hits your database, retrieves the associated link with the searched name and then provides the user with the movie located in the directory(link).
Bill Gates got DOS from IBM so cheaply because IBM didn't know what to do with it and didn't really want it. So yea, you buy something at a huge price that hasn't been developed yet. That's not stealing -- its just good business.
Not just business but Good Business. Bill gates is just one smart person the Tech industry needed and he brought a lot of competition into the industry thus leading to advancement in tech by different companies so as to attract more users and earn higher profits year after year.
I have coded in VB, C#, C++, Java, HTML, SQL, and some PHP
HTML is not considered a programming language but i must say you've made a commendable progress. i actually started programming in 2008 and I've focused intensively on VB.NET though with understanding of C# but no project executed i it yet. Recently, am trying to move to something platform independent so am reading up on java.
What is the difference between MySQL and MS SQL? I think they do the same thing but I'm not sure of their differences.
MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My.The SQL phrase stands for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.
MS-SQL is also an RDBMS but owned by Microsoft and that's the reason for the prefix, MS. They basically do same things but may vary in syntax and acceptable wildcards in their SQL.
Is it possible to have a script automatically input people's information into the Google's address book?
Not sure but i think Google provides some contact API that work with apps where that may provide such services. You can check here for more info
2. Would using an SQL database useful / make my job easier? It's okay if it doesn't go into the address book. Just something that will hold people's information and the data is easy to retrieve.
Yes you can. But it would also help if you can design a front-end application to interface with users and prevent unauthorized entry into …
you're not to copy all the codes under the search button. The codes under the Form1_load should be placed under your own form load event and those under the button1_click even t should be under your search button. It works well for me without errors
Your RAM seems to be enough for the O/S. I suggest you run a thorough system scan and you could also run a Disk Cleanup to help remove temporary data and other junks like cookies and dump files.
you may have to get a strong antivirus and do some real scan of your computer. if i may ask,what;s your RAM size and what operating system is your machine running on?
okay now. I got it to work, it was an omission on my part, did not change the 'Copy to output Directory' property of the html doc to 'Copy if newer'.
To add to Unhnd Exception's post, > you need to add the following references from the .NET library: windows base presentation core presentation framework > Correction to one of cwarn23's points: its the 'Copy to Directory' property of the html doc that should be changed to 'Copy if Newer' and not the 'Build Action' property
Every other thing works just perfectly. Thanks Unhnd Exception
Added the three references from the .NET library as requested in the error message and i had a successful run but the form is blank. Cant see any map but i noticed the 'Delete markers' in the left-bottom corner
Add a new html doc to the project and name it GoogleMap.htm and set its Build action to CopyIfNewer
Am sure you meant, 'Copy to output Directory' property of the html doc. Another thing, am done with setting up the project and codes as directed by you but when i run, it gives the following error:
Error: Project file must include the .NET Framework assembly 'WindowsBase, PresentationCore, PresentationFramework' in the reference list. WindowsApplication1
WIth this, does it mean i have to reference any of the .NET libraries. I really want to try this out so i need help here
'declare connectionstring to server
'assuming your table name where users are stored is called 'Users'
'and the column name to verify a user is called 'username'
Dim SelectStmt As String = "SELECT * FROM users WHERE UserName ='" + userNameTextBox.Text + "' and " + _
"Password ='" + passwordTextBox.Text + "'"
Dim dc As SqlCommand = New SqlCommand(SelectStmt, con) 'assming your connectionstring is called 'con'
Dim reader As SqlDataReader = objcommand.ExecuteReader
If reader.Read Then
'enter codes on what the system should do if the user exists
Else
MessageBox.Show("Invalid Username or Password!", "Login Error", _
MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning)
End if
Imports System.Data.OleDb
Public Class Form1 Inherits System.Windows.Forms.Form
Dim cn As OleDbConnection
Dim cmd As OleDbCommand
Dim dr As OleDbDataReader
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As_
System.EventArgs) Handles Button1.Click
Try
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;_
Data Source=C:\emp.mdb;")
'provider to be used when working with access database
cn.Open() 'open connection
cmd = New OleDbCommand("select * from table1 where columnname = '"+ textbox1.text + "'", cn)
dr = cmd.ExecuteReader
While dr.Read()
' loading data into datagrid
End While
Catch ex as exception
End Try
dr.Close()
cn.Close()
End Sub
End Class
You can still load your questions from a database and make changes to them anytime. Am not saying XML is not good but using VB and a database still works well and this way, your files are safe. Think about what happens if you use a text document and that document is mistakenly deleted.;)
I also have IE9, firefox, and chrome installed but i use firefox as default. I just love the joy of different browsers on my system for testing purposes when developing :)
'decare connections to server here and commands
Dim dc As SqlCommand = New SqlCommand
With dc
.Connection = con 'con is assumed to be your declared connection string
.CommandText = "INSERT INTO tablename" & _
"(column1, column2)" & _
"VALUES ( @value1, @value2)"
.Parameters.AddWithValue("@value1", TextBox1.Text)
.Parameters.AddWithValue("@Value2", TextBox2.Text)
End With
con.Open()
Try
objcommand.ExecuteNonQuery()
Catch sqlexceptionerr As SqlException
MessageBox.Show(sqlexceptionerr.Message)
End Try
I have the same temp table declared more than once
I would advise you try using another name but i would also like to ask if its a local or global temporary table. The reason for this is: Local temporary tables are only available to the current connection to the database for the current user and are dropped when the connection is closed. So if its local, you definitely can't create another temp table with the same name. It would definitely tell you that there is already an object with the same name as long as that connection is still open.
'str', and 'i' are declared variables which can hold any values in accordance with their declared datatypes
Private Sub Form_Load() str = Text1.Text i = 0 End Sub
This code was written under the Form_load event so it means that: the variable, 'str' should be assigned the value of whatever is in text1(which is a textbox on your form) and the varable, 'i' is assigned the integer value of zero (0)
Private Sub Timer1_Timer() Timer1.Interval = 100 i = i + 1 Text1.Text = Left(str, i) If i = Len(str) Then i = 1 Timer1.Interval = 100 End If End Sub
This was to control how the timer control on your form should work and i would explain each line. line 1....it has assigned the interval for the timer to hundred(The value is specified in milliseconds (1000 milliseconds = 1 second). line 2.... The varaible 'i' with intial value zero incrememnts by one line 3....this tells the compiler to begin from the first letter from the left of the value of the variable, 'str'. You need to remember here that the value of variable, 'str' is same as value of the textbox known as text1. line 4......means that if the variable, 'i' which incrememnts by one equals to the number of characters in the textbox called text1 then the timer interval should …
Why don't you rather do it this way. Use the series as an ID for tracking products then have another column(maybe named 'Number_of_Times_Ordered') and for each time the product is ordered or purchased, the value in the column is incremented by one. This would help prevent unforeseen issues. Like for instance, you want to make a search on a particular product, you must have to know the number of times the product has been ordered before you can get the exact ID(string) you want to search for and this would in turn result to a manual process and a total system failure in achieving the purpose for which it was built. So in my own opinion, just use the series as ID's to track products then have a counter for each purchase of a product.
Am happy you said your knowledge and not the generally accepted one.
Google provides relevant information for your search.I think 90 percent of internet users use Google as the best browser.
Talking about Google for relevant information, did you mean Google search engine or Google chrome? am kind of confused here. Because Google search engine providing relevant information does not guaranty that 90% of internet users would use Google chrome(Would that be a compensation?)
The datagrid gets its result set from the database so maybe you may want to try searching the database table and if the result is found, you point to the record on the datagrid.
