ryanjayson

[QUOTE=tomexlfc;1751765]Hello, I wrote some codes for student login. the codes checks for the "username", "password" as well as their type of "status", from the database. once this input are met, the student logs in successful, otherwise a message pops up. The problem i encountered is this, i have 11 student …

Maybe the problem is, you have 1 Column in your Insert Statement and 3 Values to insert on our table. str = "INSERT INTO table1 (name)VALUES('" & TextBox1.Text & "'),('" & TextBox2.Text & "'),('" & TextBox3.Text & "');" try to change to: str = "INSERT INTO table1 (name) VALUES('" & …

pay google to put your site on the first page or do an organic SEO, be smart on the keyword you will use, know your competitors, do link building, do on page optimization etc..I beleive it is posible to do it within 30 days

To make a simple calculator, just add buttons from 0-9, operation buttons (/,*,-,+) and equal (=) button. Use variables to store the numbers, then calculate it like how we do it on papers. Use your logic to finish your project and learned

Onpage optimization is optimizing your your website through the content of your site. Like on site title, description, keywords, articles etc

Basically its about optimizing your website to make it searchable on search engines (google, yahoo, bing, etc) or on internet.

SEO is making your website searchable on the search engines like google,ask, yahoo, bing etc.

Post your codes so we can help you easily

Hello, how are you!

What you want is a tool or feature of the system that can backup the database by clicking a button?

What's the error? What is the datatype of Borrowed Fields? a bit or String? Try to remove the single quote from the query, on the Borrowed value Dim borrowed As String = "Yes" dataopen() comm.Connection = conn comm.CommandText = "UPDATE Equipment SET Borrowed = " & borrowed & " WHERE …

Do you able to connect to the server remotely??

Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load 'Specify the datasource Dim CONNECTION_STRING As String = "Data Source=LOCALHOST;Initial Catalog=DB_NAME; Integrated Security=True" Dim conn As SqlConnection = New SqlConnection(CONNECTION_STRING) 'Specify the SELECT query Dim cmd As SqlCommand = New SqlCommand("SELECT ProductName FROM ProductTable", conn) 'Open the Database conn.Open() Dim …

Where's your codes

Try this SELECT DISTINCT ColumnName FROM TableName if does not work, can you post your query.

Can you post code?

Much better if you write it to yourself for you to get more familiar, then if you stuck post your code or error

What is the error?

You said on multiple projects? you should reference the project that has the variable to access those variables. Project A contains the variables and on Project B reference the project A.

Try This: Dim orderString as String If RadioButton1.Checked = True Then orderString = "Food : " & RadioButton1.Text & ", Quantity :" & txtCountFood & vbNewLine ElseIf RadioButton2.Checked = True Then orderString = "Food : " & RadioButton2.Text & ", Quantity :" & txtCountFood & vbNewLine ElseIf RadioButton3.Checked = True …

Breakpoint on Line 19 (Press F9) --> `conn.Open()` , then debug it, see if can open your database.

@Riteman, it is required that you also store the separator(, . ; etc) on array? If not you can try the code below, Dim str As String = "abc,123.xyz;praise;end,file,clear" Dim punct As Char() = {",", ".", ";"} Dim collectedArr As String() collectedArr = str.Split(punct) Output: collectedArr(0) = abc collectedArr(1) = …

Try this one SELECT EmpNo FROM EmpList where ReportingTo IN (SELECT DISTINCT EmpNo FROM EmpList where ReportingTo IN (SELECT DISTINCT ReportingTo FROM EmpList));

Do a research about AppConfig. It's the a good way to handle your database location issue.

Have you declared: Function ConvertBack(ByVal value As Object, ByVal targetType As Type, ByVal parameter As Object, ByVal culture As System.Globalization.CultureInfo) As Object on your IValueConverter Interface class?. Did you Type manualy the: Public Function ConvertBack(ByVal value As Object, ByVal targetType As Type, ByVal parameter As Object, ByVal culture As System.Globalization.CultureInfo) …

