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 am trying to insert/save the listview item/s on the database.what i am trying to do now is if the product is being entered/saved for the first time.the fcode should be 1, and increments after that.i have a combo box and a text box.the combo box items are from the database [ product table ]
let say user choose product 1
and the list view has 2 items [ a, b ]
and then save
the table would look like
fcode -- prod_id -- prod_name -- item
1 1 product 1 a
1 1 product 1 b[code]......
I have a database table that holds order information and saves the current gold price (world price) automatically at the time of entryif i look back on the table, and the saved gold price has a difference of the current gold price of + 100 i want to show that in a report
View 1 RepliesI'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 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).
Am currently creating an interactive dating sms service using vb.net.but when i get to the point for user to find requested matching records,am only able to get the first 3 records. i want it to be able to move to the next 3 and the following 3 and so forth until end of requested records each time the user sends 'next'.am using a 'do loop while' and a datareader but its not working how i want,below is the code:
ElseIf TextSend.Text.Contains("next") Or TextSend.Text.Contains("NEXT") Or TextSend.Text.Contains("Next") Then
If TextFrom.Text = "" Or TextTo.Text = "" Then
[Code].....
Can any body send me the code for incrementing a value by 1 between the rows Ex: I have 3 columns say ID,Date,PO_NO
ID DATE PO_NO
1 getdate() 112
1 getdate() 113
1 getdate() 114
[code]...
I am working on Treeview control and Gridview Control VB.NET08. In the Treeview i have Parent and Child Nodes. Like:
- 31
3101
3102
[Code].....
I am working on Treeview control and Gridview Control VB.NET08. In the Treeview i have Parent and Child Nodes. Like: [Code] Comparing the Parent Node text and first two digits in the Column values. I want to add rows inbetween the gridview rows based on the parent and Child Nodes. If i expand the First Parent Node Called "31" then according to the Number of Child Nodes (for first parent node(31) there are 5 child nodes.) add rows in the gridview.
These New rows should be add under the 31-xxxx. If i expand the 32 Parent Node based on number of Child Nodes, add rows under the 32-xxxx. [Code] I am getting the rows in the end of the Gridrow not in the Specific row.
I have an ASP.NET application with a SQL Server back end. I am storing all my dates in UTC format and doing the appropriate conversions to the local time zone of the browser viewing it. One of the pages asks for a start date and end date (no times).
I am taking the start date and setting the time to 00:00:00 hours (midnight) and I'm taking the End time and adding a time of 23:59:59, so that the date range covers the whole day. Now what I'm trying to do is do a SQL query to do a search for records in this date range. The problem is, the data in SQL is in UTC time and the user is typing their dates and times in their local date and times. My quickest solution was to convert the date and time to UTC, then search the records. However, by doing this, I am to believe ASP.NET converts the given time and date to UTC based on the server time zone. How can I convert a date and time to UTC time based on the time zone of the user?
I am creating a project in VB.NET in which one of the reports require that the name of employees should be displayed as column names and whatever work they have done for a stated period should appear in rows below that particular column.Now as it is clear, the columns will have to be added at runtime. Am using an ODBC Data source to populate the grid. Also since a loop will have to be done to find out the work done by employees individually, so the number of rows under one column might be less or more than the rows in the next column.Is there a way to create an empty data table and then update its contents based on columns and not add data based on addition of new rows.
View 1 RepliesI am trying to make a label that changes every second for an event. What I currently have makes the thread sleep all the way through from "Rock" to "Shoot" and skips the "Paper" and "Scissors". Does anyone have any ideas as to what I should do to properly display the label so that they are all displayed in equal time increments?[code]...
View 2 RepliesI am wanting to increment an integer by 1 each time i press a key. My problem is this, when i press the key, the integer is increased by a lot, unless i just 'tap' the key very precisely.
Is there a way to 'reduce' the sensitivity of pressing a key?
Im using this to increment a lable x1 each time i click a "picturebox" , it increments the first time i click it but thenm it wont go any further.
[Code]...
I can not seem to figure out how to change the size of a photo being put into a picture box.I need the photos that are placed in the picture box to come in their original size....I have 4 different pictures in an ImageList and depending on what a Text box from a different form says, one of the photos will be displayed in a picturebox when the form is loaded. Right now all the images show up very blurry and in the predetermined size in the imagelist. Here is my code:[code...]
As you can see I figured out how to autosize the PictureBox (candypic) to the size of the image coming in....just cant get the image to come in as the right size.....
When I created the imagelist all the photos have a default size of 16, 16 when entered into the list.....I see in the imagelist properties how to adjust the image size but it groups them together as one.
Im using vb.net and the database is mysql to write a time management system. how i store date and time to the database?
View 2 RepliesI have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
I have linked my vb.net application with mysql database but i am having a problem inserting data from the vb forms into the relevant fields in the database...
View 1 RepliesCurrently, 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'm working with Windows Forms - VB.NET.Here's what I have:
A ListView with checkboxes set to True
A Button (triggers the update)
A database table with similar fields as the ListView
What I want to happen:when the user clicks the Button, all items on the ListView with checkbox checked will be updated.My progress:I've already collected the ID of the checked items and stored them in an array. I'll be using this to update the database table.I don't know how to put them in the SqlCommand.Parameters Also, I don't know the update command for such scenario (where in/exist (@parameters))
Present i am working on TreeView and Datagridview in VB.NET 2008. In the Treeview one of Node if i will expand, corresponding number of ChildNodes, i want to create same number of rows on the DataGridview.
Assume my treeview Control Nodes and ChildNodes like below.
-31
3101
3102
[Code]....
I want to change the row color of every row in my DataGridView where a particular column value = "RBF3". I am currently using the DataBindingComplete event which seems to work fine, but it fires every time I change a cells value. I'd like for this bit of code to only fire when the datagridview is first displayed, sorted, or filtered. Is this possible?
[Code]...
I'm working with Windows Forms - VB.NET.
Here's what I have:
A ListView with checkboxes set to True A Button (triggers the update) A database table with similar fields as the ListView
What I want to happen:
when the user clicks the Button, all items on the ListView with checkbox checked will be updated.
My progress: I've already collected the ID of the checked items and stored them in an array. I'll be using this to update the database table.
The problem: I don't know how to put them in the SqlCommand.Parameters Also, I don't know the update command for such scenario (where in/exist (@parameters))
[code]...Find last rows each machine_id in mysql database with program?
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 have a datagrid control with a list of names that it retrieves from a MySql database. I can search through them until i have one result. I want to be able to Display a groupbox control when the number of results is equal to 1. Also, in the groupbox i have a button that when clicked will delete this user from the server and their information from the mysql table called "employee". when the user is deleted i'll display a confirmation message in a messagebox, and reload the table with the updated list. so far the only two problems i have are showing the groupbox when the results are equal to 1 and deleting the user from the sql server based on the name of the search result
Private Sub TextBox1_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyUp
'Search Function.
[code].....
How do I dynamically display the 'Edit' on the hyperlink field based on the values on the rows, generated from the database. the gridview automatically generates rows.
View 1 RepliesI have a data table in a loop that adds rows on each loop. During the loop i collect an array of unknown size. At the end of the loop i want to add a new row to the datatable with eachelement of the array as a field.[code]I could hard code this if i knew how many item would be in the array but i dont.Is there any way i can loop through the array and append the value to a row?
View 8 RepliesI have a datagridview and trying to filter recs based on a Date field. This is the
Dim ds As New AOListingDataSet
Dim da As New AOListingDataSetTableAdapters.CallwithNameTableAdapter
da.Fill(ds.CallwithName)
Dim dv As New DataView(ds.CallwithName)
dg1.DataSource = dv
[Code] .....
It works ok when filter is on other fields but brings empty on 'CallDate' date field. I have declared the 'CallDate' field in db as long date format in Access.
I am creating a program that will allow me to manage server EXE's for which I have the method to do so already completed. The problem comes when I want my front end to be able to use a database of different server configs stored in a dataset.
My Database has 4 columns (ServerID | ServerName | ServerPath | ServerMod)
I wish to be able to select the ServerName in a combo box (already done via Datasource/DataMember) and then load the ServerPATH and ServerMOD for that row into two variables.