I'm writing a program for Employees Management and i need to automatically generate a Payroll for each one then calculate some things and save it to another table.
I know how to calculate and save. I just need to get all the ID column of all rows in my Employees table, and select each Employee ID one by one in order to calculate each payroll automatically.
I'm using the following select statement to pull rows of data and display them in a datagrid.[code]This displays sometimes 5,000 different rows of data with one of the columns being time. Their times are something along the lines of 6:08, 6:09, etc. Is there a way I can show only 1 row for all times between 6-6:59?[code]
View 1 RepliesI have the following controls:
[Code]....
I have a table on a MYSQL database called "messages" and a column called "message". When i type something into textbox1 and click button1 i want to add a row to "messages" under the column "message" with the title and message as its value.(separated by a hyphen, dash, or other small delimiter)Then reload listbox1's contents to show the new message. so i want the final message to be something like:
[Code]....
I am almost there but for some reason I don't find the answer to my issue. Here it goes. In my application I have a form which displays a data grid view with some info I get through XML from a web server. The data grid view have as first column a Check Box colum. The second column have the information I get into a variable (from cells), one by one, to pass it to the sub with the XML command.
What I want to do is to be able to select all the rows and send the cell info of the second row (only for the selected rows) to my sub which will execute once then send the second cell info and execute the sub and so on until all the loop is complete. Currently my code works only if I delete one row at a time (sending the XML code will delete the info in the web server and update the datagridview which in return will remove the item).
[Code]...
How to use Select Case in reading rows in a table in mySQL? by not using the username of the user.
View 1 RepliesIm trying to fumble my way through selecting data from a mysql table and populating it to a combo box. I feel Im almost there, could someone look over my code and see whats going wrong?
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
Dim con As New MySqlConnection
[Code].....
For a project i am working on, i am taking bookings. These bookings are stored in a database alongside a users personal details. The personal details are assigned an ID according to the user who booked it. A user can book more than once with different personal details.
My problem is that i want a user to be able to edit a booking. I want a list of all the names that user booked to be listed in a combo box. This is the part i am having trouble with. i am using an access database and using sql statements to pull out the data. This is what i have tried so far:
SELECT [First Name]
FROM PersonalDetails
GROUP BY [First Name], UserID
HAVING (UserID = ?)
If i execute this query in the query editor, it works and shows the two records currently assigned the input id. However, if i try to output this to, for example, a text box, then it remains blank. I am assuming thisis because there is more than one output, but i'm not sure.
I would like to select a number of rows from a table and out of those I need away of selecting a column from the last row?
View 8 Repliesi have a problem to retreive whole rows of a datagridview and transfer to my new access database in vb environment anyone can give me advice or examples of how to do it ? for example my datagridview colums have JOB_NO, ERR_DESC , REMARK
now i would to post all row (not selected datagridrow) from this datagridview to my new database .. i search at google using row count may do the job but i still fail on ...
I 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 am using vb.net with phpMyAdmin MySql database. While running the piece of code below, the program hangs in the for loop before the variables are assigned values from the data table(dt)...
'Check for appraisal period-----------------------------------------------------------------------
Dim sqlCheckDate As String = "SELECT * FROM tblappraisalsetting where appSetID=(select max(appSetID) from tblappraisalsetting);"
[CODE]................
I'm working on a project and my boss insists I use a DataGrid for this. The grid holds information for work orders, one of the cols has a check box in it. I need the user to be able to select any number of those checkboxes/rows and then return a value to the table "stamping" that users ID. This is what I have so far to get the grids populated... I'm using 2005 with a 2000 Access Database if that helps. Though this will be changed to SQL Server once we get it working (yay more work)...
[code]...
I removed the code from the second grid to make it easier to read, obviously once I can get one to work the second shouldn't be as much trouble.
This is the check box: dgvNewBiz.Columns(1).HeaderText = "Select"At this point if someone knows how to get it to recognize the click event of the check box and pass that row info to a variable that would be super as I'm sure I could probably figure it out from there.
I have Dataset ds filled up with values Until now I was displaying values in GridView. Now I want that all the rows should be columns and columns should be rows.I have 2 options: Either 1 I can directly convert grid to columns and display it, or 2 I can convert the GridView to html and then write loops to convert. I was trying the 2nd option but I cant figure out how I should do that.[code]With this code I am still getting same as GridView. Please help me for converting rows to columns and vice versa.
View 1 Replieswhen populating a data grid i keep getting a redundant row in the bottom. is there a way to lock grid rows to the number of rows in the data table?
View 1 RepliesI have a query that I have to run that requires me to get rows from a table based on the value of a field in another table (which I have gotten earlier). I currently have it done like this (simplified).
[Code]...
My problem is with the tickets table, I have listed the user that created the ticket, the tech who will solve the ticket and a user that over sees the ticket. All three users reference the users table. So how do I can I query the tickets table and get all three users that reference the same table storing the users?
Table1: Tickets
1) Ticketnumber
2) EnteredBy User 100
3) Issue
[code]....
What I can do now is something like this:
Select Ticketnumber, EnteredBy, Issue, UserName FROM Tickets INNER JOIN Users
ON Tickets.EnteredBy = Users.UserID
How can I update local dataset with mysql database without making duplicates. Assuming I set some column in mysql as primary key, which has unique string.
adapter.fill will just add duplicates, but adapter.clear before that is not an option.
So I want to update if the key column is the same with mysql data and if there is option for ignore adding new row.
I have a fair bit of experience with VB.NET and C# (In this case I chose VB.NET, blame my laziness), but I do most of my professional work using PHP. I have no experience what so ever in using any database with VB.NET let alone MySQL.Just FYI, at the moment I am only trying to Query the database to gather the information required to activate. The Activation wizard and algorithm building (which is finished anyway), and everything else will come soon. I chose the MySQL database because I have experience with it, and it seems the best option for remote usage.The whole idea already works in PHP, I'm just have major issues moving it accross into VB.NET (Using the MySQL Connector.NET);I understand the basics, and all I need to know how to do is Count Rows and gain access to the other information in a row based on provoided information (in PHP, through mysql_ result)
So, here goes nothing, this is the Query code I am using in PHP to complete the job I want to do in VB.NET. [code] As you can see, I basically need to get the PHP code into VB.NET to fit into the 'btnQueryDB.Click' Command in VB.NET. By Equivalent, the Product ID in VB.NET will come from 'txtPID' and similar, Serial Number will come from txtSNUM. Once counted to be 1, the Activation Code and Status will be fed into 2 other text boxes in the form. (acCode, and acStatus).
I am using MS-SQL and I am trying to write a query which fetches rows from the master table and related rows from the detail table. Now, the thing I want is that it must only fetch the first row from the master table and related field from the detail tables should be blank in that first row, now if there are related rows found in the detail tables, they must be shown in the separate rows. I have been trying using the following query but it is not giving the desired result.
[Code]...
Currently, my program code is:
Imports System
Imports System.Data.SqlClient
Imports MySql.Data
Imports MySql.Data.MySqlClient
Public Class Form1
[Code]...
How do I get it where when I click button2, it will count the number of rows in the mysql table and then display it in a messagebox or label1.text?
I have two tables Employees and CafeLogs. Some employees can be cashiers and also customers at the Cafe shop.
Table structures:
Employees: EmployeeId(PK) , FirstName, LastName
CafeLogs: LogId (PK), CashierId, EmployeeId, Value, => CashierId and EmployeeId are the data from column EmployeeId of Empoyee table
Table relationship:
Employees 1:N CafeLogs (CashierId (FK))
[code]....
Right now I know how to select only LogId, Employee's name, and , Value, not with Cashier name yet.
Dim query = From log In db.CafeLogs _
Join emp In db.Employees On emp.EmployeeId Equals log.EmployeeId _
Select log.LogId, emp.FirsName, emp.LastName, log.Value
[code]...Find last rows each machine_id in mysql database with program?
View 1 Replieshow can i add rows in datagrid using for loop in compact edition.[code]
View 4 RepliesI have a dataview grid where I am loading data from a sproc. I now need to loop through all of the rows and make changes to some of the cells that are binded through the datasource
View 5 RepliesIDE : VS 2008,Platform : .NET 3.5,Here is my DataTable columns :ID Note DetailI want to write sth like this :
View 8 RepliesI'm trying to set the same value for all rows for a single column in a datatable without using for loop. Any faster methods to achieve the same.
View 2 RepliesIt is possible to check two different MySQL tables from the same sub?
For instance:
Dim Connection As MySqlConnection
Connection = New MySqlConnection
Connection.ConnectionString = "server=server; user id=userid; password=password; database=database"
Try
Connection.Open()
[Code]...
What I'm trying to get is something like an "or" function. If TextBox1.Text isn't in the database, then check if TextBox2.Text or TextBox3.Text is in the database.
I've got a table in an SQL server that often has large amounts of data imported into it via an automated process - the problem is that a lot of the data that gets imported is a duplicate of data that is already in there (for example if we have a customer in there called Mr Customer Ltd, a duplicate with a slightly different name could get imported, like Mr.Customer Ltd).
So I am using the Fuzzy Logic class that Wild Bill put in the CodeBank to find names that are similar and then highlight these items. The thing is that the target table that the imported data ends up in has several thousand rows and the table that contains the data to be imported often contains several thousand rows as well, so I'm trying to decide how to do this. Obviously reading both tables into memory is not an option as it will consume too much memory on the client PC that is running this app. So this is what I am doing at the moment:
1. Read the table that contains data to be imported into a DataTable in memory
2. Open a connection to the target table and use the SQLDataReader to start to loop through it
3. In this loop, for each row that the data reader reads I then loop through the entire set of rows in the DataTable and run this fuzzy logic method that compares the account name from the current row in the datatable loop to the account name in the row that the datareader is currently on.(there is also a Thread.Sleep(1) after each row is processed to prevent the process from eating up 100% of the CPU while it runs)
I have this code:
[Code]....
now in my DataTable called "tablaLOGICA" i have 180.000 records as strings and later on in my program i have added 90.000 more strings in this DataTable. QUESTION..'which is the quickest way to update my "real" table in MySql? 'At the moment i make 90.000 INSERT whithin a loop, but it is so slow, it take more than half an hour !!!! is there any other way to do this INSERTs?
I have been looking for some syntax online to help me do this, but i cannot seem to find anything. I am trying to move some rows from a table in an access database to another on a click event handler.
One of the tables names is "Basket", and the other is order.So far i have this.
[Code]...