the only way i could get a VB.Net program to insert a timestamp into a mysql db was using Now() in the VB and putting the column as Var Char in the Mysql DB. Have i royally screwed myself or can i still pull this back in PHP and manipulate the data, ie select * from test where date between...etc.How does mysql interpret a var char column in terms of dates/times?
View 1 RepliesI have the following code running but it only inserts the first char of each param value into the table.For example: first name is john, only j is inserted.
Dim ColParameter(15) As SqlParameter
Dim dal As DAL.SqlDAL = New DAL.SqlDAL
Dim procname As String = "pr_cust_create"
[code]....
I want to be able to retreive the row id of the insert entry
my current insert script is
Dim command As New MySqlCommand("INSERT INTO users(name) VALUES (?name)", myconnection)
I have following codes
str2 = "select sno,name from employees where sno =" & Val(Me.TextBox1.Text)
cmd2 = New SqlClient.SqlCommand(str2, con)
da2 = New SqlClient.SqlDataAdapter(cmd2)
[Code]....
Now dt2 has two columns as sno and name But I want to add a 3rd column city type char(80)
I am using VB.net (FormView and ObjectDataSource) and Sql Server 2005.
I want to get last inserted @@identity in table on FormView1_ItemInserted
Protected Sub FormView1_ItemInserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertedEventArgs) Handles FormView1.ItemInserted
End Sub My issue is that I want to redirect my FormView to readonly mode after FormView1_ItemInserted but for that I need to show the inserted record in readonly mode and that is only possible if I get my last inserted @@identity.
i want to read a character 1 by 1 from a string and a .txt, i know all about stream reader so for the .txt would it be somthing like:textbox1.text = tr.readCharacter.i would prefer to be able to read from a textbox or String array though.
View 10 RepliesI need validation for string to comply with next: no space char starts with one delimiter char ends with one delimiter char has no other char as delimiter char. Updated sorry missed that should only be one delimiter char at start and at the end
View 2 RepliesPublic Shared Function UrlTokenDecode(ByVal input As String) As Byte()
If (input Is Nothing) Then
Throw New ArgumentNullException("input")[code].....
So I have a text box in a form. The test box needs to take the value entered and insert it into a column within a row in MySQL. I know it's connecting to the MySQL online, I have a message box telling me so upon a successful connection. I'm just having problems adding the value. Here's my code: Public Class frmOptions Dim ServerString As String = "server=db4free.net; Port =3306; user id=dailylogmain; password=XXXXXXX; database=dailylogmain;" Dim SQLConnection As MySqlConnection = New MySqlConnection
Private Sub frmOptions_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
If sqlquery = "Select admin FROM userlist = True" Then
Form2.Show()
Else
Form1.Show()
End If
My login script works its checking if admin from userlist = true is what i can't seem to get working.
I have a working login script. It connects to my database but i need to have it search the column status to see if the user loging in is either admin user or mod. and so far i can't get anything to work.Here is my code i have for it checking the column
Code:If sqlquery = "Select * FROM userlist WHERE status = 'admin'" Then Form2.Show() Else Form1.Show() End If
[code]....
I have just learned MySQL in VB.NET, but I am having a complication..When I grab a SELECT Query, I want to get - lets say the 'username' column in each row it receives. How would I do that?
MySQL.CommandText = "SELECT * FROM online"
MySQL.ExecuteNonQuery()
Label1.Text = 'usernamehere'
myCommand.CommandText = "SELECT 'USED' FROM `KEYS` WHERE `KEYS`.`KEY` = '" + TextBox1.Text + "'"
Dim myReader As MySqlDataReader
myReader = myCommand.ExecuteReader
While (myReader.Read())
MessageBox.Show(myReader.GetString(0))
End While
The returning string is "USED". But that is wrong: it should be returning integer 0 instead. Why is that? I changed the MessageBox line to MessageBox.Show(myReader.GetInt16(0)) but now it sends me an error telling me that the input string is not in the right format..
I learned about this query 2 days ago:-
SELECT SUM(DTotal) AS Monthly FROM bdailytotal
but how I'm going to view the total value of the summation? I had been searching for this but most of the answers I get is for PHP. Can someone show me how to assign that total value to a variable in VB.NET?
Or teach me how to assign that total value to another table.
I am trying to set up a query to return data to a VB.Net datagrid. I want to rollup the results into a new column kinda like below:[code]I tried using "group_concat" but for some reason it rolled up the entire list on teams into a column regardless of match_no.[code]
View 2 Repliesi am trying to increment a char in vb.net, eg: Dim letter As Char = "a"c. and i want to make it b, and so on. how can i do this?
View 1 RepliesI have mysql database with one table , and I want to show the columns' names re;taed to the table in combobox in vb 2005
this is my mysql command :
SQL1 = " select column_name from information_schema.columns where table_name='others'; "
this is my code after execute the command and store the data set in variable ( DS ) which its type is "DataSet " :
If DS.Tables(0).Columns.Count > 0 Then
For j As Integer = 0 To DS.Tables(0).Rows.Count - 1
list1.Items.Add(DS.Tables(0).Rows(0).ToString)
Next (j)
End If
I have a datagridview with 4 columns (id, name, ticket_number, destination), i just want that datagridview on column "ticket_number" to display ticket_number from mysql database and another 3 columns for user input.
View 3 Repliesi have a mysql database with columns like this : id||username||password||profile and i want to get all the data saved under the ID column and place them into a richbox
View 2 RepliesI'm using VB.net to write a MYSQL application and one feature I need to add is the ability to add a column for each week that my employees worked. For example I want the first column to be called "W1" and the next one to be "W2" and so on, right up to "W52". How would I add a column to my table and have it's name add 1 to its current value? If there wasn't any letters in the name it would be easy but I need it to have the "W" in the title as well to avoid confusion. to add the column I have this:
Alter Table Manager ADD W1 MediumINT;
I just need the part that adds an INTEGER to a VARCHAR datatype if possible... Maybe there should be some sort of data type conversion involved? Just to explain further, the black bar at the very top are the date stamps for each week, I would like to have this included in the datagridview if possible but it is not required. Under each week column the employees will be entering the percents they worked (example: 20%, or 0.20 is one day of work) I know this is an odd way of doing things but its mandatory... and i was wondering if it were possible to automate the creation of these columns rather than me having to manually enter them.
I have written some code so i can connect to a Mysql db. But how can i get like an array of the columnnames?
View 2 RepliesI am doing database coding for the first time. I wanted to get connected to MYSQL database with "Root" as username, "Password" as password , "DBNAME" as database name, "Local Host" as host and Append the contents of a textbox control to MYSQL column. So can anybody please post code bit in VB.Net for doing this task.
View 17 RepliesI'm developing in MVC2 using VB.NET and MySQL and ran into a problem trying to convert a simple SQL query to LINQ. SQL Query:
[Code]...
Looking at that query its easy to spot whats causing the error. Simply, the most inner query only returns 2 columns, while the query right above it is trying to SELECT 3, thus the Unknown Column Error. So why is this happening? What is wrong with my LINQ query?
I am getting this error in MySQL on search for keywords. The error: Can't find FULLTEXT index matching the column list. My Database Table is a MyISAM and my dataTypes I am searching are Text. Any Ideas why I would get the above error?
View 6 RepliesI have this MySQL Query glitch in my VB.NET program. Here is the query in VB.NET:
"SELECT Points FROM user WHERE Username = '" & UsernameText.Text & "';"
It will select the points column from the user table from the Username they entered. When I deploy this it will set the value for points to 0 on their account. I'm not even inserting anything in.
I have split a string into a char array, now i need to copy the char array to an int array with the ASCII values of each char.Donīt know how to do it without looping each value.
This is my code:
origen = RichTextBox1.Text.ToString
Dim valor As Char() = origen.ToCharArray
Dim numeros As Integer() = (How can i convert "valor" to an int array?????)
i have found [char] specified in some of the examples at msdn , what is the difference between char and [char]
View 2 RepliesI have determined thanks to the last q & a that there is something wrong with my "save to db" code as well as my "retrieve to picture" code. Even If I manually save the pic in the db it stil wont retreive. This is code i patched together from 3 or 4 examples around the net.
Dim filename As String = txtName.Text + ".jpg"
Dim FileSize As UInt32
Dim ImageStream As System.IO.MemoryStream[code]......
MySQL databases exists for saving values as strings (text only). Is there any way that i could store files with the same speed as a mysql command ? I know that it depends on the file size but lets say that the file is "Avatar.jpg" 50KB... I ve tried FTP but this is not what im looking for. e.g. You want your users been able to upload a file like the [Add This Attachment] button does in dreamincode.net and you dont have any background on PHP/HTML/Javascript/ASP.NET just VB.NET and the basics of MySQL plus you dont want to use it for a website. How do you accomplish this? Something silly that ive tried was opening an image as text then update the mysql server with that text but it didnt work backwards after i wrote the text on the file and oppened it ...it said that the image was corrupted.
View 7 RepliesWhat i have going on, is i have a MySQL connector as a resource on my application, and im basically trying to connect to my MySQL server, to either a) register a new account, or b) check that the account exists and they are premium, and login, Now what i have run into problems with is: My MySQL Database Name has a _ in it which VB is not allowing for some strange reason.
The code i am using is below
Imports MySql.Data.MySqlClient
Public Class Form1
Function UpdateRecord(ByVal query As String) As Integer
[CODE]...
How i can allow the _ into the application, because the only databases that don't have a _ in the user or dbname are a) Paid ones which i DO NOT have the money for or self hosted ones, i cannot leave my computer on 24/7