xerohomicide

Private Sub Form16_Load(sender As Object, e As EventArgs) Handles MyBase.Load Dim sqlquery As String = "SELECT SUM(price) AS totalprice FROM expenses" Dim sqlcommand As New OleDbCommand With sqlcommand .CommandText = sqlquery .Connection = conn .ExecuteNonQuery() End With Label2.Text= 'totalprice that is SUM(price) End Sub i want to display sum(price) in …

i've 9 button(i've set "" to button text) there and all buttons have almost same code as button1 has and here is the code :- Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If (exitgame = 0) Then If (Button1.Text = "") Then Label2.Text = "Active …

I want to format today's date like this dd/mm/yyyy Please help me

I need to get the sum of two numbers but i do not know how example > **what the result should be:** 1,000,000 + 2,000 = 1,002,000 > **my code's result:** 1,000,000 + 2,000 = 3 > It seems that my code only adds the numbers before comma (,) My …

Hi i'm having a trouble with this i got 3 textbox and i format it to Textbox1.Text = Format(Textbox1.Text, "Standard") Textbox2.Text = Format(Textbox2.Text, "Standard") Textbox3.Text = Format(Textbox3.Text, "Standard") which give something like this 1,230.00 2,500.00 1,245.00 and when i add it `Textbox4.text = Val(Textbox1.Text) + Val(Textbox2.Text) + Val(Textbox3.Text)` the result …

Hi,I need to retrieve the data for Employee details After entering Empno in a 1st text box.I hope it's Simple but i'm Intermediate level in VB.net,Please help ASAP This is My Coding for VB.NET Private Sub View_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click con.Open() cmd = New …

My listview has 3 columns. "Text" , "Delay" and "". The "" column is to show which one is being ran by filling it with a "<". If I use List.Items(currentTimer - 1).SubItems.Add("<") Then it works, but how will I remove it? SubItems(1) modifies column 1, and SubItems(2) is out …

Hi how can i pass if my connection is false? i have a code here Dim con As New OleDbConnection Dim dt As New DataTable Dim ds As New DataSet con.ConnectionString = ("provider=Microsoft.Jet.OLEDB.4.0; Data Source='" & ConMonthEndLocation & "';Extended Properties=Excel 8.0;") con.Open() dt.Clear() ds.Tables.Add(dt) With Form_Month_End_Report .ListView_LOB.Columns.Clear() .ListView_LOB.Items.Clear() Dim da …

hi, I have to write an algorithm for getting a matching string from list of saves string after comparing it with the given string. say example: Saved string: ` ` Book ABC Book ABC XYZ Note Copy Note Book YYYe` If user gives Book, then the algorithm can return Book …

Hi guys...I have ready program which often hangs when the textBox is refreshing with content. I don't want to rewrite the code so I decided to add backgroundworker. My Code structure is like this private void startButton_Click(object sender, RoutedEventArgs e) { backgroundWorker.RunWorkerAsync(); } private void backgroundWorker_DoWork(object sender, DoWorkEventArgs e) { …

say im performing addition of two numbers. there are three textboxes . 2 for entering the numbers and 1 for displaying the result. im giving one value in first text box and no value in second textbox it says "conversion not possible". now wat shuld i do to make the …

Hi Folks As a newbie, my datagrid (dgvExamScores)has column4 and column5 (and othercolumns) column4 values depend on column5 values. Code works fine. PROBLEM: when I delete a column5 value, I expect the corresponding column4 to be deleted but this is not the case. Just where have I erred in my …

Hello, I am creating a toolstrip and then adding a toolstripcombobox to it. My code so far is as follows: Dim tsMenu As New ToolStrip tsMenu.Name = "tsMenu" tsMenu.Dock = DockStyle.Top tsMenu.Visible = True Dim tsComboBox As New ToolStripComboBox tsComboBox.Name = "tsComboBox" tsComboBox.Visible = True tsComboBox.Items.Add("Item 1") tsComboBox.Items.Add("Item 2") tsMenu.Items.Add(tsComboBox) …

For a project i have to create a program that is able to write and read a sequential file and list the contents into textboxes. So far i am able to write to the file but the problem is i am not able to retrive/read the information from the file. …

"SELECT * FROM table where column=" & Request.QueryString("querystringfeild") i want to add order by condition along with where condition. But i don't know how to write syntax please help me. thanks!

in my work i get 03:00:00 as the total hours work..how can i make it in just 3? Dim TimeOutHours = TimeSpan.FromHours(Val(DateTime.Parse(TimeOfDay.ToString(Me.TimeOutTextBox.Text.Trim)).Hour)) Dim TimeInHours = TimeSpan.FromHours(Val(DateTime.Parse(TimeOfDay.ToString(Me.TimeInTextBox.Text.Trim)).Hour)) Dim TimeOutMins As Integer = (Val(DateTime.Parse(TimeOfDay.ToString(TimeOutTextBox.Text)).Minute)) Dim TimeInMins As Integer = (Val(DateTime.Parse(TimeOfDay.ToString(TimeInTextBox.Text)).Minute)) Dim mingreat As TimeSpan = TimeOutHours.Subtract(TimeInHours).Subtract(TimeSpan.FromHours(1)) Dim minless As TimeSpan = TimeOutHours.Subtract(TimeInHours) …

Right im tring to figure this out.... using the form load event i have created an array which gets populated with 20 random numbers from 0-9 (numbers do repeat). Based on the users input I am now trying to search my array to findthe first occurrence if any of the …

Sub empno() ComboBox2.Items.Clear() sql = "select empno from tbl_empinfo" If rs.State = 1 Then rs.Close() rs.Open(sql, conn) Do While rs.EOF = False ComboBox2.Items.Add(rs(0).Value) rs.MoveNext() Loop End Sub how do i write this for an access connection???