Comments by armarzook

armarzook 19-Dec-12 9:37am View

That is exactly the problem here. I don't have those two fields in the table E2. and about that datatypes, two tables are having int datatype only.

armarzook 4-Dec-12 7:41am View

Thank You for the solution. This Works. But as a noob i would like to know how actually this one works. Can u explain it?

armarzook 22-Nov-12 3:19am View

Read the question now please...

armarzook 22-Nov-12 3:09am View

Sorry. not data datatype.. Its Date Datatype.

armarzook 18-Nov-12 9:42am View

So. Whats the solution???

armarzook 18-Nov-12 9:07am View

FYI

1) http://tinypic.com/r/34xrfdg/6
2) http://tinypic.com/r/v48co9/6
3) http://tinypic.com/r/2ccm5oy/6

and i actually get the error when exiting the program.

armarzook 18-Nov-12 8:58am View

Already tried it by passing the code into a msgbox
the actual output is 1. This is why iam confused.

armarzook 18-Nov-12 8:28am View

Ok. Actually i tried what u told already the result is 1

MsgBox(Prjdt.Rows.Count)
Output is 1

armarzook 18-Nov-12 7:39am View

Now it is showing a different error...
"There is no row at position 0."

armarzook 18-Nov-12 0:39am View

In this line
Dim da1 As New SqlDataAdapter("SELECT Project_ID,Trade,Fix,Material_Description FROM Mat_e1_prj where mat_sub_no='" + Mat_Sub_NoComboBox.SelectedValue.ToString + "'", con)
Dim dt1 As New DataTable
da1.Fill(dt1)

armarzook 10-Nov-12 8:38am View

If ListBox1.SelectedValue Is Nothing Then
Me.E1TableAdapter.FillBy(Me.ProcurementDataSet.E1, projid:=CType(TextBox1.Text, Integer))
Else
MsgBox(ListBox1.SelectedValue)
Me.E1TableAdapter.FillBy1(Me.ProcurementDataSet.E1, ms_no:=ListBox1.SelectedValue)
End If

Already tried this.... No solution.

armarzook 7-Nov-12 7:21am View

Actually the error is showing in this line.

Dim sql As String = "SELECT mat_sub_no FROM e1 where project_id='" + ComboBox1.SelectedValue.ToString + "'"

armarzook 4-Nov-12 9:34am View

Used the below code to get what i want but its still not working...

Private Sub ComboBox1_SelectedIndexChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged

TextBox2.Text = ComboBox1.SelectedValue

con.ConnectionString = myconstring

Dim da As New SqlDataAdapter("SELECT max(sl_no) as max FROM e1 where project_id='" + TextBox1.Text + "'", con)

Dim dt As New DataTable

da.Fill(dt)

MsgBox("Connected")
MsgBox(dt.Rows(0).Item("max").ToString)
TextBox1.Text = dt.Rows(0).Item("max").ToString

armarzook 1-Nov-12 5:23am View

Sorry Jilad I really can't figure out what exactly the problem is. I hope reinstalling the apps may help. Good Luck with that.

armarzook 1-Nov-12 4:34am View

u have any alternate code to do this same thing so that accident can never happen?

armarzook 1-Nov-12 1:46am View

May I know whats your server configuration?

armarzook 31-Oct-12 2:28am View

Thanks for your reply Anand. But where i have to insert this statement and can u explain how it exactly works? i can even give you the full vb code also. Actually the value is a text box from the datatable.

armarzook 23-Oct-12 9:34am View

Doing researching for the past one week but till now only got to know how to export and import Data from SQL server directly... still didn't get a clue for that In visual studio...

armarzook 23-Oct-12 9:19am View

I really have no idea regarding this and I am a novice to visual studio and SQL server.. I really need help...

armarzook 21-Oct-12 4:49am View

How to give a valid selection ? Or either the "sensible" value.??

Comments by armarzook (Top 20 by date)