private DataTable getLoginDetails(string username) { SqlCommand sqlcmd = new SqlCommand("sp_GetLoginDetails", sqlConn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value = username; DataTable dtUser = new DataTable(); sqlConn.Open(); SqlDataReader sqlDR = sqlcmd.ExecuteReader(); dtUser.Load(sqlDR); sqlConn.Close(); BGAssetService.Service1Client serviceAsset = new BGAssetService.Service1Client(); serviceAsset.GetLoginDetails(username); return dtUser; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)