TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Ronok Bhowmik
NA
37
30.6k
How to convert varchar into data type int
Jan 11 2014 2:21 AM
I have one textbox ,one combobox and password box.When all the three values are matched to the database value then i can login the next window.But it creates an error like this:Input string was not in a correct format. And my sample code is:
SqlConnection conn = new SqlConnection(dataconnection);
conn.Open();
SqlCommand cmd = new SqlCommand("uspLogin", conn);
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ProvostName",ProvostNametextbox.Text);
cmd.Parameters.AddWithValue("@ProfessorRank",Convert.ToInt32(ProvostRankComboBox.Text));
cmd.Parameters.AddWithValue("@Password", ProvostPasswordtextbox.Password);
//cmd.ExecuteNonQuery();
SqlDataReader sdr = cmd.ExecuteReader();
if ((sdr.Read() == true))
{
MainWindow1 main = new MainWindow1();
main.Show();
this.Close();
}
else
{
MessageBox.Show("Sorry,try again!");
}
----------------
My stored procedure is:
USE [MyHallDatabase]
GO
/****** Object: StoredProcedure [dbo].[uspLogin] Script Date: 01/11/2014 13:20:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[uspLogin]
(
@ProvostName nvarchar(20),
@ProfessorRank nvarchar(20),
@Password int
)
As
begin
SELECT *
FROM Provosts
WHERE ProvostName=@ProvostName AND ProfessorRankId=@ProfessorRank AND Password=@Password
end
--------------- Please Help me.Thanks in advance.
Reply
Answers (
1
)
How to convert the US time to India time..
Add Video Player to the website to play video that upload