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.
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.
Sathya NarayanPosted Jan 11, 2014, 3:19 AM
declare @query Nvarchar(500)
declare @ Nvarchar(500)
set @values='1,2'
set @Query=N'Select * from tblsomething where ID in('+@values+')
select @Query
select @exec
try this query it may works
with regards,
sathya