Comments by Jatinder Gupta (Top 26 by date)

Dear Sandeep sir, Actually it was not working a days back that is why add in new

Thanks sir problem solved.

One more thing to I want to ask like if I passed the command like that it ok but I suffel the field and put the data at second it shows commant like as second example Kindly see the error


"INSERT INTO SALES(docdt,docno" & _
") values ('" & Format(DTdocdt.Value, "MM/dd/yyyy") & "'," & _
(txtinvoice.Text) & ")"

"INSERT INTO SALES(docdt,docno" & _
") values (txtinvoice.Text) & "," & _
'" & Format(DTdocdt.Value, "MM/dd/yyyy") & "')"

Not sir the problem is same again after changes Format(DTdocdt.Value, "MM/dd/yyyy") the date shorted in database is 01/01/1900 00:00:00.

If I put a msgbox before that the data showing(09/21/2010) write in msgbox but stored 01/01/1900 00:00:00 in database

I'm inserting in that way
strSQL = "INSERT into Bills(docdt,tc,glc" & _
",docno,broker,amount) values (convert(varchar(20),@DTdocdt,103)," & _
CType((xtc), String) & "," & _
CType(custcmb.Items(custcmb.SelectedIndex), ListItem).ID & "," & _
(txtinvoice.Text) & "," & _
CType(cmbbrk.Items(cmbbrk.SelectedIndex), ListItem).ID & "," & _
CType(IIf(txttotal.Text = "", 0, txttotal.Text), String) & ")"


The Error occurs "Must Declare the scalar variable '@DTdocdt' ".

Kindly guide I'm passing write command or make mistake

Not sir the problem is same again after changes Format(DTdocdt.Value, "dd/MM/yyyy") the date showing 01/01/1900 00:00:00

Thanks but kindly explain with an example

Noted sir, keep in the mind from the next time.

Kindly explain about that with an example

Thanks sir, good solution.....

Thanks I have got the code but now again a slit problem occers when I press F1+Ctr it shows the message first "F1" then "F1+Ctr". Could we not use "F1" and "F1+Ctr" in a same event

If e.KeyCode = Keys.F1 Then
MsgBox("F1 Pressed")
End If
If e.KeyCode = Keys.F2 And e.Control = True Then
MsgBox("F2+Ctr")
End If
If e.KeyCode = Keys.A And e.Alt = True Then
MsgBox("Alt+A")
End If

Nextly how to add the combination of key is that correct as define under.

If e.KeyCode = Keys.F1 And e.KeyCode = Keys.ControlKey Then
MsgBox("F1+Ctr")
End If

Thanks the Problem has been solved

Yes, I try to connect thro Crystal reports.

kindly explain with an example to move next

Thanks sir, it has solved. If your have not objection kindly share your email Id

Regards,

Jatinder gupta.

It is ok to work with me.width but it will calculate from Form not from the Panel-A. As explained that the I have a panel-A inside Form and another Panel-B inside that Panel-A. Now I want to place Panel-B inside Panel-A in centre. That is my query

You r right sir as the problem at datasets. Kindly help me in step to see the error in datasets. Nextly report become ok when I use the old kind of databases i.e DBF file of other software. For just to see the problem occer at where I used the other databases to see output. With that I find that the problem occers with Sql datasets. Pl guide for the next. Regards,

Dear sir,

Pl guide for me as I'm unaware about SQL Profiler.

Kindly give me step for that.

Regards,

Jatinder gupta.

Dear Sir,

As I explained that I try to see the value even just before to Store in Database with Message which shows correct date. But store only 01/01/1900.

Thanks.Problem has been solved with control...

Thanks the example is sutiable to fulfill the requirement.