How To Search The Employees Based On Deparments
May 3, 2010
I have been using C# for 4 years along with SQL server. However, today I have to do small application using VB.Net to search some users based on their departments
This is the first time that I am trying to do something in Active directory (and this is the first time I ever seen the Active directory). I always write database queries and I have no idea how to do query on Active directory How to search the employees based on deparments?
[Code]...
View 20 Replies
ADVERTISEMENT
Feb 8, 2012
I have three controls on my form; Textbox1, cboCity, lstCity When something (lets say "a") is entered in the TextBox1; I want to get each and every item in combobox cboCity that starts with "a" and add them to listbox lstCity.
View 5 Replies
Oct 13, 2010
I want to build an application using VB, that is essentially an information system.The operation of this system would be as follows:1. User can select one of several buttons, each button being a different topic.2. When a button is selected, information about that topic appears on the right hand side of the form.3. The system allows information to be added by a user So, for example, if a user clicked on the button named 'Banana', information about the banana would appear on the form, where the user could read this info, scroll down etc.I would also like the user to be able to search a specific word like 'apple' and for information on the apple to appear.How could I implement this? I don't know how I would store paragraphs of information, and then search for it based on a keyword.
View 1 Replies
Sep 8, 2011
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].....
View 2 Replies
Jan 23, 2012
Well I have a list of things I want to search based on multiple points of data...for example Resolution, 3D capable, touchscreen capable....etc....What is the best way for display someone can think of & filtering results by capability, I have none of it typed out, etc...like list of objects & capabilities, etc... alreat...so it can be made any way that is thought to be good(with speed as well) for many different listings...say 1,000 of them & it filters pretty much instantly....reading capabilities & such & the list itself is easy but how can I make a filter(unchecking something brings back things, checking something takes away only since well your adding capabilities to filter selection....I have pictures that can go with items too as well as a name & more information could be given directly with the method or clicking on the picture/item.
View 13 Replies
Aug 22, 2009
I used following code searching records from a table in MsAccess and displaying in a Listview and it is working fine with the search criteria based on Discription.
CODE:
I also tried the above code to search records on the base of CustId and it worked fine too.My table DailyTransaction in MsAccess is as under:DTDate, DTTime, CustId, Description, Quantity, Price, Amount, AccountNumber, Name
Now I want to Search records on the base of Date I tried the following but it did not work.
Dim cmdText As String = "SELECT * FROM DailyTransaction WHERE DTDate=' " & TextBox1.Text & " ' "
Also i want to make following sort of query to retrieve data between two dates and to display the sum of amount group by DTDate. I could sketch following query and deifinitely it is so wrong with Syntex.Select * From DailyTransaction where DTDate Between textbox1.text AND textbox2.text Group By DTDate AND SUM(Amount)
View 10 Replies
Jun 21, 2010
i'm developing a project on employees. I have added a list box and display the data about my employees in the list box. How am i supposed to do that, do we have to put in codes or need to use that small arrow near the list box.
View 1 Replies
Oct 18, 2009
Dear members please guide me how thumb scanner use to take attendance of employees using vb.net and oracle 9i.
View 1 Replies
Feb 8, 2010
I have two grids displaying records of employees like name, job no, and position . Now I have to swap their jobs from Emp A to Emp B which is from one grid to other.
View 1 Replies
Jun 8, 2012
I have written a small program to allow our employees to submit work orders. I want to have each computer on our network to be able to open the program, run it, and have the files (which are actually jpeg's of the form) saved on the server. This part works fine.
I have it loaded on the server and have tried to run it from several computers. While the program does run ok, it does not load the My.Settings items that are on the server. On each computer the program has, or appears to have its own set of my.settings.
If I go to the form in the program that allows me to add items to my.settings, and make changes they are saved, but when I go to the next computer they are not there. It only reflects the my.settings that were put directly in during program construction. (opened my.setting, clicked on the setting and added them there)
My question is,, how to get the program to stay on the server when running it so that the settings are there no matter which pc is running it? This is a windows forms program, I am using Visual Basic 2010 Express.
View 12 Replies
Aug 25, 2010
I am trying to come up with a way to store 3 pieces of information for each employee in the company on a daily basis. So for instance:
Day 1: Joe, 8, 80
Day 2: Sam, 10, 90
Day 3: Bill, 5, 40
Day 4: Bob, 8, 40
Day 5: Sue, 2, 50
I am very new to collections and most of the applications that I build are Create, Read, Update and Delete type applications that don't really need arrays so I have almost no experience with either.
This is what I have so far.
VB
'
Dim iDays As Integer = NumberDaysPerMonth(Date.Now)
Dim DayNumber(iDays) As Integer
Dim EmployeeRecords As List(Of String) = New List(Of String)
For i = 1 To DayNumber.Count - 1
[Code] .....
View 4 Replies
Oct 24, 2011
Create a project that will input an employees sales and calculate the gross pay,deductions, and net pay. Each employee will receive a base pay of 900 plus a sale commission of 6% of sales.After calculating the net pay, calculate the budget amount for each category based on the percentages given in the tables below.
Pay
Base Pay
�900.00
Commission
[code]....
Your Form should use text boxes to input the employee name and the euro amount of the sales and also use text boxes to display the results of the calculations. Provide buttons for Calculate, Clear, and Exit. Display a message to the user for any bad input data.Hints - You need to declare module-level constants, declare variables, carry out calculations and use try/catch to handle any exceptions that may occur.
View 7 Replies
Sep 18, 2011
I want to make an application that allows the manager of the company whether the employees are truly active: screenshot and a "timer" to measure the time of the activity of the employee Can be controlled using the mouse or keyboard while the application is not active, but in execution.Is it possible in vb.net to know if the user of the machine is using the mouse or keyboard? My idea is to set a "Timer" which triggers automatically after the connection of the employee and every 10 seconds the application checks whether the mouse position has changed or a letter is entered on the keyboard except the"Timer" Will Be stopped until have a new mouse position or activity on the keyboard. But the problem is: is the application able to know the position of the mouse or to capture all keyboard input even if the application n 'is not active(not in the foreground)?
View 2 Replies
May 25, 2009
i am a beginner learning vb.net. I have an excercise to create a form and on clicking the totals buttons it should display the number of employees who have earnt a salary within the ranges below. Now this code works, but i want to substitute the Select Case Statement with a more efficient for..next statment to increment my counter. The code is:
[Code]....
View 2 Replies
Feb 4, 2011
I want the user to be able to click on the "search" button, and for a diaglog box to open, with two options. "ID" or "Postcode".
How would i do this, and then how could i intergrate my line of code into that?
View 1 Replies
Apr 6, 2012
This is the Project that i have to make. Create a project that will input an employees sales and calculate the gross pay, deductions, and net pay. Each employee will receive a base pay of $900 plus a sale commission of 6% of sales.
After calculating the net pay, calculate the budget amount for each category based on the percentages given in the tables below:
Your Form should use text boxes to input the employees name and the amount of the sales and also use text boxes to display the results of the calculations. Provide buttons for Calculate, Clear, and Exit. Display a message to the user for any bad input data. Now i want to know for constants its going to be : commission sale, deductions and everything in Budget? I am also guessing that for the gross pay its going to be the" Gross pay = base pay * Commission" ?
View 2 Replies
Jul 14, 2009
Would it be possible to search a table, confining to a specific date range based on a date-time column, and get a count of the 10 most used words in a particular var-char column excluding a list of words?All in SQL?Currently I am pulling out the records that match and sorting through the contents outside of SQL, I would think where I can do it directly on the server it would be more efficient.(SQL 2008)
View 4 Replies
Jul 13, 2010
I am rewriting an old app that uses Linq. One part intrigued me...The code get the ID of a row from a datagridview.Then the code executes a LINQ that in the where-part make a selection based on the ID (which is the PK) to return a single object using .Take(1).SingleOrDefault Then this object is added to the dbcontext.Employees.DeleteOnSubmit() method and finally the Submitchanges is executed...I added a watch to the Log property of the datacontext, and lo and behold, when the delete query is executed, it uses ALL properties of the object in its where query. It should use the EmployeeID only since its the PK.
My question is, is it impossible using LINQ to execute a simple "delete from employees where employeeID = 1" That is basically what the above LINQ code does. But I dont want to to excute a select statement first, and I dont want it to delete by all columns, only by the id column, which an indexed PK.Any LINQ gurus wanna share some insight on this?
View 7 Replies
Feb 21, 2011
ERROR RECEIVED: NullReferenceException was unhandled Object reference not set to an instance of an object.
And it points on the particular line: dsNewRow = ds.Tables("Employees").NewRow()
Imports System.Data.OleDb
Public Class Register
[code].....
View 2 Replies
Jun 10, 2011
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim ds As New DataSet
[code].....
View 7 Replies
Apr 6, 2011
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 Replies
Dec 31, 2009
i want to ask that how i can open a search page in my vb.net webbrowser with a separate textbox in a tool bar separate from the url text box
View 2 Replies
Jun 10, 2011
With writting a program that demotrates Binary Search Tree operation(insert, delete, and search)in VB.N NET?
View 1 Replies
Dec 15, 2009
I have a datagridview with 2 columns, 1 is Batch_Number and another is Existing_Stock, there is about 6000 rows.My question is, I want to be able to write in a TextBox and hit a Search Button to search the Batch_Number column and filter out or highlight the row with the matching number to see the Existing_Stock
View 9 Replies
Jun 11, 2011
How can I search, for example ID Number, and want to highlight the listview item found in search from my first form? I'm using combobox from my second form to search.
View 6 Replies
Nov 22, 2009
I'm using SQL as a database in VB 2010, I already add a table to my form as a datagrid view but I don't know how to add buttons for filtering, deleting and adding things in my table, for example I want to have one button on my form call it search button to search in table names or Phone Numbers. how can I do that and where shall I write the code?
View 3 Replies
Feb 9, 2011
1) is vb6 is interpreter based languge or compiler based or both interpreter and compiler based language?
2) is VB.Net interpreter based languge or compiler based or both interpreter and compiler based language?
3) if any of above mentioned is both interpreter and compiler based so tell me please when it compiles and when it interprets?
View 6 Replies
May 26, 2009
I'm in a bit of a quandry. I am trying to build a simple search form where the user selects the column title and in puts the criteria then clicks the search button. This is the code I am using
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
details = ComboBox2.Text
'column name selected by user
specifics = TextBox1.Text
'criteria input by user
[Code]...
View 9 Replies
Aug 3, 2011
when you want to use the search engine and when mouse cursor move in textbox search you'll see a small word ("Search") or ("Enter your Search term")
[Code]...
View 4 Replies
May 8, 2012
changing the way the site search is done from just search a phrase as one string to searching a phrase "as multiple words" search. For example, if I search "cute puppy" right now, it will search it for "cute puppy" as phrase and won't match just "cute" and "puppy". The way the search is implemented is by passing a search phrase to a Stored Procedure in SQL Server.So now, I need to change to site search so when "cute puppy" is searched, it will search two words.... "cute" and "puppy" instead of just "cute puppy". Below is how the store procedure is implemented
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
[code].....
View 3 Replies
