16,020,666 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Visual Basic questions
View Javascript questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Jatinder Gupta (Top 26 by date)
Jatinder Gupta
27-Dec-11 22:56pm
View
Actually my question was how I Can print number of invocies in frequent way... .i.e. I want to print invoice from 1 to 10
Jatinder Gupta
9-Oct-10 4:44am
View
The error is if I put the fields of Only Bills tables the data shows but I add the fields of Sales Tables in that the data shows blank.
Jatinder Gupta
28-Sep-10 6:19am
View
Still Waiting
Jatinder Gupta
26-Sep-10 10:42am
View
The Command is running Ok if I cheaked thro. Query but not showing the same output in Crystal Report. That is why I become confuse.
Jatinder Gupta
23-Sep-10 21:52pm
View
Thanks I have passed thro Dataset.
Jatinder Gupta
23-Sep-10 21:51pm
View
Dear Sandeep sir, Actually it was not working a days back that is why add in new
Jatinder Gupta
21-Sep-10 21:17pm
View
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") & "')"
Jatinder Gupta
20-Sep-10 21:52pm
View
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
Jatinder Gupta
20-Sep-10 21:44pm
View
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
Jatinder Gupta
19-Sep-10 8:18am
View
Not sir the problem is same again after changes Format(DTdocdt.Value, "dd/MM/yyyy") the date showing 01/01/1900 00:00:00
Jatinder Gupta
15-Sep-10 6:37am
View
Thanks but kindly explain with an example
Jatinder Gupta
15-Sep-10 3:12am
View
Noted sir, keep in the mind from the next time.
Jatinder Gupta
15-Sep-10 3:11am
View
Kindly explain about that with an example
Jatinder Gupta
14-Sep-10 20:56pm
View
Thanks sir, good solution.....
Jatinder Gupta
13-Sep-10 21:14pm
View
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
Jatinder Gupta
13-Sep-10 21:06pm
View
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
Jatinder Gupta
13-Sep-10 20:57pm
View
Thanks the Problem has been solved
Jatinder Gupta
13-Sep-10 3:20am
View
Yes, I try to connect thro Crystal reports.
Jatinder Gupta
12-Sep-10 21:06pm
View
kindly explain with an example to move next
Jatinder Gupta
11-Sep-10 7:41am
View
Thanks sir, it has solved. If your have not objection kindly share your email Id
Regards,
Jatinder gupta.
Jatinder Gupta
9-Sep-10 8:59am
View
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
Jatinder Gupta
31-Aug-10 21:25pm
View
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,
Jatinder Gupta
23-Aug-10 3:54am
View
Dear sir,
Pl guide for me as I'm unaware about SQL Profiler.
Kindly give me step for that.
Regards,
Jatinder gupta.
Jatinder Gupta
22-Aug-10 7:10am
View
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.
Jatinder Gupta
22-Aug-10 6:23am
View
Thanks.Problem has been solved with control...
Jatinder Gupta
21-Aug-10 22:23pm
View
Thanks the example is sutiable to fulfill the requirement.
Show More