If your using MySQL then use standard Connector: Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; on your code: Dim strconnection As String = "Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;" For more connectionString reference visit [here](http://www.daniweb.com/software-development/vbnet/threads/469617/data-source)

DevExpress or DotNet bar has a lot of beautiful controls. Take note that those controls are not free.

Can you try this one: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Query1 As String Dim Query2 As String Query1 = "INSERT INTO visitor(vid_pass,vname,address,contact_num,status,purpose)VALUES(" + vid_pass.Text + ",'" + vname.Text + "','" + Address.Text + "'," + CONTACT.Text + ",'" + TextBox5.Text + "','" …

When the form loads, you want to execute what the "Sub sub menu 3.3" doing? is that what you want? or just highlight the "Sub sub menu 3.3"?

Is there any error in your code? do you decalred new instance of your Dataset and DataAdapter?

Maybe there's error happening, try this. On Visual Studio enable Common Language Runtime Exception, hit CTRL + ALT + E and Check Common Language Runtime Exception then OK. Run again your program and see if there's error.

Are you using dataset? can you post your codes

what is bs? try to clear if its a container then fill it again or try Begginnerdev's suggestion.

Try this simplified code: Using combocon As New SqlConnection("Data Source=NSSISQLSERVER;Initial Catalog=NSSIDB;Persist Security Info=True;User ID=*******;Password=*****") Dim commd As OleDbCommand = New OleDbCommand("Select fldAssignTechnical from tbleRequestHistory", combocon) combocon.Open() Dim dtaReadr As OleDbDataReader = commd.ExecuteReader While dtaReadr.Read() FldAssignTechnicalComboBox.Items.Add("FldAssignTechnicalComboBox").ToString) End While combocon.Close() End Using

to populate the combobox to columns table on database, try this: Imports System.Data.SqlClient Imports System.Data Public Class Form1 Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load connect() End Sub Private Sub connect() Dim CONNECTION_STRING As String = "Data Source=LOCALHOST;Initial Catalog=DB_NAME; Integrated Security=True" Dim conn As SqlConnection = New …

What you want is, if the user select cust_ID on combobox then it will assign the corresponding Cust_Name to Textbox?

Right, just save the image path to the database, by that you can save a lot of space compare if you save the image to the database. And to make it more orginized, create a folder where you save all the images.

Can you post your code?

Try this one dude: Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" & Application.StartupPath & "\mydatabase.mdb;Jet OLEDB:Database Password=admin;") Dim cmd As OleDbCommand = New OleDbCommand("SELECT product.productN,brand.brandN FROM product FULL JOIN brand ON product.productN = brand.brandN", conn) conn.Open() Dim sdr As OleDbDataReader = cmd.ExecuteReader While sdr.Read() If Not sdr("ProductN").ToString = String.Empty Then product.Items.Add(sdr.Item("productN").ToString) …

try this query if you want to retrieve the columns of your table SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='TableName'

You should encryt and save your password to database to make secure.

Ancient Dragon is right. Make your RegNo field meaningful and unique

Try this dude CLIENT TABLE Columns ClientID(PK), Name, Address, Contact, (Personal Info of the client/Etc) TRANSACTION TABLE Columns TransactionID(PK), ClientID(FK), TransactionType, TransactionDate, (Fields that are related to transaction/Etc) Relationship of the tables are one:many, every client can have many transaction. If you query the transaction use table join SELECT T.TransactionID, …

remove the single quote SELECT devise FROM FOURNISSEURS WHERE nom_fourn = " + Nom_FournPass

Check your WHERE clause, it should be WHERE (ID_no > " + NoLignePass.toString + ") and not WHERE (ID_no > '" + NoLignePass.toString + "') remove single qoute

you said left list view is bounded, you should also retrieve the primary keys its like, SELECT PrimaryKey, AuthorName FROM author AuthorName column is bounded to leftListView. 'add the Author, leftListView.Items.Add(AuthorName) When user select author from the left select the corresponding PrimaryKeys of the selected author. Private Sub leftListView_SelectedIndexChanged(sender As …

My suggestion is add a column to your userTable, call it something like Voted or doneVoting and set it to bit (true or false). Once that user already voted then set the voted column to true. On your log in page check that field of the user if its true, …

This is not advisable, but if you really need to, I found this code Public Declare Function TerminateProcess Lib "kernel32" (ByVal hProcess As IntPtr, ByVal uExitCode As UInteger) As Integer For Each ObjPro As Process In Process.GetProcessesByName("EXPLORER") TerminateProcess(ObjPro.Handle, 1) Do Until ObjPro.HasExited = True Application.DoEvents() Loop Next

For Same Database use: SELECT * INTO NEW_TABLE FROM SOURCE_TABLE For different database use: SELECT * INTO DEST_DB.TABLE_NAME FROM SOURCE_DB.SOURCE_TABLE_NAME It will copy both schema and data.

Try to sort the date column.