Search results for query: *

why not just do a + 1 then

Dim AuthCheck As New MySql.Data.MySqlClient.MySqlConnection(Conn) Dim AuthGo As New MySql.Data.MySqlClient.MySqlCommand("Auth", AuthCheck) AuthGo.CommandType = Data.CommandType.Text AuthGo.CommandText = "Select notes from access " Dim AuthGoAdapter As New...

Here is a sample of what I used for login. On top of that each page uses the user name to check a db table to see if the user has access to that page and if something goes to the page directly it checks if the cookie is empty and if so it redirects to login page. Protected Sub...

I think one of the important things to learn is how to interact with a SQL server as it gives you more power for working with data.

why are you using a += 1 why not just a = 1 I would do: Dim a As String a = 1

I need help I cant get this to display parent child rows. Dim CallsGo As New MySql.Data.MySqlClient.MySqlCommand("Calls", AuthCheck) CallsGo.CommandType = Data.CommandType.Text CallsGo.CommandText = "Select * from calls" Dim NotesGo As New MySql.Data.MySqlClient.MySqlCommand("Notes"...

Sorry I figued out a way to do it.

Anyone know how to get a sql result into a string? Such as: "Select admin From access Where (usrs = "me")" admin has either the value y or f which needs to be evaluated in an IF statement. To determine if the user has access to the page.

Oh sorry guys I had already figured it out

http://www.tek-tips.com/viewthread.cfm?qid=1166514&page=1 Not sure that will help but that is a small discussion on it I believe.

Not sure that you can read it. I think it maybe just a "Notes" for managing the tables.

I have a datagrid that is set for multiline in the properties bar. But when is query the sql and get the data back it comes back all smashed together instead of in multiple lines and when I view the data in the sql server it is in multiline form.

Thank you I got it to work.

Why not just do this Select columnA as Items, columnB as Prices, columnC as Descriptions From table columnA, columnB,columC would be the names that you are currently using and Items,Prices,Descriptions would be the names you wish to use. Hope that helps...

AddItemGo.CommandText = "Insert INTO `book` (`recipe`,`ingredients`,`whos`,`instructions`,`type`)" + "VALUES"+""(rName.Text.ToString(), Ingred.Text.ToString(), wName.Text.ToString(), Instruct.Text.ToString(), TypeBox.SelectedItem.ToString(), "Dawn")""" For some reason I get an error, expected...

Same Result Tried that but still get same result.

Im have a problem with a datagrid. when i run the sql statement to populate it, it gets the header field and displays it but it doesnt populate any other data. When I run the same statement on the sql server i get results. Private Sub GetR_Click(ByVal sender As System.Object, ByVal e As...

Wish it was that easy I wish it was that easy I get the database from the State of Hawaii has 650,000 records all of them are Jones, Jim M. style or Jones, Jamie style. I'm trying to get it extracted out into a better format so I can insert it into a better table scheme

SELECT VoterName, SUBSTRING(VoterName, 1, CHARINDEX(',', VoterName) - 1) AS LName, LTRIM(SUBSTRING(VoterName, CHARINDEX(',', VoterName) + 1, CHARINDEX(' ', LTRIM(SUBSTRING(VoterName, CHARINDEX(',', VoterName) + 1, LEN(VoterName)))))) AS FName...

Crystal Reports It depends on what you need to do with the reports and if there are variables involved. If you dont need to use variables you can use the Crystal Report Viewer from the toolbox then tell it to use new report. It should open the Crystal Reports Designer and go from there.