16,016,425 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 Javascript questions
View Visual Basic 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 Sissy Ram (Top 23 by date)
Sissy Ram
14-Mar-20 6:30am
View
Still Gov is not completely have the procedures.
Sissy Ram
14-Mar-20 4:13am
View
@Rahul(10217975) Do you think this is right query
IF
My Table: (For Current Month)
EMPCODE DATE ATTENDANCEMODE
100 01/01/2020 P
100 02/01/2020 A
100 03/01/2020 A
100 04/01/2020 P
100 05/01/2020 A
100 06/01/2020 A
100 07/01/2020 A
Current date 07-01-2020
What I need?
EMPCODE CONTINUOUSLEAVEFORHOWMUCHDAYS:
100 3
Will the above query works for this?
NO..
Sissy Ram
3-Apr-18 8:47am
View
Check whether rights given to access in server
Sissy Ram
21-Feb-18 0:57am
View
Forgive me if any typo.
My Expected Output is:
ECNO BRANCH MONTH ISDELETED 2 B3 February 2018 n 3 B3 March 2018 n
My Input is user give startedate and end date and brach
Startdate and enddate will be like March 2018
Sissy Ram
9-Feb-18 2:59am
View
Thanks Ralf Meier Finally Your idea Runs Perfectly.
But Now I am Concentrating on forms to fit in any resolution. That's the Final Solutions.
Sissy Ram
9-Feb-18 0:32am
View
My PC in windows 10 64 bit version.
Destination is also the same.
Sissy Ram
9-Feb-18 0:32am
View
Team,I found the screen resolution is different between PC's.
My pc has resolution 1600 * 900.
Desination Pc has only 1366 * 768.
Is there any solutions or suggestions for this issue?
Sissy Ram
5-Jan-18 5:31am
View
Thanks for your suggestion frnds
Sissy Ram
29-Dec-17 4:53am
View
Please anyone atleast reply
Sissy Ram
29-Dec-17 2:26am
View
anyone there?
kindly help me as soon as possible please.
Sissy Ram
26-Feb-14 10:52am
View
that code is not working friend,
say me a example,
Here i edited that line as like this but error shown
acList.AddRange("select TCODE from Tailor ")
Sissy Ram
26-Feb-14 10:45am
View
No that is not working friend
Sissy Ram
26-Feb-14 10:30am
View
No i resolved it myself.
The problem still occurs while i am using database file format as "accdb".
So i convert 'accdb' to 'mbd'
and used,
Dim con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\DB.mdb")
Now it works fine.
Thank you for all your supports friends.
Sissy Ram
26-Feb-14 1:47am
View
As a message box or somewherelse in the sql query
Sissy Ram
24-Feb-14 11:45am
View
Should i wanna to add any files to support GetByValue query?
Because it shows as an error GetByValueQuery is not declared
Sissy Ram
24-Feb-14 11:39am
View
that is ok cool sir i have another problem in my form.
if i make upadation in runtime it works.
but after restarting the form the updation are not diplaying.
and here is my code
Imports System.Data
Imports System.Data.OleDb
Public Class _01_TAILOR_SETUP
Dim con As OleDbConnection
Dim cmd As OleDbCommand
Dim da As OleDbDataAdapter
Dim ds As DataSet
Private Sub _01_TAILOR_SETUP_FormClosed(sender As Object, e As FormClosedEventArgs) Handles Me.FormClosed
End Sub
Private Sub _01_TAILOR_SETUP_FormClosing(sender As Object, e As FormClosingEventArgs) Handles Me.FormClosing
Dim result As DialogResult = MsgBox("do you want to close?", MsgBoxStyle.YesNo)
If result = Windows.Forms.DialogResult.Yes Then
e.Cancel = True
_00_MAIN.Show()
Me.Hide()
ElseIf result = Windows.Forms.DialogResult.No Then
e.Cancel = True
End If
End Sub
Private Sub _01_TAILOR_SETUP_Load(sender As Object, e As EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'DBDataSet.TAILOR' table. You can move, or remove it, as needed.
' Me.TAILORTableAdapter.Fill(Me.DBDataSet.TAILOR)
ComboBox1.Items.Add("Available")
ComboBox1.Items.Add("Terminated")
ComboBox1.Items.Add("Both")
con = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=DB.accdb")
con.Open()
da = New OleDbDataAdapter("Select * from tailor", con)
ds = New DataSet()
da.Fill(ds, "tailor")
DataGridView1.DataSource = ds.Tables(0)
con.Close()
End Sub
Private Sub ComboBox1_KeyDown(sender As Object, e As KeyEventArgs) Handles ComboBox1.KeyDown
If e.KeyCode = Keys.Escape Then
If TextBox1.Text = "" And TextBox2.Text = "" And TextBox3.Text = "" And ComboBox1.Text = "Select value" Then
MsgBox("Fill appropriate values")
TextBox3.Focus()
Else
Dim result As DialogResult = MsgBox("Do you want to save", MsgBoxStyle.YesNo)
If result = Windows.Forms.DialogResult.Yes Then
con.Open()
cmd = New OleDbCommand("INSERT INTO Tailor (TCODE, TNAME, TADDRESS,STATUS) VALUES ('" & TextBox3.Text & "', '" & TextBox2.Text & "', '" & TextBox1.Text & "', '" & ComboBox1.Text & "');", con)
cmd.ExecuteNonQuery()
MsgBox("INSERTED")
da = New OleDbDataAdapter("Select * from tailor", con)
ds = New DataSet()
da.Fill(ds, "tailor")
DataGridView1.DataSource = ds.Tables(0)
con.Close()
ElseIf result = Windows.Forms.DialogResult.No Then
End If
End If
End If
End Sub
End Class
i need to resolve this please help me
Sissy Ram
24-Feb-14 7:57am
View
I need to set to my form fit into screen resolution
Sissy Ram
24-Feb-14 7:50am
View
That works fine
Sissy Ram
17-Feb-14 10:10am
View
I tried this simple code but how to set this for all textboxes in the form?
Private Sub textBox1_KeyPress(sender As Object, e As KeyPressEventArgs)
If e.KeyChar <> ControlChars.Back AndAlso e.KeyChar <> "-"C Then
'allow backspace for deleting and minus simbol
e.Handled = Not Char.IsNumber(e.KeyChar)
'allow numbers only
If Not e.Handled Then
Dim num As Integer = Integer.Parse(String.Format("{0}{1}", If(textBox1.Text = String.Empty, "", textBox1.Text), e.KeyChar.ToString()))
If num > 11 Then
e.Handled = True
End If
End If
End If
End Sub
Sissy Ram
17-Feb-14 10:03am
View
Help me please
Sissy Ram
17-Feb-14 9:52am
View
vb .net, windows forms
Sissy Ram
15-Feb-14 1:15am
View
this illustrate for asp .net and i need it for vb .net
Sissy Ram
15-Feb-14 1:13am
View
the links shows crystal reports for c# but i need for vb .net
Show More