here is my stored procedure
CREATE PROCEDURE [dbo].[Retrieve_ConvictName]
(
@ConvictName char(300),
@ConvictIdNo varchar(100)
)
AS
BEGIN
SET NOCOUNT ON;
SELECT ConvictName FROM Convict_Info WHERE ConvictIdNo=@ConvictIdNo
END
GO
here is my code
protected void txtTest_TextChanged(object sender, EventArgs e)
{
this.code = this.txtTest.Text;
DataTable DT = new DataTable();
DT = ExecuteDataTable("Retrieve_ConvictName", this.txtTest.Text);
this.ConvictName = DT.Columns.ToString();
this.lblConvictName.Text = this.ConvictName;
}
private DataTable ExecuteDataTable(string p1, string p2)
{
throw new NotImplementedException();
}
I want to display the convict Name in a label, when t ...
Go to the complete details ...