Search:

I have two Identical twins forms (for editing and updating purposes),when I double click on the DGV row it gives me the value of the row in another form.
Now I have three radio buttons on form...

I got the answer ...:)

Hi,
I have a form in which there are 11 text boxes and two button controls(Just example) ,I want the tab key control to be in the textbox1 when the form loads ,and then If I press Tab Key from...

* szlamany*
This is no school project ,I'm learning Vb.net as a language and making a project like a payroll system, so I can cover as much as I can(learning),and in coming time when it is ready...

But what I make the salary of a person for a whole year then how would I be calculating ,which field value will I use and how? ...still no Idea @&!#

Ok the problem has been solved


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim con = New SqlConnection("Data...

cmd.CommandText = "SELECT SUM(Present) FROM Attendance WHERE AttendanceStatus = 1 And (Firstname = Firstname) Group BY Firstname"

If I change above statement to this


cmd.CommandText =...

Adding a new column to an existing table ,how would it solve my problem ...when I update the column by new salary at the end of the month, when salary is to be made how would it work?
Or adding a...

Present is the Column name and it hold the value 1 who ever is present against the name is 1 and I want to count the number or sum against the name.

ok so I have to add the columns for previous salary in the update and date change also.

Hi,

CODE:


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim con = New SqlConnection("Data...

Yes I have stored all the information about Employee including his basic salary in the sql database ,so if I update the basic salary of an employee,from 3000 to 5000 the it show in m y end of the...

Hi,
This code is just an Example

update dbo.Employee set
Salary = Salary * 1.2 -- Increase Salary by 20%
where
Employeename = 'danial'

The salary of the Employee is 3000 per...

This code creates XML File


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connetionString As String
Dim...

dunfiddlin
DavesChillaxin
Thank you two for solving this issue :)

I have two combo boxes
when I use this in the form load event
one on the top gets populated ,other does not...why this is happening?And if I put the second one on the top, it get's...

Hi,

When the form loads the DateandTime Control shows the current date,but I want the date to be blank when the form loads and when I click on the dateandtime down arrow then the date shows up to...

I have assigned fk to EmpoyerID on the employee table and then the data is there ,but now I wonder weather now the two tables related or not ,If I create employer profile and add three employee how...

Yes both the tables have there first name matching,with column name Firstname
Employer table,Fieldname Firstname = Danial
Employee table,Fieldname Firstname = Danial

Here is the full code


Public Function DGVload_testsql() As DataView
Dim con = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Danial\documents\visual studio...

here is the code
I'm getting the field names in the DataGridView but not the values



_string = "select Employer.CompanyName,Employee.Firstname from Employee inner join Employer on...

Now this works as my datagrid shows two table columns one after another ,but with no value inside the tables?

I have Employee table IDEmployer as a field and assigned Foreign Key to it(and Allow Null :Checked) .
I hope this is right.(as shown in the screenshot)
96411
Now I just have to use the select...

Hi I'm using sql express,and I have two tables Employer and Employee,how can I relate the two tables so to differentiate between who works for who?

Employee table has EmployerID as a field and...

You were right ' Joacim Andersson' I comment out each line one by one and I found out that this line

dr("Imagepath") = Txtfilepath1.Text
which does not give any error and add a new row rather...

I have made and Text box(hidden)in my form and assigned my PK (Field)value to it and based on that,I have edited my where clause (Not the code I posted above with parameterized SQL statemen).Now it...

I'm not focusing on Firstname Field ,but any other field in the form ,I have checked and it does not contain any more numbers,spaces,or characters in the text fields,and if that was the case it would...

I have done implementing breakpoints at almost all the lines,but this line

da.Update(ds.Tables("Employee"))is the one which gives me that error(provided in Screenshot).
Isn't that the update...

Yes I'm dead sure about not having firstname field does not contain Danial followed by 44 or more spaces...and I know he is right about what he says,and I also know what my text fields contains.:)

hummm...but Those values which I'm trying to update is as long as it's already been in the database,so I don't think I have a such a long value in the textboxes...I'm just replacing firstname...

I'm getting this error while executing this code .

Private Sub UpdateData_adapter()
Dim fstream As FileStream
Dim imgdata As Byte()
Dim data As Byte()
Dim...

Not a problem..yeah I'm using 2010

ok I got it

change

Excel.ApplicationClass xlapp = new Excel.ApplicationClass();

to this


Excel.Application xlapp = new Excel.Application();

Here are the errors I get from this code
96075

Now how do I make this thread [solved]?

My where clause has the problem ...so I changed it to this


where Firstname = '" & _
DGV1.CurrentRow.Cells(1).Value() & "'"
and now it works fine :)
Thank you all for...

I have changed the Sql statement ..where clause is gone,I have got the image but not according to the name,just one picture is showing no matter which row I click .


Dim connection As New...

ok my sql query has a problem ?

Yes you are right I'm getting an error on that line.
here is the screen shot without Try and catch

95531
How can I change the code to make it work?

I'm trying to get values from DataGridView to the another form in textboxes and in Picturebox ,data in textboxes are there but when I trying to get a picture in a picturebox from DB it gives me this...